Webinars > All COMPUTERS / SOFTWARE Categories > Office Software Webinars Excel® Power Tools: Power Query and Power Pivot WebinarThis LIVE, virtual, hands-on data management course provides the essential 21st century Excel training you need to get ahead. It goes beyond the fundamentals of PivotTables to explore more advanced topics, such as calculated fields, calculated items and conditional formatting. Course Description/AgendaAccelerate your spreadsheet data analysis proficiency. This LIVE, virtual, hands-on data management course provides the essential 21st century Excel training you need to get ahead. It goes beyond the fundamentals of PivotTables to explore more advanced topics, such as calculated fields, calculated items and conditional formatting. Then it brings you up-to-date and up-to-speed with Excel for Office 365 Power Tools, including Power Query and Power Pivot. With Excel Power Tools, you’ll be equipped to analyze an unlimited amount of data, combine multiple data sources into a single report, analyze data across multiple tables and create more sophisticated calculations. What You Will Learn
Workshop AgendaProgram time: 3 Hours Session 1: Building Advanced PivotTables With Calculated Items and FieldsLook at PivotTable fundamentals, then push the limits of built-in pivots by customizing them with calculated items, calculated fields and conditional formatting.
Session 2: Power Query Including the M languageLearn how Power Query helps you automate the process of importing, transforming and cleansing your data. Building an effective Power Query that can be used over and over on new datasets will save hours of effort and make you a more effective analyst.
Session 3: Introduction to Power Pivot — Gathering DataBusiness analysts use Power Query to prepare data, then they use Power Pivot to build reports. Power Pivot is an Excel Add-in used to analyze huge amount of data from multiple sources. Power Pivot has a different calculation engine from Excel which makes data analysis faster.
|
Search similar training Email this page Print this document
|
||||||||||||||
All Date/Location Information |