Excel Power Query
- Learn to use Power Query to create queries, data connections to a large number of data sources and reports which will update when new data are added to the data source. Save hours of work converting, cleaning, formatting, deleting, changing structure in source data. Save hours of work updating data analysis worksheets. Save time changing source data to flat lists.
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 204,132 people .
- Over 14,056 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
This course will benefit:
People who work with reports, dashboards, and analysis in Excel and spending hours converting, cleaning, formatting, deleting, changing structure in source data from other Excel worksheets, financial systems, databases, websites, SharePoint, and many other sources.
Those using Vlookup and other lookup and reference function to merge data.
All, who want to automate the process working with external data in Excel.
Everybody, who need to combine data to use in Excel.
All, who get data from CSV files, text files, XML files, or other excel workbooks.
Everyone, who would like to drop source data files into a folder and get the Excel report/dashboard updated automatically from the data in the new files, added to the folder.
Everybody working with data models in Excel can use Power Query to extract, clean, combine, merge, and aggregate data before adding the data to a data model.
Training Course Content
Getting started
Use Power Query in different versions of ExcelNavigate and get a basic understanding of Power Query
Understand Applied Steps in Query Settings
Extract Data
Extract data from excel tableExtract data from excel external workbooks
Extract data from databases
Extract data from web
Extract data from other sources
From folder (multiple files)
Transform Columns and Add Columns
Use Group By to group source dataUse first row as headers
Aggregate columns
Calculate columns
Use text functions in columns
Clean Data
Change text to columnsRemove unwanted columns and rows from data source
Cope with formatting issues
Manage are source data cleaning issues
Unpivot data
Replace errors or values in columns
Merge and Append
Merge data from an Excel workbookMerge data from multiple Excel workbooks
Merge data from multiple data sources
Append data from Excel worksheets and multiple data sources
Automate Queries
Understand Power Query technics to automate queriesUnderstand how to create simple functions in Power Query
Create Dashboard/Report from Power Query data
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.9
Thank you Jens; it was a real pleasure to have you as our trainer one more time :)
perhaps more on report creation i.e. linking to power tables/charts or other ways to present data
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Most useful topic: Dax