Designed with the busy teacher in mind, this 4-page quick reference guide provides step-by-step instructions in 60 essential topics for Excel for Microsoft 365. When you and your students need an answer fast, you will find it at a glance with this Excel for Microsoft 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

UInterface 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