Ready to Checkout?

shopping-cart

Quality Training Since 2001

Microsoft Excel 2016 Introductory Quick Reference Guide

  Excel 2016 Introductory Quick Reference Guide
Subject: Excel
Version: 2016
Level: Introductory
Topics Covered: 59
Pages: 4
Dimensions: 11 x 17″ – Folded
Cover: Laminated
ISBN: 978-1-941854-09-9
Quantity: Price:
1-49 $5.75
50-99 $4.60
100-499 $4.20
500-999 $3.85
1000+ $3.45
Qty:  


Product Description

Designed with the busy professional in mind, this 4-page laminated 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. Durable 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

TOP