Excel 2010 Training Beginner
Expand All | Collapse All
| Chapters |
Courseware |
Online
Learning |
Skills Assessments |
1. Program Fundamentals
| Starting Excel |
Demo |
Demo |
Demo |
| What’s New in Excel 2010 |
- |
- |
- |
| Understanding the Excel Program Window |
- |
- |
- |
| Giving Commands |
- |
- |
- |
| Using Command Shortcuts |
- |
- |
- |
| Creating a New Workbook |
- |
- |
- |
| Opening a Workbook |
- |
- |
- |
| Previewing and Printing a Worksheet |
- |
- |
- |
| Saving a Workbook |
- |
- |
- |
| Closing a Workbook |
- |
- |
- |
| Using Help |
- |
- |
- |
| Exiting Excel |
- |
- |
- |
2. Getting Started with Worksheets
| Navigating a Worksheet |
Demo |
Demo |
Demo |
| Entering Labels and Values |
- |
- |
- |
| Selecting a Cell Range and Entering Data in a Cell Range |
- |
- |
- |
| Overview of Formulas and Cell References |
- |
- |
- |
| Entering Formulas |
- |
- |
- |
| Entering Content Automatically |
- |
- |
- |
3. Editing a Worksheet
| Editing Cell Contents |
Demo |
Demo |
Demo |
| Copying and Moving Cells |
- |
- |
- |
| Controlling How Cells are Copied or Moved |
- |
- |
- |
| Collecting Items to Move or Copy |
- |
- |
- |
| Checking Your Spelling |
- |
- |
- |
| Inserting Cells, Rows, and Columns |
- |
- |
- |
| Deleting Cells, Rows, and Columns |
- |
- |
- |
| Using Undo and Redo |
- |
- |
- |
| Finding and Replacing Content |
- |
- |
- |
| Adding Comments to Cells |
- |
- |
- |
4. Formatting a Worksheet
| Formatting Text |
Demo |
Demo |
Demo |
| Formatting Values |
- |
- |
- |
| Adjusting Row Height and Column Width |
- |
- |
- |
| Working with Cell Alignment |
- |
- |
- |
| Adding Cell Borders and Background Colors |
- |
- |
- |
| Copying Formatting |
- |
- |
- |
| Applying and Removing Cell Styles |
- |
- |
- |
| Creating and Modifying Cell Styles |
- |
- |
- |
| Using Document Themes |
- |
- |
- |
| Applying Conditional Formatting |
- |
- |
- |
| Creating and Managing Conditional Formatting Rules |
- |
- |
- |
| Finding and Replacing Formatting |
- |
- |
- |
