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