Tables & Data

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

Revert to Original Sort Order 640

Revert to Original Sort Order in Excel

March 14, 2019

Add New Items to Drop-down Lists Automatically Thumb 640

Tables & Data, Tips, Tips & Shortcuts

How to Add New Rows to Drop-down Lists Automatically – Dynamic Data Validation Lists

August 13, 2018

Excel Tutorial Drop Down Lists in Cells

Tables & Data, Tips, Tips & Shortcuts

How to Create Drop-down Lists in Cells – Data Validation Lists

August 8, 2018

Automate Filters with VBA Macros - AutoFilter Guide

Macros & VBA, Tables & Data

The Ultimate Guide to Excel Filters with VBA Macros – AutoFilter Method

July 12, 2018

Table Number Formatting Doesn't Copy Down

Macros & VBA, Tables & Data

Why Table Number Formatting Doesn’t Copy Down and How to Fix It

March 8, 2018

Remove Duplicates Video Thumb 640

Macros & VBA, Tables & Data, Tools

3 Ways to Remove Duplicates to Create a List of Unique Values in Excel

October 18, 2017

How to Delete Blank Rows 640 YouTube Video Thumb

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

3 Ways to Delete Entire Blank Rows in Excel + Video Tutorial

October 5, 2017

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