Excel Tutorials (Blog)

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

Enable or Disable Background Refresh on Power Query Connections

Library, Macros & VBA

Enable or Disable Background Refresh on All Power Query Connections

April 4, 2016

List All Slicers in the Excel Workbook with VBA - Print to the Immediate Window

Library, Macros & VBA

How to List All Slicers in the Excel Workbook with VBA

March 24, 2016

Apply Conditional Formatting to Shapes in Excel Youtube Thumb 689x388

Tips, Tips & Shortcuts

2 Ways to Apply Conditional Formatting to Shapes (Video Tutorial)

March 23, 2016

Power BI, Power Pivot/Query/BI

Free Online Sessions on Excel & PowerBI from the Microsoft Data Insights Summit

March 21, 2016

Personal Macro Workbook Video Series

Macros & VBA

How to Create a Personal Macro Workbook (Video Series)

March 15, 2016

How To Quickly Attach Excel Files to Emails

Keyboard Shortcuts, Tips, Tips & Shortcuts

3 Ways to QUICKLY Attach Excel Files to Emails

March 1, 2016

Filter or Sort Slicer with Another Slicer GIF

Pivot Tables

How to Filter or Sort a Slicer with Another Slicer + Video

February 23, 2016

Add Search Box to Slicer Youtube Video Thumbnail

Pivot Tables

How to Add a Search Box to a Slicer to Quickly Filter Pivot Tables and Charts + Video

February 16, 2016

Dynamic Stacked Column Chart Labels with Slicer Dark Theme GIF 2

Charts & Dashboards

Create Dynamic Chart Data Labels with Slicers

February 9, 2016