Skip Main Navigation
Page Content

Save This Event

Event Saved

Microsoft Excel Advanced BSBITU402

HB Recruitment & Training

Thursday, 22 June 2017 at 8:30 am - Friday, 23 June 2017 at 3:30 pm (AEST)

Microsoft Excel Advanced BSBITU402
Available Dates

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Excel Advanced Workshop 10 Tickets 22/06/2017 $435.00 $0.00
Current HB Trainees undertaking this as part of a qualification only 10 Tickets 22/06/2017 Free $0.00
This course is aligned to Nationally Recognised training and participants have the option to undertake formal assessment to gain competence in a nationally recognised unit of competency (which may contribute towards gaining a formal qualification).
10 Tickets 22/06/2017 $55.00 $0.00
Take Home Resource
Take home the full manual used during the workshop.
10 Tickets 22/06/2017 $35.00 $0.00

Share Microsoft Excel Advanced BSBITU402

Event Details

What will you learn in this course?

This course is designed for users with good working knowledge of Excel, and covers the advanced features of Excel, enabling the student to design and produce complex spreadsheets.

  • use a range of formula techniques
  • use a range of logical functions
  • use the mathematical functions in Excel
  • use the statistical function in Excel
  • use a variety of Financial functions
  • use the date and time functions to perform calculations
  • use a range of lookup and reference functions
  • use a range of techniques to work with worksheets
  • use data linking to create more efficient workbooks
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • use a range of techniques to enhance charts
  • apply a variety of page setup techniques
  • import data into Excel and export data from Excel
  • create and use templates in Microsoft Excel
  • create recorded macros in Excel
  • use the macro recorder to create a variety of macros
  • find the information you need in Help
  • work comfortably and safely, be assured that you are a responsible environmental citizen, and effectively manage your files and folders

This course offered as: 
Public workshop | One-on-one training | Customised or tailored to your workplace needs for groups of 3 or more employees

Course details

Duration: 2 days
Time: 8:30 am - 4:00 pm  
Class size: : A minimum of 4 participants are required to run this workshop. Class sizes are kept to a maximum of 8-10 people to allow for individualized attention 
Includes: Morning & afternoon tea
Certificate: A Certificate of Attendance is provided upon completion 
Assessment: Purchase the Assessment Ticket in addition to the Workshop Ticket if you wish to undertake assessment to gain competence in a Nationally Recognised unit of competency.


IMPORTANT NOTE RE PAYMENT:  If you are purchasing on behalf of an organisation and/or your employer prefers to be invoiced for payment, please contact

Have questions about Microsoft Excel Advanced BSBITU402? Contact HB Recruitment & Training

Save This Event

Event Saved

When & Where

HB Recruitment and Training
4 Laurel St
Toowoomba, QLD 4350

Thursday, 22 June 2017 at 8:30 am - Friday, 23 June 2017 at 3:30 pm (AEST)

  Add to my calendar
Microsoft Excel Advanced BSBITU402
Things to do in Toowoomba Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.