Sign up to our mailing list

Sign up for more info including course updates,
upcoming courses and the latest news from GTA

Search

Covid 19

Covid 19 Update

In light of the new COVID-19 situation, the GTA has closed its office and training rooms to the public until further notice. The GTA team are working hard to move our portfolio of courses online and we will provide an update shortly. During this period please contact us via email [email protected].

Digital Skills

Microsoft Excel – Intermediate

Alternative Dates

Course details

Start Date

11 May 2021

CPD Points

4

Cost

£195

Length

Half day (09:00-13:00)

Course Overview

This half-day course is designed to assist those wishing to build upon their basic knowledge of Microsoft Excel.

Course Content

  • Relative and absolute cell referencing
  • Using the =If () function and logical functions
  • Understanding statistical formulas such as MAX, MIN etc.
  • Using the =VLookup() function
  • Protecting the worksheet
  • Date, time or percentage formatting
  • Understanding the auto-calculate, basic filter, table and sort functions
  • Using the freeze pane function
  • Creating a basic graph from data, editing and formatting the chart and changing chart type

Course Benefits

This course will equip you with a sound intermediate level knowledge of excel and is the second of our Excel series, the others being Excel Beginners, Excel Advanced and. Excel – An Introduction to Macros and VBA (Visual Basic).

Prerequisites

Ideally you will have completed the ‘Beginners’ module or have a good working knowledge of other Excel versions to begin with.

Next Steps

If you would like to book a place on this course please click on the ‘Book Course’ button to the right of this page and login or register for a user account to complete your booking(s). Any queries please do not hesitate to contact us via [email protected] or call us on 01481 721555.

If no date is scheduled for this course at the present time please click on the ‘Register Interest’ button and login or register for a user account so that we can add you to our course interest register. This register allows us to contact our tutors and finalise dates for a course as soon as we have a few people who have expressed their interest, so the more delegates who register their interest, the sooner we can schedule a particular course.

Course Tutor

  • Jacqui Ward

    Jacqui Ward is the proprietor and trainer of JW Training, specialising in providing Microsoft application training and business consultancy.

    Jacqui is a qualified PRINCE 2 Project Manager and freelance computer software trainer with over 25 years’ experience both in Guernsey and the UK. She has delivered packaged and bespoke training on a corporate, group or one-to-one basis for a variety of major financial companies, the States of Guernsey, Guernsey Electricity and quarterly Excel sessions for the GTA to name just a few.
    In previous roles Jacqui has worked as both a marketing director for an international merchant bank and as an IT business solutions manager. Delegate feedback is consistently high, emphasising Jacqui’s ability to draw on her vast experience to deliver training which is targeted on user requirements in her relaxed, friendly and focused style.

Testimonials

  • Jacqui has a very understanding way about her and no question is a stupid question.

    Emma S

Jacqui has a very understanding way about her and no question is a stupid question.

Emma S

Upcoming Courses

Some courses we run are scheduled based on demand. Please ensure you register your interest to ensure we know which courses you would like to attend.