Intermediate Excel

Start date: 17 June 2019

Location: Boyle Enterprise Centre

Cost: €40

Course Aim

This course will provide participants with some experience of Microsoft Excel, the opportunity to learn new Excel features in order to achieve more complex tasks.

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.