Excel Basic

Open Courses > Business Support Courses

Introduction

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.

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.

  • 3D spreadsheets
  • Linking spreadsheets
  • Linking formulae across sheets and files
  • The formula wizard
  • Graph options
  • Data tables
  • Lookups
  • Pivot tables
  • Sort & filter
  • File management

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

Participants will:

  • Identify and use spreadsheets & graphs correctly
  • Analyse data
  • Understand and use formulae & functions
  • Create and format charts
Go Back

Book a Short Course