1. Self Service Portal
  2. Client System Login
  3. Frameworks
Close Icon
  1. Self Service Portal
  2. Client System Login
  3. Frameworks

Excel Calculating

Formulas, Functions and Multiple Sheets

Note: For our contracted customers (CCS and CPFT only), there is no charge for attending this course, as it's already covered by our partner Service Level Agreement.

It is important that before you attend this training course you are competent with the topics covered on the Microsoft Fundamentals course. If not, please register for our Excel Fundamentals course.

Excel Training Pre-requisites

Completed 1st

Completed 2nd
(in any order after the Fundamentals course)

Completed 3rd
(in any order after the Calculations course)

 ✓ Fundamentals ✓ Calculations
 ✓ Data Analytics - Part 1
 ✓ Tables
 ✓ Data Validation
 ✓ Pivot Tables, filter and sort
 ✓ Charts
 ✓ Data Formatting and Cleansing
 ✓ Dates and Times
 ✓ Data Analysis - Part 2 (max 4 delegates)
 ✓ Excel Macro Recording Fundamentals (on request - max 4 delegates

 

Who is it for?

Anyone who wishes to create Excel formulas and is familiar with the subjects covered on the Microsoft Excel Fundamentals course.

 

How long is the course?

3 hours

 

Objectives

By the end of this course you will be able to create formulas, use some of Excel's built in functions and work with multiple sheets.

 

Course Content

Analysing Data

  • Insert and modify formulas
    • Build, edit and copy formulas
    • Use autosum
    • Use absolute and relative references
    • Use a range name in a formula
    • Adding totals using Quick Analysis [vs. 2016]
    • Apply Conditional formatting to formulas
    • Apply Conditional formatting to formulas, including Quick Analysis formatting [vs. 2016]
  • Use statistical and logical functions
    • Understand basic functions
    • Use statistical functions, for example to calculate an average or find the highest or lowest numbers
    • Use logical functions, including the Count and IF functions
    • Get help with functions
  • Recognising standard error messages

 

Training Dates

    Kingfisher House, Huntingdon:

    • Tuesday 15 October 2019 - 13.30 to 16.30
    • Thursday 31 October 2019 - 13.30 to 16.30
    • Thursday 14 November 2019 - 13.30 to 16.30
    • Tuesday 19 November 2019 - 09.30 to 12.30
    • Wednesday 27 November 2019 - 09.30 - 12.30
    • Friday 06 December 2019 - 09.30 to 12.30
    • Tuesday 24 December 2019 - 09.30 to 12.30

    Victoria House, Cambridge (CPFT employees only):

    • Thursday 17 October 2019 - 13.30 to 16.30
    • Wednesday 20 November 2019 - 09.30 to 12.30

    Cavell Centre, Peterborough:

    • Wednesday 13 November 2019 - 10.00 - 13.00

    Healthy Living Centre, Peterborough:

    • Wednesday 18 December 2019 - 09.30 to 12.30 (Room 2F)

     

    If there are no suitable dates scheduled, please email the IT Training Team and we will endeavour to accommodate your request.

     

    To book this course

    NHS SBS staff - Email our Training Administration team
    CPFT staff - Book via the Academy
    CCS staff - Email our Training Administration team
    Other organisations - Contact our IT Training team

     

     

    If you are interested in other Microsoft courses, please select one of the topics below:

    Access

    Excel

    Outlook

    PowerPoint

    Publisher

    Word

    Visio

    Useful Pages

    Share this page

    Facebook icon Twitter icon Email icon

    Print

    Print icon