The Complex spreadsheet development credential covers the skills and knowledge required in understanding and developing complex spreadsheets that provide and reflect important data in the workplace in managing data and for analysis.

The Complex spreadsheet development comprises of 2 micro-credential stacked courses of learning, followed by a completion of assessment tasks at the end of each skill level, to test the learner’s knowledge and understanding.

Course Series: 1 of 2

Course Award: Micro-Credential 

Course Duration: 3 Hours Course 

Complexity: Foundation

It comprises 6 lessons of learning, followed by a completion quiz to test your knowledge and understanding.  By the end of this course, you will demonstrate understanding in:

  • How to organise your personal work environment 
  • Strategies in analysing tasks to determine specifications 
  • How to apply work organisation strategies in planning work activities
  • How to utilise spreadsheet design in software functions. 
  • Implementing spreadsheets and link spreadsheets and testing formulas in spreadsheets. 
  • Developing and implementing task automation, macros, and templates in spreadsheets.



Course curriculum

  • 1

    Introduction

    • Complex spreadsheet development
  • 2

    Lesson 1

    • Organise personal work environment

  • 3

    Lesson 2

    • Analyse task and determine specifications
  • 4

    Lesson 3

    • Apply work organisation strategies to plan work activities
  • 5

    Lesson 4

    • Utilise spreadsheet design software functions
  • 6

    Lesson 5

    • Link spreadsheets and test formula
  • 7

    Lesson 6

    • Tasks automation, macros and templates
  • 8

    Test your knowledge

    • Instructions before taking the test

    • Next steps
  • 9

    The boring stuff

    • Learning Vault Copyright Notice