Available 24/7
Professional Instruction
Free Training Materials
Course Details
The Data Analysis Fundamentals Using Excel course will train students on how add data analysis capabilities to their Excel spreadsheets. The course is designed for any Excel user who needs to perform basic data analysis.
Upon completion of the course, users will be able to:
- Build a report in Excel
- Create Excel Tables
- Work with Pivot Tables and Pivot Charts
- Create Excel Dashboards
- Understand Heirachies
- Learn about the Excel Data model
Section 1: Reporting in Excel
This section explains how to Creating a report in Excel
Lessons
• Filtering and Formatting Data
• Charts
Lab : Creating an Excel report
• Filtering Excel Data
• Formatting Excel Data
• Creating excel Charts
Section 2: Excel Tables
This section explains how to Creating data tables in Excel
Lessons
• Excel Data Tables
• Summarizing Data
Lab : Creating an Excel Table
• Creating an Excel Table
• Summarizing Excel Data
Section 3: Pivot Tables and Pivot Charts
This section 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
Section 4: Dashboards
This section describes Excel dashboards, how to Creating them and the role in data analysis in Excel pivot tables.
Lessons
• Creating a Dashboard
• Data Analysis in Excel Pivot Tables
Lab : Creating a Dashboard
• Arranging Tables and Charts
• Slicing Data
• Data Analysis
Section 5: Hierarchies
This section describes hierarchies and time data.
Lessons
• Hierarchies
• Time Data
Lab : Creating Hierarchies
• Creating a Hierarchy
• Configuring Time data
• Creating an Animated Time Chart
Section 6: The Excel Data Model
This section 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
• Adding Multiple Tables
• Creating Relationships
• Adding External Data
Please check the course description to find prerequisite information.
MOC On-Demand: 10994-Data Analysis Fundamentals Using Excel
On-Demand Training Course
90/month licence
- 24/7 Access
- Hands-On Practice Exercises
- Free Repeats
- Professional Instruction
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Free Repeats
Learn At Your Pace
No Travel
Professional Instruction
Affordable Pricing
Group Discounts
