-
In this online, instructor-Led course, you will learn the more advanced Excel features of PivotTables and Data Modelling. This course can be used as a prelude to Power BI as it provides valuable insight towards using the Power Query Editor and Measures using DAX formulas.
Pricing
- 1 Day of group training is £799 + VAT per day
- 2 Days of group training is £699 + VAT per day
- 3 Days of group training is £649 + VAT per day
- Solo training is available for £350 + VAT per day
Microsoft Excel PivotTables & Data Modelling
Whats covered in this course
-
Creating PivotTables
-
Create a PivotTable Report
-
Amend a PivotTable
-
Format a PivotTable
-
Change the PivotTable layout
-
PivotTable Style Options
-
-
Create and use PivotTable Slicers
-
What are Slicers?
-
Create and use Slicers
-
Report Connections
-
-
Create and use PivotTable Charts
-
What is a PivotTable Chart?
-
Create a PivotTable Chart
-
Chart Selection Pane
-
Filter Connections
-
-
Create and use PivotTable Timelines
-
What are PivotTable Timelines?
-
Create a PivotTable Timeline
-
Make Changes to the Timeline
-
Format the Timeline
-
-
Data Modelling & the PowerPivot Add-in
-
Import (Get Data) from various sources
-
Transform Data Using Power Query Editor
-
Add More Tables to the Data Model
-
Queries & Connections
-
-
The PowerPivot Add-in
-
What is the PowerPivot Add-in?
-
Installing the PowerPivot Add-in
-
Create a PowerPivot with related tables
-
-
A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.
-
We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.
-
Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.
We at Etopia Training are committed to providing the best IT & business training services available in Scotland. If you are not 100% happy with the outcome of your course, you are entitled to a full refund through our 100% Satisfaction Guarantee.
1 Day of Group Training is £799 per day, 2 Days of Group Training is £699 per day, 3 Days of Group Training is £649 per day. Solo training is available from £350 per day.