Online Excel Training Course

Course Description: This virtual course is designed for people wish to learn how to create and work with PivotTables, PowerPivot and Data Modelling within Excel.  PivotTables are powerful to summarise and manipulate your data.  You can also use the PowerPivot add-in to create sophisticated data models by building relationships between multiple tables.  These topics will assist in developing your worksheets further.

 Prerequisites: Delegates attending this course should have a basic knowledge of Excel.

Course Content

• PivotTables:
• Creating a PivotTable
• Amending the fields in a PivotTable
• Updating the PivotTable
• Adding Calculations to a PivotTable
• Add Grouping to a PivotChart
• Pivot Tools Gear Settings
• Creating a PivotChart
• Create and use Slicers
• Create and use PivotTable Timelines
• Creating from Tables and Related Tables.
• PowerPivot & Data Models
• Install the PowerPivot
• Use workbooks with no tables or relationships
• Build Relationships in Diagram View
• Add more data to the Data Model
• Format columns and sort data
• Use the Calculation area to Calculate a column
• Create a PivotTable
• Create a PowerPivot with related tables
• Uset Get & Transform
• Use the Power Query window
• Load & Transform data

This course will run 3 hours with a 15-minute break.  Morning sessions will be 09:30 until 12:30.  Afternoon sessions will be from 13:00 until 16:00 with a 15-minute break.