Excel With Excel Power Query and Get & Transform
4.2 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
83 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel With Excel Power Query and Get & Transform to your Wishlist.

Add to Wishlist

Excel With Excel Power Query and Get & Transform

Microsoft Excel Power Query / Get & Transform to Clean, Consolidate & Automate in Excel 2010, 2013, 2016
4.2 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
83 students enrolled
Last updated 7/2017
English
Current price: $10 Original price: $190 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 4 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn the various techniques within Power Query or Get & Transform to clean and transform your data & consolidate reports without the need to use Formulas or Macros
  • Learn the various Data Analytical tools within Excel to easily find & clean your data
  • Use Excel Formulas & Functions to pull data out & reorganize it to your desired outcome
View Curriculum
Requirements
  • Compatible with Microsoft Excel for Windows 2010, 2013 or 2016
Description

The course will get yo up and running and using Power Query / Get & Transform with CONFIDENCE!

This must have introductory course covers all of Excel´s must-know features for cleaning up, transforming, consolidating and automating your Excel data and reports.  

You will learn Excel features such as the Functions & Formulas, Text to Columns, Find & Remove Duplicates, Go to Special, Excel Tables, Flash Fill and obviously Power Query (Excel 2010 & 2013) and Get & Transform (Excel 2016) and many more Excel tips & keyboard shortcuts!

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single data cleansing & consolidation tool that is available in Microsoft Excel. 

The course is designed for Excel 2010, 2013 or 2016. There are 4 different modules so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.

In no time you will be able to clean lots of data and report it in a quick and interactive way, learn how to work with various transformation Formulas, create consolidated monthly reports with the press of a buttonWOW your boss with stunning Excel visuals and get noticed by top management & prospective employers! 

The course is just over 2 hours long so you can become an awesome analyst and advanced Excel user within 1 day!

In this course there are FREE downloadable Excel workbooks for each tutorials so you can follow along & practice what you learn.  

We have collectively been helping over 25,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way

These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!

We are so confident that you will get lots of value from this course that you can take it for the full 30 days, download all the workbooks, watch all the videos and apply it to your work to see the results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!

So go ahead and learn from the following in depth Excel subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...

Who is the target audience?
  • New users, beginners, intermediates and advanced Excel users
  • Professionals working in the corporate world or government sectors who want to leverage Excel for increased productivity, accurate data management and more
  • People who want to change career and apply for a new job
  • People who work with large volumes of data and want to quickly sift through, analyze, and chart the data in a professional way
  • People who prepare reports that require constant updating with new data on a daily/weekly/monthly basis
  • Import data into Excel from an external source e.g. ERP System like Oracle, SAP, PeopleSoft, company database, Access, Web etc...and need to quickly & accurately analyze that data and extract valuable information
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
02:15:09
+
HOW TO INSTALL POWER QUERY IN EXCEL 2010 & 2016
2 Lectures 11:59
  • It is imperative to install Power Query if you are using Excel for Windows 2010 or 2013 before continuing on with this course.  If you have Excel 2016, Power Query is already installed automatically.  It is located in your Data tab in the ribbon menu and it is called Get & Transform

The following Office versions for Windows are supported:

  • Microsoft Office 2016 – All Versions
  • Microsoft Office 2013 – All Versions
  • Microsoft Office 2010 Professional Plus with Software Assurance
  • If you do not have this then you will need to upgrade to Office 365 using this link: https://products.office.com/en-us/home

Both 32-bit and 64-bit are supported.  Power Query is not compatible with any Mac versions of Excel.

Preview 11:57

+
POWER QUERY / GET & TRANSFORM - ESSENTIALS
8 Lectures 52:36
Downloadable Workbooks
00:00



Intro to Power Query
09:49

PARSING TEXT (Excel 2010, 2013 & 2016): Splitting data apart when the name, age and email addresses are all in the same cell.

Parsing Text
08:21

INNER JOIN (Excel 2010, 2013 & 2016): Comparing lists to extract entries that appear on both lists.

Inner Join
06:26

UNPIVOT (Excel 2010, 2013 & 2016): Converting a report into raw data so that it's useful for analysis.

Unpivot
05:43

CONSOLIDATE MULTIPLE WORKSHEETS (Excel 2010, 2013 & 2016): An easy way to compile data from multiple worksheets.

Import & Merge Sheets From Another Workbook
09:06
+
POWER QUERY / GET & TRANSFORM - SUPER USES
4 Lectures 29:30
Downloadable Workbooks
00:00

From ERP to Flat File
08:10

Consolidate Multiple Workbooks - Connect To a Folder
09:13

Append Multiple Worksheets
12:07
+
NON POWER QUERY / GET & TRANSFORM SOLUTIONS TO DATA CLEANSING
4 Lectures 41:03
Downloadable Workbooks
00:00

DATA MODELS (Excel 2013 & 2016): Analyzing multiple data sets as if they're a single data set.

Data Models
08:23

Learn the following Excel Formulas & Functions:

  1. PROPER
  2. TRIM
  3. TEXT
  4. LEFT
  5. RIGHT
  6. SUBSTITUTE
  7. REPLACE
Clean & Extract Data Using Excel Formulas & Functions
18:54

Learn the following Excel analytical tools:

  1. CONVERT TEXT TO NUMBER
  2. NUMBER FORMAT SPECIALS
  3. GO TO BLANKS BY COLOR
  4. REMOVE DUPLICATES
  5. TEXT TO COLUMNS FULL NAMES
  6. FLASH FILL
Clean & Extract Data Using Excel Analytical Tools
13:46
About the Instructor
John Michaloudis
4.4 Average rating
1,044 Reviews
22,254 Students
4 Courses
Founder of MyExcelOnline | 35,000+ Excel Students

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline.  I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

Join one of my courses and get ready to change your life!

Oz du Soleil
4.2 Average rating
8 Reviews
83 Students
1 Course
Excel MVP, Author

Excel and data have been my life for the past 15 years, and I'm driven by the impact that data has on peoples' lives. I've seen where crap data has resulted in termination warning letters going to the wrong people, a business' marketing efforts completely stopped, a nonprofit's inability to apply for grants for their literacy program, a small manufacturing company guessing about inventory levels.

After tracking down a lot of issues, I eventually realized that the people in the processes weren't incompetent. Instead, the problem was the many ways that data gets corrupt. Thus, I've been on a crusade to bring focus to the importance of data cleansing as a skill

It's not glamorous. In fact, data cleansing can be thankless and brutal when you have to deal with 9 different misspelling of Albuquerque in your source data or 3 different codes for the same product.

But nothing happens reliably without clean data--no dashboards, no data visualizations, no reports, no paychecks ... no peace, just misery and confusion. People who cleanse data are the stealth warriors for peace from sea to shining sea.


Today, I make fun YouTube tutorials, host workshops and do presentations whenever there's an opportunity to share the knowledge and sound the alarm about cleaning data and ending misery.

About Me

Microsoft Excel Most Valuable Professional: 2015, 2016
Author of Guerrilla Data Analysis, 2nd Ed
Former Co-Host on ExcelTV
Resident of Portland, OR after 19 years in Chicago, IL

Other Stuff
US Navy Veteran
BA in Philosophy from University of IL-Chicago
Kennedy School of Government at Harvard University
Second City Training Center, Chicago