Excel 2007 Foundation

Course Description

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel® 2007 to manage, edit, and print data.

View other Excel Courses available
1 days
Contact us for pricing

Prerequisites

To effectively understand this course, we recommend that you take the Microsoft Office Windows XP or Vista Introduction course or have equivalent knowledge.

Getting Started

Starting Out
What is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel

About Workbooks

Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook

Exploring your Workbook

Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature

Getting Help in Excel 2007

Using the Help Screen
About Online Help
About Offline Help

The New Interface

The Quick Access Toolbar
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
The Home Ribbon
Clipboard
Font
Alignment
Number
Style
Cells
Editing

The Insert Ribbon

Tables
Charts
Illustrations
Shapes
Links
Text

The Page Layout Ribbon

Themes
Page Setup
Scale to Fit
Sheet Options
Arrange
Step-By-Step
Skill Sharpener

The Formulas Ribbon

The Function Library
Defined Names
Formula Auditing
Calculation
Step-By-Step
Skill Sharpener

The Data Ribbon

Get External Data
Connections
Sort and Filter
Data Tools
Outline

The Review Ribbon

Proofing
Comments
Changes

Excel Basics

Working With Excel 2007
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet

Basic Excel Features

What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas

Moving your Data

Dragging and Dropping Cells
How to Cut, Copy, and Paste Cells
How to Cut, Copy, and Paste Multiple Cells and Items
How to Use Paste Special
How to Insert and Delete Cells, Rows, and Columns
Using Undo, Redo, and Repeat

Smart Tags and Options Buttons

What Are Smart Tags?
The Error Option Button
The AutoFill Option Button
The Paste Option Button
Setting Smart Tag Options

Editing Tools

Using AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments

Editing Your Workbook

Modifying Cells and Data
Changing the Size of Rows or Columns
Adjusting Cell Alignment
Rotating Text
Creating Custom Number and Date Formats

Cell Formatting

Conditional Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting

Enhancing a Worksheet’s Appearance

Adding Patterns and Colors
Adding Borders
Working with Styles

Working With Charts

Creating a Chart
Formatting a Chart
Modifying Charts with the Layout Ribbon
Manipulating a Chart
Enhancing a Chart with Shapes and Graphics

Working with Charts, Part 2

Changing the Type of Chart
Changing the Source Data
Working with the Chart Axis and Data Series
Saving a Chart as a Template

Printing and Viewing your Workbook

Using the View Ribbon
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview

Managing a Single Window

Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane

Managing Multiple Windows

Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace

Printing your Workbook

Opening Print Preview
Using the Print Preview Ribbon
Quick Printing
The Print Dialogue
Using Page Setup

Excel 2007Microsoft Excel 2007