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 masteradding master level guidesadding a customized layoutcreating and changing personal templatesorganizing slides with sectionsinserting an excel TableWordArt EffectsRecoloring a PictureInserting an Audio ClipInserting a VideoMerging ShapesUngrouping Clip ArtCreating a Button to Jump to Another Slide or File During a Slide ShowHiding SlidesDisplaying the Animation PaneReordering AnimationsRemoving or Modifying AnimationsPreviewing AnimationsUsing the Animation PainterSyncing Animation/Text Overlays with Audio/VideoAnnotations During a Slide ShowSaving Different Slide OrdersSetting up a Self Running ShowSetting Timings by Viewing the ShowRecording NarrationCompressing Media FilesPackaging Presentations on a CD/USB DriveSaving a Presentation as a VideoBroadcasting Your Presentation on the Web.

This guide is one of two titles available for powerpoint 2013: PowerPoint 2013 Introduction ISBN 978-1936220878, PowerPoint 2013 Advanced. Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced features of Microsoft Office PowerPoint 2013.

Laminated Card - Microsoft PowerPoint 2013 Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use 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 a new slide; changing a slide's layout; switching between standard and widescreen Format; Custom Slide Size and Orientation; Entering Text; Starting a Line without a Bullet; Moving Between Text Areas with the Keyboard; Adding Other Text on the Slide; Changing Level of Indention; Text Formatting; Using Presentation Views: Normal View, Outline View, Slide Sorter View.

Applying design themes; changing Background of a Slide; Adding a Header or Footer; Creating Speaker Notes. Using the slide Master; Suppressing Slide Master Objects. Adding clip art and online images; creating a chart; creating an org chart; adding and deleting org chart boxes; drawing Shapes; Resizing a Shape or Picture; Rotating Objects; Moving a Shape; Adding Text to Shapes; Selecting Shapes; Changing Color, Fill Pattern, or Line Style of a Shape or Line; Using Eyedropper to Match Colors; Duplicating Shapes; Animating an Object.

Running a slide show; assigning transition Effects and Timings for a Slide Show; Changing Slide Show Settings; Printing. Also includes a list of Touch Actions, Text Selection and Movement and Slide Show Shortcuts. This guide is one of two titles available for powerpoint 2013: PowerPoint 2013 Introduction, PowerPoint 2013 Advanced ISBN 978-1936220885.

Recommended companion title covering office basics: Microsoft Office 2013 Essentials ISBN 978-1936220755.

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

Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features. Geared toward the intermediate to advanced microsoft Excel 2013 user, this example-rich 4-page laminated quick reference card/guide provides explanations and context for many powerful Excel 2013 spreadsheet formulas and functions.

. This guide is suitable as a training handout, or simply an easy to use reference guide. Topics include:controlling order of precedenceconditionally summing/counting data sumif, using the error checker, displaying cell relationships, day, indirectly referring to a named range indirectmerging text and numbers concatenate, showing/hiding formulas, watching cells, evaluating nested formulas, trim, len, left, year, substitutechanging results: if, limiting scope, automatic error checking, MATCHError Recovery ISNA, WEEKDAY, TODAY, Managing Names, VALUE, HLOOKUP, COUNTIFBeing Precise Rounding functionsImproving Clarity with Range Names: Creating Names, MID, NOTTable Lookups VLOOKUP, AND, MONTH, EDATEUsing a Formula for Data ValidationTroubleshooting: Types of Errors, FIND, Selecting Related Cells, NETWORKDAYS, TEXT, OR, RIGHT, INDEX, ISERRORArray Formulas Single Cell & Multi-Cell ArraysDates and Times DATE, Defining a Constant or Formula for a Name, Removing Relationship Arrows.

This guide is one of multiple titles available for excel 2013: excel 2013 introduction isbN 978-1936220762; Excel 2013 Functions & Formulas; Excel 2013 Data Analysis with Tables 978-1936220786.

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

Relative cell referencescopying and moving data: copying to adjacent cells; cut, moving, inserting, deleting sheets; editing multiple Worksheets SimultaneouslyPreviewing, Selecting, Copy, Paste; Drag & DropSheet Features: Renaming, Copying, Printing and Page SetupScaling to PrintPrinting a Specific AreaUsing Page Break Preview to Adjust Page BreaksRepeating Rows/Columns on Every PageAlso includes a list of Touch Actions, Selection and Movement Shortcuts.

Recommended companion title covering office basics: Office 2013 Essentials, ISBN 978-1936220755. This guide is one of multiple titles available for excel 2013: excel 2013 introduction; excel 2013 Functions & Formulas ISBN 978-1936220779; Excel 2013 Data Analysis with Tables ISBN 978-1936220786. Laminated quick reference showing step-by-step instructions and shortcuts for how to use 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:entering and editing datapicking from a drop-down listselecting cellsresizing Column Width and Row HeightInserting and Deleting Rows, Columns and CellsClearing Cells, Clearing FormattingBorders, Shading, Text ColorFormatting Number CellsAligning and Merging Cell ContentsEntering DatesEntering a Sequence of NumbersEntering Formulas & FunctionsEntering SUM and Other Functions QuicklyAbsolute vs.

.

Laminated Card - Microsoft Word 2013 Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts

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:margins, resizing, grammar, formatting, selection and movement shortcuts, and draft viewusing the highlighterusing the dictionary and thesauruscreating and inserting quick part building blocksinserting a cover pagecreating and Editing Headers and Footers; Suppress/Change Header or Footer on the First PageInserting a Page NumberInserting a Text Box: Drawing a Text Box; Moving, and Deleting a Text BoxInserting a Page BreakChecking Spelling, and Paper SizeMoving and Copying TextFormatting Text with the Mini Toolbar & Touch MiniBarSpacing between ParagraphsCreating Bulleted ListsChanging Bullet StyleCreating Numbered ListsTurning off Bullets or NumberingParagraph AlignmentCopying FormattingSearching using the Navigation PaneFinding and Replacing TextJumping to Other PagesResuming ReadingRead Mode, AutoCorrectPreviewing and Printing DocumentsPrinting Envelopes and LabelsAlso includes: Lists of Touch Actions, Orientation, Print Layout, Editing and Formatting Shortcuts.

Recommended companion title covering Office basics: Office 2013 Essentials ISBN 978-1936220755. This guide is one of several titles available for word 2013: word 2013 introduction; word 2013 intermediate isbn 978-1936220823; Word 2013 Templates & Forms ISBN 978-1936220847, and Word 2013 Advanced ISBN 978-1936220830

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2013.

Microsoft Excel 2013 Data Analysis with Tables Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card

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, Removing Duplicates, Turning On/Off the Total Row, Using a List Range for Sorting, Using Table Specifiers in Formulas, Converting a Table to a List Range, Subtotals, Filtering, and PivotTables.

Pivottables: creating a pivottable or pivotchart from worksheet data, adding excel workbook tables to the data model, changing how values are shown, using a pivottable to analyze multiple data sources, creating a new pivottable to Analyze Multiple Data Model Tables, Creating a Power View Sheet, Refreshing a PivotTable, Adding/Removing a PivotTable Field, Rearranging a PivotTable, Defining Relationships Across Multiple Tables, Adding a PivotChart to an Existing PivotTable, Adding Tables and Fields to an Existing PivotTable, Sorting and Filtering a PivotTable, Show/Hide the PivotTable Fields Pane, Advanced Data Analysis, Filtering PivotTables with Timelines, Changing the Summary Function, Adding External Data to the Data Model, 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, Selecting/Ordering Columns, Using Advanced Filters/Copying Filtered Data to Another Range, Clearing Filtering and Sorting, Subtotals.

This guide is one of multiple titles available for excel 2013: excel 2013 introduction isbn 978-1936220762; Excel 2013 Functions & Formulas ISBN 978-1936220779; Excel 2013 Data Analysis with Tables. Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting and filtering features in Microsoft Office Excel 2013.

Microsoft Word 2013 Intermediate Quick Reference: Paragraphs, Tabs, Columns, Tables & Pictures Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card

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:Displaying the RulerDisplaying Paragraph Marks, Tabs, etc. Paragraphs: Paragraph Breaks vs. Text wrapping; using an Object's Anchor; Quickly Positioning Objects on a Page.

Also includes: lists of Table Selection and Movement Shortcuts, and Formatting Shortcuts. This guide is one of multiple titles available for word 2013: word 2013 introduction isbn 978-1936220816; word 2013 intermediate; Word 2013 Templates & Forms ISBN 978-1936220847, and Word 2013 Advanced ISBN 978-1936220830

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Paragraphs, Columns, Tabs, Indents, Tables & Pictures features of Microsoft Office Word 2013. Line breaks; changing paragraph and line spacing; Clearing Formatting; The Indent Markers; Changing Indents; Formatting Paragraphs Using the Style Gallery.

Setting tabs:moving, removing Tabs; Clearing Tab Settings; Setting Tabs with Leaders. Using format Painter to Fix Tabs. Layout using columns:Adding a Line Between Columns. When to use tabs, tables or columnssorting paragraphs, or tablesworking with tables: inserting a table; moving a table; inserting rows and columns within a Table; Adding a Row at the End of a Table; Deleting Cells, Rows, Columns, Tabbed Columns, or the Entire Table; Changing Column Widths; Changing Row Height; Evenly Resizing Rows/Columns; Repeating Header Rows on Every Page; Merging and Splitting Cells; Centering a Table within the Margins; Changing Text Direction; Wrapping Text around Tables.

Adding paragraph/cell borders and Shading: Using the Border Painter; Copying Border Style Border Sampler.

Microsoft Word 2013 Advanced Quick Reference: Styles & Long Documents Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Card

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use styles and other features useful for long documents in Microsoft Office Word 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:using styles; character, section, comment, paragraph, linked styles; applying character and paragraph styles; Creating a Style; Displaying the Styles Pane; Changing Styles; Deleting a Style; Selecting All Text with Same Style; Adding Styles to the Default Style List; Showing Formatting as Styles to "Clean Up" a Document; Importing Styles; Using Numbered Lists with Styles; Applying Table StylesJumping to a Specific Element Page, etc.

Creating multilevel numbered listsexpand/collapse in print Layout ViewViewing & Structuring your Document Using the Navigation PaneOutliningRestricting FormattingFinding and Replacing FormatsFinding and Replacing Special Characters Tabs, Spaces, etc. Options when pastinginserting entire documentscreating a table of contents; updating a table of contentscreating an index; generating an index; updating an indexcreating a bookmark; going to/selecting bookmarked text; using bookmarks to Refer to PagesSection Breaks: Inserting a Section Break; Changing Page Numbering Mid-Document; Changing Headers and Footers; Changing Page Setup in a SectionInserting a Footnote/EndnoteThis guide is one of several available for Word 2013: Word 2013 Introduction ISBN 978-1936220816; Word 2013 Intermediate ISBN 978-1936220823; Word 2013 Templates & Forms ISBN 978-1936220847; and Word 2013 Advanced.

.

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

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, 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, Hiding or Displaying a Group, Worksheets, Ungrouping; Hiding Columns, Rows, 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.

Laminated Card - Microsoft Excel 2013 Charts & Sparklines Quick Reference Guide Cheat Sheet of Instructions, Tips & 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, switching rows and columns, resizing a chart in the worksheet, using styles and layouts, adding and adjusting data labels, creating a chart using the default chart type, adding/removing a data series, charting Non-Adjacent Data, Handling Hidden and Empty Cells in a Chart, Using Gridlines, Adding a Projection or Trendline to a Data Series, Using Chart Buttons, Changing the Default Chart Type, Creating a Custom Chart Template, Adjusting the Legend, Selecting Chart Objects, Adding and Adjusting Axis and Chart TItles, Exploding a Piece of a Pie Chart, Adding Explanatory Text, Using Tables as a Data Source, Adding Visuals, Changing Chart Type, Understanding Chart Types, Creating a Chart with Two Scales, Inserting a Recommended Chart, Moving a Chart to Another Worksheet, Adjusting Scale, Applying a Custom Chart Type.

Sparklines: creating a sparkline, customizing axis settings, changing marker Color, Changing Sparkline Type, Change Sparklines Color and Weight, Customizing Sparklines with Text and Markers, Grouping Sparklines, Removing Sparklines, Handling Hidden and Empty Cells in Sparklines. This guide is one of multiple titles available for excel 2013: excel 2013 introduction; excel 2013 functions & formulas isbn 978-1936220779; Excel 2013 Data Analysis with Tables ISBN 978-1936220786, Excel Advanced Features & Macros ISBN 978-1936220809.

.

Laminated Guide - Microsoft Outlook 2013 Mail, Calendar, People, Tasks Quick Reference Cheat Sheet of Instructions, Tips & Shortcuts

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:mail: displaying mail folders; hiding/displaying: folder 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.

Quick filters: all and unread; reading messages; Using the People Pane; Manual Send/Receive; Using the Outbox; Using Desktop Alerts. Deleting messages; 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; Finding Mail Messages; Using Task Flags; Creating a Folder; Favorite Folders; Moving or Copying Messages; Using Quick Steps; Creating a Contact from a Message; Creating a Distribution List; Creating an E-Mail Signature; Manually Inserting Signatures; Using the Rules Wizard.

Using the out of Office Assistant, Handling Junk Mail. Calendar: setting up your work week; viewing the calendar; creating appointments; creating, Scheduling and Editing Meetings; Repeating Appointments or Meetings; Responding to Meeting Requests; Changing Time or Date of Meeting/Appointment; Viewing Multiple Calendars; Creating a Calendar Group; Printing the Calendar.

People: displaying people; creating & editing contacts; linking contacts; Deleting a Contact; E-Mailing a Contact; Searching for People; Connecting to a Social Media Site; Viewing Social Media Updates; Merging with Contacts. Tasks and to-do items: displaying to-do and task list folders; creating tasks; marking complete; adding messages or contacts to the to-do list, changing task order; assigning tasks; viewing to-do Items in the Calendar; Hiding /Displaying Tasks in the To-Do Bar; Printing TasksFor Any Outlook Item: Deleting Items; Assigning an Item to a Category; Sorting by Category; Sorting Items; Creating a New Calendar/Contact/Task Folder; Sharing Calendar Contacts Tasks or Notes using an Exchange Server; Using Another Person's Calendar Contacts Tasks or Notes Folder; Responding to a Sharing Request; Using the Reading Pane.