Excel Guidance Videos & Articles

Excel Indirect Function Tutorial

By Chris Mortimer | Published: June 7, 2019
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Excel Data Table Tutorial

By Chris Mortimer | Published: May 9, 2019
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Excel VBA to Move Data Around a File – My Approach

By Chris Mortimer | Published: May 3, 2019
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Your Weird Skillset is Your Best Asset

By Chris Mortimer | Published: March 28, 2019
Also posted in Beginner Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

.Cells For Beginners

By Chris Mortimer | Published: March 8, 2019
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Your First Pivot Table

By Chris Mortimer | Published: March 1, 2019
Also posted in Beginner Articles, Excel Guidance Articles, Uncategorized | Comments closed

19 Excel Beginner Shortcuts for 2019

By Chris Mortimer | Published: February 8, 2019
Also posted in Beginner Articles, Excel Guidance Articles, Uncategorized | Comments closed

Understand an Excel File in 3 Steps

By Chris Mortimer | Published: February 1, 2019
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Most Important Skill in Excel VBA

By Chris Mortimer | Published: December 18, 2018
Also posted in Beginner Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

VLOOKUP Formula Problems / Fixes

By Chris Mortimer | Published: November 30, 2018
Also posted in Advanced Articles, Beginner Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Excel VBA to Copy Data to Sheets

By Chris Mortimer | Published: November 23, 2018
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed

Excel Frequency Formula: Common Problems / Fixes

By Chris Mortimer | Published: November 9, 2018
Also posted in Advanced Articles, Excel Guidance Articles, Intermediate Articles, Uncategorized | Comments closed