Working with Workbooks and Worksheets

An Excel workbook is made up of individual worksheets. By default, three worksheets are set up with each workbook file. You can add or delete as many worksheets as you want. Each worksheet is an individual portion of the workbook and does not need to link to the other worksheets.

Part I: Excel Basics

Hour 1. Getting Started

Hour 2. Entering Data

Hour 3. Organizing Your Files

Hour 4. Managing Your Files and Workbooks

Creating a Blank Workbook

Opening an Existing Workbook

Making Use of the Getting Started Task Pane

Searching for the Right File

Working with Workbooks and Worksheets

Getting a View of the Workbook

Changing Worksheet Views

Workbook and Worksheet Navigation Tools

Hour 5. Letting Excel Do the Math

Hour 6. Using Excel Templates

Hour 7. Printing Your Workbook

Part IV: Advanced Excel Techniques

Part V: Creating and Using Databases in Excel

Part VI: At the Office and on the Internet/Intranet