Technology: SQL Server
Software Assurance Value:
The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets.
After completing this course, students will be able to:
This course is intended for anyone responsible for analyzing data with Excel.
Module 1: Reporting in Excel
This module explains how to create a report in Excel
Lab: Create an Excel report
After completing this module, students will be able to:
Module 2: Excel Tables
This module explains how to create data tables in Excel
Lab: Create an Excel Table
Module 3: Pivot Tables and Pivot Charts
This module describes pivot tables and pivot charts and how to work with them.
Lab: Importing Data from a CSV File
Module 4: Dashboards
This module describes Excel dashboards, how to create them and the role in data analysis in Excel pivot tables.
Lab: Create a Dashboard
Module 5: Hierarchies
This module describes hierarchies and time data.
Lab: Creating Hierarchies
Module 6: The Excel Data Model
This module explores the Excel data model and looks at ways of extending it.
Lab: Explore an Excel Data Model
Before attending this course, students must have: