Accredited Course
BSBITU314 Design & Produce spreadsheets
Scheduled
Key information for this course
Overview
Upon completion of this course attendees will have a strong skill base for developing and maintaining effective workplace spreadsheets
Course Outline
Learning outcomes:
1 Design and create simple business systems using both single and multiple worksheets
2 Manage files and templates more effectively
3 Create simple charts
4 Process simple databases
5 Design more advanced spreadsheet solutions
6 Design spreadsheet solutions that require linked workbooks and linked applications
7 Perform advanced formatting operations
Construct and enter formulae and functions relevant to a business environment
9 Use the full range of functions
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
IMPORTANT
All participants attending this course MUST have skills equivalent to those covered in the first day of the Introductory course including the ability to construct basic formulas use functions and format numbers dates and times
The following questions will assist in determining this
Can you:
Create a formula that takes a number in one cell multiplies it by a number in another cell and displays the correct answer in such a way that it will automatically update if either of the numbers changes
Use Excel functions to calculate the total and average of a column of numbers
Create a formula once and then copy it through a range of cells using absolute cell references where necessary to ensure that the copies reference the correct data
If you are booking on behalf of other people it is important that you confirm directly with them that they can answer yes to the above questions before proceeding
More information about this course
Training Provider
Who to contact
(03) 6334 4910
Location
Hobart Level 3 / Trafalgar Centre, 110 Collins Street Hobart TAS 7000
Who is this for?
Business owner Manager Project Manager Director Trades People Tradesman Administration Accounts Payroll Receptionist Builder Plumber Electrician
Course Date
From Jan 7th at 12:00 AM
to Jan 9th at 12:00 AM
Withdrawals
Withdrawals Closed
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
(03) 6334 4910
bookings@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. TBCITB 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.