Microsoft Excel - Excel Tables

Become a Master in Excel Tables

Created by : Rated :4.2 89602 views

Last Updated: 2022-05-03 11:05:39 English Course Type: Self Learning

What is an Excel Table, and why would you want to use one?
How to quickly create and name a table
How to use the right terminology to describe tables and table parts
Table skills
Structured references
Formulas and Tables
Slicers
Table styles

What you'll learn

The basics

What is an Excel Table, and why would you want to use one?
How to quickly create and name a table
How to use the right terminology to describe tables and table parts
How to get rid of a table when you don't want one anymore
The four key options that control table behavior, and their unlikely locations
How calculated columns work, and how to manually override the automatic behavior

Table skills

How to control table rows and columns
How tables create dynamic ranges and how to use them
How table filters work, and how to quickly hide and display the filter
How to sort a table by one or more columns
The special shortcuts you can use to work with tables
How to add and customize the totals row in a table
How to quickly remove duplicates in a table
How to extract unique values from a table

Structured references

What structured references are and how they work with tables
How to use formulas to access different parts of a table
How structured references behave inside a table (vs. outside a table)
How to copy structured references and lock references when needed

Formulas and Tables

How to use formulas to do a conditional sum with a table using SUMIFS
How to use VLOOKUP and MATCH with a table together for dynamic column referencing
How to use INDEX and MATCH with a table, and the key benefit this offers
How to set up a running total in a table using structured references
How you can use the INDEX function to get the first row in a column
How to set up conditional formatting in a table with a formula
How to use data validation in a table + how to use a table to create a dynamic list
How to use named ranges when Excel won't let you use structured references
How to set up a formula to display how many items in a table are visible

Slicers

How to quickly add (and remove) a slicer to a table
How to add more than one slicer to to table
How to stop slicer buttons from moving around
What options are available for slicers, and how they work
How to define and apply a custom style to control how slicers look

Table styles

How tables are formatted with styles, and what you can include in a style
How to quickly apply a style and see what style is applied
How to remove all formatting from a Table, and override local formatting
How to create your own custom style
How to move a custom style from one workbook to another
How to set up Excel to use your custom style by default

Practical table examples

How to use a table to create a dynamic pivot table
How to make a dynamic chart based on table data

Having microsoft excel

Everybody who want to learn Excel

Section 1 : Course Design 1 Lectures 00:03:03
Lecture 1 :
Course Introduction Preview
Section 2 : Getting started 4 Lectures 00:11:59
Lecture 1 :
What is an Excel Table
Lecture 2 :
How to create an Excel Table
Lecture 3 :
How to remove an Excel Table
Lecture 4 :
Excel Table Options
Section 3 : Working with tables 6 Lectures 00:24:15
Lecture 1 :
Working with table rows and columns
Lecture 2 :
How Excel Table ranges work
Lecture 3 :
How to use Table filters
Lecture 4 :
How to sort an Excel Table
Lecture 5 :
How to add a totals row to a Table
Lecture 6 :
How to remove duplicates from a table
Section 4 : Table formula examples 5 Lectures 00:00:00
Lecture 1 :
How to use SUMIFS with an Excel Table
Lecture 2 :
How to use VLOOKUP with a table
Lecture 3 :
How to set up a running total in a table
Lecture 4 :
Conditional formatting formula in a table
Lecture 5 :
Data validation with an Excel table
Section 5 : Table Slicers 2 Lectures 00:00:00
Lecture 1 :
How to add a slicer to a table
Lecture 2 :
How to use table slicer options
Section 6 : Table styles 4 Lectures 00:01:37
Lecture 1 :
Introduction to table styles
Lecture 2 :
How to apply a table style
Lecture 3 :
How to create a new table style
Lecture 4 :
How to copy a table style to another file
Section 7 : Practical table examples 3 Lectures 00:00:00
Lecture 1 :
Why you should use a table for your pivot table
Lecture 2 :
How to build a simple summary table
Lecture 3 :
How to count items in a filtered list

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Rajesh Vydhala,

125516 Course Views

3 Courses

Hello Everyone, I'm having 8+yrs experience in IT industry especially in software development and Quality Engineering.Worked with various Top CMM Level organizations. Experience in various domains like Banking, insurance, telecom,CRM,data security. Expertise in Agile and scrum process environments.