Microsoft Office 2016 Excel - Part 1

Microsoft Office 2016 Excel - Part 1


Course Overview

This course teaches students about getting started with Microsoft Office Excel 2016. Students will learn how to perform calculations, modify a worksheet, format a worksheet, and print and manage workbooks.                                                            

Chapter 01 - Getting Started with Microsoft Office Excel 2016

Topic A: Navigate the Excel User Interface

Microsoft Office Excel 2016

Office 365 Portal

Spreadsheets, Worksheets, and Workbooks

Cells and Ranges

Cell and Range References

The Excel User Interface Outer Elements

The Excel User Interface Inner Elements

Excel Window Commands

The Backstage View

Mouse Cursor Icons

Basic Data Entry

Demo - Navigating the Excel User Interface

Topic B: Use Excel Commands

The Ribbon

Tell Me

ScreenTips and KeyTips

The Quick Access Toolbar

The Mini Toolbar and Context Menus

Demo - Using Excel Commands

Topic C: Create and Save a Basic Workbook

The New Tab

The Save and Save As Commands

The Save As Screen

Compatibility Mode

The Convert Option

The Compatibility Checker

Demo - Creating and Saving a Basic Workbook

Microsoft OneDrive for Business

Demo - Signing in to Office 365 and OneDrive

Excel Online

Topic D: Enter Cell Data

Data Types

The Cut, Copy, and Paste Commands

The Undo and Redo Commands

The AutoFill Feature

AutoFill Options

Flash Fill

Demo - Entering Cell Data

Topic E: Use Excel Help

The Excel 2016 Help Window

Demo - Using Excel Help

Chapter 01 Review

Chapter 02 - Performing Calculations

Topic A: Create Worksheet Formulas

Excel Formulas

The Formula Bar

A Basic Mathematical Formula

Elements of Excel Formulas

The Order of Operations

Intersection Operator

Demo - Creating Worksheet Formulas

Topic B: Insert Functions


The Function Library Group

The Insert Function Dialog Box

The Function Arguments Dialog Box

Graphical Cell and Range Reference Entry

The AutoSum Feature

Other Commonly Used Functions

Basic Function Syntax

The Formula AutoComplete Feature

The Arguments Tooltip

Demo - Inserting Functions

Topic C: Reuse Formulas and Functions

The Paste Options

The Paste Special Dialog Box

Relative References

Absolute References

Mixed References

AutoFill and Formulas

Worksheet References

Excel Errors

Error Indicators

Demo - Reusing Formulas and Functions

Chapter 02 Review

Chapter 03 - Modifying a Worksheet

Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows

The Insert and Delete Options

Manual Width and Height Adjustments

Manual Fit

The AutoFit Feature

The Row Height and Column Width Dialog Boxes

The Hide and Unhide Commands

Demo - Adjusting Cells, Columns, and Rows

Topic B: Search for and Replace Data

The Find Command

The Replace Command

The Go To Dialog Box

The Go To Special Dialog Box

Demo - Searching for and Replacing Data

Topic C: Use Proofing and Research Tools

The Spelling Dialog Box

The Thesaurus Task Pane

The Insights Task Pane

Demo - Checking the Spelling in a Worksheet

Chapter 03 Review

Chapter 04 - Formatting a Worksheet

Topic A: Apply Text Formats


The Font Group

Live Preview

The Format Cells Dialog Box

The Colors Dialog Box


The Insert/Edit Hyperlink Dialog Box

The Format Painter

Demo - Formatting Text in a Worksheet

Topic B: Apply Number Formats

Number Formats

Number Format Tab

Custom Number Formats

Demo - Applying Number Formats

Topic C: Align Cell Contents

Alignment Options

The Indent Commands

The Wrap Text Command

Orientation Options

The Merge & Center Options

Demo - Aligning Cell Contents

Topic D: Apply Styles and Themes

Cell Styles


The Style Dialog Box

The Merge Styles Dialog Box


Guidelines for Using Themes

Demo - Applying Cell Styles and Themes

Topic E: Apply Basic Conditional Formatting

Conditional Formatting

The Conditional Formatting Dialog Boxes

The Highlight Cells Rules

Data Bars

Color Scales

Icon Sets

Demo - Applying Basic Conditional Formatting

Topic F: Create and Use Templates


Templates and the Backstage View

Demo - Creating a Template

Chapter 04 Review

Chapter 05 - Printing Workbooks

Topic A: Preview and Print a Workbook

The Print Tab

Print Settings

Page Orientation


Print Preview

Demo - Configuring and Previewing a Print Job

Topic B: Set Up the Page Layout

The Page Setup Dialog Box

The Print Area

The Print Titles Command

Page Breaks

Workbook Views

Page Break Preview View

Demo - Setting Up the Page Layout

Topic C: Configure Headers and Footers

Headers and Footers

Page Layout View

Contextual Tabs

The Header & Footer Tools Contextual Tab

The Header and Footer Dialog Boxes

Demo - Configuring Headers and Footers

Chapter 05 Review

Chapter 06 - Managing Workbooks

Topic A: Manage Worksheets

Tab Formatting Options

Drag to Reposition Worksheets

The Move or Copy Dialog Box

Methods of Inserting and Deleting Worksheets

The Hide and Unhide Worksheet Options

Topic B: Manage Workbook and Worksheet Views

Custom Views

The Add View Dialog Box

The Split Command

The Freeze Panes Options

The Arrange All Command

The Arrange Windows Dialog Box

The View Side by Side Command

The Switch Windows Command

The New Window Command

Topic C: Manage Workbook Properties

Workbook Properties in the Backstage View

The Properties Dialog Box

Custom Workbook Properties

Chapter 06 Review

Course Closure

Microsoft Office 2016 Excel - Part 1
tag icon Price $49.99
tag icon Instrutor 1
tag icon Duration 4h 17m
tag icon Lessons 6
tag icon Access 12 Months
Add to Cart