Events

Microsoft Excel – Beginners Course

Date & Time

7 Dec 09:00 - 13:00

Location

GTA University Centre, Guernsey

Course Summary

This half-day course is designed to assist those wishing to learn the basic functions of Microsoft Excel. You will learn how to create calculations and graphs, as well as getting to grips with formatting.

Topics

  • Introduction to Spreadsheets
  • The Excel 2007 Workspace
  • Formatting, copying and moving Worksheets and formatting cells, rows and columns
  • Simple arithmetic calculations including working with percentages
  • Creating and editing basic formulas using logical operators i.e. +, -, / and *
  • Inputting data and automatic formatting and functionality
  • Moving and copying Data
  • Understanding a 'series' of data and Autofill function
  • Understanding how a formula is entered and constructed
  • Creating Graphs
  • Formatting numbers, text and cells
  • Using the =SUM() and =ROUND() functions
  • Understanding Print and Print Preview, scaling output and how to set and clear a Print Area

Course Benefits

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

Tutor Profile

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.