Microsoft Word 2010 Templates & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Microsoft Word 2010 Templates & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) Review

See more picture @ amazon.com

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use macros and template features of Microsoft Office Word 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered:
Templates: Templates vs. Documents, Using a Template, Creating a New Template, Editing a Template, Adding a Workgroup Template Folder, Changing which Template is Attached, Changing Defaults in the Attached Template, Changing Elements in the Attached Template, Changing the Normal Template.
Making Elements Available in All Documents: Using Global Templates, Removing a Global Template, Organizing Macros and Styles in Templates and Documents, Inserting Fields with Options, Including Building Blocks in a Template, Copying Building Blocks Between Templates, Moving Building Blocks Between Templates, Creating a Custom Building Block, Creating Building Block Libraries.
Macros: Showing the Developer Tab, Recording a Macro, Naming a Macro, Renaming a Macro, Creating a Macro without Recording, Editing Macros, Running Macros, Documenting Macros, Assigning Macros to the Quick Access Toolbar and Shortcut keys, Auto Macros, Calling Another Macro, Deleting Macros, Setting Macro Security, Getting Help on Visual Basic.
This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros.

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

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

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.

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

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

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.
The following topics are covered:

Goal Seek, Saving Views, Defining Scenarios, Hiding Columns, Rows or Sheets, Restricting Cell Entry with Data Validation, Highlighting Invalid Data, Clearing Data Validation Circles, Data Consolidation, Conditional Formatting, Clearing Conditional Formatting, Conditional Formatting Rules Manager, Creating a Workspace With Multiple Workbooks, Protecting/Unprotecting Worksheets, Password Protecting Specific Cells, Keeping Part of a Worksheet Visible: Freeze Panes, Split Panes.

Macros: Showing the Developer Tab, Macro Names, Recording a Macro, Running a Macro, Renaming a Macro, Automatic Macro Execution, Relative vs. Absolute Recording, Assigning to the Quick Access Toolbar, Creating a Macro Without Recording, Documenting a Macro, Calling Another Macro, Setting Macro Security, Getting Help on Visual Basic, Saving a Macro Enabled Worksheet, Creating a Custom Ribbon Group, Adding a Macro to the Ribbon, Creating a Function Procedure, Using a Function Procedure.

This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.