DAY 1
09:30 – 16:30
- Performing calculations on data
– Creating formulas to calculate values
– Summarising data meeting specific conditions - Defining tables
- Using filters to display specific data
– Limiting the amount of data on the screen
– Filtering table data using slicers
– Manipulating worksheet data
– Finding unique values in a data set - Reorganising and summarising data
– Sorting worksheet data
– Performing vertical searches - Adding charts
– Creating column, bar, line and scatter diagrams
– Editing/formatting graphs
– Sparklines - Using pivot tables and pivot graphs
– Using pivot tables to analyse data dynamically
– Filtering, displaying and hiding pivot-table data
– Editing pivot tables (including calculated fields/columns)
– Formatting pivot tables
– Using pivot charts to create dynamic graphs
DAY 2
09:30 – 16:30 hrs.
- Getting started with PowerPivot
– Opening PowerPivot
– Reading data from various data sources - Creating a first dashboard with PowerPivot
– Creating relationships in PowerPivot
– Creating hierarchies in PowerPivot
– Creating pivot tables
– Creating pivot charts
– Converting pivot tables to formulas - Preparing data for better dashboards and analyses
- Reading data into Power Query
– Editing files and variables
– Adding and linking files
– Creating a dynamic dashboard
DAY 3
09:30 – 16:30
- Continued data preparation and automation
- More complex analyses and dashboards using table formulas
– Calculating unique values
– More complex formulas
– Other useful features in Power Pivot - Analysing data through ‘data analysis’
– Performing visual analyses
– Performing statistical analyses - Analysing data using ‘solver’
