Chapter 1 - Viewing and Modifying Worksheets
Chapter 2 - Modifying Worksheets
Chapter 3 - Named Ranges
Chapter 4 - Enhancing Worksheets
Chapter 5 - Using and Creating Templates
Chapter 1 - Viewing and Modifying Worksheets
 Opening Excel
Changing the Zoom Setting
Zooming in on a Worksheet
Splitting a Worksheet
Freezing Labels in a Row
Hiding and Unhiding Columns and Rows
Chapter 2 - Modifying Worksheets
Inserting and Deleting Selected Cells
Inserting and Deleting Columns and Rows
Using the Offset Clipboard
Chapter 3 - Named Ranges
Adding a Named Range
Using Labels to Name a Range
Inserting a Row in a Named Range
Using a Named Range in a Formula
Printing a Selection
Changing Page Scaling
Chapter 4 - Enhancing Worksheets
Applying Cell Borders and Shading
Using Copy Special Command
Using Paste Special Command
Displaying Gridlines
Rotating Text and Changing Indents
Defining and Applying a Style
Merging Styles
Applying Autoformats
Chapter 5 - Using and Creating Templates
Understanding Templates
Using a Template
Creating Templates
Using Save As
Applying Templates
|
|
