Moving On Up - Getting to the Next Level with Excel Functions & Formula Knowledge

Introduction

This virtual classroom seminar will uncover more advanced level Excel functions and techniques.

This live session is useful for regular Excel users who want to go to the next level in their Excel formula knowledge.

It is ideal for those who create reports in Excel or work with formulas regularly.

What You Will Learn

This live and interactive session will cover the following:

• The brilliant SUMIFS and COUNTIFS functions - multiple examples
• The INDEX function - the versatile lookup function
• XLOOKUP function - the successor to VLOOKUP
• How to harness the power of dynamic arrays and tables in your formulas
• Use formulas with charts and in conditional formatting rules

Recording of live sessions: Soon after the Learn Live session has taken place you will be able to go back and access the recording - should you wish to revisit the material discussed.