Hour 4. Managing Your Files and Workbooks

The topics in this hour cover:

How to create blank workbooks
How to open workbooks
The best ways to view your workbook
How to work with range names
The easiest methods for navigating workbooks and worksheets

In this hour, you learn how to create new workbooks, how to open saved files, and how to navigate through individual worksheets. At the end of this hour, you'll be able to find workbooks and open multiple files. Ready? Let's go.

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

Using Ranges

Changing Worksheet Views

Workbook and Worksheet Navigation Tools

Summary

Q&A

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