Microsoft Excel 2007 Advanced And Macros Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

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.

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.

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.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2013. This guide is suitable as a training handout, or as an easy to use reference guide, for any type of user.The following topics are covered:Organizing with Grouping: Hiding Columns, Rows or Sheets, Consolidating Data, Freezing or Splitting Rows/Columns, Using the Selection Pane, Conditional Formatting, Goal Seek, Scenarios, Converting Text to Data, Intercepting Entry Errors With Data Validation, Preventing Changes (Protecting Data), Quick Analysis.Macros: Recording Workbook Actions, Running a Macro, Executing Macros Automatically, Saving a Macro, Showing the Developer Tab, Setting Macro Security, Assigning to a Worksheet Button, Assigning to the Quick Access Toolbar, Editing a Macro, Visual Basic for Applications, Debugging VBA Code, Documenting VBA Code, VBA Examples to Enhance Productivity: Subroutines, Function Macros, Macro Name Rules.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Groove 2007. The following topics are covered: The Groove Notification Icon, Creating an Account, Opening the Groove Launchbar, Logging On/Off, Resetting your Groove Password, Creating a Standard Workspace, Adding People to a Workspace, Accepting Workspace Invitations, Opening a Workspace, Working with Workspace Tools, Unread/Read Show/Hide the Workspace Members Panel, Chatting with Workspace Members, Navigating Together, Using the Files Tool, Using the Discussion Tool, Creating a New Topic, Creating a Response, Editing a Topic/Response, expanding/Collapsing Topics, Changing How Topics are Listed, Using the Calendar Tool, Deleting a Workspace, Adding a Contact, Organizing Contacts and Workspaces in the Launchbar, Sending a Message, and Viewing Message History. Also includes a list of keyboard shortcuts and indicators.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use macros and template features of Microsoft Office Word 2007. The following topics are covered: Templates: Templates vs. Documents, Using Existing Templates, Creating New Templates, 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: Recording a Macro, Naming a Macro, Renaming a Macro, Creating a Macro without Recording, Editing Macros, Running Macros, Documenting Macros, Assigning Macros to Toolbars, Shortcut keys and Menu Commands, Auto Macros, Calling Another Macro, Organizing Macros in Templates and Documents, Deleting Macros, Setting Macro Security, Getting Help on Visual Basic. 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 Word 2007: Word 2007 Introduction, Word 2007 Formatting, Word 2007 Advanced, Word 2007 Mail Merge & Forms, Word 2007 Templates & Macros.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features of Microsoft Office PowerPoint 2007. The following topics are covered: Reusing Slides from Other, Presentations, Adding Placeholders to a Slide Master, Adding a Customized Layout, Switching from Color to Black & White, Making Changes to a Template, Using a Theme from Another Office Document, Inserting Tables, WordArt, The Selection and Visibility Pane, Ungrouping Clip Art, Recoloring Pictures, Placing an Excel Object on the Slide, Editing an Excel Object Hiding/Showing Slides, Creating a Button to Jump to Another Slide or File During a Slide Show, Adding Custom Animations, Modifying Previewing the Effect, Annotations during a Slide Show, Self Running Presentations, Setting Timings, Recording Narration, Creating a Photo Slide Show, Saving Different Slide Orders, Packaging Presentations on a CD, Packaging Multiple Presentations on a CD. 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 two titles available for PowerPoint 2007: PowerPoint 2007 Introduction, PowerPoint 2007 Advanced.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 2007. The following topics are covered: Working with Database Files, Definitions of Access Objects, Navigating Tabbed Documents, Adding a Record, Editing Fields and Records, Undoing Changes, The Datasheet Window, Deleting Records and Searching for a Record. Creating a Table - Suggestions, Creating a Table, Using Design View to Create or Modify a Table, Sorting Tables, Optimizing Data Collection Using Masks, Creating a Query, Creating Forms with a Wizard, Working with a Form, Creating Reports with a Wizard, Printing a Report, Grouping Database Objects, Renaming or Deleting Groups, Compacting Database Files, Customizing Access and Backing Up a Database. Also includes a list of Movement Shortcuts, and Data Field Types. 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 two available titles for Access 2007: Access 2007 Introduction and Access 2007 Intermediate.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2016. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. This guide is suitable as a training handout, or as an easy to use reference guide, for any type of user. The following topics are covered: Advanced Features: Organizing with Grouping - Manual, Automatic, Hiding or Displaying a Group, Ungrouping; Hiding Columns, Rows, or Sheets; Consolidating Data; Freezing or Splitting Rows/Columns; Using the Selection Pane; Conditional Formatting; Goal Seek; Scenarios; Converting Text to Data; Intercepting Entry Errors with Data Validation; Preventing Changes (Protecting Cells, Worksheets, and Workbooks); Quick Analysis.. Macros: Recording Workbook Actions; Running a Macro; Executing Macros Automatically; Saving a Macro; Showing the Developer Tab; Setting Macro Security; Assigning a Macro to a Worksheet Button; Assigning a Macro to the Quick Access Toolbar; Editing a Macro; VBA; Debugging VBA Code; Documenting VBA Code; VBA Examples: Subroutines, Function Macros; Macro Name Rules.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use features of Microsoft Office 2007 that are common to Word, Excel & PowerPoint. Great companion product to Word, Excel & PowerPoint Introduction guides. Covers the following topics: The Ribbon, The Office Button, The Quick Access Toolbar, Using the Status Bar, File Formats, Compatibility with Previous Versions, Formatting with the Mini Toolbar, Using Themes to Format a Document, Adding SmartArt, Using Shape Styles, The Research Task Pane, Smart Tags, Embedding an Object from Another, Office File, Linking to an Office Object, Hyperlinking Between Office Files, Showing the Developer Tab, Inserting and Deleting Comments, Removing Personal Information, Marking as Final, Saving as PDF, E-mailing a PDF, Restricting Distribution, Digital Signatures, Adding & Signing Signature Lines (Word & Excel), Working with Multiple Windows. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.