Duration: 1 day(s)
Course Code: XL16L2
Early Bird Courses
London 10th Jun 2019 £198.25 Book
London 11th Jul 2019 £198.25 Book
London 12th Aug 2019 £198.25 Book
London 24th Sep 2019 £198.25 Book
London 16th Oct 2019 £198.25 Book
London 20th Nov 2019 £198.25 Book
London 10th Dec 2019 £198.25 Book
Click to view further dates
Course Dates Within Next 4 Weeks
London 14th May 2019 Book
Normal price: £305.00+VAT

Microsoft Excel 2016 Level 2

Course Aims

This Microsoft Excel 2016 Level 2 course is aimed at people who want to expand their basic knowledge of Microsoft Excel to work with larger spreadsheets and workbooks, create charts and manage tables of data.

Course Pre-Requisites

Students who wish to attend this course must have a basic knowledge of Excel and feel comfortable with creating, saving, editing and formatting spreadsheets, and creating simple formulas and functions.

Course Objectives

On completion of this course you will be able to:

  • Manage and enhance large Excel worksheets
  • Create formulas across multiple worksheets
  • Copy formats and values across multiple worksheets
  • Create range names and use range names in formulas
  • Copy and link information across multiple workbooks
  • Represent data graphically using charts
  • Understand the concepts an Excel database and create and modify data tables
  • Sort lists and filter information

Course Content

Introduction and Objectives

Using Large Excel Worksheets

  • Increasing & decreasing the magnification
  • Splitting the window,
  • Freezing & unfreezing panes

Working with Multiple Worksheets

  • Navigating between and selecting worksheets
  • Renaming worksheets
  • Selecting multiple worksheets
  • Colouring worksheet tabs
  • Copying & moving worksheets
  • Copying and moving data between worksheets
  • Using grouped worksheets
  • Creating formulas across sheets
  • Creating aggregate functions across sheets
  • Referencing cells across sheets
  • Hyperlinking between sheets

Using Paste Special & Flash Fill

  • Working with Paste Special
  • Copying values & formulas between worksheets
  • Performing mathematical operations
  • Creating data sequences using ‘Flash Fill’

Working with Excel Data Tables

  •  Creating & modifying a data table
  • Working with the data form
  • Creating an Excel table
  • Using the ‘Quick Analysis button” to create an Excel table
  • Use the Slicer to filter an Excel table


Using Multiple Workbooks

  • Opening, activating & tiling workbooks
  • Copying data between workbooks
  • Linking cells between workbooks
  • Managing and troubleshooting workbook links

Creating Charts

  • Creating, moving, resizing, printing & deleting charts
  • Using built-in chart styles and ‘Quick Layouts’
  • Formatting chart objects & data series
  • Adding & removing chart elements (eg. titles, data labels, legend)
  • Changing the data source
  • Changing chart type and location
  • Filtering chart categories and data series
  • Creating chart templates
  • Using ‘Recommended Charts’
  • Advanced chartin
  • Creating a combination chart
  • Using a secondary axis
  • Adding a trendline
  • ‘Sparklines’ (mini charts in a single cell)
  • Using the ‘Quick Analysis button” to create a chart

Analysing Data Tables

  • Sorting tables
  • Sorting a table by multiple fields
  • Filtering data in a table
  • Creating a custom filter
  • The SUBTOTAL function
  • Using the ‘Quick Analysis button” to add totals to a table

Appendix - Using Graphics in a Workbook (if time)

  • Drawing and formatting ‘Shapes’
  • Inserting SmartArt

Click to expand...