Excel Tutorials (Blog)

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

Why the Pivot Table Calculation Type Defaults to Count

Pivot Tables

Pivot Table Defaults to Count Instead of Sum & How to Fix It

December 19, 2016

Tables & Data

How to Filter for Duplicates with Conditional Formatting

December 7, 2016

table-formula-references-can-be-turned-off-example

Library, Tables & Data

How to Turn OFF Structured References in Excel Table Formulas

December 1, 2016

how to filter multiple columns in excel

Tables & Data

Filter Multiple Columns – Free Video Training Series – Part 3 of 3

November 30, 2016

keyboard-shortcuts-for-excel-filter-drop-down-menus

Tables & Data

Keyboard Shortcuts for the Filter Menus – Free Video Training Series – Part 2 of 3

November 21, 2016

filters-training-video-1-thumb-640

Tables & Data

Excel Filters – Free Video Training Series – Part 1 of 3

November 16, 2016

horizontal-scrolling-to-find-applied-filter-icon-button-in-excel

Add-in, Macros & VBA

Preview of The Filter Mate Add-in for Excel

November 3, 2016

the-range-find-method-to-find-the-first-used-non-blank-cell-with-vba-macro-excel

Library, Macros & VBA

How to Find the First Used Cell with a VBA Macro

October 13, 2016

the-table-of-contents-image-gallery-for-excel

Macros & VBA

How to Add a Table of Contents Image Gallery Sheet to Your Excel Files

October 5, 2016