microsoft partner logo color
8420  Reviews star_rate star_rate star_rate star_rate star_half

Excel Power Query in a Day

Skills Gained Master the basics of Power Query Extract and transform data from a variety of sources Work with Power Query data to clean, shape, and analyze data Edit and refresh queries to ensure...

Read More
By Request
$438 USD
Duration 1 day
Course Code OFC-152-HF
Available Formats Classroom

Overview

Skills Gained

  • Master the basics of Power Query
  • Extract and transform data from a variety of sources
  • Work with Power Query data to clean, shape, and analyze data
  • Edit and refresh queries to ensure that your data is always up-to-date
  • Use Power Query data to create pivot tables, reports, and other visualizations

Prerequisites

Learn how to use Power Query within Excel in 1 day! This Excel Power Query training course teaches attendees how to extract different types of data, clean up the data in various ways, and load the cleaned-up data into Excel. Participants also learn how to work with Power Query data in Excel.

Course Details

Training Materials

All Excel Power Query training attendees receive a course workbook.

Software Requirements

  • Excel installed from Microsoft Office Professional Plus or Microsoft 365
  • Related lab files that Ascendient Learning will provide

Outline

  • Introduction to Power Query
    • Extracting and Transforming Data
    • Working with Power Query Data
  • Editing & Refreshing Queries
    • Editing Queries
    • Refreshing the Data
  • Appending & Merging Data
    • Appending Files
    • Hiding Queries
    • Combining Data from Folder
    • Merging Files
  • Creating Formulas in Power Query
    • Using Custom Column Button
    • Using Standard Functions
    • Renaming Steps
    • Editing Formulas
  • Using Power Query Data
    • Creating Pivot Tables
    • Sharing Files with Queries
  • Conclusion
Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information
Ascendient Learning would like to occasionally share news about our services and career opportunities via e-mail when we believe it would be relevant to you. Would you like to opt-in to these communications? You may withdraw your consent at any time using the opt-out/preferences link in the emails sent.

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

Although there seemed to be too many links for the course, everything worked smoothly.

This is my second course with ExitCertified. This course exceeded my expectations. The teacher was great and the class was fun.

They are very good and made sure we had all the appropriate materials for class.

my experince was great from the day i regetered to the actuall day of the class.

Provided good amount of material and a great instructor to teach the material.