Excel Tables Course

Learn everything you need to work with Tables in less than 1 hour. Make huge efficiency gains by using dynamic named ranges to automatically update formulas, Pivot Tables and charts. Automate formatting like banded rows or columns; sorting and filtering; and totals and statistics. 
M.Treacy ·September 21, 2020


Course Details

Course Overview 

Less than 2% of Excel users are making use of the huge efficiency gains available with Excel Tables, which is crazy because Tables are dead easy to use and they automate time saving techniques like:

  • Dynamic named ranges that automatically update formulas, PivotTables and charts
  • Formatting, like banded rows or columns
  • Sorting and filtering
  • Totals and statistics

In this mini-course you’ll learn everything you need to know about working with Tables in under 1 hour. You’ll be up to speed and getting your work done faster in no time.

I’ll also share their limitations and teach you some clever workarounds only the experts know.

  • Introduction to Tables (0:20:18)

  • Getting Started With Tables (0:13:27)

  • Sort, Filter and Slicers (0:10:32)

  • Formulas, Structured References, Absolute References (0:12:16)

  • Table Limitations and Workarounds (0:12:05)

Course Syllabus 

Excel Tables introductionIntroduction to Tables – I’ll show you where the majority of people go wrong with their data layout and how and why Tables fix these problems.
Getting Started with Excel TablesGetting Started with Tables – How to insert, rename and work with Tables.
Sort and filter Excel TablesSort, Filter and Slicers – Tables come with a plethora of built in sorting and filtering options. And then there are Slicers for dead easy filtering.
Formulas for Excel TablesFormulas, Structured References and Absolute References – One of the main benefits of working with Tables revolves around formulas. Their simplicity and automatic updating is a huge efficiency benefit.
Excel Table limitations6 Table Limitations and Workarounds – For all their upsides, Tables do have a few gotchas. I’ll cover them all and provide workarounds so you don’t get caught out.
Excel Table course practice fileThere are extensive notes in the Excel workbook included with the course, which also contains practice data.
Excel Table course certificate of completionAnd when you’re finished we’ll send you a Certificate of Completion to add to your résumé.

Who Is Teaching The Course

M.Treacy, a Microsoft Excel MVP.

I have been working with Excel since 1995 and teaching since 2010 (not including teaching many colleagues over the years), and I’m excited to be able to share what I have learned with you.

Back when I started using Excel I was lucky, in that you weren’t expected to know how to use it! As you’d know, that’s not the case these days.

What you learn in this course will set you up for success and simplify your Excel workday with huge efficiency gains.

Prerequisite

  • This course is for every Excel user who doesn’t use Tables or who is using Tables but only scratching the surface.
  • Requires Excel 2007 or later. The course was filmed in Excel 2019/Office 365.

10% off

Be The First

to Know

For Your next purchase when sign up.

Great News ?

  • This Discount Offer is exclusively available only to clients coming from Pro-education Academy website.

100 % Guarantee

Notes

  1. Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  2. Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  3. Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  4. You can request a refund provided that no more than 30% of the course videos have been watched.

Choose Your Membership Level

Currency

cart images

Excel Tables Online

$19.00

12 Months Online


Online Only Access To Course


Excel Tables Course Videos 0hrs 51mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

 

 

Currency

cart images

Excel Tables  Online + Download

$39.00

12 Months Online + Download


Online Access + Download & Keep Course Videos


Excel Tables Course Videos 0hrs 51mins


One Payment for 12 Months Access


Unlimited 24/7 access


Pause, rewind, replay


Download Workbooks and Practice Data


30 Day Money Back Guarantee

Notes

  • Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
  • Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
  • Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
  • You can request a refund provided that no more than 30% of the course videos have been watched.

Our Business Excel Course Collection

                Why Not Discover, More Courses Below! 

Excel 
Charts
Formulas
PivotTables 
Online Training
Dashboard
 Shortcuts 
 VBA
01 / 05

PROFESSIONAL TRAINING

Course Delivery – Live online sessions
Course Duration – 8 Weeks (Three hours every weekend)
Why Learn with Us?
Interactive Learning: You’ll learn with a team of ambitious professionals.
Lifetime Access: It will allow you to revisit the course every time you need it.
Certification: Completion Certificate provided to back your learnings.
IIBA Certified Trainer: You’ll learn from certified industry experts.

So whatever job you are in, let us hold your hand and show you our innovative approach to success using one of our courses. You won’t find a more committed team.
Studying a Business Analyst Course, you can rely on our skillful team of Consultants to build your Business Analyst career even with no experience. Taking this course you’ll find only the most cutting-edge classes designed by Industry Experts. The instructors you’ll meet know SDLC, AGILE and HYBRID project methodologies inside out. Setting you for the highest level of success as a Business Analyst.
These courses are aligned to IIBA and designed to provide you with the core and job ready Business Analysis experience and certification so that you are set on the right growth track in Australia and globe.

02 / 05
Lara Madrigal
DESIGNER

Lara has over 10 years’ experience in the design industry. During this time, she has developed skills across many areas including branding, illustration, UI design, print and web design. She loves to be challenged and to enhance her skillset.

“Being a member of such a talented team is constantly inspiring. We each bring our passion to the studio to make our company a very special creative hive.”
03 / 05
Deborah Barbosa
BRAND STRATEGIST

Deborah describes brand strategy as her perfect blend of critical thinking and collaborative research, one that encourages her natural love of questions and genuine interest in people.

“We are fortunate enough to get to work with many internationally recognised brands, on interesting projects, which makes working at our company an exciting place to be.”
04 / 05
Martijn Dragonjer
PARTNER

Martijn joined the team in early 2015, after ten years working in the film industry. With a strong background for sales and marketing, Will was excited to bring a new perspective to the team.

“There is a constant buzz here, everyone is driven and focused on producing the best work possible for clients. It is a very rewarding place to work with fantastic clients .”
05 / 05
Dominik Doudny
DEVELOPER

Dominik has a passion for developing sites with clean, beautiful code. Dominik’s love for full-stack web development makes him a great asset that can take on back-end code and front-end UI needs if necessary.

“What makes a good company enjoyable? Working with enthusiastic members of well-structured teams of engaging characters.”
previous arrownext arrow
Slider

Still Not too Sure ?

No problem at all, you can book an appointment to speak to one of our subject experts, please, click in Get Support button below.

About Instructor

M.Treacy

4 Courses

+181 enrolled
Open Registration
Skip to content