Excel 2002 Advanced & Macros
Laminated quick reference card showing step-by-step instructions and shortcuts for advanced features (including macros) of Microsoft Excel 2002 (XP). See topics below.
ISBN # : 978-1-934433-11-9
The following topics are covered:
Range Names, Comments, Hiding Columns or Rows, Mixed References, More Functions, Goal Seek, Data Validation, Conditional Formatting, Scenarios, Views, Protecting Cells, Data Consolidation
Macros: Recording & Running a Macro, Naming a Macro, Relative vs. Absolute Recording, Documenting Macros, Automatic Macro Execution, Assigning to Tools or Menus, Writing a Macro, Calling another Macro, Getting Help on VBA, Creating a Function Procedure
