How to import and export. Txt,. Csv,. Tsv, and. Xlsx files. How to sort and filter data. Hole punched. How to add, edit, and hide data. How to perform simple math and calculate averages. An overview of Microsoft s Ribbon interface. Universal keyboard shortcuts for Excel 2016. Examples of basic formulas, functions, and AutoFill.

How to use static cell references. High quality card stock. The content is based on excel Basics In 30 Minutes, by award-winning author Ian Lamont. The excel 2016 reference and cheat sheet was created by the publisher of the top-selling guides Excel Basics In 30 Minutes, Google Drive & Docs In 30 Minutes, and Dropbox In 30 Minutes.

It has holes for three-ring binders. Creating and saving workbooks. How to create a chart or graph. Almost all of the instructions and examples also apply to Excel 2013. The reference covers excel 2016 for Windows and Macs as well as Excel Online, Microsoft s free Web-based spreadsheet program. Fully recyclable and designed for readability.

Topics include: Excel 2016 vs Excel Online.

Laminated Guide - Windows Version 4-page Cheat Sheet focusing on examples and context for ... functions and formulas - Microsoft Excel 2016 Functions & Formulas Quick Reference Card

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. Topics include: controlling order of precedence conditionally summing/counting data sumif, hlookup, text, defining a constant or formula for a name, iserror array formulas single cell & multi-cell arrays dates and times date, showing/hiding formulas, ifs, and, index, networkdays, match error recovery isna, year, substitute changing results: if, edate using a formula for data validation troubleshooting: types of errors, using the error checker, textjoin, or, mID, VALUE, MAXIFS/MINIFS, TODAY, Indirectly Referring to a Named Range INDIRECT New Functions for Office 365, LEFT, NOT Table Lookups VLOOKUP, Displaying Cell Relationships, Selecting Related Cells, Mobile & Online CONCAT, COUNTIF Being Precise Rounding functions Improving Clarity with Range Names: Creating Names, Automatic Error Checking, Limiting Scope, SWITCH Merging Text and Numbers CONCATENATE, LEN, DAY, Managing Names, RIGHT, TRIM, FIND, WEEKDAY, Evaluating Nested Formulas, MONTH, Removing Relationship Arrows.

. Examples: summing selected data; being precise; merging text & Numers; Table Lookups; Table Lookups with IF and ISERROR; Dates & Times; Single- and Multi-Cell Arrays. This guide is one of multiple titles available for excel 2016, pivottables, sorting, other excel titles are: excel 2016 introduction isbn 1939791928; excel 2016 charts & sparklines isbn 9781939791955; Excel 2016 Tables, Filtering & Inquire ISBN 9781939791962; Excel 2016 Business Analytics & Power BI ISBN 9781944684143; Excel 2016 Advanced Features & Macros ISBN 9781944684082.

Geared toward the intermediate to advanced Excel 2016 user, this example-rich 4-page laminated card/guide provides explanations and context for many powerful Excel 2016 spreadsheet formulas and functions. This guide is suitable as a training handout, or simply an easy to use reference guide. Step-by-step instructions for many formula/function-related features such as using range names, and Excel's troubleshooting features.

Laminated Card - Windows Version Cheat Sheet of Instructions, Tips & Shortcuts - Microsoft Excel 2016 Tables, PivotTables, Sorting, Filtering & Inquire Quick Reference Guide

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 2016 Windows version. Using the inquire add-in: install the Inquire Add-In, Compare Two Workbooks, Analyze a Workbook. This guide is one of multiple titles available for excel 2016, other excel titles are: excel 2016 introduction isbn 1939791928; excel 2016 charts & formulas isbn 9781939791979; excel 2016 Business Analytics & Power BI ISBN 9781944684143; Excel 2016 Advanced Features & Sparklines ISBN 9781939791955; Excel 2016 Functions & Macros ISBN 9781944684082.

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, Converting a Table to a List Range, Using Table Specifiers in Formulas. Advanced filtering: criteria for Advanced Filters, Using Advanced Filters, Selecting/Ordering Advanced Filter Columns.

Using a pivottable to analyze multiple data Sources, Adding Excel Workbook Tables to the Data Model, Creating a New PivotTable from the Data Model. Written with beezix's trademark focus on clarity, and the user's perspective, accuracy, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016.

Clearing filtering, showing/Hiding AutoFilter, Grouping and Subtotaling List Data. Pivottables: creating a pivottable or pivotchart from worksheet data, refreshing a pivottable, show/hide the PivotTable Fields Pane, Changing How Values are Shown, Sorting and Filtering a PivotTable, Rearranging a PivotTable, Changing the Summary Function, Adding a PivotChart to an Existing PivotTable, Adding/Removing a PivotTable Field, Filtering with Timelines and Slicers.

Sorting & filtering a table or list range: using a List Range, Basic Sorting, Complex Sorting, Filtering and Advanced Filtering, Filtering with AutoFilter.

Windows Version Cheat Sheet of Instructions, Tips & Shortcuts - Microsoft Excel 2016 Introduction Quick Reference Guide - 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:entering and editing datapicking from a drop-down listselecting cellsresizing Column Width and Row HeightInserting and Deleting Rows, Clearing FormattingBorders, Columns and CellsClearing Cells, Shading, Text ColorFormatting Number CellsAligning and Merging Cell ContentsEntering DatesEntering a Sequence of NumbersEntering Formulas & FunctionsEntering SUM and Other Functions QuicklyAbsolute vs.

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. Relative cell referencescopying and moving data: copying to adjacent cells; cut, 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, Copy, Copying, Selecting, Paste; Drag & DropSheet Features: Renaming, Inserting, Deleting Sheets; Editing Multiple Worksheets SimultaneouslyPreviewing, Moving, Selection and Movement Shortcuts.

Recommended companion title covering Office basics: Office 2016 Essentials ISBN 9781939791900 This guide is one of multiple titles available for excel 2016, other excel titles are: excel 2016 charts & formulas isbn 9781939791979; excel 2016 tables, sorting, pivottables, filtering & inquire isbn 9781939791962; Excel 2016 Business Analytics & Sparklines ISBN 9781939791955; Excel 2016 Functions & Power BI ISBN 9781944684143; Excel 2016 Advanced Features & Macros ISBN 9781944684082.

Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2016 Windows Version.

Word 2016 Reference and Cheat Sheet: The unofficial cheat sheet reference for Microsoft Word 2016 and Microsoft Word Online

The content is based on microsoft Word In 30 Minutes, by award-winning author Angela Rose. The word 2016 reference and cheat sheet is an independent publication and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft Corporation. High quality card stock. Almost all of the instructions and examples also apply to Word 2013 as well.

Topics include: what the various ribbons in word 2016 do annotated list of the Word 2016 Home ribbon buttons Inserting headers, charts, page numbers, footers, and more Creating and saving documents Working with MS Word Styles and Themes How to import and export . Rtf,. Txt,. Doc or other formats how to add a footnote, index, endnote, and table of contents to a Word 2016 document How to adjust margins or orientation for printing Finding and replacing text Keyboard shortcuts for both Windows and Mac users These cheat sheets are designed and printed in the USA using high-quality card stock.

Keyboard shortcuts. Do you need a quick reference for ms word 2016? the four-panel Word 2016 Reference & Cheat Sheet contains tips, shortcuts, and an annotated list of the most frequently accessed Word 2016 features. Made in USA. The word 2016 reference and cheat sheet does not cover advanced features of Word 2016, the Microsoft Word mobile apps for tablets and phones, or other Microsoft Office 2016/Office 365 applications.

4 pages.

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

Written with beezix's trademark focus on clarity, and the user's perspective, accuracy, this guide will be a valuable resource to improve your proficiency in using Microsoft Excel 2016. Made in USA. 4 pages. Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use advanced features and macros in Microsoft Office Excel 2016.

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 multiple titles available for excel 2016, other excel titles are: excel 2016 introduction isbn 1939791928; excel 2016 charts & sparklines isbn 9781939791955; excel 2016 functions & Inquire ISBN 9781939791962; Excel 2016 Business Analytics & Formulas ISBN 9781939791979; Excel 2016 Tables, Sorting, PivotTables, Filtering & Power BI ISBN 9781944684143.

Hole punched. This guide is suitable as a training handout, or as an easy to use reference guide, for any type of user. Keyboard shortcuts. High quality card stock. The following topics are covered: advanced features: organizing with grouping - manual, 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, Ungrouping; Hiding Columns, Hiding or Displaying a Group, Rows, Worksheets, Automatic, and Workbooks; Quick Analysis.

.

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

Made in USA. 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, grammar, and deleting a text boxinserting a page breakchecking spelling, orientation, moving, 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 PagesDifferent Views of the Document: Read Mode, Formatting, Resizing, Print Layout, and Draft ViewUsing the HighlighterProofreading Using Smart Lookup and the 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, AutoCorrectPreviewing and Printing DocumentsPrinting Envelopes and Labels.

Also includes: lists of touch Actions, Selection and Movement Shortcuts, Editing and Formatting Shortcuts. Keyboard shortcuts. High quality card stock. Recommended companion title covering office basics: Office 2016 Essentials - Windows Version ISBN 9781939791900 This guide is one of multiple titles available for word 2016 windows version, other word titles are: word 2016 intermediate isbn 9781939791009; word 2016 Templates & Forms ISBN 9781939791030; Word 2016 Advanced ISBN 9781939791016; Word 2016 Mail Merge ISBN 9781939791023.

4 pages.

Microsoft Excel 2016 Charts & Sparklines Quick Reference Guide - Laminated Card - Windows Version Cheat Sheet of Instructions, Tips & Shortcuts

Made in USA. Keyboard shortcuts. Hole punched. 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:charts: inserting a chart, adding and adjusting axis and chart titles, using tables as a data source, switching rows and columns, changing the default chart type, adding visuals, using gridlines, adding explanatory text, adding and adjusting Data Labels, Charting Non-Adjacent Data, Moving a Chart to Another Worksheet, Exploding a Piece of a Pie Chart, Handling Hidden and Empty Cells in a Chart, Creating a Custom Chart Template, Adjusting the Legend, Creating a Chart with Two Scales, Using Styles and Layouts, Creating a Chart Using the Default Chart Type, Changing Chart Type, Inserting a Recommended Chart, Resizing a Chart in the Worksheet, Adding/Removing a Data Series, Using Chart Buttons, Selecting Chart Objects, Adjusting Scale, Understanding Chart Types, Adding a Projection or Trendline to a Data Series, Applying a Custom Chart Type.

Sparklines: creating a sparkline, customizing axis settings, removing sparklines, Changing Marker Color, Customizing Sparklines with Text and Markers, Changing Sparklines Color and Weight, Grouping Sparklines, Changing Sparkline Type, Handling Hidden and Empty Cells in Sparklines. This guide is one of multiple titles available for excel 2016, sorting, other excel titles are: excel 2016 introduction isbn 1939791928; excel 2016 functions & inquire isbn 9781939791962; excel 2016 Business Analytics & Formulas ISBN 9781939791979; Excel 2016 Tables, PivotTables, Filtering & Power BI ISBN 9781944684143; Excel 2016 Advanced Features & Macros ISBN 9781944684082.

. Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Charts/Graphs and Sparklines features of Microsoft Excel 2016 Windows Version. 4 pages. Written with beezix's trademark focus on clarity, and the user's perspective, accuracy, this guide will be a valuable resource to improve your proficiency in using Excel 2016.

Windows Version Cheat Sheet of Instructions, Tips & Shortcuts - Microsoft Outlook 2016 Mail, Calendar, People, Tasks, Notes Quick Reference - Laminated Guide

Great companion product to: word 2016 isbn 9781939791917; excel 2016 isbn 9781939791924; powerPoint 2016 ISBN 9781939791931 Windows Introduction Guides. 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 the folder pane; 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; Manual Send/Receive; Using the Outbox; Using Desktop Alerts. Deleting messages; saving an Attachment; Removing an Attachment; Replying, Forwarding, Printing a Message. Sorting messages; changing the width of the list; grouping messages by conversation; ignoring a conversation; cleaning up redundant messages; Marking a Message as Clutter; 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: displaying the 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; Using a Calendar Group; Using the Weather Panel.

People: displaying people; creating & editing Contacts; Linking Contacts; Deleting a Contact; E-Mailing a Contact; Searching for People; Merging with Contacts. Tasks and to-do items: displaying to-do and task list folders; creating tasks; putting items in the To-Do List; Editing a Task; Marking Complete; Changing Task Order; Assigning Tasks; Viewing To-Do Items in the Calendar; Hiding /Displaying Tasks in the To-Do Bar; Printing Tasks.

Laminated Updated January 2019 - Windows 10 Introduction Quick Reference Guide Cheat Sheet of Instructions, Tips & Shortcuts

High quality card stock. Hole punched. 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:Getting Started: Starting Windows; Ending your Windows session. Accessing apps and content start menu: configuring the Start Menu; Resizing the Start Menu; Pinning an App to Start; Rearranging and Resizing App Tiles; Managing Tile Groups.

Accessing apps and notifications taskbar: Configuring the Taskbar; Pinning an App to the Taskbar; Using Taskbar Jump Lists; Using the Action Center. Working with apps: starting an app; opening an app file document; saving an app file; switching between apps/windows; switch using Task View; Snapping Multiple Apps to the Same Screen; Resizing an App; Moving an App; Maximizing an App; Restoring to Previous Size; Hiding an App; Closing an App; Close an app window from the Taskbar; Searching for Apps; Searching with Cortana; Working with Multiple Desktops.

Managing content with file explorer: managing files and folders with file explorer; customizing the quick access toolbar; navigating in file explorer; customizing the default quick access view; searching in file Explorer; Refine Your Search; Changing File Explorer's Display; Grouping and Sorting Files and Folders; Opening a Second Explorer Window; Creating a Folder; Renaming Files or Folders; Selecting Multiple Items; Selecting Items with Checkboxes; Moving and Copying Files and Folders; Using Cut, Copy & Paste for files; Deleting Files or Folders; Restoring Deleted Items; Deleting Permanently; Linking to a Document, Folder, or App; Sending Files and Folders Zip; Unzipping Extracting Files; Working with Libraries.

Working in tablet mode: Configuring Tablet Mode; Using Tablet Mode. Settings & troubleshooting: using the settings app; adding a picture or slide Show to Your Lock Screen; Setting Up WiFi; Using Airplane Mode; Using the Control Panel App; What to Try if an App Freezes; Getting Help. Users & security: changing Users; Adding User Sign-Ins; Configuring Sign-In.

Word 2019 Reference and Cheat Sheet: The unofficial cheat sheet reference for Microsoft Word 2019

Publisher i30 media offers separate cheat sheets including the excel 2016 reference and cheat sheet isbn 9781939924469, the Google Drive Reference and Cheat Sheet ISBN 9781939924438 and the Google Docs Reference and Cheat Sheet ISBN 9781939924445. High quality card stock. The four-panel reference is printed on 8.

5 by 11 inch high-quality card stock, walls, perfect for desks, and shelves. Keyboard shortcuts. The word 2019 reference and cheat sheet was created by the publisher of the top-selling guides Microsoft Word In 30 Minutes, Google Drive & Docs In 30 Minutes, and Dropbox In 30 Minutes. Hole punched. The word 2019 reference and cheat sheet is an independent publication and is not affiliated with, sponsored, nor has it been authorized, or otherwise approved by Microsoft Corporation.

4 pages. Made in USA. Do you need a quick reference for ms word 2019? the four-panel word 2019 Reference & Cheat Sheet contains tips, shortcuts, and an annotated list of the most frequently accessed Word 2019 features for Windows and macOS. It has holes for three-ring binders. Almost all of the instructions and examples also apply to Word 2016, Word 2013, and Word 2010 as well.

Topics include: what the various ribbons in word 2019 do annotated list of the word 2019 Home ribbon buttons Adding images, shapes, charts, footers, and other elements Inserting headers, and more Creating and saving documents Formatting text, media, text boxes, page numbers, and working with MS Word Styles and Themes How to export .