Advanced Formulas in Excel

Advanced Formulas in Excel
  • Tests
  • Anytime Learning
  • Certificates
  • CPD Accredited Training
  • Video Tutorials
  • 30-Day Refund Guarantee

This advanced Excel course teaches you to combine advanced Excel functions to solve common business problems.


In this course you will learn:

  • How to a dataset using the UNIQUE and FILTER functions
  • How to sort an Excel dataset using formulas and defined variables
  • How to create multi-dependent dynamic drop-down lists in Excel
  • How to use INDEX MATCH and Data Validation to perform a 2-way lookup in Excel
  • How to use AND, OR and IF to create complex logical calculations
  • How to use LEFT, RIGHT, MID, SEARCH and FIND to extract parts of a text string
  • How to combine functions to create a dynamic chart title
  • How to combine functions to find the last occurrence of a value in a list
  • How to use the XLOOKUP function
  • How to combine INDEX, MATCH, MIN and ABS to find the closest match to a value

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.

Sale price
£49.00
Regular price
Sale price
£49.00
Regular price
Sold out
Unit price
per 
Tax included.

This advanced Excel course teaches you to combine advanced Excel functions to solve common business problems.


In this course you will learn:

  • How to a dataset using the UNIQUE and FILTER functions
  • How to sort an Excel dataset using formulas and defined variables
  • How to create multi-dependent dynamic drop-down lists in Excel
  • How to use INDEX MATCH and Data Validation to perform a 2-way lookup in Excel
  • How to use AND, OR and IF to create complex logical calculations
  • How to use LEFT, RIGHT, MID, SEARCH and FIND to extract parts of a text string
  • How to combine functions to create a dynamic chart title
  • How to combine functions to find the last occurrence of a value in a list
  • How to use the XLOOKUP function
  • How to combine INDEX, MATCH, MIN and ABS to find the closest match to a value

+ Syllabus


About the author

Simon Sez IT

For this course, we’ve partnered with training experts SimonSezIT, who help learners win when it comes to computer and software technology. Just like EWB, the SimonSezIT team are passionate about Microsoft applications and computer programs, knowing what makes excellent training work. Their content is inventive and compelling, and we’re sure you’ll love it.


If you are not 100% happy with your EwB course, you have 30 days to exchange or refund.