We're experts in delivering Eureka moments with Microsoft Power Query
Power Query
Training Courses
We're experts in delivering Eureka moments with Microsoft Office
Microsoft Power Query Training Courses
We're experts in delivering Eureka moments with Microsoft Power Query
Excel Power Query enables you to get data from almost anywhere: web; databases; Excel files; SharePoint; Salesforce etc. and to manipulate it: clean; transform; merge and append. It’s a great way for non-technical Excel users to access large, business databases; conduct analysis and produce reports.
Our team bring the training to you, delivering the workshops at your site, helping you focus on what’s important to you. Get in touchto find out more and see how we can help.
Power Query (Get and Transform): Introduction
Duration:One day (9:30 - 16:30)
This workshop is ideal for business anyone using Excel to create complex reports, or needing advanced data analytics to process, analyse and display data. To get the most from this workshop you should have a basic knowledge of Excel. Experience of creating and manipulating tables and PivotTables is beneficial but not essential. This foundation course will show show you how to:
Create effective and professional reports
Gather and transform data from multiple sources
Discover and combine data in mashups
Learn about data model creation
Explore, analyse, and visualise data
Course Content
Overview
Installing Power Query
Creating and editing a simple query
Data import sources
Working with CSV; text; Excel files
Importing multiple files
Working with web data
Finding data using Power Query online search
Working with folders and multiple files
Working with columns
Name
Move
Split
Merge
Filtering and sorting
Auto-Filter
Number, text and date filters
Filter by range
Removing duplicates
Filter out errors
Sorting
Grouping rows
Changing values in a table
Replacing values
Transformations
Date/time
Replacing missing values
Table transformations
Unpivoting columns and rows
Transposing a table
Creating custom columns
Loading data
Loading data into a worksheet
Loading data in to the Excel data model
Power Query and table relationships
Refreshing
Query editor
Editing query steps
Editing query step settings
Queries
Understanding Power Query’s language syntax
Merging tables and queries
Using Power Query functions in columns
Using IF statements
Creating customer Power Query functions
Implementing dynamic parameter tables
Creating calendar tables
Sharing queries
Best practices for query organisation
To find out more about this course, or to make a booking, please call us on 0118 9789 279 or click here
to email us.
We offer face-to-face and virtual sessions, tailored to your specific needs and designed to: build confidence; help you work more effectively and understand what to do next. Find out more.
DOWNLOAD OUR BROCHURE
We're delighted to announce that our brochure, covering our core services - IT Training, Consultancy & Personal Development - is now available for download.