Excel Training
Starting DateApril 7, 2022
DurationOne Day
LocationDonegal
CertificateN/A
CostTo Be Confirmed
Course code9028

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 28th March 2022