Learn how to create key Excel formulas to reduce time spent crunching numbers, improve reports and analysis.
This recorded webinar will cover essential Excel formulas, including
Key topics:
- How and when to use Sumifs over Sumproduct
- One cell commission formula
- Lookup formulas - use vlookup to pick up the left most item in a range
- Using indirect and the Address formula to create a dynamic flexible summary report
Learning objectives
- How and when to use Sumifs over Sumproduct
- Lookup formulas - use vlookup to look right and left, lookup the left most item in a rate, lookup multiple text criteria
- Work through the detailed tasks accompanying the webinar to test your knowledge
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.
