Excel Tutorials (Blog)

Learn how to use Excel more efficiently with our in-depth articles and videos.

XLOOKUP vs VLOOKUP

Formulas

When to use VLOOKUP instead of XLOOKUP

June 22, 2022

File Explorer Shortcuts

Tips & Shortcuts

12 Keyboard Shortcuts for Windows File Explorer

June 1, 2022

Excel Challenge Guessing Game

Formulas

Excel Challenge: Baby Shower Guessing Game

May 25, 2022

Power Query Editor for Mac Video Tutorial

Power Pivot/Query/BI

Excel Update: Power Query Editor for Mac

May 11, 2022

TEXTSPLIT versus TEXTBEFORE

Formulas

Best Way to Split Text in Excel – TEXTSPLIT versus TEXTBEFORE & AFTER

April 20, 2022

Numbered Lists

Tips

4 Ways to Create Numbered Lists in Excel

April 12, 2022

Sort Before Deleting Rows

Tables & Data, Tips, Tips & Shortcuts

How to Prevent Excel from Freezing or Taking A Long Time when Deleting Rows

April 6, 2022

14 New Excel Functions YouTube Live 640

Uncategorized

14 New Excel Functions: Text Split and Array Processing

April 5, 2022

7 Dashboard Tips for the QAT

Charts & Dashboards

7 Excel Dashboard Tools & Tips for the Quick Access Toolbar

March 2, 2022