Loading

The New Alison App has just launched Download Now

Data Analysis with Tables and PivotTables in Microsoft Excel 2013

Learn all about tables and PivotTables and how to perform data analytical techniques with this free online Excel course.

Business
Free Course
This free online Data Analysis in Excel course featuring the expert tutor from Simon Sez IT will teach you about the essentials of setting up Tables and PivotTables in Excel. You will learn how to create and name a table, remove duplicate rows, and insert rows and columns into tables. This course will also discuss the use of the Scenario Manager, Goal Seek, Solver Tool, when the use of these data analysis tools are most appropriate, and more!
  • Duration

    3-4 Hours
  • Certification

    Yes
  • Mobile Friendly

    Yes
  • Publisher

    SimonSezIT
  • Accreditation

    CPD

Description

Modules

Outcome

Certification

View course modules

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.

Start Course Now

Careers