Excel Tutorials (Blog)

Power Pivot/Query/BI, Power Query

Split by Delimiter into Rows (and Columns) with Power Query

November 4, 2020

11 comments

Formulas, Macros & VBA

3 Ways to Fill Down Blank Cells in Excel

October 21, 2020

26 comments

Tips, Tips & Shortcuts

Best Practices for Naming Files

October 13, 2020

27 comments

Keyboard Shortcuts

5 Keyboard Shortcuts for the F4 Key in Excel

October 7, 2020

16 comments

Formulas

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

September 30, 2020

18 comments

Formulas

Distinct Count Report with Dynamic Array Formulas

September 22, 2020

3 comments

Power Pivot/Query/BI, Power Query

How to Count Unique Rows with Power Query

September 16, 2020

Add comment

Pivot Tables

2 Ways to Calculate Distinct Count with Pivot Tables

September 9, 2020

27 comments

Tables & Data

Excel Data Analysis Challenge

August 26, 2020

111 comments