This video explains how to use the Power Query editor in Microsoft Excel. The tutorial covers how to load data into the Power Query editor and how to manipulate data types and text. The tutor then explains how to load the data back to Excel as a Table and then how to use the Power Pivot tool to report on the data set.

This video is step one of a series

Most popular video at the moment: Spill Error https://youtu.be/uyNXVbpfsiE
Play list for this video: https://www.youtube.com/playlist?list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc

#itseasytraining
#powerquery
#powerpivot

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-saxton/

Training Guide Books

Excel for New Managers
https://www.amazon.co.uk/Excel-New-Managers-understanding-Microsoft/dp/1695396863

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv

Please take the opportunity to connect and share this video with your friends and family if you find it useful.