Microsoft® Excel Crash Course:  Learn Excel in Two Days! 

Length: 2 days
Software Version:  2007/2010
Prerequisites: Familiarity with the Windows operating system.
Course Level:  Introductory through intermediate topics

Course Description:  The first day of this course, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. On the second day, you will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

 Course Objectives:

  • create a basic worksheet by using Microsoft Excel 2010.
  • perform calculations in an Excel worksheet.
  • modify an Excel worksheet.
  • modify the appearance of data within a worksheet.
  • manage Excel workbooks.
  • print the content of an Excel worksheet.

  • use advanced formulas.

  • organize worksheet and table data using various techniques.

  • create and modify charts.

  • analyze data using PivotTables, Slicers, and PivotCharts.

  • insert and modify graphic objects in a worksheet.

  • customize and enhance workbooks and the Microsoft Office Excel environment.

     

Course Content Day 1:

 

Lesson 1: Getting Started with Excel

Identify the Elements of the Excel Interface

Navigate and Select Cells in Worksheets

Customize the Excel Interface

Create a Basic Worksheet

 

Lesson 2: Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet

Insert Functions in a Worksheet

Reuse Formulas

 

Lesson 3: Modifying a Worksheet

Edit Worksheet Data

Find and Replace Data

Manipulate Worksheet Elements

 

Lesson 4: Modifying the Appearance of a Worksheet

Apply Font Properties

Add Borders and Colors to Cells

Align Content in a Cell

Apply Number Formatting

Apply Cell Styles

 

Lesson 5: Managing an Excel Workbook

Manage Worksheets

View Worksheets and Workbooks

 

Lesson 6: Printing Excel Workbooks

Define the Page Layout

Print a Workbook

 

Course Content Day 2:

 

Lesson 1: Calculating Data with Advanced Formulas

Apply Cell and Range Names

Calculate Data Across Worksheets

Use Specialized Functions

Analyze Data with Logical and Lookup Functions

 

Lesson 2: Organizing Worksheet and Table Data

Create and Modify Tables

Format Tables

Sort or Filter Data

Use Functions to Calculate Data

 

Lesson 3: Presenting Data Using Charts

Create a Chart

Modify Charts

Format Charts

 

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report

Filter Data Using Slicers

Analyze Data Using PivotCharts

 

Lesson 5: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt

Draw and Modify Shapes

Illustrate Workflow Using SmartArt Graphics

Layer and Group Graphic Objects

 

Lesson 6: Customizing and Enhancing the Excel Environment

Customize the Excel Environment

Customize Workbooks

Manage Themes

Create and Use Templates