Excel Tutorials (Blog)

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

LAMBDA Explained

Formulas

The LAMBDA Function Explained – How to Create Custom Functions in Excel

September 15, 2021

Quick Way to Insert Slicers

Pivot Tables

Quick Way to Insert Slicers in Excel Worksheets

September 2, 2021

The Hero Tools Add-in is Now Available

Add-in, Uncategorized

The Hero Tools Add-in is Now Available

August 24, 2021

Drop Down List Width and Font Size

Tips

How to Change Drop-down Width and Font Size in Excel

August 3, 2021

Olympic Commercials Dashboard Cover wt 640x360

Charts & Dashboards

The NBC Olympic Commercials Dashboard

July 27, 2021

Manual Calc Mode

Formulas

How to Fix Excel Formulas that are Not Calculating or Updating

July 20, 2021

Show Changes Feature

Tips

Show Changes and History of Edits in Excel

July 12, 2021

3 Tips for the Pivot Table Fields List in Excel

Pivot Tables

3 Tips for the Pivot Table Fields List in Excel

July 7, 2021

Power Query Quickly Reorder Multiple Columns Post Thumbnail

Power Pivot/Query/BI, Power Query

How to Reorder Multiple Columns in Power Query with Drag & Drop

June 23, 2021