Links
Translating Excel Functions
My Online Training Hub shows us an add-in that can translate into 80 languages!
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.