FROG Software Training: Excel Advanced - Formulae and Functions

Designed for existing users of Excel who wish to increase their knowledge with the more popular common functions in Excel. It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.

Objectives

By the end of this course you will be able to create a wide range of advanced calculations, be able to create custom formats and use conditional formatting to display data in various formats based on a condition.  

Advanced Autofill 

  • Flash Fill 
  • Fill Options

 

Advanced Formatting

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

 

Formulae 

  • Refresh on Formulae and basic Functions
  • Absolute referencing ($)
  • Mixed referencing 
  • Use Names in a formula 

 

Advanced Functions 

  • Text Functions to Clean Data
  • IF and Nested Functions – IF / COUNTIF /SUMIF
  • Logical Functions  - using AND / OR
  • Lookup Functions  - VLOOKUP / HLOOKUP
  • Date Functions – TODAY / NOW / NETWORKDAYS

 

Auditing Worksheets

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

Looking for something specific?