Identifier: 52397462

Duration:

Subscription Period: 365 Days

Language: English

Cost: SGD 50.00

 

Action

Add To Cart

Overview

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

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.

loading...