Microsoft Excel 2013 Introduction Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2013. The following topics are covered: Entering and Editing Data Picking from a Drop-Down List Selecting Cells Resizing Column Width and Row Height Inserting and Deleting Rows, Columns and Cells Clearing Cells, Clearing Formatting Borders, Shading, Text Color Formatting Number Cells Aligning and Merging Cell Contents Entering Dates Entering a Sequence of Numbers Entering Formulas & Functions Entering SUM and Other Functions 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. Previewing, Printing and Page Setup Scaling to Print Printing a Specific Area Using Page Break Preview to Adjust Page Breaks Repeating Rows/Columns on Every Page. Also includes a list of Touch Actions, Selection and Movement Shortcuts.

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 2013. 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: List Range or Table? Excel Tables: Creating an Excel Table, Adding or Deleting a Table Row or Column, Turning On/Off the Total Row, Removing Duplicates, Using Table Specifiers in Formulas, Converting a Table to a List Range, Using a List Range for Sorting, Filtering, Subtotals, and PivotTables. PivotTables: Creating a PivotTable or PivotChart from Worksheet Data, Show/Hide the PivotTable Fields Pane, 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 and Filtering a PivotTable, Filtering PivotTables with Timelines, Using a PivotTable to Analyze Multiple Data Sources, Adding Excel Workbook Tables to the Data Model, Adding External Data to the Data Model, Defining Relationships Across Multiple Tables, Creating a New PivotTable to Analyze Multiple Data Model Tables, Adding Tables and Fields to an Existing PivotTable, Advanced Data Analysis, Creating a Power View Sheet, Adding a Visualization to Power View. Sorting & Filtering a Table or List Range: Basic Sorting, Complex Sorting, Filtering and Advanced Filtering, Show/Hide AutoFilter, Filtering with AutoFilter. Advanced Filtering: Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting/Ordering Columns, Clearing Filtering and Sorting, Subtotals. This guide is one of several titles available for Excel 2013: Excel 2013 Introduction; Excel 2013 Data Analysis with Tables; 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 card showing step-by-step instructions and shortcuts for how to use Microsoft Lync 2013. 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: Signing In/Out, Show/Hide the Menu Bar, Using Presence Status, Status Indicators, Changing Status Manually, Using Location Status, Adding a Note to Your Status, Viewing Other User's Notes Adding Contacts, Deleting Contacts, Emailing a Contact, Using the Favorites Group, Viewing Contact Cards, Monitoring a Contact's Status, Controlling Presence Privacy Creating and Using Groups Starting a Conversation; Sending an Instant Message; Inviting Additional Participants to Your Conversation; Sending a File; Receiving a File; Working with Multiple Conversations; Conversation Window On Top; Sharing Your Desktop or a Program; Sharing PowerPoint, Whiteboard, or Polls Scheduling an Online Meeting; Joining an Online Meeting; Using Meet Now; Ending an Online Meeting. Viewing Presence Information in Outlook; Responding to an Email with an Instant Message; Responding to an Email with a Call Also includes a list of keyboard shortcuts.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Microsoft Office Excel 2013.The following topics are covered:Charts: Inserting a Chart, Inserting a Recommended Chart, Understanding Chart Types, Charting Non-Adjacent Data, Creating a Chart Using the Default Chart Type, Using Chart Buttons, Resizing a Chart in the Worksheet, Selecting Chart Objects, Changing Chart Type, Adding/Removing a Data Series, Adding and Adjusting Axis and Chart TItles, Switching Rows and Columns, Using Tables as a Data Source, Adjusting Scale, Creating a Chart with Two Scales, Adjusting the Legend, Using Gridlines, Adding Explanatory Text, Adding Visuals, Adding and Adjusting Data Labels, Exploding a Piece of a Pie Chart, Using Styles and Layouts, Moving a Chart to Another Worksheet, Adding a Projection or Trendline to a Data Series, Handling Hidden and Empty Cells in a Chart, Changing the Default Chart Type, Creating a Custom Chart Template, Applying a Custom Chart Type.Sparklines: Creating a Sparkline, Grouping Sparklines, Changing Sparkline Type, Removing Sparklines, Customizing Sparklines with Text and Markers, Changing Marker Color, Change Sparklines Color and Weight, Customizing Axis Settings, Handling Hidden and Empty Cells in Sparklines.

Laminated quick reference card showing step-by-step instructions and shortcuts for Microsoft Excel 2011 for Mac. 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: Beginning a New Workbook, Opening an Existing Document, Page Layout vs. Normal View, Entering New Data, Entering Data into a Selected Range, Replacing the Contents of a Cell, Undo or Redo an Action, Editing the Contents of a Cell, Clearing Cells or Ranges of Cells, Inserting Rows or Columns, Inserting Cells, Deleting Rows, Columns, or Cells, Column Width and Row Height, Changing Column Width to Fit, Entering Dates, Copying to Adjacent Cells, Entering a Sequence of Numbers, Excel Formulas, Entering a Formula, Commonly Used Functions, Entering a SUM ˆFunction Quickly, Using the Formula Builder, Absolute vs. Relative Cell References, Moving or Copying Data: Cut, Copy, and Paste; Drag and Drop. Formatting Numbers, Aligning Cell Contents, Borders, Shading, Clearing Formatting, Renaming a Sheet, Selecting Sheets, Moving Sheets, Copying Sheets, Inserting a Worksheet, Deleting Sheets, Moving Among Sheets, Printing the Worksheet, Printing a Specific Area, Setting a Page Break, Repeating Rows or Columns on Every Page of a Printout. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This card is one of two titles available for Excel 2011: Excel 2011 Introduction and Excel 2011 Charts, Tables & PivotTables.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced features of Microsoft Office PowerPoint 2013. 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: Adding Placeholders to a Slide Master Adding Master Level Guides Adding a Customized Layout Creating and Changing Personal Templates Organizing Slides with Sections Inserting an Excel Table WordArt Effects Recoloring a Picture Inserting an Audio Clip Inserting a Video Merging Shapes Ungrouping Clip Art Creating a Button to Jump to Another Slide or File During a Slide Show Hiding Slides 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 Saving Different Slide Orders Setting up a Self Running Show Setting Timings by Viewing the Show Recording Narration Compressing Media Files Packaging Presentations on a CD/USB Drive Saving a Presentation as a Video Broadcasting Your Presentation on the Web. This guide is one of two titles available for PowerPoint 2013: PowerPoint 2013 Introduction, PowerPoint 2013 Advanced.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2013. The following topics are covered: Margins, Orientation, and Paper Size Moving and Copying Text Formatting Text with the Mini Toolbar & Touch MiniBar Spacing between Paragraphs Creating Bulleted Lists Changing Bullet Style Creating Numbered Lists Turning off Bullets or Numbering Paragraph Alignment Copying Formatting Searching using the Navigation Pane Finding and Replacing Text Jumping to Other Pages Resuming Reading Read Mode, Print Layout, and Draft View Using the Highlighter Using the Dictionary and Thesaurus Creating and Inserting Quick Part Building Blocks Inserting a Cover Page Creating and Editing Headers and Footers; Suppress/Change Header or Footer on the First Page Inserting a Page Number Inserting a Text Box: Drawing a Text Box, Moving, Resizing, Formatting, and Deleting a Text Box Inserting a Page Break Checking Spelling, Grammar, AutoCorrect Previewing and Printing Documents Printing Envelopes and Labels. Also includes: Lists of Touch Actions, Selection and Movement Shortcuts, Editing and Formatting Shortcuts.