Month: July 2018
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!