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 Thursday, December 12, 2019 - Download as vCalendar
Venue FROG, Great Shelford, Cambridge CB22 5NE
Contact Name Debby O'Gorman
Email debby@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.