Excel 2016 Introduction Quick Reference
Laminated quick reference showing step-by-step instructions and shortcuts for how to use Microsoft Excel 2016 (Windows version). The following topics are covered:
Entering and Editing Data
Picking from a Drop-Down List
Resizing Column Width and Row Height
Inserting and Deleting Rows, Columns and Cells<
Clearing Cells, Clearing Formatting
Borders, Shading, Text Color
Formatting Number Cells
Aligning and Merging Cell Contents
Entering a Sequence of Numbers
Entering Formulas & Functions
Entering SUM and Other Functions Quickly
Absolute vs. Relative Cell References.
Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop.
Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Worksheets Simultaneously.
Previewing, Printing and Page Setup
Scaling to Print
Printing a Specific Area
Using Page Break Preview to Adjust Page Breaks
Repeating Rows/Columns on Every Page.
Also includes a list of Touch Actions, Selection and Movement Shortcuts.