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


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 23 Apr 2019 - Download as vCalendar
Opening times 9.30am to 4.30pm
Venue FROG, Great Shelford, Cambridge CB22 5NE
Organiser name Debby O'Gorman
Telephone
01223 841848
Email
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

 

FROG Software Training Limited

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.

FROG Software Training Limited directory information