Excel Tutorials (Blog)

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

Combine Tables with Power Query

Power Pivot/Query/BI, Power Query

How to Combine Tables with Power Query

May 20, 2020

How to Add Macro Buttons to the Ribbon

Macros & VBA

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar

May 19, 2020

Power Query Overview YouTube Video

Power Pivot/Query/BI, Power Query

Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool

May 13, 2020

Power Query Date Errors and Settings

Power Pivot/Query/BI, Power Query

4 Ways to Fix Date Errors in Power Query + Locale & Regional Settings

April 29, 2020

Tips for Inserting Excel

Tables & Data

Tips & Shortcuts for Inserting Excel Tables

April 20, 2020

My Journey With Standing Desks

Tips, Tips & Shortcuts

My Journey with Standing Desks

April 16, 2020

Best Practices for Naming Tables

Tables & Data

Best Practices for Naming Excel Tables

April 8, 2020

Prevent Table Formulas From Filling Down

Tables & Data

How to Prevent or Disable Auto Fill in Table Formulas

March 31, 2020

Working from home isn't always easy 5 Tips for working from home

Tips, Tips & Shortcuts

5 Tips for Working from Home

March 18, 2020