Revealed: Excel Power Query One Hour Bootcamp (Great Stuff)

The Short And Sweet Beginners Guide To Using Power Query In Real Life

Created by: Doug Burke
Financial Systems Leader and Experienced Teacher

What Will I Learn?

• You will control your data - - instead of letting it control you. Invest an hour and get a lifetime of benefits.
• You will build fast, repeatable data transformations that improve your Excel analysis and reporting
• You will use the Power Query Editor and its many push-button, formula and multi-query functions
• 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
• You will take a big career step forward as a professional data analyst who understands the importance of 'clean' data

Requirements

• 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

Target audience

• This course is for all analysts who need a better way to handle large amounts of data
• They want to improve or eliminate their manual, error-prone spreadsheet data transformations and replace with a simpler, more reliable system
• They understand the benefits of a systems-based approach and want to take their data transformation techniques to a much higher level