Curriculum
Course: Excel For Data Analyst
Login

Curriculum

Excel For Data Analyst

Section 1.1 Course Overview

0/12

Section 2.1 Common office features

0/41

Section 3.1 Creating and Managing Workbooks

0/42

Section 4.1 Entering Simple Formulas

0/27

Section 5.1 Displaying Data in Charts

0/21

Section 6.1 Excel Live Projects

0/7

Section 7.1 Preparing for MOS Associate Certification

0/16

Section 8.1 Managing Workbooks

0/19

Section 9.1 Filling Cells Based on Existing Data

0/30

Section 10.1 Advanced Formulas and Macros

0/57

Section 11.1 Advanced and Charts and Tables

0/29

Section 12.1 Preparing for MOS Expert Certification

0/18

A.1 TestOut Certified: Microsoft Excel Advacnced Certification

0/13

Glossary

0/1
Text lesson

1.1.1 The Microsoft Office Suite

As you study this introductory section, answer the following questions:

 

  • Which features of Excel do you already feel comfortable using?
  • Which features are you less familiar with?
  • How can you use Excel for personal projects, such as data or financial analysis?

 

This section introduces you to Microsoft Excel and provides an overview of the features you will be learning to use. In this section, you will be introduced to the following general tasks:

 

  • Create workbooks.
  • Manage worksheets.
  • Enter data.
  • Protect worksheets.
  • Print worksheets.
  • Format cells.
  • Enter simple formulas.
  • Use advanced functions.
  • Create charts and graphs.
  • Analyze data in tables.
  • Summarize complex data using PivotTables and outlines.