Got a question? Call 1800 853 276   |   

Microsoft Excel 2016 – Part 1

  • Length 1 day
  • Price $440 inc GST
Course overview
View dates &
book now
  • Register interest

Why study this course

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.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


What you’ll learn

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


Microsoft Office Applications at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

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 contact us on 1800 853 276.


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


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.


Terms & Conditions

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.



Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.