Designed for existing users of Excel who wish to increase their knowledge with the more popular common functions in Excel.
FROG Software Training: Excel Advanced - Formulae and Functions
It is assumed that the participant will have either attended an Excel Intermediate course or have equivalent knowledge.
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.
- Flash Fill
- Fill Options
- Styles and Themes
- Custom Number Formatting
- Conditional Formatting
- Quick Analysis Tool
- Refresh on Formulae and basic Functions
- Absolute referencing ($)
- Mixed referencing
- Use Names in a formula
- 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
- 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!