Excel 2007/2010/2013/2016 Advanced - Formulae and Functions

Short course

In Cambridge

Save 4%
£ 205 + VAT

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Cambridge

  • Duration

    1 Day

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. Suitable for: Designed for existing users of Excel.

Facilities

Location

Start date

Cambridge (Cambridgeshire )
See map
4 Station Court, Great Shelford, CB225 NE

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Formula referencing
  • Create multi function calculations
  • MS Excel
  • Excel
  • Excel 2007
  • Excel 2010
  • Excel 2013
  • Excel 2016
  • Accounts
  • Accounting

Teachers and trainers (1)

TBA TBA

TBA TBA

Trainer

Course programme

Excel Advanced Advanced Formulae and Functions

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 WorkbooksLink workbooks

Use multiple workbooks

Save a workspace

Consolidate information

Forecasting

Goal Seek

Scenario Manager

Solver
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

Additional information

FROG have been providing excellent training for 30 years

Excel 2007/2010/2013/2016 Advanced - Formulae and Functions

£ 205 + VAT