Our workshops

Length: Approx 4.5 hours exc breaks

Cost: $395 excl GST per person

Attendees: Min 2 - Max 4 per course

Requirements: A willingness to learn.

What's provided: Laptop and exercises, plus the option to purchase a workbook to keep.

ABOUT THIS COURSE.

This module will familiarise you with the most fundamental concepts of what Excel is about; creating spreadsheets with an emphasis on managing your spreadsheet - including worksheet navigation and set-up, with examples along the way.

The course is written to take you from no or limited knowledge to being able to grasp the essentials. The training is based around practical applications. You will be stepped through some basic layouts, terminology, inputting and formatting your data, an introduction to creating formulas and some handy functions, through to how to save your workbook.

We work at the speed of the class, with over 20 interactive examples provided for you to test drive your new knowledge.

At the end of this module you will feel ready to advance your skills to the next level - learning timesaving data analysis and presentation skills which will allow you to use Excel to produce well-designed robust spreadsheets allowing you to manipulate, analyse, produce graphs and problem solve scenarios.

It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review the course handbook material once you are back at your workplace.

PREREQUISITES

None - this course will familiarise you with the absolute fundamentals.

COURSE OUTLINE

• Starting Excel

• The Excel Window and working with the Excel Environment

• The Backstage View

• Modifying worksheet views

• Entering and editing data

• Navigating around the workbook

• Working with and naming worksheets

• Selecting ranges

• Using formulae & functions

• Double checking your formulas

• Inserting & deleting rows & columns

• Cut, copy and paste

• Number formatting

• Using absolute & relative references

• Formatting and changing the worksheet appearance.

AT COURSE COMPLETION

This course is designed to provide the fundamental concepts for using a spreadsheet application with an emphasis on creating formulas and managing your spreadsheet. It provides the foundation for immediate spreadsheet use and future development.

Length: Approx 4 hours exc breaks.

Cost: $395 excl GST per person

Attendees: Min 2 - Max 4 per course

Requirements: A willingness to learn. 

What's provided:  Laptop and exercises, and the option to purchase a reference workbook to keep.

ABOUT THIS COURSE.

This course is perfect if you are looking for pointers on presenting data in a clear and meaningful way.

With pivot tables you can quickly explore, analyse and summarise your data, revealing insights that you might not otherwise quickly see. Pivot tables are gold for providing you with fast and accurate solutions to complicated analytical questions. This course will show you when, why, and how to use Pivot tables, it's perfect for stepping up your analytical skill set when using Excel.

PREREQUISITES.

We recommend that you first complete our Essential Skills course, or have a good level of knowledge and comfort with Microsoft Excel before attending this workshop.

Course participants should be comfortable with:

• Creating Excel formula

• Familiar with Excel functions (e.g. SUMIFS, COUNT, MAX AVERAGE)

• Familiar with relative and absolute cell referencing ($A$1)

COURSE OUTLINE

• Chart types, using and editing charts.

• Layout, styles, and formatting of your pivot tables.

• Using pivot charts and slicers.

• Creating a dashboard.

AT COURSE COMPLETION

This course is designed to provide the fundamental concepts for using and creating dynamic charts, pivot tables and how they can be used to establish a dashboard for monthly reports. 

Length: Approx 4.5 hours excl breaks

Cost: $395 excl GST per person.

Attendees: Min 2 - Max 4 per course

Requirements: A willingness to learn.

What's provided: Laptop and exercises plus the option to purchase a reference workbook to keep.

ABOUT THIS COURSE.

You've got the basics nailed and you are now ready to explore some of the more advanced formulas, functions and tools that Excel has available for you to use.

If you're ready to learn ways to use Excel that will improve your productivity and performance in all sorts of areas - equipping you with ways to become a more proficient Excel user then this workshop is right for you.

Our aim is to provide you with the necessary skills that use the best methods to efficiently analyse data in your spreadsheet.

PREREQUISITES.

We recommend that you first complete our Essential Skills workshop.  Alternatively, you should have a solid base level of being able to use Excel, including basic formula and function writing, and using absolute references.

COURSE OUTLINE.

• Build upon your knowledge of basic formula and functions, and learn some more advanced functions, such as logic-based IF functions, SUMIF, SUMIFS and nested IF formulas.

• Use advanced sorting and filtering techniques.

• Group and outline your data.

• Lookup and retrieve information from your data.

• Apply data validation and error messages.

• Use What if? analysis to problem solve.

• Use Excel Tables.

We will work at the speed of the class and you will gain hands-on experience as we practice examples for your newly honed skills during the class.

AT COURSE COMPLETION.

This course is designed to equip you with ways to analyse data. It provides the foundation for advanced spreadsheet use and future development.

A new half-day workshop for the very beginner.  Approx 3 hours of interactive Word and Excel learning.