Excel Courses

Introduction to Excel

Introduction to Microsoft Excel is a two night course designed to provide a solid introduction for those new to spreadsheets, and for those self taught users wanting to enhance their knowledge.

 

This course is designed to give the spreadsheet user a thorough understanding in the basics of spreadsheets and using Microsoft Excel.

 

The importance of accuracy, good formula building techniques and sound formatting and design of spreadsheets will be emphasised throughout this course.

 

Upon completion of this course you will be able to:

 

  • Identify the main features of the Excel screen

  • Customise basic settings

  • Use the toolbars and the menu commands

  • Create a new workbook / spreadsheet

  • Understand, create and work with formulas and functions used to perform calculations

Intermediate Excel

This Intermediate Excel course will equip you with the skills and knowledge required to produce more effective and productive workbooks within the Microsoft Excel Program.

At the completion of the Intermediate Excel course you will be able to: 

  • Reviewing Basic formulas

  • Formulas using absolute and relative cells

  • Grouping Worksheets

  • Functions such as

  • 3D Formulas

  • Create Names

  • Functions using names

  • Data Validation

  • Conditional Formatting

  • Protecting your Worksheet

  • Conditional & Logical Functions

 

It is a prerequisite of the intermediate course that you are familiar with introductory excel skills including how to navigate around a workbook and toolbars; enter and edit data quickly; basic formatting and borders; work with ranges of cells; copy and paste data between sheets; be familiar with sort and filter function; complete basic formulas (AutoSum, SUM); use the AutoFill handle.

 

 

Course Details

Introduction to Excel

DATE:                          Monday, 12 and Wednesday 14 November 2018

TIME:                           5.15pm to 8.15pm (2 nights)

COST:                         $150.00

TRAINER:                    Michelle Bate

Intermediate  Excel

DATE:                          Monday, 19 and Wednesday 21 November 2018

TIME:                           5.15pm to 8.15pm (2 nights)

COST:                         $150.00

TRAINER:                    Michelle Bate