Intermediate Excel

Start date: 22 June 2021

Location: Online Webinar

Cost: FREE

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.