Using Large Worksheets
Changing Range Magnification
Splitting the Window
Working with Multiple Worksheets
Navigating between Worksheets
Managing Worksheets
Using Grouped Worksheets
Creating 3-D Formulas
Using 3-D Ranges in Functions
Using Multiple Workbooks
Opening Multiple Workbook Windows
Cascading Open Workbook Windows
Tiling Opern Workbook Windows
Copying Data between Workbooks
Using Paste Special
Copying Values and Formulas between Worksheets
Performing Mathematical Operations
Using Range Names
Using Range Names in Formulas
|
|
Creating 3-D Range Names
Using 3-D Range Names in Formulas
Managing Data
Sorting Lists
Finding and Replacing Data
Finding and Replacing Cell Formats
Creating Charts
Creating Chart - Chart Wizard
Using Chart Options
Formatting Charts
Adding Chart Titles
Changing the Text Orientations
Creating an Exploded Pie Chart
Adjusting the 3-D View
Drawing an Object
Working with Drawing Objects
Adding to and Selecting Text in an Object
Changing and Removing the Fill Color
Changing the Font Color
|
|
