Microsoft Excel 2016 – Part 1

Course subjects

Lesson 1: Getting Started with Microsoft Excel 2016

TOPIC A: Identify the Elements of the Microsoft Excel Interface

• Microsoft Excel 2016

• What are Spreadsheets, Worksheets, and Workbooks?

• What are Columns, Rows, Cells, and Ranges?

• The Microsoft Excel Interface

• Navigation Options

• Creating a New Blank Workbook

• Creating a New Workbook from a Template

TOPIC B: Create a Basic Worksheet

• The Ribbon

• The Backstage View

• Data Types

• Excel 2016 File Formats

• The Save and Save As Commands

• Saving to Microsoft OneDrive

• Compatibility Mode

• The Convert Option

• The Compatibility Checker

• Checking for Accessibility Issues

TOPIC C: Use the Help System

• Using Tell Me

• Accessing Advanced Help Options

Lesson 2: Performing Calculations

TOPIC A: Create Formulas in a Worksheet

• Excel Formulas

• The Formula Bar

• Elements of an Excel Formula

• Common Mathematical Operators

• The Order of Operations

TOPIC B: Insert Functions in a Worksheet

• Functions

• The Function Library

• Common Functions in Excel

• The Formula AutoComplete Feature

TOPIC C: Reuse Formulas

• The Cut, Copy, and Paste Commands

• Paste Special Options

• Relative References

• Absolute References

• Mixed References

Lesson 3: Modifying a Worksheet

TOPIC A: Manipulate Data

• The Undo and Redo Commands

• The AutoFill Feature

• AutoFill Options

• The Transpose Option

• Live Preview

• The Clear Button

TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows

• The Insert and Delete Options

• Column Width and Row Height Alternation Methods

• The Hide and Unhide Options

TOPIC C: Search For and Replace Data

• Cell Names and Range Names

• The Find Command

• The Replace Command

• The Go To Command

TOPIC D: Spell Check a Worksheet

• The Spelling Dialog Box

Lesson 4: Formatting a Worksheet

TOPIC A: Modify Fonts

• Fonts

• The Font Group

• The Format Cells Dialog Box

• The Format Painter

• Galleries

• Live Preview and Formatting

• The Mini Toolbar

TOPIC B: Add Borders and Colors to Cells

• Border Options

• Fill Options

• Sheet Backgrounds

• Paste Options

TOPIC C: Apply Number Formats

• Number Formats

• Number Formats in Excel

• Custom Number Formats

TOPIC D: Align Cell Contents

• Alignment Options

• The Indent Commands

• The Wrap Text Command

• Orientation Options

• The Merge and Centre Options

TOPIC E: Apply Cell Styles

• Cell Styles

• The Style Dialog Box

Lesson 5: Printing Workbook Contents

TOPIC A: Define the Basic Page Layout for a Workbook

• The Print Options in Backstage View

• The Page Setup Dialog Box

• The Print Preview Option

• Workbook Views

• Headers and Footers

• Header and Footer Settings

• Page Margins

• Margins Tab Options

• Page Orientation

TOPIC B: Refine the Page Layout and Apply Print Options

• Zoom Options

• Page Breaks

• Page Break Options

• The Print Area

• Print Titles

• Scaling Options

Lesson 6: Managing Large Workbooks

TOPIC A: Format Worksheet Tabs

• Renaming Worksheet Tabs

• Changing Tab Color

TOPIC B: Manage Worksheets

• Grouped Worksheets

• Repositioning Worksheets

• Inserting or Deleting Worksheets

• Hiding and Unhiding Worksheets

• Worksheet References in Formulas

TOPIC C: Manage the View of Worksheets and Workbooks

• 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

Lesson 7: Customising the Microsoft Excel Environment

TOPIC A: Customise General and Language Options

• The Excel Options Dialog Box

• The General Category

• The Language Category

TOPIC B: Customise Formula Options

• The Formulas Category

TOPIC C: Customise Proofing and Save Options

• The Proofing Category

• The Save Category

• Version Control

TOPIC D: Customise the Ribbon and Quick Access

• Toolbar

• The Customise Ribbon Category

• The Quick Access Toolbar Category

TOPIC E: Customise the Functionality of Excel

• Enabling Add-Ins

• What Are Add-ins?

• The Add-Ins Category

• The Developer Tab

TOPIC F: Customise Advanced and Trust Center Options

• The Advanced Category

• The Trust Center Category