Spreadsheet Models for Managers

This reading is especially relevant for Session 1Excel Workbooks

To work in Excel, it pays to learn a few basic concepts and commands for making your way around Excel documents. Two fundamental categories of these concepts are the structure of Excel documents and how to move around inside them.

xcel documents are organized as workbooks, which consist of a set of worksheets. Knowing your way around workbooks makes life easier. This page contains a collection of some of the things you might find handy, but of course, you can get by without knowing most of this. It will be painful, but you can get by.

• Sheet tabs
• Active sheet
• Viewing the sheet tabs in a workbook
• Sheet tab shortcut menu
• Selecting a worksheet to view
• Controlling how many sheet tabs you see
• Changing the order of the sheets of a workbook
• Copying the sheets of a workbook
• Selecting sheets
• Deselecting sheets
• Reordering several sheets at once
• Selecting all sheets
• Inserting a new sheet
• Deleting sheets
• Renaming a sheet
• Moving a sheet to another workbook
• Copying a sheet to another workbook

Sheet tabs

The pages of a workbook are worksheets. The names of the pages in a workbook appear on the sheet tabs at the lower left of the screen. To change a worksheet name, double-click the sheet tab.