Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

September 2008 - The Excel Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2

    Today's author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles. The spreadsheet can be found in the attachments at the bottom of this post. For those of you who don't already know, Sudoku is a type of logic puzzle (that I was completely addicted to about three years ago) that requires you to place the numbers 1-9 into a grid obeying certain rules ( lots more information on Sudoku is available on the web ). A while back...

  • Chart Advisor

    Today's author, Scott Ruble, a Program Manager on the Excel team, is seeking feedback on a new prototype for building charts. When Office 2007 was released, one of the strong pieces of feedback was Excel needs to do a better job guiding users in the proper selection of charts to effectively communicate their data. Though it wasn't our intent, some of the new formatting options such as glow and legacy 3D charts can be used inappropriately, which obscure the meaning of a chart. Some people...
    Filed under:

  • New Online Training Courses for Excel Services

    We just recently released some online training courses for Excel Services and I wanted to call your attention to them. Excel Services I: The Basics - An overview of the value proposition of Excel Services as well as the basics for publishing and sharing workbooks using Excel Services. Excel Services II: Requirements, Recommendations, and Permissions - Delves deeper into the proper configuration settings you need to be aware of to get up and running smoothly. Excel Services III: Control What People...
    Filed under: ,

  • Video Tip: Conditional Formatting and Data Validation

    Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration and do the post via community clips. The topic is an Excel tip about using conditional formatting and data validation to turn on and off the formatting on the sheet without needing VBA code. The video can be found here and is also embedded...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.