Product Description:

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 Using "Drag and Drop" to Cut, Copy, and Paste 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