| Print |

Excel Advanced - Formulae and Functions

Location Cambridge
Price ex. VAT 215 GBP
Start Date 20 June 2019
Course type Standard
Course code FROG226
Duration 1 Day

Description

By the end of this course you will be able to create a wide range of advanced calculations including IFs, LOOKUPs, Date and Text Functions.

Target Audience

Designed for existing users of Excel.

Prerequisites

It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.  A basic understanding of calculations in Excel is essential although there will be a refresher of this topic.

Outline

Advanced Autofill 

  • Flash Fill 
  • Fill Weekdays 
  • Fill Values Only 
  • Growth Trend 

Advanced Formatting

  • Styles and Themes
  • Custom Number Formatting
  • Conditional Formatting
  • Quick Analysis Tool

Formulae 

  • Refresh on Formulae 
  • Absolute referencing 
  • Mixed referencing 

Named Ranges 

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

Advanced Functions 

  • Text Functions 
  • Logical Functions 
  • Lookup Functions
  • Date Functions
  • Round Functions 
  • IF and Nested Functions
  • COUNTIF
  • SUMIF 

Multiple Workbooks 

  • Link Workbooks 
  • Arrange Workbooks 
  • Consolidate Data

What-If Analysis 

  • Goal Seek 

Auditing Worksheets

  • Checking Errors
  • Formula Evaluator
  • Watch Window
  • GoTo Special

Customising/Options

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

Book the course: Excel Advanced - Formulae and Functions

Course Search