Multiple Sheets and Files
Grouping Sheets
Using Groups
3-D Formulas
3-D Ranges
Multiple Files
External Cell Addresses
Files on the Task Bar
Spreadsheet Consolidation
Personalized Menus (A Review)
Consolidating Files with Identical Structures
Updating the Consolidation
Consolidating Files with Similar Structures
Saving the Workspace
Opening a Workspace
Formula Construction
Formula Construction
Absolute References
Names
Naming Ranges
Naming Rules
What are Names Good For?
Names from Existing Text
Modifying Names
Natural Language Formulas
Some Very Interesting Functions
Decision making functions
AND(), OR(), VLOOKUP()
The Edit Formula Button and the Formula Palette
Push Button Sorting
Some More Useful Functions
PMT(), ROUND(), COUNT()
COUNTA(), SUMIF()
Advanced Formatting
Copy and Paste Formats
The Format Painter
Styles
Creating Styles
Applying Styles
Modifying Styles
Merging Styles
|
Advanced Alignment Options
Horizontal Alignment
Vertical Alignment
Text Control Options
Merge and Center
Orientation
Conditional Formatting
Hiding/Unhiding Columns Rows
Hiding and Unhiding Worksheets
Protection
Worksheet Protection
Workbook Protection
Charting Basics
About Charts
Modifying a Chart
Chart Toolbar
Printing a Chart
Drawing Tool Basics
Rectangle, Ellipse, Line, Arrow
Text Boxes
Moving and Sizing Drawn Objects
Customizing Excel
Controlling Screen Display
Customizing Toolbars
Moving Toolbars
Hidden Toolbar Buttons
Adding/Removing Buttons
Moving Toolbars and Menus
Custom Fill Lists
View Settings
Gridline Display
Controlling Zeros
Appendix
Naming Formulas
Macro Basics
Relative vs. Absolute Macro Recording
Viewing the Macro Code
|