Microsoft Excel 365 PowerPivot Training Course Beginners Hammersmith

Hammersmith Beginners Microsoft Excel 365 PowerPivot Course Overview

If you're wanting to book your Microsoft Excel 365 PowerPivot Training Course and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft Excel 365 PowerPivot Training Course then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft Excel 365 PowerPivot Training Course Beginners training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

This course is designed for those with a solid Excel foundation. To make the most of the training, we recommend:

• Familiarity with Windows-based systems.
• Comfort with the Excel interface, formulas, functions, and PivotTables.
• A desire to explore advanced Excel tools for data modelling.

Complete Course Outline

Getting Started with Microsoft Power Pivot

• Enable and navigate Power Pivot.
• Import data from various sources.
• Refresh data from a data source.
• Create linked tables.

Manipulating Power Pivot Data

• Manage tables.
• Create calculated columns.
• Sort and filter Power Pivot data.
• Create and manage table relationships.

Creating Power Pivot Reports

• Create PivotTables.
• Create PivotCharts.
• Create key performance indicators (KPIs).
• Filter data using slicers.
• Create sparklines.
• Apply conditional formatting.

Using DAX Functions in Power Pivot

• Manipulate Power Pivot data using DAX functions.
• Extract data from tables using functions.
• Work with time-dependent data.

Other Related Courses

Excel Training Courses

Microsoft Excel 365 VBA Training Course - Beginners

Microsoft Excel 365 Training Course - Advanced

Microsoft Excel Power BI Training Course - Beginners

Power BI DAX Training Course - Beginners

Post-Course Resources

• Training notes & exercise files
• Online materials: video tutorials & shortcuts
• 3 months post training support

Microsoft Excel training is available in person and online.

Live Online Training