Category: Tips and Tricks
Excel Unplugged explains why Power Query can replace VLOOKUP!
Brad Edgar shows you some ways to spruce up your Excel reports by using some uncommon fonts.
Peltier Tech shows you how to create Cycle Charts in Excel: a unique way to show multiple categories of data.
Don Tomoff shows why Power Query is such an important tool for large datasets in Excel.
Engineer Excel uses Goal Seek to solve complex problems in Excel.
Leila Gharani shows you how powerful the new Dynamic Arrays will be in Excel!
Depict Data Studio shows you how to add some sizzle to a presentation, with this great visualization exercise.
Excel Campus shares some helpful tips for navigating and manipulating multiple worksheet tabs.
u/finickyone chimes in again with the helpful SUMIFS formula, to calculate the total of cells for each category in Excel.