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 touch
to 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 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.
Enquire Now
Need 1-2-1 support?
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
Download Brochure
We're delighted to announce that our brochure, covering our core services - IT Training, Consultancy & Personal Development - is now available for download.
Click below to request a copy:
Further details and bookings
To find out more or book a Microsoft Power Query training course, call our team now on 01189 789 279 or complete this enquiry form:
Microsoft Word Enquiry Form
*This is in-line with the company
Privacy Policy and you may unsubscribe / update your preferences at any point in the future.
What our customers have to say
We constantly collect feedback to ensure we deliver training to the highest standards. Here are some of our many testimonials:
