All you need to know about Excel Tables
What you will 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.
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!