Multiple Sheets and Files
Grouping Sheets
Using Groups
3-D Formulas
3-D Ranges
Multiple Files
External Cell Addresses
Spreadsheet Consolidation
Consolidating Files with Identical Structures
Updating the Consolidation
Consolidating Files with Similar (but not Identical) Structures
Saving the Workspace
Opening a Workspace
Formula Construction
Formula Construction
Absolute References
Names
Naming Ranges
Naming Rules
So What are Names Good For?
Creating Names from Existing Text
Modifying Names
Naming Formulas
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 and Rows
Hiding and Unhiding Worksheets
Protection
Worksheet Protection
Workbook Protection
Macros and Graphics
What is This Thing Called Macro?
Relative vs. Absolute Macro Recording
Viewing the Macro Code
Charting Basics
Modifying a Chart
Chart Toolbar
Printing a Chart
Drawing tools
Rectangles, Ellipses, Lines, and Arrows
Text Boxes
Moving and Sizing Drawn Objects
Customizing Excel
Controlling Screen Display
Customizing Toolbars/Menu Bars
Resetting Toolbars
Creating New Toolbars
Moving Toolbars and Menus
Deleting Toolbars
Custom Fill Lists
Controlling Excel Defaults
Default Data Folder
Gridline Display
Controlling Zeros
|