microsoft partner logo color
8245  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
$438 USD
Course Code OFC-152-HF
Duration 1 day
Available Formats Classroom

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 Accelebrate 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