Our courses are short one-day programmes, for more information please click on the course title below:

Basic Excel

Aim:

This course is for users who are new to Microsoft Excel and wish to gain the necessary knowledge to set up their own spreadsheets and to edit and manipulate existing ones.

Course Content:

  • Basic Knowledge
  • Entering, Selecting and Editing Data
  • Creating Formulae and Functions
  • Frequently Used Functions
  • Formatting your Spreadsheet
  • Data Sort and Filter
  • Charts/Graphs

Course Objective:

To develop a good working knowledge of Excel including basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.

Intermediate Excel

Aim:

This course is aimed at users who need to create and manipulate more complex models using some of the more advanced features of Excel.

Course Content:

  • Review Concepts
  • New Features
  • Naming Cell Ranges
  • Linking Sheets and Files
  • Logical Functions
  • Applying and Managing Conditional Formatting
  • Lookup Functions
  • Database List Management
  • Formulae Auditing Formula View
  • Charts/Graphs Advanced Techniques
  • Pivot Tables
  • Protection

Course Objective:

At the end of this course participants will be able to:

  • Create complex formulae incorporating relative & absolute cell addressing
  • Use a wide range of Excel functions such as Sumif, Countif, IF, IF And, Lookups, ISError and many more
  • Build and apply Conditional Formatting
  • Link Sheets and Files
  • Manipulate Data – Sorting, Filtering, Validation
  • Create Pivot Tables
  • Create a wide range of Charts

Advanced Excel

Aim:

This course is aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel.

Course Content:

  • Review of Intermediate level
  • Advanced Functions
  • Summarising Data with Pivot Tables
  • What if Analysis Tools
  • Protecting and Sharing
  • Introduction to Macros
  • Templates
  • Themes

Course Objectives:

At the end of the course participants will be able to:

  • Create complex formulae
  • Use a wide range of Excel functions – Mathematical / Statistical / Financial / Text / Lookup / Date & Time
  • Link worksheets and workbooks via formulae
  • Use Data Validation and Audit a workbook
  • Analyse data using Scenarios / What Ifs / Goalseek
  • Share workbooks
  • Use advanced sorting and filtering features
  • Create advanced Pivot Tables
  • Create and use a keystroke macro

Powerpoint Introduction

Aim:

This course is for users who are new to Microsoft PowerPoint and wish to be able to create professional looking presentations or wish to be able to edit existing ones.

Course Content:

  • Introduction and Overview
  • Parts of the Screen
  • Presentations
  • Slide Masters
  • Slides
  • Formatting Slides
  • Checking the Presentation
  • The Slide Sorter
  • Using Smart Art
  • Charts
  • Drawing
  • Printing
  • Slide Shows
  • Using the ‘Tell me what you want to do’ feature
  • Templates

Course Objectives:

At the end of the course participants will be able to:

  • Create a presentation incorporating a range of slide types
  • Use the Slide Master to control the “look” of the presentation
  • Format Slides
  • Arrange the presentation – Order, Animation, and Transitions
  • Print the presentation – slides, handouts etc.
  • Create a Slideshow
  • Save a Presentation Template

Microsoft Access – Introduction

Aim:

This course is for users who are new to Microsoft Access and want to set up their own databases or learn to manage an exiting database.

Course Content:

  • Introduction and Overview
  • Introduction to Databases
  • Introduction to Access
  • Creating a Database
  • Working with a Table
  • Creating a Query
  • Complex Queries
  • Other Queries
  • Access Forms
  • Using Forms
  • Access Reports
  • Using the ‘Tell me what to do…’ function

Course Objective:

The objective of this  course is to be able to plan, design, create, manipulate and query databases. Once completed you will be capable of using Microsoft Access to generate reports, understand terminology and produce input user forms.