Category: Tips and Tricks
Replacing VLOOKUP in Excel – With Power Query
Excel Unplugged explains why Power Query can replace VLOOKUP!
Using Fonts to Enhance Your Excel Reports
Brad Edgar shows you some ways to spruce up your Excel reports by using some uncommon fonts.
Cycle Charts in Excel
Peltier Tech shows you how to create Cycle Charts in Excel: a unique way to show multiple categories of data.
Excel VBA Immediate Window
Wellsr schools you on the VBA Immediate Window in Excel.
Using Power Query for Large Datasets in Excel
Don Tomoff shows why Power Query is such an important tool for large datasets in Excel.
Using Goal Seek to Solve Complex Problems in Excel
Engineer Excel uses Goal Seek to solve complex problems in Excel.
Excel Dynamic Arrays – Game Changer!
Leila Gharani shows you how powerful the new Dynamic Arrays will be in Excel!
Improve Your Presentations – Visualizing Demographic Data
Depict Data Studio shows you how to add some sizzle to a presentation, with this great visualization exercise.
7 Tips for Worksheet Tabs in Excel
Excel Campus shares some helpful tips for navigating and manipulating multiple worksheet tabs.
SUMIFS to Calculate Totals by Category in Excel
u/finickyone chimes in again with the helpful SUMIFS formula, to calculate the total of cells for each category in Excel.
IF AND in Excel
Able Bits shows you some use cases for the IF & AND formulas.
Scrape Website Data into Excel with VBA
My Online Training Hub shows you how to use Excel VBA to scrape data from websites.