Excel 2007 Training Beginner

Title Banner
Expand All | Collapse All

Chapters	Courseware	Online Learning	Skills Assessments

1. The Fundamentals

Starting Excel 2007	Demo	Demo	Demo
What’s New in Excel 2007	-	-	-
Understanding the Excel Program Screen	-	-	-
Understanding the Ribbon	-	-	-
Using the Office Button and Quick Access Toolbar	-	-	-
Using Keyboard Commands	-	-	-
Using Contextual Menus and the Mini Toolbar	-	-	-
Using Help	-	-	-
Exiting Excel 2007	-	-	-

2. Worksheet Basics

Creating a New Workbook	Demo	Demo	Demo
Opening a Workbook	-	-	-
Navigating a Worksheet	-	-	-
Entering Labels	-	-	-
Entering Values	-	-	-
Selecting a Cell Range	-	-	-
Overview of Formulas and Using AutoSum	-	-	-
Entering Formulas	-	-	-
Using AutoFill	-	-	-
Understanding Absolute and Relative Cell References	-	-	-
Using Undo, Redo and Repeat	-	-	-
Saving a Workbook	-	-	-
Previewing and Printing a Worksheet	-	-	-
Closing a Workbook	-	-	-

3. Editing a Worksheet

Editing Cell Contents	Demo	Demo	Demo
Cutting, Copying, and Pasting Cells	-	-	-
Moving and Copying Cells Using the Mouse	-	-	-
Using the Office Clipboard	-	-	-
Using the Paste Special Command	-	-	-
Checking Your Spelling	-	-	-
Inserting Cells, Rows, and Columns	-	-	-
Deleting Cells, Rows, and Columns	-	-	-
Using Find and Replace	-	-	-
Using Cell Comments	-	-	-
Tracking Changes	-	-	-

4. Formatting a Worksheet

Formatting Labels	Demo	Demo	Demo
Formatting Values	-	-	-
Adjusting Row Height and Column Width	-	-	-
Working with Cell Alignment	-	-	-
Adding Cell Borders, Background Colors and Patterns	-	-	-
Using the Format Painter	-	-	-
Using Cell Styles	-	-	-
Using Document Themes	-	-	-
Applying Conditional Formatting	-	-	-
Creating and Managing Conditional Formatting Rules	-	-	-
Finding and Replacing Formatting	-	-	-

Popular Courses

FREE QUICK REFERENCES

Sign up to download Quick References for your favorite software programs - 100% spam free.

Copyright © 2010 CustomGuide Inc. - All rights reserved.