25,000+ Courses Nationwide
0345 4506120

Microsoft Excel Data Analysis with Tables and PivotTables

Please note that the duration of this course is 3 hours.

In this half day session, attendees will learn how to best model data lists and how to create the extremely powerful Excel Table. You will learn how to apply basic sort orders and complex sort orders and how to filter a Data Table in Excel using various criteria. In order to summarise large data sets, attendees will learn how to use a PivotTable, one of the most powerful analysis tools available in Excel.

Select specific date to see price, venue and full details.

Learning Objectives

Delegates will learn how to:

  • Work with data in Excel data tables
  • Create and manage PivotTables and PivotCharts

Pre-Requisites

  • Create, edit and format spreadsheets
  • Navigate within worksheets and books
  • Use Insert Function to create built-in functions

Course Content

Creating Excel Tables

  • Create and edit Excel Tables
  • Sort, filter and calculate data

Creating PivotTables and PivotCharts

  • Create and modify PivotTables
  • Grouping and Calculated Fields
  • Applying Filters and Slicers
  • Creating a PivotChart

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best