Excel 2007 Advanced & Macros
Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2007. This guide is also available in French. See topics below.
Volume Price
| |
| 1 – 49 | $3.60 |
| 50 – 99 | $2.90 |
| 100 – 499 | $2.40 |
| 500 – 999 | $2.25 |
| 1000 + | $2.00 |
ISBN # : 978-1-934433-63-8
The following topics are covered: Range Names - Naming a Range, Creating Several Names at Once, Limiting the Scope of a Named Range, Selecting a Named Range, Using a Range Name in a Formula, Managing Named Ranges, Structured References for Excel Tables; Mixed Reference; More Functions; Goal Seek; Saving Views; Defining Scenarios; Hiding Columns, Rows, or Sheets; Data Consolidation; Restricting Cell Entry with Data Validation; Highlighting Invalid Data; Conditional Formatting; Conditional Formatting Rules Manager; Protecting/Unprotecting Worksheets; Password Protecting Specific Cells. Macros: Showing the Developer Tab; Recording & Running a Macro; Naming a Macro; Relative vs. Absolute Recording; Documenting Macros; Assigning a Macro to the Quick Access Toolbar; Automatic Macro Execution; Creating a Macro without Recording; Calling another Macro, Setting Macro Security; Getting Help on Visual Basic; Creating a Function Procedure.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
