Convention_edited.png

Want your whole team to attend this seminar? Contact us to enquire about an in-house training session. 

We come to you to deliver the training, we can even personalise the content to be specific to your oganisation.

Book an in-house session?

Seminar Overview

Become a Microsoft Excel master with our EXCE201 seminar. Moving on from the fundamentals, this workshop delves into more complex functionality of Excel.

Pivot tables, quick analysis, complex formulas, and functions are just part of the key learning outcomes of this program.

This program assumes knowledge of our EXCE101 - Microsoft Excel Beginners program.

Course Outline

  • Use common worksheet functions.

  • Use filling techniques.

  • Apply a variety of page setup techniques.

  • Use a range of techniques to work with worksheets.

  • Apply borders to cells and ranges in a worksheet.

  • Create and use defined names in a workbook.

  • Apply conditional formatting in ranges in a worksheet.

  • Create and work with tables.

  • Use a variety of financial functions.

  • Select and change the format of object in a chart.

  • Use a range of elements and features to enhance charts.

  • Create more complex formulas and functions.

  • Apply a range of number formatting techniques to sheet cells.

  • Understand and use Excel's Quick Analysis tools.

  • Understand and create basic pivot tables


Suggested Participants

Seminar participants will be required to bring a laptop to the session with Microsoft Excel installed.

The presenter will be using 2019 version, if you are using an older version, the functionality may not be available during the session.

2022 Dates

  • Wednesday, 25 May 1pm - 4pm AEST

  • Tuesday, 30 August 1pm - 4pm AEST

  • Thursday, 17 November 1pm - 4pm AEDT

Program Testimonial

"I am a lot more confident now using excel for more complex things like budgets and presenting information in graphs and tables." - Tim, Varsity Lakes QLD

ACFI101.png

EXCE201

Microsoft Excel Intermediate

Build on your skills to become an excel master user.

Webinar

$279+GST