Microsoft Excel

Microsoft Excel Training

Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.

For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!

Please select the level that you’re interested in

Microsoft Excel Power Query and Power Pivot Introduction

Course Overview

Audience:

This course will benefit those who wish to take the next step in their Excel skills. How to analyse huge data sets and speed-up processes.

Prerequisite:

Learners should have Intermediate/advanced level of knowledge of Microsoft Excel including knowledge of Pivot Table.

Duration:

This is a 2 day Power Query and Power Pivot in Excel Course. The course starts at 09:30 and runs until 16:30. Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Power Query and Power Pivot in Excel course can be run at our training venue near Liverpool Street  (London) or any preferred location in the UK or Europe.

Power Query and Power Pivot in Excel Introduction Course Outline

What is Power Query & Power Pivot?

What is Power Query?

What is Power Pivot?

How the tools should be used together

Importing Data into Excel & the Model

From Text Files

From CSV files

From Web

From Folder

From Excel ranges and sheets

Understanding Power Query

Understanding the Power Query interface

Renaming and deleting steps

Cleaning messy data example

Refreshing a query

Power Query Options

Common Power Query Features

Unpivot Columns

Setting Data Types

Append Queries

Merge Queries

Using the Advanced Editor

Understanding Power Pivot

How to access Power Pivot

Understanding the Power Pivot
Interface

Different Power Pivot Views

Creating the Data Model

Create table relationships

Edit and delete relationships

Understand filter context

Getting Started with DAX

How is DAX different to Excel
Formulas

Calculated Columns vs Measures

Creating a Calculated Column

Creating Measures

Using Common DAX Functions

Lookup and Filter DAX Functions

Why these functions are useful?

RELATED Function

CALCUALTE Function

FILTER Function

PivotTables and PivotCharts

Creating a PivotTable from the model

Working with the model in a
PivotTable

Filter data using Slicers

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.