Microsoft Excel 2016 Essentials

BCEX16ESS

Code

Classroom/Virtual

Format

£700 ex VAT

£400 ex VAT

Price

1 Day

Duration

Overview

 You will create and edit basic Microsoft Excel 2016 / 365 worksheets and workbooks.

 

Target Audience: This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 / 365 worksheets. This course is suitable for users of Microsoft Excel 2016 or 365 subscription editions. The course will be delivered on Microsoft Excel 2016.

 

Objectives

  • Get started with Excel 2016 / 365
  • Create a basic worksheet
  • Modify a workbook
  • Use formulas and functions
  • Format an Excel worksheet
  • Manage worksheets and workbooks
  • Set up printing options

Course Content

Module 1: Getting Started with Excel 2016 / 365

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

Module 2: Modifying a Workbook

  • 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

Module 3: Using Formulas and Functions

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

Module 4: Formatting an Excel Worksheet

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

Module 5: Managing Worksheets and Workbooks

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

Module 6: Printing Options

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

Book your training session now!