Power Pivot
What is Power Pivot ?
What are the benefits of using Power Pivot ?
How to enable the Power Pivot add-in
The Power Pivot Window
Importing Your Data and the Data Model
How to import data into the PowerPivot Data Model.
Importing Data from a variety of Data Sources
Working with Data Connections
Refreshing Data
Creating the Power Pivot Data Model
How to create relationships between tables in the PowerPivot Data Model.
Understanding One-to Many Relationships
Excel Analysis Tables
What is an Excel Analysis Table?
Using Slicers to filter data in the Table
Why Excel Tables are important to Power Pivot
Adding Linked Tables to the Data Model
Analysing Data using a Pivot Table
Understanding Compact Layout
Changing the Layout
Using the in-situ filters
Grouping data for ad-hoc subtotals
Grouping date columns into years, months
Creating PivotTables with PowerPivot
How to create a PivotTable with PowerPivot data
How to use the Field list with the Data Model
What is different in a PowerPivot Pivot Table
How Drill-down differs in PowerPivot.
Creating a Flattened Pivot Table to analyse combinations of unique data.
Working with Dates in Power Pivot
How to analyse by Year, Quarter, Month etc.
Why a Date Table (Calendar Table) is required
Generating & Marking as a Date Table.
Using Slicers to Filter Data
How to filer data using Slicers
Connecting Slicers to multiple Tables
Using Pivot Charts and Dashboards
What is different about PowerPivot Charts
Connecting Slicers to Pivot Charts
Creating “Dashboards”.
Creating Simple Calculated Columns
How to create a Calculated Column
Looking up values from related tables
What is a Calculated Field
How to Add a Calculated Field to a PowerPivot PivotTable
What are PowerPivot Sets?
Anyone who has a basic knowledge of and uses Microsoft Excel.
We can deliver our training sessions in several ways, these being:
- Open public course (Contact us if you can’t see a suitable date listed)
- Closed group
- In person face to face
- Virtual
- One to one coaching
Have two or more people to train? You may consider a closed group course.
Benefits include:
- Cost effective
- Choose a date to suit you
- Customise content and timings
- No minimum delegate
Contact us on [email protected] to discuss specific date and delivery requirements.
How Our Tutor led Courses Are Delivered:
Delegates are given Pre-work
Group courses use your real-world scenarios so learning is immediately relevant and actionable.
Our sessions are participative and highly Interactive by including a variety of activities throughout the delivery including
Real-world case work
Practical exercises
Real Play
Peer learning
Case studies
Simulation
Facilitated discussion and Structured reflection
Leave with Actionable outcomes
Post-session measurements
Participants leave with:
Practical tools
Clear action plans
Greater confidence
Skills they can apply immediately
Course Benefits
- Fully tutor led instruction
- Comprehensive courseware for all delegates
- Certificates of attendance
- Course Guarantee
- Emergency trainer
- Contextualisation and customisation for Closed group courses
- Evaluation Feedback
- Pre & Post Course Activities
- Access to Customer Portal (course bookers) for oversight of past and future training events and attendance details
Key Features
Engaging tutor led event
Comprehensive course materials
£695.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.