COURSE MODULE

Microsoft Excel for Data Analysis

Use Excel to organize, calculate and analyze data.

13 Lessons

2 Module

LEARNING PATH

Module Lessons

Explore the learning materials and work through the lessons in this module.

13 Lessons

Available

LESSON 1

Excel Interface

Excel Interface Microsoft Excel is one of the most widely used tools for data analysis. It allows analysts to enter,...

Lesson 1 of 13 View Lesson

Available

LESSON 2

Data Entry

Data Entry Data entry is one of the first practical skills every Excel data analyst needs to understand. Before data...

Lesson 2 of 13 View Lesson

Available

LESSON 3

Formatting Datasets

Formatting Datasets Formatting is an important part of working with datasets in Microsoft Excel. Good formatting makes information easier to...

Lesson 3 of 13 View Lesson

Available

LESSON 4

Sorting and Filtering

Lesson 4: Sorting and Filtering Sorting and filtering are two of the most important tools used when working with datasets...

Lesson 4 of 13 View Lesson

Available

LESSON 5

Excel Formulas

Lesson 5: Excel Formulas Excel formulas are one of the most important features for anyone learning data analysis with Microsoft...

Lesson 5 of 13 View Lesson

Available

LESSON 6

Functions

Lesson 6: Functions Excel functions are predefined formulas that make it easier to perform calculations and analyze large amounts of...

Lesson 6 of 13 View Lesson

Available

LESSON 7

IF Statements

Lesson 7: IF Statements The IF function is one of the most important logical functions in Microsoft Excel. It allows...

Lesson 7 of 13 View Lesson

Available

LESSON 8

SUMIF and COUNTIF

Lesson 8: SUMIF and COUNTIF In data analysis, analysts often need to answer questions such as: How much did each...

Lesson 8 of 13 View Lesson

Available

LESSON 9

Lookup Functions

Lookup Functions in Microsoft Excel Lookup functions are some of the most useful tools in Microsoft Excel for data analysis....

Lesson 9 of 13 View Lesson

Available

LESSON 10

Tables

Tables in Microsoft Excel Excel Tables are one of the most useful features for organizing, managing and analyzing datasets. A...

Lesson 10 of 13 View Lesson

Available

LESSON 11

Pivot Tables

Pivot Tables in Microsoft Excel Pivot Tables are one of the most powerful tools in Microsoft Excel for data analysis....

Lesson 11 of 13 View Lesson

Available

LESSON 12

Charts

Charts in Microsoft Excel Charts are visual tools used to represent data graphically. Instead of examining rows and columns of...

Lesson 12 of 13 View Lesson

Available

LESSON 13

Basic Dashboards

Basic Dashboards A dashboard is a visual interface that brings important data, key performance indicators, charts, summaries, and filters together...

Lesson 13 of 13 View Lesson