Learn how to create key Excel formulas to reduce time spent crunching numbers, improve reports and analysis.
Overview
Learn how to create key Excel formulas to reduce time spent crunching numbers, improve reports and analysis.
Using practical exercise for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- This recorded webinar will cover the essentials of Excel formulas, such as
- 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. Click here for Marcus' biography.
Course updated: 2020
Objectives
- Learn the important Excel functions used in finance data and reports
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.