Excel Tutorials (Blog)

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

Overview of Dates in Excel 640x360 Youtube Video Thumb

Formulas

How Dates Work in Excel – The Calendar System Explained + Video

January 26, 2016

Month-to-Date Filter in Excel Pivot Tables

Pivot Tables

How to Create Month to Date (MTD) Comparisons with a Pivot Table + Video

January 20, 2016

COUNTIF Function Explained - Counts the Number of Cells that Contain a Matching Value in a Range

Formulas

How to use the COUNTIF Function Instead of VLOOKUP + Video

January 12, 2016

Andy with his Awesome Excel Resume

Tips, Tips & Shortcuts

What Are Your (Excel) Plans For 2016?

January 5, 2016

Excel User Voice Web Page 615

Tips, Tips & Shortcuts

I Wish Excel Could… Excel User Voice Explained

December 15, 2015

Formulas

A Few Questions About VLOOKUP & INDEX MATCH

November 23, 2015

How to Analyze Mutiple Choice Survey Data in Excel

Pivot Tables, Power Pivot/Query/BI, Power Query

How to Analyze Survey Data in Excel + Video

November 15, 2015

Win a Copy of the Mr Excel 40 Greatest Tips Book

Tips, Tips & Shortcuts

Win a Copy of the New Mr. Excel Book! It’s Awesome!

October 27, 2015

3 Ways to Group Times in Excel

Charts & Dashboards, Formulas, Pivot Tables

3 Ways to Group Times in Excel

October 13, 2015