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

Online Course

Udemy

Go to Udemy

Start Learning

What is the course about?
Prerequisites & Facts
Cost, Certificate & Degree
Reviews & Experiences

What is the course about?

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

The course Revealed: Excel Power Query One Hour Bootcamp (Great Stuff) is an online class provided by Udemy. It may be possible to receive a verified certification or use the course to prepare for a degree.

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

Course description

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

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

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

1 hour on-demand video
2 articles
4 downloadable resources
Full lifetime access
Access on mobile and TV
Certificate of Completion
Doug Burke

Start Learning

Prerequisites & Facts

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

Course Topic

Business, Data Analytics, Power Query

University, College, Institution

Udemy

Course Skill Level

see course summary

Course Language

English

Place of class

Online, self-paced (see curriculum for more information)

Degree

Certificate

Start Learning

Degree & Cost

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

To obtain a verified certificate from Udemy you have to finish this course or the latest version of it, if there is a new edition. The class may be free of charge, but there could be some cost to receive a verified certificate or to access the learning materials. The specifics of the course may have been changed, please consult the provider to get the latest quotes and news.

Udemy

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

provided by Udemy

Start Learning