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
020 7375 7300
Email