Excel Tips


Hilary Smart beats Alex Gordon in Excel Championships »

December 9, 2013

It was the second year for the ModelOff Financial Modelling championships and sixteen finalists competed head to head at Bloomberg on December 8, 2013. After four grueling hours, Hilary Smart was crowned the new ModelOff World Champion.


Learn Excel Dashboards »

October 24, 2013

Excel dashboarding guru Mynda Treacy is offering an online course on building dashboards. The course is video based and available online 24/7.


Dealing with a Puzzle »

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.