Excel 2016 Training Guide Quick Reference Card 4 Page Cheat Sheet Instructions
Excel 2016 Introductory Guide- Quick Reference Card (Laminated Cheat Sheet)
Product Details:
Product Name: Microsoft Excel 2016 Introductory Guide- Quick Reference Card (Laminated Cheat Sheet)
Manufacturer: TeachUcomp, Inc.
Versions Covered: 2016
Level: Introductory
Pages: 4
Dimensions: 11 X 17"' Folded
Product Type: Laminated Cheat Sheet
Designed with the busy professional in mind, this 4-page quick reference guide provides step-by-step instructions in Excel 2016. When you need an answer fast, you will find it right at your fingertips with this Microsoft Excel 2016 Quick Reference Guide. Clear and easy-to-use, quick reference cards are perfect for individuals, businesses and as supplemental training materials. Includes touch gestures and keyboard shortcuts.
Topics Covered:
Interface Basics
Using the Ribbon
Using the File Tab and Backstage View
Using the Quick Access Toolbar
Enabling and Disabling Touch Mode
Changing Workbook Views
File Management Basics
Creating New Workbooks
Saving Workbooks
Opening Workbooks
Recovering Unsaved Workbooks
Data Entry
Selecting Cells
Entering New Data
Picking from a Drop-Down List
Using AutoFill for Data Entry
Using Flash Fill
Formulas
Understanding Formulas
Ranged Formula Syntax
Simple Formula Syntax
Entering a Formula
Understanding 3D Formulas
Ranged 3D Formula Syntax
Simple 3D Formula Syntax
Entering a 3D Formula
Inserting Functions
Using AutoSum and Quick Entry Functions
Editing a Range
Using AutoCalculate
Copying and Pasting Formulas
Relative vs. Absolute Cell References
Cutting, Copying and Pasting
AutoFilling Formula Cells
Using Paste Special
AutoFilling Formula Cells
Undo and Redo
Adjusting Columns and Rows
Selecting Columns, Rows and Worksheets
Resizing Column Width and Row Height
Hiding and Unhiding Columns and Rows
Inserting and Deleting Columns and Rows
Formatting Worksheets
Formatting Text, Shading and Borders
Formatting Number Cells
Aligning and Merging Cells
Using the Format Cells Dialog Box
Copying Cell Formatting
Clearing Cells and Cell Formatting
Worksheet Tools
Inserting and Deleting Worksheets
Selecting and De-Selecting Multiple Worksheets
Navigating Worksheets
Renaming Worksheets
Coloring Worksheet Tabs
Moving and Copying Worksheets
Worksheet Layout
Adjusting Page Breaks
Changing Page Size, Orientation and Margins
Repeating Rows/Columns on Every Page
Printing
Viewing Worksheets as they Will Print
Previewing and Printing Worksheets
Adjusting Scaling to Print
Printing a Specific Worksheet Area
Touch Actions
Using a Touch Interface
Keyboard Shortcuts
Moving in Worksheets and Workbooks
Selecting Cells, Columns and Rows
Entering Data
We accept PayPal for all orders- the safest way to shop on eBay.
Physical Products:
We offer FREE shipping on all U.S. orders.
Your order will be shipped within 1 business day of receiving payment (Monday-Friday).
In the very unlikely event that your item is lost or damaged during shipment, please be sure to let us know. We will issue either a full refund or replacement.
If you are not 100% satisfied with your purchase, you can return the product and get a full refund (minus any shipping costs) or exchange the product for another one.
You can return a product for up to 30 days from the date you purchased it.
Any physical product you return must be in the same condition you received it and in the original sealed packaging.
Please use the eBay message center to contact us. This assures that we receive your message. We are open Monday through Friday 9-5 Eastern and will answer you within one business day.
We're always happy to answer questions. We want to make your buying experience as pleasurable as possible.
