Microsoft Excel 2007 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated)

Beezix Inc.

ISBN 10: 1934433632 / ISBN 13: 9781934433638

Published by Beezix Inc., 2007

About this Item

2 pages. 10.80x8.10x0.50 inches. In Stock.

Seller Inventory # __1934433632

Bibliographic Details

• Title: Microsoft Excel 2007 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated)
• Publisher: Beezix Inc.
• Publication Date: 2007
• Language: English
• ISBN 10: 1934433632
• ISBN 13: 9781934433638
• Binding: Pamphlet
• Condition: Brand New

About this title

Synopsis

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2007. 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.
This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.

This guide is one of several titles available for Excel 2007: Excel 2007 Introduction, Excel 2007 Charts & Tables, Excel 2007 Advanced & Macros.

About the Author

Beezix has been publishing quick reference computer guides for trainers, training companies, corporations, and individuals across the US and Canada for over 15 years. Founded by trainers, and with a strong focus on the learner, extensive industry experience made us aware of the need for a line of high-quality, trainer-produced courseware, and led to the creation of Beezix Quick Reference guides in 1994. Our cards are designed for casual computer users right through to trainers and trouble-shooters.