MS Excel Intermediate

MS Excel Intermediate

Computers, IT and the internet are at the very centre of modern day life.  In our society it is almost impossible to get by without having a basic understanding of IT.  This course is designed for personnel who need to manipulate and interrogate spreadsheets more thoroughly using Microsoft Excel.

Enquire Now
Aim

The aim of this practical one day course is to provide a practical knowledge of how to use spreadsheets to gain information back from data entered.

Benefits

Participants will:

  • Identify and use spreadsheets & graphs correctly
  • Analyse data
  • Understand and use formulae & functions
  • Create and format charts
Programme
  • 3D spreadsheets
  • Linking spreadsheets
  • Linking formulae across sheets and files
  • The formula wizard
  • Graph options
  • Data tables
  • Lookups
  • Pivot tables
  • Sort & filter
  • File management
Approach

This programme uses a mixture of group discussions, pro-forma examples, information input sessions along with practical application to fully involve participants.