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.

365 Days

loading...