Intermediate Excel

Start date: 10 April 2019

Location: Boyle Enterprise Centre

Cost: €40

Programme overview

Course Content

  • Tips and Tricks
  • Working with multiple Worksheets
  • Spreadsheet Formatting
  • Functions
  • Working with Lists
  • Using Worksheet Protection
  • Linking Data
  • Introduction to Pivot Tables
  • Charts

Course Objective

To create complex models involving multiple linked sheets and files; to analyse data using what-ifs and scenarios; validate and audit data; generate reports using Pivot Tables.