Why learn tables in Excel?

Excel Tables and Pivot Tables in Excel allow you to organize and analyze data quickly. You can avoid data entry problems by defining validation rules in Excel Tables. At the same time, you mesh up large datasets in Pivot Tables to create state of the art analysis, reports and dashboards in minutes.

This course includes :

  • About 90 minutes on-demand videos.

  • 7 Downloadable resources

  • Unlimited access for twelve months

  • Certificate of completion - 2 CPD credits

What you 'll learn

  • How to organize data in Excel table and create an automated data model.

  • What is a pivot table and how to create a dynamic report.

  • How to use advanced features of Pivot Table to create more complex reports and analysis.

  • How to use recommeded Pivot Tables.

  • Who should attend

    Anybody who have basic knowledge of MS Excel.

  • Prerequisites

    Basic knowledge of Microsoft Excel.

  • Requirements

    Microsoft Excel 2016 or later. Microsoft Excel 365 is preferred.

Course curriculum

  • 1

    Organize, Slice and Dice your data.

    • Organize data with Excel Table

    • Pivot Table Basics

    • Data Analysis with Pivot Tables

    • Advanced Pivot Tables

    • Recommended Pivot Tables