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. 

Dates Tuesday, February 23, 2021 - Download as vCalendar
Event Times: 09:30 to 16:30
Venue Microsoft Teams
Contact Name Rachel Crew
Email training@frog.co.uk
Contact Phone 01223841848
Website Event website

Event details:

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.  If time, you will be able to combine data across sheets and files effectively and perform error checks.

 

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

For over 30 years we have improved the skillset of over 20,000 individuals with our exceptional and enjoyable courses. Our training and support started back in 1986, when our founder was working with Stephen Hawking as his PA. But you don’t have to be a world-famous theoretical physicist to take part in our training – All our courses from beginner to advanced level provide you with actionable, hands-on training that you can put into practice immediately and save you valuable time!