Learn how to use essential Excel formulas like SUMIFs and SUMPRODUCT to create summaries based on multiple criteria and solve advanced problems using formulas like XLOOKUP, LOOKUP, and nested formulas.
Description
In this recorded webinar, you will learn important Excel formulas, such as SUMIFs and SUMPRODUCT. You'll discover when to use each formula and how to use them to create summaries based on multiple criteria. Additionally, the webinar will cover more complex problems using SUMPRODUCT and newer formulas like XLOOKUP, while including LOOKUP and other nested formulas.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- How and when to use SUMIFs over SUMPRODUCT
- One cell commission formula
- LOOKUP formulas to look left and right, select the left most item in a range, lookup multiple text criteria
- Using INDIRECT and the ADDRESS formula to create a dynamic flexible summary report
As part of this webinar you will receive,;
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Clickherefor Marcus' biography.
Course updated: May 2023
Learning objectives
- Explain the differences between SUMIFs and SUMPRODUCT formulas, and how to choose the appropriate one for creating summaries based on multiple criteria in Excel.
- Apply advanced techniques for solving complex problems using SUMPRODUCT formulas
- Demonstrate the use of newer formulas like XLOOKUP and nested formulas to efficiently solve problems in Excel.
- Demonstrate a solid foundation of essential Excel formulas and problem-solving techniques and apply them to financial analysis and reporting tasks.