Tables & Data

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

Excel Tables

Tables & Data

I’ve STOPPED Recommending This Excel Feature (After YEARS of Trying)

June 11, 2024

Excel Best Practice - Prefix Table Names

Tables & Data

Use a Prefix for Table Names – Excel Best Practice

June 14, 2023

5 Reasons to use Excel Tables

Tables & Data

5 Reasons to Use Excel Tables

April 6, 2023

Retain the Original Sort Order

Tables & Data, Tips & Shortcuts

Retain the Original Sort Order in Excel

March 22, 2023

Sort Before Deleting Rows

Tables & Data, Tips, Tips & Shortcuts

How to Prevent Excel from Freezing or Taking A Long Time when Deleting Rows

April 6, 2022

Table Name Box in QAT

Tables & Data

Quick Tips and Shortcuts for Renaming Excel Tables

February 23, 2022

Split Text with Flash Fill

Tables & Data, Tips, Tips & Shortcuts

How to Split Text in Cells with Flash Fill in Excel

June 2, 2021

Improve Table Performance

Tables & Data, Tips, Tips & Shortcuts

How to Fix an Excel Table That’s Slow to Scroll or Respond

May 19, 2021

Split Cells with Text to Columns

Tables & Data, Tips, Tips & Shortcuts

Split Cells with Text to Columns in Excel

May 5, 2021