19/06/2024 – 21/06/2024 |
Price: $ 217.87 |
|
10/10/2024 – 12/10/2024 |
Price: $ 217.87 |
Course Outline Module 1: Reporting in Excel Module 2: Excel Tables Module 3: Pivot Tables and Pivot Charts Module 4: Dashboards Module 5: Hierarchies Module 6: The Excel Data Model
Data Analysis Fundamentals Using Excel
This module explains how to create a report in Excel
Lessons
• Filtering and Formatting Data
• Charts
Lab: Create an Excel report
• Filtering Excel Data
• Formatting Excel Data
• Create Excel Charts
This module explains how to create data tables in Excel
Lessons
• Excel Data Tables
• Summarizing Data
Lab: Create an Excel Table
• Create an Excel Table
• Summarize Excel Data
This module describes pivot tables and pivot charts and how to work with them.
Lessons
• Pivot Tables
• Pivot Charts
• Editing Pivot Tables and Pivot Charts
Lab: Importing Data from a CSV File
• Creating a Pivot Table
• Creating a Pivot Chart
• Editing Pivot Tables and Pivot Charts
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
Lessons
• Creating a Dashboard
• Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard
• Arranging Tables and Charts
• Slicing Data
• Data Analysis
This module describes hierarchies and time data.
Lessons
• Hierarchies
• Time Data
Lab: Creating Hierarchies
• Create a Hierarchy
• Configure Time data
• Create an Animated Time Chart
This module explores the Excel data model and looks at ways of extending it.
Lessons
• Using an Excel Data Model
• External Data
Lab: Explore an Excel Data Model
• Add Multiple Tables
• Create Relationships
• Add External Data