Tables & Data

Learn how to use the data tools like Tables, Data Validation, Filters, Conditional Formatting, etc. to format & analyze data faster.

5 Reasons to use Excel Tables with Pivot Tables 640

Pivot Tables, Tables & Data

5 Reasons to Use an Excel Table as the Source of a Pivot Table

September 13, 2017

2 Keyboard Shortcuts to Select Column with Blank Cells 640

Keyboard Shortcuts, Macros & VBA, Tables & Data, Tips & Shortcuts

2 Keyboard Shortcuts to Select a Column with Blank Cells

August 30, 2017

The Calendar Table Explained

Pivot Tables, Power Pivot, Power Pivot/Query/BI, Tables & Data

The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI

July 5, 2017

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

Unpivot Exported Data with Powe rQuery in Excel

Pivot Tables, Power Pivot/Query/BI, Power Query, Tables & Data, Video

How To Unpivot in Excel with Power Query + Video Tutorial

March 30, 2015