Loading

Alison's New App is now available on iOS and Android! Download Now

Explore Diplomas & Certificates Discover Careers More
  1. Free Online Data Analysis in Microsoft Excel Course

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.

Publisher: SimonSezIT
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!
Start Course Now
Data Analysis with Tables and PivotTables in Microsoft Excel 2013

  • Duration

    3-4 Hours

  • Students

    28,204

  • Accreditation

    CPD

Share This Course And
Earn Money  

Become an Affiliate Member

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

Start Course Now
Tags:

Similar Courses

Careers