Category: Tips and Tricks
Not Just Numbers walks through some interesting applications for the SUMPRODUCT() formula!
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!
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!
ExcelJet has a great video on how to shade groups of rows for better visibility. Very clever use of the CEILING(), ROW(), and ISEVEN() formulas!
ExcelGuru goes in-depth on different ranking methods, and how to use Power Query to solve for them!