Excel Training
Starting DateMarch 24, 2022
DurationOne Day
LocationDonegal
CertificateN/A
CostTo Be Confirmed
Course code9018

Programme Overview

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

Learning Outcome

  • Learn Range Names
  • Conditional Functions, if, nested if, countif, sumif, averageif
  • Conditional formatting
  • Formula Auditing Tools
  • List management – custom sort/freeze panes/data validation
  • Worksheet management & linking – linking content/protecting worksheets and workbooks

Who is this course for

  • Everyone

Modules

Modules to include;

  • Range Names
  • Conditional Functions, if, nested if, countif, sumif, averageif
  • Vlookup/Hlookup
  • Conditional formatting
  • Formula Auditing Tools
  • List management – custom sort/freeze panes/data validation
  • Worksheet management & linking – linking content/protecting worksheets and workbooks
  • Macros – introductio

Trainer Profile

Applications Closing on 21st March 2022