SHORT COURSE

Develop and Use Complex Spreadsheets

Description

This continuing professional development course provides you with a skills and knowledge required to use Microsoft Office Excel (spreadsheet) to complete business tasks and produce complex documents.

It applies to individuals employed in a range of work environments who require skills in the creation of complex spreadsheets to analyse business transactions and develop automated reports.

This course may satisfy the continuing professional development requirements for bookkeepers, BAS agents, accountants, Tax agents and employees working in the business service sector.

This course will also be of benefit to business owners, managers, business partners, bookkeepers, assistant accountants and accounts clerks.

Skills Covered:
- Introduction to Microsoft Excel
- Effective spreadsheet utilisation
- Spreadsheet presentation
- Spreadsheet productivity tools
- Analytical charts and graphs
- Incorporating spreadsheet data in a Word document
- Statistical analysis and forecasting
- Spreadsheet macros
- Financial functions
- Logical functions
- Lookup tables

This course requires students to purchase textbooks at an additional cost of approximately $60. More information will be provided following enrolment.

This course has either written or oral supervised assessment. Students will require access to Skype video chat for assessment purposes.

  • You will be given 8 weeks to complete this course. If you study 4-6 hours per week, we estimate that you will be able to complete the course in this time frame. However as this online course is self-paced, if you prefer you are able to complete it in a shorter time frame. This course has either written or oral supervised assessment. Students will require access to Skype video chat for assessment purposes.

Short Course Delivery Locations Some short courses can provide accreditation for industry-specific registration, while others merely provide skills and knowledge in the subject area. Concession prices are available for some courses.

Location

Online

Date
Continuous enrolments
Cost Information
This course requires students to purchase textbooks at an additional cost of approximately $60. More information will be provided following enrolment.

Cost

$400.00

Add to Cart

For more details on short course enrolments, discounts, refunds, international student eligibility and more, please visit Applying for Short Courses
︿
Back to Top