Excel Tips
May 2, 2013
On Wednesday, May 1, 2013, the podcast talked about the math behind a 26x26 grid and that the math seems to indicate it is not possible to build such a grid.
Learn Excel 2013 GAUSS Function »
September 7, 2012
Excel 2013 includes 52 new functions, most of which were added to be compliant with the Open Document Spreadsheet standards. This post will cover the Excel 2013 Gauss function.
A New Record - Pivot Table in 4 Clicks »
July 26, 2012
I just created a cross-tab pivot table in four clicks using Excel 2013.
Quick Reaction to Excel 2013 »
July 17, 2012
The Excel Apps concept will make everyone in between happy.
Richard Schollar: VLOOKUP Left! »
March 27, 2012
How do you use a VLOOKUP if your table data holds the lookup value in a column to the right of the data column you want to return?
James Chen: Use Consistent Sheet Names »
March 27, 2012
More often than not we need to pull info from various worksheets in a workbook. If you use care to consistently name the worksheets, you can combine VLOOKUP with INDIRECT to pull data from different worksheets. This technique is a life and time saver.
Collection of VLOOKUP Week Articles »
March 25, 2012
Back in 2012, I asked many of my Excel friends to write an article for VLOOKUP week. Many of these are still live on the web.
Upgrade to Excel 2007 or Excel 2010? »
October 29, 2010
I recently received a call from an old colleague. His company was finally upgrading from Excel 2003 and asked if I could send him a book. I figured that I would send him Rev Up to Excel 2010: The Upgraders Guide to Moving from Excel 2003 to Excel 2010.
October 21, 2010
During the beta, PowerPivot was know as Gemini. When they announced the official name as PowerPivot, I caught myself getting hung up on whether I was talking about PowerPivot or PowerPoint.