Revealed: Excel Power Query One Hour Bootcamp (Great Stuff)
The Short And Sweet Beginners Guide To Using Power Query In Real Life
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
What You'll Learn in This Course
Master key concepts and practical skills through structured learning modules. By completing this curriculum, you'll gain valuable expertise applicable to real-world scenarios.
Learning Outcome 1
You will control your data - - instead of letting it control you. Invest an hour and get a lifetime of benefits.
Learning Outcome 2
You will build fast, repeatable data transformations that improve your Excel analysis and reporting
Learning Outcome 3
You will use the Power Query Editor and its many push-button, formula and multi-query functions
Learning Outcome 4
Import Excel file, remove top rows, use first row as header, remove columns, change type, split columns by delimiter, rename columns, close & load, merge columns, conditional columns, reorder columns, rename steps, move steps, view 'M' code, sort rows, filter rows, rename query, reference, group-by, duplicate, refresh, merge
Learning Outcome 5
You will take a big career step forward as a professional data analyst who understands the importance of 'clean' data
Skills You'll Develop
This comprehensive Revealed: Excel Power Query One Hour Bootcamp (Great Stuff) curriculum is designed to take you from foundational concepts to advanced implementation. Each module builds upon the previous, ensuring a structured learning path that maximizes knowledge retention and practical application.
Course Requirements & Target Audience
Understand what you need to succeed in this course and determine if it's the right fit for your learning goals
Prerequisites & Requirements
What you need before starting this Revealed: Excel Power Query One Hour Bootcamp (Great Stuff) course:
- Basic knowledge of Microsoft Excel
- An interest in learning a great new Excel skill that will enhance your career while saving you time & effort
- Beginners course for people new to Power Query; focus is on quickly getting new users up and running
- Excel for Windows or Office 365. Power Query does not work in native Mac unless you're running Windows OS such as Boot Camp or Parallels VM.
- Power Query is known as Get & Transform in Excel 2016; this course applies to both
Who This Course Is For
This course is perfect for:
- Motivated learners at any level
- Self-paced students
- Anyone interested in the subject
This course might not be suitable if:
- • You're looking for a quick tutorial rather than comprehensive learning
- • You prefer learning without structured curriculum
- • You need highly specialized or niche content
Course Information & Details
Everything you need to know about this online course, from duration to certification
Course Instructor
Doug Burke
Expert instructor with industry experience
Course Language
English
All materials in English
Start Your Learning Journey Today
This online course offers comprehensive training with expert instruction, practical exercises, and a certificate of completion. Join thousands of students advancing their careers through quality online education.
Course Enrollment
Professional Course
Investment around $69.99
Pricing may vary. Check the course provider for current promotions and exact pricing.
What's Included
- 1 hour on-demand video
- 4 downloadable resources
- 2 articles
- Access on mobile and TV
- Certificate of Completion
- Full lifetime access
Affiliate disclosure: if you enroll through links on this page, the course provider may pay us a commission. This comes at no extra cost to you and does not influence how we describe courses.
- ✓Instant access after enrollment
- ✓Learn at your own pace
- ✓Direct enrollment with Udemy
Where this course fits
Certifications in this area
- Microsoft Certified: Azure Data Fundamentals · Foundational
- Microsoft Certified: Azure AI Fundamentals · Foundational
- AWS Certified AI Practitioner · Foundational
- Microsoft Certified: Fabric Data Engineer Associate · Associate
- Microsoft Certified: Power BI Data Analyst Associate · Associate
- Databricks Certified Data Engineer Associate · Associate
Concepts behind this area
Machine Learning
Machine learning is the branch of computing in which a program works out its rule from examples instead of being handed that rule by a programmer, and is judged on how well the rule holds on cases it was never shown.
Neural Networks
A neural network is a stack of layers of very simple arithmetic units whose connection strengths are adjusted by training until the whole arrangement turns the inputs you have into the outputs you want.
Deep Learning
Deep learning is machine learning built on neural networks of many stacked layers, which work out for themselves which properties of the raw data matter instead of being handed a list by a person.
SQL
SQL is the declarative language for asking questions of relational databases: you state which rows and columns you want and how tables relate, and the database engine works out how to retrieve them.
Data Analysis
Data analysis is the practice of interrogating data to answer a specific question, and of establishing how much weight the answer can bear.
Data Wrangling
Data wrangling is the work of repairing and reshaping real records, and of deciding what their gaps and inconsistencies mean, until a table can be trusted with the question being asked of it.
The field, explained: Artificial Intelligence & Machine Learning · Data & Analytics
Wider context: the fields we cover, the glossary and certification exams, all written by us rather than pulled from a provider feed.
