Ultimate Excel Course #10 - Formatting your Data Ranges as Tables for Superior Management

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (28m)
    • 1. Introduction

    • 2. Formatting a Data Range as a Table

    • 3. Exploring the Benefits to using Tables

    • 4. Creating your own Table Styles

    • 5. Formulas with a Tables Structured References

    • 6. Convert a Table back to a Normal Range


About This Class


This class is #10 in a series called the Ultimate Excel Course.

In this class you will learn how to work with tables to manage your data better.

Tables were introduced with Excel 2007, but are still unknown by many Excel users. However this feature of Excel gives access to very powerful features.

We will explore the benefits of managing your data with tables in this class. There are also more advantages coming in later classes in this course.

By using tables your data is dynamic, consistently formatted and wonderfully structured. Some of the greater benefits become clear when we write formulas based on table data. The references are more meaningful and easier to write when compared with normal grid references.

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enrol and let's do this.

Please note that this is class #10 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions - The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make your Data Come to Life

Class #5 - Lookup Functions - The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your data ranges as Tables for superior management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot