Not Just Numbers walks through some interesting applications for the SUMPRODUCT() formula!
My Online Training Hub shows us an add-in that can translate into 80 languages!
MVP John MacDougall guest posts on Vertex42 to show us how to track Income and Expenses with Pivot Tables!
Peltier Tech shows us how to create Step Charts in Excel. This is great for tracking periodic changes in value, and the duration of the value!
Excel Spreadsheets Help is here with a quick tip on one of my pet peeves. Hide your gridlines!
CPA Self Study has a neat trick to prevent users from entering duplicate data.
Ann K Emery is here with some solid advice on improving your charts. Make them easy to understand!
Jay Burleigh uncovers a strange addition error in Excel, and explains why this is happening. Very interesting; try it out for yourself!
CPA Self Study shows us how to create Gantt Charts in Excel; very helpful for project Scheduling!
Chandoo makes learning fun by building a Penalty Kick Shootout game in Excel! Amazing use of VBA here!
The Spreadsheet Guru shows you how to build an interactive Powerpoint quiz that shows you the correct answer. The twist? It’s all done with Excel VBA!