Designed with the busy teacher in mind, this 4-page quick reference guide provides step-by-step instructions in 60 essential topics for Microsoft Excel 2021 & 365. When you and your students need an answer fast, you will find it at a glance with this Microsoft Excel 2021 & 365 Quick Reference Guide. Provided in full-color PDF with high-resolution, not-for-profit reprinting rights. Clear, concise, and easy-to-use, quick reference guides are perfect for teachers, students, individuals, businesses and as supplemental training materials. Includes 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
Other Common Functions