Jon Acampora, Author at Excel Campus - Page 20 of 50

Split into Rows with Power Query

Power Pivot/Query/BI, Power Query

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

November 4, 2020

3 Ways to Fill Down Blank Cells

Formulas, Macros & VBA

3 Ways to Fill Down Blank Cells in Excel

October 21, 2020

Best Practices for Naming Files

Tips, Tips & Shortcuts

Best Practices for Naming Files

October 13, 2020

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