Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Working with Power Query: Advanced Excel
Rating: 4.5 out of 5(2 ratings)
6 students

Working with Power Query: Advanced Excel

Elevate your Excel skills and learn the advance features of Excel with Microsoft Excel Advanced.
Created bySimon Sez IT
Last updated 11/2024
English

What you'll learn

  • Import data efficiently using Get and Transform.
  • Navigate and utilize the Power Query Editor.
  • Combine and transform files seamlessly.
  • Load refined data directly into Excel.

Course content

1 section • 12 lectures • 42m total length

  • Course Introduction1:13
  • WATCH ME: Essential Information for a Successful Training Experience2:11
  • DOWNLOAD ME: Course Files0:23
  • DOWNLOAD ME: Exercise Files0:23
  • Power Query Overview1:32
  • Importing Data Using Get and Transform7:07
  • The Power Query Editor4:42
  • Combining Files4:50
  • Transforming Files9:28
  • Loading Files into Excel4:00
  • Course Exercise5:51
  • Course Close0:56
  • Course Quiz

Requirements

  • Familiarity with Excel’s user interface, basic formulas, and functions (e.g., SUM, AVERAGE, VLOOKUP).
  • Basic knowledge of data tables, rows, columns, and common formats such as CSV and Excel files.
  • Access to Microsoft Excel 2021.
  • Experience with data cleaning or analysis is helpful but not mandatory.

Description

**This course includes downloadable course instructor files and exercise files to work with and follow along.**


Welcome to our "Microsoft Excel: Power Query" course. In this comprehensive program, you will delve into the powerful world of Power Query, empowering you to manipulate and analyze data in Excel efficiently. Through engaging lessons, you will learn how to import data seamlessly using Get and Transform, navigate the versatile Power Query Editor, and adeptly combine and transform files to meet your analytical needs.


You will also explore how to clean messy data, remove duplicates, split columns, and apply filters to prepare your datasets for reporting. Learn how to merge queries from multiple sources, create custom columns, and apply transformations that support accurate and organized outputs.


By the end of this course, you should possess the skills to load refined data directly into Excel, enhancing your productivity and decision-making abilities. Elevate your Excel skills, save time, and improve your analytical capabilities with our hands-on approach to Power Query essentials.


Course Objectives

In this course, you will learn how to:

  • Import data efficiently using Get and Transform.

  • Navigate and utilize the Power Query Editor.

  • Combine and transform files seamlessly.

  • Load refined data directly into Excel.


This course includes:

  1. 42 minutes of video tutorials

  2. 9 individual video lectures

  3. Course and Exercise Files to follow along

  4. Certificate of completion

Who this course is for:

  • Data analysts and professionals who regularly handle, clean, and analyze large datasets in Excel and want to streamline their workflows.
  • Individuals in finance, marketing, operations, or management who need to combine and transform data for reporting and decision-making.
  • Learners and instructors looking to develop or teach advanced Excel skills, especially for projects involving data manipulation.
  • IT and database professionals who integrate data from multiple sources and need to prepare it for analysis in Excel.
  • Anyone transitioning to advanced Excel features.

Report abuse