Ultimate Excel Tables
Master the most important feature in Excel
Master the one feature that separates beginners from power users
Are you frustrated by clunky spreadsheets and manual updates? You’re not alone.
Most Excel users don’t realize the root of their spreadsheet headaches is not in formulas, but in how they store data.
Formulas break, charts don’t update, and reports require manual adjustments. No matter how advanced your formulas are, they’ll always fall short if the underlying data isn’t structured properly.
We believe Excel should work for you, not the other way around. And when you master Tables, it will.
There’s a better way, and it starts with mastering Tables
Excel Tables are more than a formatting trick. They are the most important element for building dynamic reports and managing data.
In our course Ultimate Excel Tables, you’ll gain the skills to use Table with confidence.
No matter your current experience level, whether you’re a business analyst, financial professional, or data enthusiast, this course will transform how you work with Excel.
Ultimate Excel Tables is only available within the Excel Academy.
What’s included?
✓ 4 hours of on-demand video (50+ lessons)
✓ Real-world scenarios to work through
✓ Exercises to practice the skills
✓ Quizzes to test your knowledge
✓ Certificate of completion
✓ English closed captions
✓ Ask questions and get expert answers
Syllabus:
Introduction
- Course Introduction
- Download the support files
- What is a Table
- Learning Journey
Basic Table operations
- Basic Table operations – Introduction
- Create a Table
- Table menu options
- Table Anatomy and Rules
- Selecting parts of a Table
- Convert a Table back to a range
- Naming and renaming Tables
- Resize a Table range
- Filtering a Table
- Sorting a Table
- Advanced and sorting filtering
- Adding rows and columns
- Delete data and remove duplicates
- Table formatting options
- Calculated columns
- Basic Table operations – Exercise #1
- Basic Table operations – Answers #1
- Basic Table operations – Exercise #2
- Basic Table operations – Answers #2
- Basic Table operations – Quiz
Structured references and common formula scenarios
- Structured references and common formulas – Introduction
- Introduction to structured references
- Basic structured reference examples
- Structured references full syntax
- Absolute and relative structured references
- Common functions used with Tables
- Structured references and formulas – Exercise
- Structured references and formulas – Answers
- Calculate a running total in a Table
- Calculate an unordered and grouped running total in a Table
- Calculate the last non-blank value in a column
- Calculate based on rows above or below
- Common formula scenarios – Exercise
- Common formula scenarios – Answers
- Structured references and common formulas – Quiz
Using slicers for user interactivity
- Using slicers for user interactivity – Introduction
- Filter with slicers
- Advanced filter with slicers
- Disconnected slicers
- Using Slicers – Exercise
- Using Slicers – Answers
- Using Slicers – Quiz
Using Tables with other Excel features
- Using Tables with other Excel features – Introduction
- Using named ranges with Tables
- Using charts with Tables
- Using PivotTables with Tables
- Using Conditional Formatting with Tables
- Using data validation with Tables
- Using dynamic arrays with Tables
- Using Tables on protected worksheets
- Using the Data Analyze feature
- Using Excel Online with Tables
- Using SharePoint lists with Tables
- Using Tables with other Excel features – Quiz
Miscellaneous Table options
- Miscellaneous Table options – Introduction
- Miscellaneous Table options
Wrap up
- Wrap-up
- Feedback
- Certificate
Getting started with Ultimate Excel Tables is easy.
Join the Excel Academy
Enrol today to get instant access to the Ultimate Excel Tables course.
Follow the course
Learn all the essential Table techniques.
Apply the learning
Apply the skills and start saving time today.
You’ve been using Excel the hard way. It’s time to let Excel do the heavy lifting.
Join Ultimate Excel Tables today and start building dynamic, flexible, and future-proof spreadsheets that save you hours every week.
Ultimate Excel Tables is only available within the Excel Academy.