Microsoft Excel 2013 Advanced & Macros Quick Reference Guide (Cheat Sheet of Instructions, Tips & 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 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:

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.

This guide is one of several titles available for Excel 2013: Excel 2013 Introduction; Excel 2013 Data Analysis with Tables; Excel 2013 Charts & Sparklines; Excel 2013 Functions & Formulas.

• Microsoft Excel 2013 Functions & Formulas Quick Reference Card (4-page Cheat Sheet focusing on examples and context for intermediate-to-advanced functions and formulas- Laminated Guide)
• Microsoft Excel 2013 Data Analysis with Tables Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Excel 2013 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Excel 2013 Charts & Sparklines Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Word 2013 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Word 2013 Intermediate Quick Reference: Paragraphs, Tabs, Columns, Tables & Pictures (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Word 2013 Advanced Quick Reference: Styles & Long Documents (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft PowerPoint 2013 Introduction Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft PowerPoint 2013 Advanced Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)
• Microsoft Word 2013 Templates & Forms Quick Reference Guide (Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card)