Jon Acampora, Author at Excel Campus

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

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

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

September 30, 2020

Dynamic Array Formulas

Distinct Count Report with Dynamic Array Formulas

September 22, 2020

Unique Rows with Power Query

How to Count Unique Rows with Power Query

September 16, 2020

Distinct Count Report with Pivot Tables

2 Ways to Calculate Distinct Count with Pivot Tables

September 9, 2020

Data Analysis Challenge

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