Woodthorpe IT Solutions Ltd

powerpivot_01

Introduction to Microsoft Power Query (1 day)

Microsoft Power Query is a must-have tool for anyone who works with data as part of their job function. Power Query is a free add-in for Microsoft Excel* – it allows users to connect to a wide variety of data sources, such as; Excel workbook / worksheet, Access database, SQL, SSAS and many more.  Having connected to the data source(s), Power Query allows users to manipulate, standardise and blend data for ease of analysis in other applications such as MS Excel,  MS Power BI and MS SSAS and others.

During this 1 day training course you will learn:

  • About Power Query’s most popular built-in data transformation tools.
  • How to connect Power Query to a range of data sources; Excel, CSV & Access.
  • How to re-shape report data into rows and columns in preparation for analysis.
  • How to blend data from multiple sources into a single data stream.
  • How to refresh data when connecting to differing data sources.


North West Office

Woodthorpe IT Solutions Ltd
4 Haycroft Close
Great Sutton
Ellesmere Port
Cheshire
CH66 2GY

Registered No. 05572129

VAT No. 936 2824 09

North East Office

Woodthorpe IT Solutions Ltd
13 Queensway House
Middlesbrough
Cleveland
TS3 8TF

Telephone

0800 044 3779

Email

contactus@woodthorpeitsolutions.co.uk

top
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.
Performing arts school database Video

No flash installed

×
IFA Practice Manager

No flash installed

×
Production Scheduling Tool

No flash installed

×
Format As Table Part 1

No flash installed

×
Format as a table part 2

No flash installed

×
Subtotalling a list

No flash installed

×
Sorting basics

No flash installed

×
Cell Styles

No flash installed

×
Remove Duplicates In List

No flash installed

×