Microsoft Excel - Formulas & Functions Course - Bunbury

Overview

Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of formulae and functions and their use in a variety of spreadsheet applications.  

    

This is best for

Experienced Excel user who wants a greater understanding of more sophisticated formulas & functions within Excel.

      

Content

Working with Multiple Sheets

  • Grouping sheets for editing & linking data from multiple sheets
  • Create 3 dimensional formulae
  • Manage multiple sheets with data consolidation
        

Excel Formula & Functions

  • Scoping a formula
  • Working with specific function groups including -

    • Text
    • Date/time
    • Statistical
    • Maths
    • Financial
    • Lookup & reference
    • Logical
  • Nesting & combining functions
  • Formula referencing

Cell Referencing

  • Working with labels and names
       

Protection

  • Protecting worksheets
  • Protecting workbooks

  

Learning outcomes

On completion of this course participants will be able to use multiple files, link these with formulae and work with three dimensional ranges.

They will have an understanding of a wide range of functions and their application and how to build complex formulae and functions.

Prerequisites

Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.

   

Duration

1 day

 

Investment

$450 GST free per person

Includes:

  • Experienced facilitator
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

 

Enjoy Real People, Real Conversations, Real Results 

  

Software versions

Available for 2010, 2013, 2016 & 365