Power Function in MS Excel 2013 - TED Learning

Microsoft Excel Power Query technology enhances the self-service business analytics experience in Excel by simplifying data discovery, access and collaboration. Power Query for Microsoft Excel functioned as an Excel add-in that can be downloaded and installed on Excel 2010 and 2013. When comes to data transformation, Power Query can be a good alternative to VBA as it does not require programming effort.

Upon completion of this Power Query training, participants should be able to:

• Connect to many new data sources, such as Facebook and Salesforce, to import the data
• Extract a preview of the data and load it to the Query Editor to define transformation steps that will allow you to transform the data to the format that meets your needs, such as remove, group, pivot or unpivot columns, and filter rows
• Find the data you need by searching the Power BI
• Simply click the Refresh All button on the Data ribbon to repeat the import and transformation of the data to your workbook

Delegates should be proficient users of Excel and be familiar with PivotTables.

1. Introduction to Microsoft Power Query for Excel Concepts and Components Compatible Data Sources Data Import Process
2. Import Data from External Data Sources Connect To and Query Compatible Data Sources Using the Default Excel Table Output
3. Transforming Table Data Filter, Sort and Group Data Group Rows Shape Data Replacing Values, Text Transforms, Number Transforms, Date and Time Transforms Data Aggregation Unpivoting Transposing a Table Work with Columns Name, Move, Split, Merge
4. Using the Query Editor Edit Query Steps Edit Query Step Settings Refresh a Query Combine Multiple Queries Merge and Append Queries Manage Queries
5. Shape Data from Multiple Data Sources Power Query and Table Relationships Table Links and Navigation Choose a Destination for your Data Add a Query to an Excel Worksheet Add a Query to the Data Model Advantages of using the Data Model
6. An Introduction to Advanced Queries Creating an Advanced Query Modify a Formula Power Query Formula Language