Kıbrıs Microsoft Excel 2013 Data Analysis and Power Tools Part 2 Eğitimi

Please note that this course is not suitable for new Excel users

• Attendance on QA's Working with Data in Microsoft Excel 2013 Part 1
• Able to import data and work with the Data Model and Relationship
• Be able to create formulas using standard aggregate functions

Dual monitor setup is required for when attending this course via the QA Attend from Anywhere delivery method.

Learning Outcomes

• Create PivotTables and analyse data
• Connect to and shape external data using Power Query
• Use PowerPivot for data connection and analysis
• Use Power Map to create visualisations of geo-dat

Course Outline

Lesson 1: Create and Work With PivotTables

• Creating PivotTables from tables
• Working with PivotTables to create views and analysis
• Dynamic Filters with Slicers and Timelines
• Use the Data Model to create PivotTables
• PivotTables from related data sources

Lesson 2: Introduction to Power Query for Excel

• What is Power Query?
• Power Query Data Sources
• Data Import Process and Query Editor Overview
• Data Transforms using the Query Editor
• Column, Row and Calculated Transform Actions
• Combining Data Sources as a Mash Up

Lesson 3: PowerPivot

• Concepts and Components
• Working with the Manage Console
• Creating and Editing Data Relationships
• Calculated Items and KPIs
• Creating PivotTables
• Dashboards using PowerPivot

Lesson 4: Power Map

• Overview of Power Map
• What is geo-data?
• Creating Maps and Applying Options
• Tours and Scenes in Power Map
• Exporting Maps to other applications