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

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

See more picture @ amazon.com

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced 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:
Using Styles, Character, Paragraph, Linked Styles, Applying Character and Paragraph Styles, Creating a Style, Displaying the Styles Pane, Disabling Linked Styles, Changing Styles, Deleting a Style, Selecting All Text with the Same Style, Showing Formatting as Styles to Clean Up a Document, Importing Styles from Another Document, Using Numbered Lists with Styles, Adding Styles to the Default List, Applying Table Styles, Restricting Formatting, Creating a Table of Contents, Updating a Table of Contents, Preparing an Index, Generating an Index, Updating an Index, Section Breaks, Inserting a Section Break, Changing Page Numbering Mid-Document, Changing Headers and Footers, Changing Page Setup in a Section, Displaying the Section Number in the Status Bar, Inserting a Footnote/Endnote, Editing a Footnote/Endnote, Deleting a Footnote/Endnote, Creating a Bookmark, Going to/Selecting Bookmarked Text, Using Bookmarks to Refer to Pages, Outlining, Adding a Watermark, Inserting an Excel Spreadsheet, Comparing Documents Side by Side, Creating a Template Library in Windows 7, Creating a Template.

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 Project 2010 Quick Reference Guide: Creating a Basic Project (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Microsoft Project 2010 Quick Reference Guide: Creating a Basic Project (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 Microsoft Office Project 2007. 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:
Starting a New Project, Setting the Project Start Date, Describing a Project, Switching to a Different View, Switching to an Unlisted View, Undoing Changes, Entering Task Information in a Sheet, Entering or Changing a Task Duration, Using Automatic Scheduling, Sequencing All Tasks Quickly, Unlinking Tasks, Changing Data in One More Rows, Inserting a Task, Deleting Rows, Zooming in a View, Moving or Copying Items, Copying Data to Adjacent Cells, Changing Gantt Chart Appearance, Reviewing SmartTags, Setting the Calendar, Creating a New Group Calendar, Entering a Resource, Entering a Cost Resource, Entering a Consumable Resource, Booking a Resource to a Task, Using Resource Driven Scheduling, Saving the Baseline, Showing Planned vs. Actual in the Gantt Chart, Displaying the Project's Statistics, Changing the Progress of a Single Task, Changing Progress of Several Tasks, Setting Up a Printout, Previewing a View, Printing a View, Previewing or Printing a Report, Transferring Data to Other Project Files.

This guide is one of two titles available for Project 2010: Project 2010 Creating a Basic Project, Project 2010 Managing Complexity.

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

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

See more picture @ amazon.com

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use 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:

Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences.
Entering Formulas & Functions, Entering a SUM Function Quickly, Absolute vs. Relative Cell References.
Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop.
Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets.
Editing Multiple Worksheets Simultaneously, Copying Data and Formatting to Multiple Worksheets.
Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page.
Working with Previous Versions (Compatibility Mode).
Also includes: Lists of Selection and Movement Shortcuts.

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.

Microsoft Outlook 2010 Mail Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Microsoft Outlook 2010 Mail Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) Review

See more picture @ amazon.com

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use mail features of Microsoft Office Outlook 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 included:

Displaying Mail Folders; Navigation Pane; To-Do Bar; Creating and Sending a Message; Attaching a File to a Message; Showing BCC; Sending a Message with High or Low Importance; Requesting a Read or Delivery Receipt; Drafting a Message; Delaying the Delivery of a Message; Restricting Forwarding, Printing or Copying. Reading Messages, Using the People Pane, Manual Send/Receive, Using the Outbox, Using Desktop Alerts.

Deleting Messages, Emptying the Deleted Items Folder, Saving an Attachment, Removing an Attachment, Replying, Forwarding, Printing a Message.
Sorting Messages, Grouping Messages by Conversation, Ignoring a Conversation, Cleaning up Redundant Messages, Turning Grouping On/Off, Creating an E-Mail Signature, Manually Inserting Signatures, Creating a Distribution List.
Using Task Flags, Creating Folders, Adding/Removing Favorite Folders, Moving or Copying Messages, Using Quick Steps, Finding Mail Messages, Creating a Contact from a Message, Using the Rules Wizard, Using the Out of Office Assistant, Handling Junk Mail.
Also includes a list of Keyboard and Selection Shortcuts.

This guide is one of several titles available for Outlook 2010: What s New in Outlook 2010 from 2003, Outlook 2010 Mail, Outlook 2010 Calendar, Contacts, Tasks, Outlook Web Access for Exchange 2010.

Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Microsoft Excel 2010 Tables, PivotTables, Sorting & Filtering Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) Review

See more picture @ amazon.com

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting and filtering features 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:

Excel Tables: Creating an Excel Table, Changing the Table Area, Adding a New Row or Column to the Table, Deleting a Table Row or Column, Turning On/Off the Total Row, Changing the Total Row, Convert a Table to a Normal Range, Using a Normal Range for Sorting, Filtering, Subtotals, and PivotTables, Removing Duplicates, Structured References in Excel Tables.

PivotTables: Creating a PivotTable or PivotChart Report, Show/Hide the PivotTable Field List, Adding/Removing a PivotTable Field, Refreshing a PivotTable, Rearranging a PivotTable, Adding a PivotChart to an Existing PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting in a PivotTable, Grouping by Dates or Time, Filtering PivotTables and Charts with Slicers.

Sorting & Filtering: Basic Sorting, Complex Sorting, Re-applying a Sort, Creating a Custom List, Creating a Custom List from Cell Data, Sorting Using a Custom List, Filtering and Advanced Filtering, Show/Hide AutoFilter, Searching for Filter Criteria in AutoFilter, Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting /Ordering Columns, Filter/Copy Unique Rows, Clearing Filtering and Sorting, Subtotals.

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.

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

Microsoft PowerPoint 2010 Advanced 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 advanced features of Microsoft Office PowerPoint 2007. 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:

Reusing Slides from Other Presentations, Adding Placeholders to a Slide Master, Adding a Customized Layout, Using a Theme from Another Office Document, Creating Templates, Using Templates, Making Changes to a Template, Inserting an Audio Clip, Inserting a Video, Inserting an Excel Table, WordArt Effects, Recoloring a Picture, Ungrouping Clip Art, Organizing Slides With Sections, Creating a Button to Jump to Another Slide or File During a Slide Show, Displaying the Animation Pane, Reordering Animations, Removing or Modifying Animations, Previewing Animations, Using the Animation Painter, Syncing Animation/Text Overlays With Audio/Video, Annotations During a Slide Show, Setting up a Self Running Show, Set Timings by Viewing the Show, Recording Narration, Saving Different Slide Orders, Compressing Media Files, Packaging a Presentation on a CD, Saving a Presentation as a Video, Broadcasting Your Presentation on the Web.

This guide is one of two titles available for PowerPoint 2010: PowerPoint 2010 Introduction, PowerPoint 2010 Advanced.

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.

Microsoft Word 2010 Mail Merge & Forms Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

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

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use mail merge and forms features of Microsoft Office Word 2010.

The following topics are covered:
Mail Merge:
Choosing the Document Type, Recipient Lists: Creating a Recipient List in Word, Selecting an Existing Recipient List, Using Outlook Contacts, Editing an Existing Recipient List, Selecting and Sorting Recipients. Writing the Document: Creating a Label Document, Using an If...Then...Else Rule. Previewing the Merge & Merging, The Mail Merge Wizard, Highlighting Merge Fields.
Forms:
Showing Macro and Form Controls, Creating a Template Library in Windows 7, Creating the Template File, Inserting Content Controls, Setting Content Control Properties: Add a Title, Format Contents Using a Style, Self Destruct Plain or Rich Text, For Plain Text, For Building Block Gallery, For Combo Box and Drop-Down List, For Date Picker, For Check Box. Turning On/Off Design Mode, Changing Placeholder Text, Protecting a Form from Changes, Unprotecting a Form, Protecting Only Parts of a Form: Preventing Editing of a Control's Content, Prevent Editing Parts of a Document, Preventing Deletions. Accessing the Form to Fill it Out, Changing the Form Template.

Windows 7 Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Windows 7 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 Microsoft Windows 7. Covers the following topics: Starting a Program, Accessories (Calculator, Note Pad), Using the Shortcut Menu, Properties, Pinning a Program to the Start Menu, Opening Files or Folders, Using Jump Lists (Recently Used Files, Pinned Files, Common Tasks), Pinning Files to Jump Lists, Switching Among Open Windows, Manipulating Windows: Moving, Enlarging, Restoring, Hiding or Minimizing, Restoring a Minimized Window, Showing the Desktop. Exiting a Program/Closing a Window, Adding Gadgets to the Desktop, Using the Notification Area (Printing, Security, Sound), What to Try if a Program Freezes, Using the Control Panel, Saving a Document, Getting Help. File Management with Windows Explorer: Changing Views, Show/Hide Menu Bar, Show/Hide Navigation Pane, Arrange Group or Sort Files and Folders, Navigating Folders in Explorer, Working with Libraries, Selecting Multiple Items, Moving or Copying Files or Folders, Creating a Folder, Creating a Shortcut to a Document Folder or Other Item, Renaming Files or Folders, Zipping Files or Folders, Deleting Files or Folders, Restoring Items from the Recycle Bin, Emptying the Recycle Bin, Burning to a CD/DVD, Searching for a File Folder or Program, Ending your Windows Sessions, and Changing Login Password. Also includes a list of keyboard shortcuts. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.

Microsoft Access 2010 Intermediate Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)

Microsoft Access 2010 Intermediate Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card) Review

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 2010.
The following topics are covered:
Table Design: Preventing Data Entry Errors, Find and Sort More Quickly With Indexing, Joining Tables to Create Relationships, Deleting a Table Join, Preventing Orphaned Data with Referential Integrity.
Query Design: Performing Calculations, Summarizing Selected Data.
Form Design: Adding Form Controls, Sorting, Removing Automatic Labels, Modifying Automatic Labels, Modifying Form Controls.
Report Design: Summarizing by Group, Printing Options.
Table Relationships. Complex Expressions Examples. Form Control.

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

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

Geared toward the intermediate to advanced user, this example-rich 4-page laminated quick reference guide provides explanations and context for many powerful functions and formulas. Step-by-step instructions for many function/formula-related features. Topics include:
Conditionally Summing Data (SUMIF, COUNTIF)
Being Precise (Rounding functions)
Improving Clarity with Range Names
Merging Text and Numbers (CONCATENATE, TEXT, LEFT, RIGHT, MID, LEN, FIND, VALUE, TRIM, SUBSTITUTE)
Changing Results: IF, AND, OR
Table Lookups (VLOOKUP, HLOOKUP, INDEX, MATCH)
Error Recovery (ISNA, ISERROR)
Array Formulas (Single Cell & Multi-Cell Arrays)
Dates and Times (DATE, YEAR, MONTH, DAY, TODAY, WEEKDAY, NETWORKDAY)
Using a Formula for Data Validation
Troubleshooting: Types of Errors, Automatic Error Checking, Using the Error Checker, Show/Hide Formulas, Watching Cells, Evaluating Nested Formulas, Selecting Related Cells, Displaying Cell Relationships, Removing Relationship Arrows.

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

Microsoft Excel 2007 Introduction 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 Microsoft Office Excel 2007. The following topics are covered: Creating Workbooks, Entering and Editing Data, Clearing Cells, Undo and Redo, Inserting and Deleting Rows Columns and Cells, Column Width and Row Height, Entering Dates, Entering Sequences, Entering Formulas & Functions, Using AutoSum, Absolute vs. Relative Cell References, Resizing the Formula Bar, Formatting Numbers and Cells, Aligning Cell Contents, Borders and Grids, Previewing, Printing and Page Setup, Repeating Rows/Columns on Every Page, Copying and Moving Data: Fill Handle; Cut, Copy, Paste; Drag & Drop. Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting, Editing Multiple Worksheets Simultaneously, and Copying Data and Formatting to Multiple Worksheets. Also includes: Lists of Selection and Movement Shortcuts. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.