BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART:20180222T140000Z
DTEND:20180222T220000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:COMMUNITY EVENT: 2016 Excel Training
DESCRIPTION:Get and Transform\; Power Query\n\n8:00 a.m. - 11:30 a.m. (3.5 hours)\n\n \nExcel 2016 includes a powerful new set of features called \n\nGet & Transform\, which provides fast\, easy data gathering and shaping capabilities. These tools enable you to connect\, combine\, and refine data sources to meet your analysis needs. These features are also used in Power BI\, and in the Power Query Add-In available for previous versions of Excel. \n\n\n\n\n Power Query Basics\n Column-Level Actions\n Table ACtions\n Importing Data from Files\, Databases\n Unpivoting\n Common Transformations\n Custom Columns\n Grouping and Aggregating\n Managing Queries\n Reusing Query Steps\n Merge & Append Queries\n Practical applications\n Replace VLOOKUP\n\n\n\n \n\nGetting Started with the Data Model & Power Pivot\n\n12:30 - 4:00 p.m. (3.5 hours) \n\n \n\nPower Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot\, you can mash up large volumes of data from various sources\, perform information analysis rapidly\, and share insights easily.\n\n\n\n Working with the Data Model\n Replace VLOOKUP\n Database Terms & Concepts\n Linking Excel Tables to Power Pivot\n Loading Data from Relational Databases & files\n Building table relationships\n Calculated columns\n Measures\n Basic DAX functions\n Understanding Evaluation Contexts\n Creating Pivot Tables from the Data Model
X-ALT-DESC;FMTTYPE=text/html:\n
\n
Get and Transform\; Power Query
\n\n
8:00 a.m. - 11:30 a.m. \; (3.5 hours)
\n \;
\nExcel 2016 includes a powerful new set of features called \;
\n\n
Get &\; Transform\, which provides fast\, easy data gathering and shaping capabilities. These tools \;enable you to connect\, combine\, and refine data sources to meet your analysis needs. These features are also used in \;Power BI\, and in the \;Power Query Add-In \;available for previous versions of Excel. \; \;
\n
\n
\n - Power Query Basics
\n - Column-Level Actions
\n - Table ACtions
\n - Importing Data from Files\, Databases
\n - Unpivoting
\n - Common Transformations
\n - Custom Columns
\n - Grouping and Aggregating
\n - Managing Queries
\n - Reusing Query Steps
\n - Merge &\; Append Queries
\n - Practical applications
\n - Replace VLOOKUP
\n
\n
\;
\n\nGetting Started with the Data Model &\; Power Pivot
\n\n12:30 - 4:00 p.m. (3.5 hours) \; \;
\n \;
\n\nPower Pivot \;is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With \;Power Pivot\, \;you can mash up large volumes of data from various sources\, perform information analysis rapidly\, and share insights easily.
\n\n\n
\n - Working with the Data Model
\n - Replace VLOOKUP
\n - Database Terms &\; Concepts
\n - Linking Excel Tables to Power Pivot
\n - Loading Data from Relational Databases &\; files
\n - Building table relationships
\n - Calculated columns
\n - Measures
\n - Basic DAX functions
\n - Understanding Evaluation Contexts
\n - Creating Pivot Tables from the Data Model
\n
\n