Microsoft Office Excel 2007 Level 2

DSOC0272—One Day Training Class

Elements of this syllabus are subject to change.

Overview

This course introduces some useful functions designed to sum or count data conditionally, including two functions that are new to version 2007. This course also includes the IF function, some text functions and utilities, and tips for working with dates. This course introduces Excel 2007 tables and includes sorting, filtering, and table formats. Conditional formatting of data and creating and modifying charts are also topics included.

Audience

The target students for this course are those who already have the skills presented in Microsoft Office Excel 2007 Level 1 and are ready to take it up a notch.

Prerequisites

Before starting this course, students are recommended to take the following course or possess equivalent knowledge: Microsoft Office Excel 2007: Level 1.

At Course Completion

After completing this course, students will be able to:

• Recall how to create formulas, use the Insert Function tool, and copy formulas so they don't change
• Use more built-in functions than before, including IF
• Join data and parse data
• Explain how dates work, format dates in a wide variety of ways, and do math with dates
• Use Excel 2007 tables to sort, filter and calculate
• Apply conditional formatting
• Create and modify charts

Training Course Content

Module 1: Review

• Functions
• Copying Formulas
• Creating Formulas That Don’t Change When Copied
• The Insert Function Tool
• The COUNTIF Function
• Creating Formulas that Refer to Cells on Other Worksheets

Module 2: Conditional Calculations Using Excel

• Functions to use when the Answer is Conditional

Module 3: Text Functions and Utilities

• Joining Text Strings Together
• Converting Formulas to Values
• Parsing Data
• Changing the Case of Text to Upper, Lower, or Proper

Module 4: Working with Dates

• Entering Dates and Times
• Formatting Dates and Times
• Calculations Involving Dates and Times

Module 5: Creating and Using Data in Tables

• Elements of an Excel Table
• How to Create a Table
• Making Selections in a Table
• Sorting
• Filtering
• How to Insert and Delete Table Rows and Columns
• Remove Duplicate Rows from a Table
• How to Use a Calculated Column
• Using Structured References
• How to Display and Calculate a Total Row
• How to Create a Custom Table Style
• Conditional Formatting

Module 6: Charts

• Embedded Charts and Chart Sheets
• Create Charts
• Modify Charts