×

Contact Us

Corporate Headquarters

TeachUcomp, Inc.
1140 Abbot Road
#64
East Lansing MI 48823
USA

Phone

Toll Free (U.S. and Canada): 877-925-8080
International:  +1-517-333-2560

Email

sales@teachucomp.com

Hours of Operation

Monday-Friday 9:00-5:00 Eastern.

Policies

Privacy Policy

Terms and Conditions

Excel 365 Introductory Quick Reference Guide

$5.95

Available via Printed/Laminated (Shipped/Physical) or PDF (Download Only):

Quantity: Price:
1-49 $5.95
50-99 $4.85
100-499 $4.05
500-999 $3.50
1000+ $3.35

Clear

Description

Subject: Excel
Version: 365
Level: Introductory
Topics Covered: 59
Pages: 4
Dimensions: 11 x 17″ – Folded
Availability: Printed & Laminated or PDF Download
ISBN: 978-1-941854-61-7

Product Description

Designed with the busy professional in mind, this 4-page quick reference guide provides step-by-step instructions in Excel 365. When you need an answer fast, you will find it right at your fingertips with this Microsoft Excel for Office 365 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

You may also like…

TOP
SALE! $49 All-Access 0 Days 9 Hours 17 Minutes 28 Seconds      $199 $49 Entire Library!
See Deal