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


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

For existing Excel users who wish to become proficient in the use of advanced formulae and functions. Our training centre is located on the outskirts of Cambridge with easy road and rail transport links. We provide professional and enthusiastic training and of course there is the pub lunch to look forward to!

Dates 12 Dec 2018 - This event is in the past.
Opening times 09.30-16.30
Venue FROG, Great Shelford, Cambridge CB22 5NE
Organiser name Debby O'Gorman
Telephone
01223841848
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
    • 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
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