By using our website you agree to our use of cookies.

Microsoft Excel 2016 / 365 Introduction

1 Day Course
Hands On
Code QAEX16INT

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Getting Started with Excel 2016 / 365 (5 topics)

  • Excel and the Excel Environment
  • Navigate and Select in Worksheets
  • Create a Basic Workbook
  • Open, Save and Close Workbooks
  • Use Microsoft Help

Modifying a Workbook (9 topics)

  • Cut, Copy and Paste Commands
  • Flash Fill
  • AutoFill Options
  • Find and Replace
  • Spelling
  • Undo and Redo
  • Insert and Delete Options
  • Column Width and Row Height
  • Hide and Unhide Options

Using Formulas and Functions (6 topics)

  • Create Relative Formulas
  • AutoCalculate
  • Insert Functions
  • Use AutoSum
  • Copy Formulas
  • Create Absolute Formulas

Formatting an Excel Worksheet (5 topics)

  • Font Group
  • Add Borders and Fill Colours
  • Cell Alignment
  • Number Formatting
  • Cell Styles and Galleries

Managing Worksheets and Workbooks (3 topics)

  • Manage Worksheets
  • Freeze Rows and Columns
  • View Options for Worksheets and Workbooks

Printing Options (5 topics)

  • Print Preview
  • Print Worksheets and Workbooks
  • Page Setup
  • Print Titles
  • Page Layout View

Prerequisites

  • Use a mouse
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with windows - minimise, maximise, open and close
User Microsoft Office Training Courses

Course PDF

Print

Sections