Length
1 day

Overview

This course is intended to help all novice computer users get up to speed with Microsoft Excel quickly.

We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting.

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Microsoft Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

Key Topics

Detailed Info
  • Getting Started with Microsoft Excel 2016
  • Formatting a Worksheet
  • Managing Large Workbooks
  • Performing Calculations
  • Modifying a Worksheet
  • Printing Workbook Contents
  • Customising the Microsoft Excel Environment
Skills Gained
Key Topics
Target Audience
Prerequisites

Skills Gained

At the completion of this course you should be able to:

  • Create a new spreadsheet
  • Work with basic formula
  • Make a spreadsheet look professional and presentable
  • Save and print a spreadsheet

Key Topics

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

Target Audience

This course is designed for users new to Microsoft Excel 2016 and spreadsheeting as a concept.

We can also deliver and customise this training course for your organisation. For more information, please email [email protected]

Prerequisites

This manual assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Excel is necessary.

Print course details

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Book Your Course

Virtual Classroom
July 27 2021 - July 27 2021
July 29 2021 - July 29 2021

Email Course Outline
Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.