Intermediate Excel
Starting DateJuly 23, 2020
DurationOne and a half days
LocationOnline
CertificateN/A
CostTo Be Confirmed
Course code7063

Programme Overview

This course is designed to give users more advanced commands and functions and how to apply these in their own working environments.

Learning Outcome

  • Learn Custom Lists
  • Learn about Advance Data Validation
  • Learn about Subtotals
  • Learn about Data Clean Up Tools

 

Who is this course for

  • Everyone

Modules

  • Functions – countifs/sumifs/averageifs/choose/match/index
  • Advanced data validation
  • Custom lists
  • Subtotals
  • Data clean up tools
  • Pivot Tables
  • More Macros

Trainer Profile

 

Applications Closing on 20th July 2020