Store

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

Title :Microsoft Excel 2007 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
Product Group : Book
Type : Pamphlet
Price : $3.60

Product Description

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.

Product Details

Author	Beezix Inc.
Binding	Pamphlet
ISBN	1934433632
Label	Beezix Inc.
Manufacturer	Beezix Inc.
NumberOfPages	2
PublicationDate	2007-01-31
Publisher	Beezix Inc.
Studio	Beezix Inc.