FROG Software Training: Excel 2007/2010/2013/2016 Advanced - Formulae and Functions


By the end of this course you will be proficient in the use of advanced formulae and functions, you will have gained an understanding of Formula referencing and be able to create multi function calculations.

Dates Wednesday, July 22, 2020 - Download as vCalendar
Venue FROG Software Training Ltd, Great Shelford, Cambridgeshire CB22 5NE
Contact Name Rachel Crew
Email rachel.crew@frog.co.uk
Contact Phone 01223 841848
Website Event website

Event details:

Pre-requisites
It is assumed that the participant will have either attended an Excel Intermediate course or has equivalent knowledge.

Objectives
By the end of this course you will be proficient in the use of advanced formulae and functions, you will have gained an understanding of Formula referencing and be able to create multi function calculations.

Formulae

  • Refresh on Formulae
  • Absolute referencing
  • Mixed referencing

Named Ranges

  • Add & delete a named range
  • Use named ranges in a formula
  • Natural Language

Set Display Options   

  • Customise Quick Access Toolbar
  • Customise the Ribbon
  • Excel Options

Advanced Autofill

  • Fill Weekdays
  • Fill Values Only
  • Growth Trend

Format Worksheets

  • Apply accounting, currency & scientific formats
  • Create custom number formats
  • Conditional formatting

Multiple Workbooks

  • Link workbooks
  • Use multiple workbooks
  • Save a workspace
  • Consolidate information

Forecasting

  • Goal Seek

Advanced Functions

  • String functions
  • Logical functions
  • Random numbers and rounding
  • Nesting If’s
  • CountIfs
  • SumIfs
  • Handling errors
  • HLookups
  • VLookups
  • Date Functions
  • Subtotals

Auditing a Worksheet

  • Check and review data
  • Finding cells that refer to a specific formula
  • Finding formulas that refer to a specific cell
  • Finding errors

Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.