Tips and guides July 7, 2009 3 min read Use the VBA SaveAs Method in Excel 2007 Today’s author is Ron de Bruin , an Excel MVP.
Tips and guides June 30, 2009 3 min read Week Numbers in Excel Today’s author is, Ron de Bruin, an Excel MVP.
Tips and guides March 12, 2009 6 min read Excel VBA Performance Coding Best Practices Today’s author, Chad Rothschiller, a Program Manager on the Excel team, is back with a follow up from his previous post on VBA and Excel performance.
Tips and guides January 16, 2009 4 min read Printing Envelopes Using Excel and Word Excel allows you to define names that apply to a range of cells in the worksheet.
Tips and guides September 30, 2008 10 min read 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.
Tips and guides March 6, 2008 1 min read Unusual (but cool!) Uses of Excel Many of you who have been using Excel for a long time have most likely seen some of the creative, interesting, and rather unusual uses of Excel that people have conjured up.
News February 21, 2007 1 min read Data Mining In Excel One of the technologies available in SQL Server Analysis Services is data mining.