# Excel 2007 Training Beginner

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 - - -