Module 1: Getting Started
Starting Out
What is Microsoft Excel 2007?
Opening Microsoft Excel
Interacting with Excel
Closing Excel
Step-By-Step
About Workbooks
Creating a New Workbook
Opening a Workbook
Saving a Workbook
About Excel File Types
Closing a Workbook
Step-By-Step
Skill Sharpener
Exploring your Workbook
Using Worksheets
The Active Cell
Selecting Cells
Exploring a Worksheet
The Zoom Feature
Step-By-Step
Skill Sharpener
Getting Help in Excel 2007
Using the Help Screen
About Online Help
About Offline Help
Step-By-Step
Skill Sharpener
Module 2: The New Interface
The Quick Access Toolbar
The Default Buttons
Adding Buttons
Removing Buttons
Customizing the Toolbar
Step-By-Step
Skill Sharpener
The Home Ribbon
Clipboard, Font, Alignment, Number, Style, Cells, Editing
Step-By-Step
Skill Sharpener
:: Course EXC07B ::
The Insert Ribbon
Tables, Charts, Illustrations, Shapes, Links, Text
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
The Review Ribbon
Proofing , Comments, Changes
Step-By-Step
Skill Sharpener
Module 3: Excel Basics
Working With Excel 2007
Columns, Rows, Cells, and Ranges
Creating Worksheet Labels
Entering and Deleting Data
Printing Your Worksheet
Step-By-Step
Skill Sharpener
Basic Excel Features
What is AutoFill?
What is AutoSum?
What is AutoComplete?
Working with Basic Formulas
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
:: Course EXC07B ::
Editing Tools
Using AutoCorrect
Using Spell Check
Using Find and Replace
Adding Comments
Step-By-Step
Skill Sharpener
Module 4: 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
Step-By-Step
Skill Sharpener
Cell Formatting
Conditional Formatting
The Format Painter
Cell Merging and AutoFit
Find and Replace Formatting
Step-By-Step
Skill Sharpener
Enhancing a Worksheet’s Appearance
Adding Patterns and Colors
Adding Borders
Working with Styles
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
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
Step-By-Step
Skill Sharpener
Module 5: Printing and Viewing your Workbook
Using the View Ribbon
Using Normal View
Using Full Screen View
Using Page Layout View
Page Break Preview
Step-By-Step
Skill Sharpener
:: Course EXC07B ::
Managing a Single Window
Creating a New Window
Hiding a Window
Unhiding a Window
Freezing a Pane
Step-By-Step
Skill Sharpener
Managing Multiple Windows
Switching Between Open Workbooks
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling, Resetting a Window, and Saving a Workspace
Step-By-Step
Skill Sharpener
Printing your Workbook
Opening Print Preview
Using the Print Preview Ribbon
Quick Printing
The Print Dialogue
Using Page Setup
Step-By-Step
Skill Sharpener
Programme scope, delivery arrangements and suitability are confirmed during enquiry.