Course Description

The course Data Analysis with Tables and PivotTables in Microsoft Excel 2013 takes you through the essentials of setting up Tables and PivotTables in Excel before moving onto some more advanced Data Analysis techniques.

The course begins by showing you how to create a table, name a table and remove duplicate rows. You'll learn how to insert rows and columns into tables, and use the table styles, reference and selection functions. The course shows you how to create a PivotTable, use the filter function, and perform data analytical techniques using PivotTables. You'll also learn how to use the Scenario Manager and Goal Seek in Excel.

If you are interested in a career that involves data analysis, or you are a professional looking to improve your skills, then this is the course for you. After taking this Advanced Microsoft Excel course on data analysis you'll be able to perform more advanced data analytical tasks including data analysis in PivotTables and using the Scenario Manager and Goal Seek in Excel. So start this free online course today and gain valuable skills in the area of using tables and PivotTables in Excel.

What you'll learn in this course?

• Data Analysis

• Microsoft

• Excel

• Pivot Tables

• Advanced Excel