10994 Data Analysis Fundamentals using Excel

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

Learning Objectives

After completing this course, students 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
Data Analysis Fundamentals using Excel

Course Outline

1 - REPORTING IN EXCEL

Filtering and Formatting Data
Charts
Lab : Create an Excel report

2 - EXCEL TABLES

Excel Data Tables
Summarizing Data
Lab : Create an Excel Table

3 - PIVOT TABLES AND PIVOT CHARTS

Pivot Tables
Pivot Charts
Editing Pivot Tables and Pivot Charts
Lab : Importing Data from a CSV File

4 - DASHBOARDS

Creating a Dashboard
Data Analysis in Excel Pivot Tables
Lab : Create a Dashboard

5 - HIERARCHIES

Hierarchies
Time Data
Lab : Creating Hierarchies

6 - THE EXCEL DATA MODEL

Using an Excel Data Model
External Data
Lab : Explore an Excel Data Model

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Contact Us For Price

Course Length: 2 Days

1. Choose a Date | 2. Click Enroll Now

Dec 28

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Feb 11

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Apr 08

Online LIVE, 8:00 am - 4:00 pm
NHCLC G2R

Jun 03

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Jul 08

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Need Help Picking the Right Course? Give us a call! 781-388-0026