Microsoft Excel: Data Cleaning with Power Query

Microsoft Excel: Data Cleaning with Power Query

Microsoft Excel's Power Query tool is the biggest feature Microsoft has added to Excel since PivotTables. Seriously, no joke. Read on to learn more about Excel Power Query and how you'll save loads of time as you take advantage of this powerful feature.

Excel Power Query removes the hassle and complex formulas of manual tasks such as:

• Finding the Data each time you need a report

• Cleaning Columns of Data

  • Splitting or Joining Column Values

  • Removing unnecessary characters and extra spaces

  • Formatting data correctly

• Filtering data needed for the report

• Combining multiple Datasets into a master list

• Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts

In just 3 easy steps, you'll have a final report ready for presentation and your next raise.

1. Get Data

2. Transform/Clean Data

3. Report on Data

Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.

Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.

Clean, Transform and Summarize Microsoft Excel Data Quickly with Excel's Power Query

Url: View Details

What you will learn

• Clean, Transform and Prepare Data Sets for Reporting within Excel
• Create Connections and Discover External Data Sources
• Streamline Data Work by Automating with Power Query Steps

Rating: 4.5

Level: All Levels

Duration: 1.5 hours

Instructor: Aims Trainings