Excel Master Class-Power Query-Consume and Transform Data..70% off udemy coupon code

Udemy coupon......................Skills in data analysis, reporting and the creation of dashboards are highly valued in today's business environment. Microsoft Excel is recognized as the leading data analysis tool in the world.

Please note that this course is the first course in a series of three courses for the Excel Master Class that cover the key outcomes of the Exam 70-779.

Excel Master Class-Power Query-Consume and Transform Data

1. Course 1 - Power Query - Consume and Transform Data
2. Course 2 - Power Pivot - Data Modelling and DAX Formulas
3. Course 3 - Analysis and Visualization - Pivot Tables and Pivot Charts

Ian Littlejohn is a professional trainer and consultant. Ian has been working and training users on Microsoft Excel . In this series of courses Ian teaches and prepares users for the Microsoft Exam 70-779 Analyzing and Visualizing Data by using Microsoft Excel.  

The Microsoft MCSA BI Reporting is a valuable  certification for every Excel and Power BI user. The certification consists of two exams. Exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI and Exam 70-779 Analyzing and Visualizing Data with Microsoft Excel. Ian has created a series of courses that will assist all users to prepare for these exams.

Even, if you are not preparing for the exam you will find these courses a valuable resource to learn the most important and powerful features of Microsoft Power BI and Excel.

In this first course - Power Query - Consuming and Transforming Data we will cover:

1. Introduction and Course Content
2. Connecting to Data Sources - Learn how to connect and access data from a variety of different data sources including, files, databases, web URL and SQL Analysis Services
3. Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns
4. Advanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fields
5. Data Cleansing - Techniques and skills to clean up your data

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Excel.

Who this course is for:

• Excel users who want to learn how to import and transform data in Excel
• Learners who want to prepare themselves for Microsoft Exam 70-779
• Learners who want to learn advanced techniques for preparing data for analysis
• Get the course