Category: Tips and Tricks
Advanced uses for SUMPRODUCT()
Not Just Numbers walks through some interesting applications for the SUMPRODUCT() formula!
Using Pivot Tables to Budget
MVP John MacDougall guest posts on Vertex42 to show us how to track Income and Expenses with Pivot Tables!
Step Charts in Excel
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!
Hiding Gridlines
Excel Spreadsheets Help is here with a quick tip on one of my pet peeves. Hide your gridlines!
Preventing Duplicate Entries with Data Validation
CPA Self Study has a neat trick to prevent users from entering duplicate data.
Make Your Charts Easier to Understand
Ann K Emery is here with some solid advice on improving your charts. Make them easy to understand!
Easy Gantt Charts in Excel
CPA Self Study shows us how to create Gantt Charts in Excel; very helpful for project Scheduling!
VBA Soccer Game
Chandoo makes learning fun by building a Penalty Kick Shootout game in Excel! Amazing use of VBA here!
Using VBA to Build a Powerpoint Quiz
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!
Alternate Shading on Groups of Rows
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!
Different types of Ranking in Excel with Power Query
ExcelGuru goes in-depth on different ranking methods, and how to use Power Query to solve for them!
Checkmarks in Excel
Here’s MrExcel with a quick hack to add checkmarks in Excel; Great for creating task lists.