Excel Core Level 4

Description

Delegates should be confident in creating their own spreadsheets including formulas and functions requiring absolute and partial absolute cell referencing. In addition delegates must be confident in writing formulas and functions using basic range names and multiple work sheets/books. This is a high level, fast-paced course and if you are not confident in these areas we would recommend you consider one of our Level 2 or 3 courses first.

What you will learn

  • Cross reference information from specific rows and columns in a table using INDEX and MATCH
  • Make your Lookups and Indexes more powerful using other functions such as, INDIRECT, MATCH
  • Use the Formula Evaluator to make it easier to fix errors
  • Create and use Dynamic Range names to ensure that functions continue to reference new data
  • Using Arrays in Non-Array Formulas
  • Basic and Logical Array Formulas
  • Workshop, consolidating nesting functions and problem solving in Excel. Including Dependent Data Validation Lists using Indrect, Nesting and Using Dynamic Range Names

Further information

Happy
Provider:
Happy
Duration:
1 Day
Price:
£300 (ex VAT)
Availability:
Scheduled dates
Course type:
Classroom
Locations:
London

Contact Information

Happy

3rd Floor
9 Alie Street
London
E1 8DE

Locations