Learn how to plan, build, and manage spreadsheets that handle real tasks. Design and Produce Complex Spreadsheets covers everything from setting up your workspace to designing clear, well-structured workbooks.
You’ll create formulas, use functions, format cells, and work across multiple sheets. You’ll also use templates, automate tasks with macros, and present data using charts and graphs.
By the end, you’ll know how to enter, check, protect, and share data while following workplace procedures. Ideal for anyone who needs to build spreadsheets that work efficiently and meet clear requirements.
Course Structure
Design and Produce Complex Spreadsheets
- Organise person work environment
- Ergonomics and work station layout
- Tasks and determine specifications
- Designing a workbook
- Plan your spread sheet
- Procedures and guidelines
- Identify data entry, storage and output requirements
- Energy and resource conservation techniques
- Design spreadsheet to meet requirements
- Cell references
- Colum width and row height
- Manipulating data
- Creating formulae
- Type in method
- AutoSum
- Using functions
- Testing formulae
- Cell and range references
- Working with multiple sheets of information
- Referencing data from another sheet or workbook
- Formatting cells
- Cell borders
- Styles
- Number format
- Conditional formatting
- Identifying tasks requiring automation
- Create use and edit macros
- Develop, edit and use templates
- Template error messages
- Enter check and amend data
- Freeze panes
- Data validation
- Import and export data
- Using the help function
- Adjusting content to fit the page
- Graph styles
- Graphs with labels and titles
- Chart types
- Name and store spreadsheets
- Protecting content
- Advanced functions of spreadsheet software
- Organisation policies and procedures
Study Hours
Estimated duration 10 hours
Course Delivery and Start
Start anytime, self-paced and 100% online
Assessment
Assessment will be comprised of written exercises, including short-answer questions, reflective tasks, short reports and/or projects. There are no examinations or due dates for assessment. As a result, you can complete training in your own time and at your own pace with the assistance of unlimited tutor support.
Testimonials
I found the layout of the online training easy to use, so going back to sections studied was quick and simple to be able answer assessment questions easily.
Kim | Gladstone, QLD | Design and Produce Complex Spreadsheets
Graduation
A Certificate of Attainment and Statement of Results will be issued upon successful completion of this course.
How to Enrol
Enrolment Form – Employment Services and Rehabilitation Providers
Enrol via Live Chat (Business Hours)
Enrol via Telephone 1300 76 2221 (Business Hours)
Payment Options
Visa, Mastercard, BPAY and EFT/Direct Deposit. Please allow 1-2 Business days for processing for EFT and BPAY.
Course FAQs
Why Choose Australian Online Courses?
- Professional development that is widely recognised and respected;
- Improve your employment opportunities;
- Study online, anywhere via our elearning system;
- High-quality professional development programs written by industry experts;
- All course materials provided online – no textbooks to buy;
- Unlimited tutor support via email;
- We offer twelve (12) months’ access, with extensions available upon application (fees apply);
- Course may be tax deductible; see your tax advisor.
Are there any entry requirements or pre-requisites?
There are no course or subject pre-requisites for entry into our programs. However, our professional development programs are generally intended for people over the age of 18. In some circumstances, enrolments from younger people may be considered. Please complete the AOC Parent Guardian Consent Form prior to enrolling and submit here.
Are there any computer requirements?
To study online with Australian Online Courses you will need a computer (desktop PC/laptop) running a current/updated operating system with reliable high-speed internet access. You will need to use the Google Chrome browser to access your course.
When can I start this course?
You can start within 60 minutes during business hours when you enrol and pay in full with a credit card!
Credit card: Within 60 mins during business hours.
BPAY: Within 1-2 working days.
Internet Banking: Within 1-2 working days.
Cheque/Money Order: Upon receipt of mailed cheque.
How is this course delivered?
This course is delivered online via our easy-to-navigate Learning Management System (LMS), where you will discover interactive online learning/written content, resources and assessment.
Do I need to attend classes or undertake any work placements?
No. All courses are delivered online via our LMS and there are no work placement requirements in this course.
What support can I expect from Australian Online Courses?
Unlimited tutor support is available throughout your studies via email only during business hours Monday to Friday. Our Administrative team are available Monday to Friday via email, live chat and telephone.
I am an international student. Can I enrol into this course?
Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.
