Accredited Course

BSBITU402 Develop and use complex spreadsheets

Scheduled

Key information for this course

Overview

Upon completion of this course attendees will have the knowledge and skills to design effective spreadsheets and work with financial or other business applications in an efficient manner Attendees will have the skills to design and create larger and more complex spreadsheets incorporating protection automation with macros and importing /exporting data to and from other applications They will be able to use advanced techniques to analyse historical data and compare future scenarios

Learning outcomes:

1 Design larger and more complex spreadsheet solutions
2 Design spreadsheet solutions that require linked workbooks and linked applications
3 Complete everyday tasks faster and more effectively
4 Construct and enter formulae and functions relevant to a business environment
5 Use a wide range of statistical text logical and lookup functions
6 Use advanced techniques to analyse historical data
7 Use advanced charting techniques to analyse graphical data
8 Use advanced techniques to project current data and analyse future scenarios Optional Assessment This is a nationally recognised training program

Participants who successfully complete the optional assessment component of this course will receive a Statement of Attainment for the units of competency outlined above additional fee applies please enquire when you book

Exercises completed during the course will be used as evidence towards unit competency

Participants who choose not to be assessed will receive a Certificate of Attendance

Pre-requisites

Excel Introductory

More information about this course

Training Provider

Training Provider Logo

Who to contact

Karina Stojansek
(03) 6334 4910

karina@nda.com.au

Location

4B, 21 Alexandra Road, Ulverstone Tas 7315

Who is this for?

Business owner Manager Project Manager Director Trades People Tradesman Administration Accounts Payroll Receptionist Builder Plumber Electrician

Course Date

From Sep 8th at 12:00 AM
to Sep 9th at 12:00 AM

Withdrawals

Up until Sep 3rd

This course is also available subject to customer demand.

Contact the training provider for more information.

Hours

14 hours per attendee

Minimum Attendees

3

About the Training Provider

NDA Computing Pty Ltd

NDA services include computer training, management training, traineeships and qualifications, group training and training room hire. The company has training centres in Hobart, Launceston, and Devonport. NDA is 100% Tasmanian-owned and was established in 1985.

The services provided by NDA include:

Computer training - desktop, web, systems, programming and accounting software. Management training.

Traineeships and qualifications in business, business administration, human resources, training and assessment, frontline management, IT and project management.

Group training - the supply of NDA trainees who work in your organisation.

Training needs analysis.

Project management of training roll-outs.

Customised training.

Walkabout trainer.

Courseware development and technical writing.

Training room hire.

Accreditation

NDA is accredited by the ASQA as a Registered Training Organisation.

NDA is accredited by Skills Tasmania as a Group Training Organisation.

State-wide locations

NDA operates from training centres in Hobart, Launceston, and Devonport.

Contact the Training Provider

Karina Stojansek
(03) 6334 4910
karina@nda.com.au

Disclaimer

Training providers are solely responsible for the quality and accuracy of content and delivery of training courses listed on the Industry Training Calendar. Keystone Tasmania provides the Training Calendar in good faith as a service to industry practitioners. Please note that by taking the option of applying for funding you are not securing a booking for the selected course. All bookings must be made directly with the training provider.

Submit your feedback

Did you find what you were looking for?

If not then please leave a message detailing your requirement and we'll attempt to follow it up for you.

Leave your feedback