Excel With Excel Power Query and Get & Transform

Microsoft Excel Power Query / Get & Transform to Clean, Consolidate & Automate in Excel 2010, 2013, 2016
Instructed by: John Michaloudis | Subject: Office Productivity, Microsoft

Free coupon for this course has been sold out.

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 button, WOW 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 ...

Outcome

1. 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
2. Learn the various Data Analytical tools within Excel to easily find & clean your data
3. Use Excel Formulas & Functions to pull data out & reorganize it to your desired outcome

Take This Course

Course Info

• 18 Lectures
• 2.5 Hours
• Language: English
• Subject: Office Productivity, Microsoft
• Instructed by: John Michaloudis
• Last updated on July 2017
• Platform: Udemy