Excel Power Query Crash Course
What you'll learn
- Excel Power Query is a fairly new tool useful for redundant data clean-up tasks
Requirements
- Must have Microsoft Excel 2010, 2013, 2016, or Ofc 365
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
Who this course is for:
- Any Excel user who is tasked with preparing data for further analysis and charts
Course content
- Preview02:15
- Preview03:19
- Preview04:12
- Preview02:53
- 04:03Intro to Conditional Columns
- 03:10Edit Query Settings
- 02:11Close-and-Load to Save
- 03:4010 Conditions in 1 Step
- 03:43Format Numbers and Dates
- 03:01Conditional Col from 3 columns
- 03:28Advanced Editor
- 01:47Final Overview and Review
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