- Introduction to Excel Power Query
- Get Data and Screen Overview
- How to Change the Data Source
- How to Fix Mistakes
- Intro to Conditional Columns
- Edit Query Settings
- Close-and-Load to Save
- 10 Conditions in 1 Step
- Format Numbers and Dates
- Conditional Col from 3 columns
- Advanced Editor
- Final Overview and Review
What you'll learn
- Excel Power Query is a fairly new tool useful for redundant data clean-up tasks
Description
This short course will give you the base level introduction, and a few tips and tricks, that will embolden you to explore the new "Power Query" tool. It was first launched in Excel 2010 and has only gotten better and easier since then. It's purpose is for redundant data clean-up that will then be used in data analysis, charts, and pivot tables. Set up the clean-up steps once-and-for-all, then just refresh each time you need it.
*** Course access includes project files, homework exercises, 1-on-1 instructor support, LIFETIME access and a 60 day money-back guarantee!***
Hear why this is one of the TOP-RATED Excel Power Query course on Udemy, and the #1 Excel Power Query course:
Excellent Instructor, Explained very key concepts succinctly and with clarity. Looking forward to more learning!
-Ajay
I am an Advance Power Query user and was able to pick up a trick or 2. it was quick, no messing around, and engaging.
-Ngoe Royce Mekolle
Great crash course! I already knew Power Query, but still learned several extremely valuable things. LOVED the Advanced Editor section.
-John Adair
Very fast, easy and interestingly explained.
-Natalia Pankoke
Students also bought
Información sobre el Instructor

- 4.47 Calificación
- 19451 Estudiantes
- 8 Cursos
Andy Lanning
Instructor
Andy Lanning, Owner/Trainer
Computer Software Training, LLC
Maybe you are entering the workforce; maybe you are RE-entering the workforce; or, maybe the Work Force has forced you to re-evaluate your skills...
Andy is a self-taught computer “nerd” who became a formal instructor at the local college in her city, and has been training individuals and groups since 1996. She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 20+ years experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.
Be prepared to learn more than you bargained for in her class. Andy always teaches the 4 Super Secrets to computers and believes firmly in efficiency training.
“My goal is to lower frustration and raise productivity.
And maybe have some laughs along the way!”
Software specialty areas include:
· Microsoft Office: Word, Excel, Outlook, PowerPoint, Publisher
· Office Processes: mail merges, forms, databases, data analysis
· Internet and E-mail
· Computer Basics
- Excel Data Analysis and Power Query
- Word for ADA Compliance
Student feedback
Course Rating
Reviews
Easy and fast Power Query course
Really helpfull !!