Lesson 1 - Using Large Worksheets
Increasing the Magnification
Decreasing the Magnification
Changing the Magnification of a Range
Switching to Full Screen View
Splitting the Window
Removing Split Windows
Freezing the Panes
Unfreezing the Panes
Lesson 2 - Working with Multiple Worksheets
Using Multiple Worksheets
Navigating between Worksheets
Selecting Worksheets
Renaming Worksheets
Selecting Multiple Worksheets
Coloring Worksheet Tabs
Inserting Worksheets
Deleting Worksheets
Printing Selected Worksheets
Lesson 3 - Managing Worksheets
Copying Worksheets
Moving Worksheets
Using Grouped Worksheets
Moving Data between Worksheets
Copying Data between Worksheets
Creating 3-D Formulas
Using 3-D Ranges in Functions
Workshop Information Page |
Lesson 4 - Using Range Names
Working with Range Names
Jumping to a Named Range
Assigning Names
Using Range Names in Formulas
Creating Range Names from Headings
Applying Range Names
Deleting Range Names
Using Range Names in 3-D Formulas
Creating 3-D Range Names
Using 3-D Range Names in Formulas
Lesson 5 - Using Other Functions
Using Function Arguments
Using Financial Functions
Using Logical Functions
Using Date Functions
Formatting Dates
Revising Formulas
|
