Description
Duration: 2 days
This 2-day course is intended for students to learn how to add analysis capabilities to Excel spreadsheets
IT professionals who are responsible for analyzing data with Excel would benefit from this course.
Once the student has completed this course, the student will be able to:
Create an Excel report
Create an Excel table
Create a pivot table and pivot chart
Create a dashboard and analyze data
Create Hierarchies
Create an Excel data model and connect to external data
Prerequisites
Students that are interested in this course, it is recommended that they have:
Basic knowledge of the Microsoft Windows operating system and its core functionality
Basic knowledge of Excel spreadsheets
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands-on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 9/23/2024 | 9/24/2024 | ||||
| 10/14/2024 | 10/15/2024 | ||||
| 11/4/2024 | 11/5/2024 | ||||
| 11/25/2024 | 11/26/2024 | ||||
| 12/16/2024 | 12/17/2024 | ||||
| 1/6/2025 | 1/7/2025 | ||||
| 1/27/2025 | 1/28/2025 | ||||
| 2/17/2025 | 2/18/2025 | ||||
| 3/10/2025 | 3/11/2025 | ||||
| 3/31/2025 | 4/1/2025 | ||||
| 4/21/2025 | 4/22/2025 | ||||
| 5/12/2025 | 5/13/2025 | ||||
| 6/2/2025 | 6/3/2025 | ||||
| 6/23/2025 | 6/24/2025 | ||||
| 7/14/2025 | 7/15/2025 | ||||
| 8/4/2025 | 8/5/2025 | ||||
| 8/25/2025 | 8/26/2025 | ||||
| 9/15/2025 | 9/16/2025 | ||||
| 10/6/2025 | 10/7/2025 | ||||
| 10/27/2025 | 10/28/2025 | ||||
| 11/17/2025 | 11/18/2025 | ||||
| 12/8/2025 | 12/9/2025 | ||||
| 12/29/2025 | 12/30/2025 | ||||
| 1/19/2026 | 1/20/2026 |
Curriculum
Module 1: Reporting in Excel
Lessons
Filtering and Formatting Data
Charts
Lab: Create an Excel report
Filtering Excel Data
Formatting Excel Data
Create excel Charts
Module 2: Excel Tables
Lessons
Excel Data Tables
Summarizing Data
Lab: Create an Excel Table
Create an Excel Table
Summarize Excel Data
Module 3: Pivot Tables and Pivot Charts
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
Module 4: Dashboards
Lessons
Creating a Dashboard
Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard
Arranging Tables and Charts
Slicing Data
Data Analysis
Module 5: Hierarchies
Lessons
Hierarchies
Time Data
Lab: Creating Hierarchies
Create a Hierarchy
Configure Time data
Create an Animated Time Chart
Module 6: The Excel Data Model
Lessons
Using an Excel Data Model
External Data
Lab: Explore an Excel Data Model
Add Multiple Tables
Create Relationships
Add External Data
