Excel Tutorials (Blog)

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

F4 Keyboard Shortcuts

Keyboard Shortcuts

5 Keyboard Shortcuts for the F4 Key in Excel

October 7, 2020

Vlookup to Other Workbooks - Managing & Sharing Files with Formula Links

Formulas

Vlookup to Other Workbooks – Managing, Updating, & Sharing Files with Formula Links

September 30, 2020

Dynamic Array Formulas

Formulas

Distinct Count Report with Dynamic Array Formulas

September 22, 2020

Unique Rows with Power Query

Power Pivot/Query/BI, Power Query

How to Count Unique Rows with Power Query

September 16, 2020

Distinct Count Report with Pivot Tables

Pivot Tables

2 Ways to Calculate Distinct Count with Pivot Tables

September 9, 2020

Data Analysis Challenge

Tables & Data

Excel Data Analysis Challenge

August 26, 2020

Filter by Selected Cells Value

Keyboard Shortcuts, Tips, Tips & Shortcuts

Shortcut to Filter by Cell’s Value in Excel

August 19, 2020

Total Rows for Dynamic Array Formulas and Spill Ranges in Excel

Formulas

Total Rows for Dynamic Array Formulas & Spill Ranges

August 12, 2020

Groups and Outlines

Tips, Tips & Shortcuts

Quickly Hide Rows & Columns with Groups and Outlines in Excel

August 3, 2020