Your cart is empty.
Keep shoppingExcel Tables (Beginners' Guide) Mini Free Course
9,055 students
Excel Tables (Beginners' Guide) Mini Free Course
All you need to know about Excel Tables
Created bySama Sadat
Last updated 10/2021
English
What you'll learn
- Excel Tables are a must know feature of Excel, but few Excel users know about them.
- Learn to format your Data in an Excel Table .
- Learn how to use filter buttons to filter and sort your Data.
- Learn how to add a total row.
- Learn how change the style and design of your Excel table .
- Learn how to format Data cells in your Excel table.
- Learn how to add Data to your table .
- Learn how to move columns and rows and how to resize your Excel Table.
- Learn to visualize your Tables using charts and slicers.
- Learn how to understand formulas used with Tables.
- Learn the difference between using Excel tables and Data range with Pivot Tables.
- Learn how to change your Excel table back into a Data range.
- Learn how to quickly remove duplicates in your Data.
Explore related topics
Course content
7 sections • 13 lectures • 29m total length
Requirements
- Microsoft Excel for Windows
- This course is for Excel Beginners .
- No prior Microsoft Excel knowledge is required.
- Mac users are welcome, but note that the course was created in Excel for windows. Excel interface varies across platforms.
Description
If you are not using Tables in Excel, you are missing out on a huge efficiency gain . They include amazing features that will change how you analyze and summarize your data .
This is a very short course that will introduce you to Excel Tables in less than 35 minutes .
You will learn all about excel tables and how you can style , format , sort , filter and summarize your Data.
You will learn how to easily understand and write formulas with tables and automatically fill them down the sheet
In addition we will visualize the Data in Excel tables through inserting charts and slicers, that will provide valuable insights to your Data .
You will learn why Excel pivot tables are prefer over Data range when used with Pivot tables.
Tables will save you a lot of time and increase your productivity .They are one of the most useful easy to use tools of excel.
The course is broken down into short lectures so you can watch them around your schedule and can easily refer back to them if you need .
I hope you are excited as I am to start learning about Excel Tables and implement them in your daily work
Let’s get started!
Who this course is for:
- People who are in Accounting, Finance, Management, Auditing, Admin, Banking, Marketing and any field that used Data.
- Anyone who wants to learn about Excel Tables.
- Those who want to quickly analyze their Data sets to provide them with useful insights.