Home / Courses / Design and Produce Complex Spreadsheets

Design and Produce Complex Spreadsheets

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.
shuttle
Start Anytime
Yes
streaming
Delivery Method
100% Online
clock
Study Hours
10 hours
calendar
Course Access
12 Months

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.

Printed learning materials are available for purchase for this course and can be ordered during enrolment.  

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
clock
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.

Enrol & start today
* Ts&Cs apply
Design and Produce Complex Spreadsheets
$199.00
Choose Enrolment Type Business Details Service Provider Details Participant Details Add Another Course Additional Participants Payment
Stripe Logo

About Us

At Australian Online Courses, we are passionate about helping individuals from diverse backgrounds achieve their career goals. Since 2008, we have created opportunities for people in Australia and around the world.

Our Difference

What sets us apart is that we genuinely care about your career development. That’s why flexible study schedules, competitive pricing and exceptional customer and student support are at the heart of what we do. Our comprehensive courses, developed in consultation with industry employers, provide the skills and knowledge necessary for success in your current role or to pursue new opportunities.

Our state-of-the-art eLearning platform means you can study anywhere, anytime. So, enrol today and get the skills and confidence you need to achieve your career dreams, big or small.

Graduation

A Certificate of Attainment and Statement of Results will be issued upon successful completion of this course.

How to Enrol

You can enrol online by clicking Get Started on any course page under Enrol & Start Today. Follow the prompts to complete your enrolment as an individual, business, or service provider.

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.

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 with a competent level of English. For those under 18, please complete the Parent/Guardian Consent Form before enrolling.

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.

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.

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.

No. All courses are delivered online via our LMS and there are no work placement requirements in this course.

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.

Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.

Offer
Enrol in June and take 15% off!
  • Valid for courses only
  • Enter the coupon code JUNE when enrolling.
  • Ts&Cs apply.
Image 7b@2x
Offer
Gift Vouchers.
Give the Gift of Growth!

Perfect for individuals or as part of your team’s rewards and recognition program. Buy a gift voucher today and invest in someone’s future.

Cta Block 2 Img@2x
Subscribe to our newsletter and receive a FREE eBook!
THE ULTIMATE A-Z GUIDE TO CAREER CHANGE

Subscribe today and receive the free e-book The Ultimate A-Z Guide to Career Change. It’s packed with tips and advice from career coaches, psychologists, recruiters and human resources professionals to help you find your new direction.

"*" indicates required fields

Step 1 of 2

This field is for validation purposes and should be left unchanged.
Image 2