The Design and produce spreadsheets credential covers the skills and knowledge required in understanding the importance that spreadsheets play on the organisation, management and tracking of data in an organisation. It also reviews and highlights the importance of the way that these are designed to ensure easy use and maximum functionality.

The Design and produce spreadsheets comprise of 1 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 1

Course Award: Micro-Credential 

Course Duration: 4 Hours Course 

Complexity: Foundation

It comprises 8 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 work environment for effectiveness and efficiency 
  • How to apply business strategies to your work activities 
  • Analysing tasks to determine and develop specifications
  • Implementing task automation, macros, and templates
  • The utilisation of spreadsheets to enter graph numerical data integrating software functions to maximise capability.
  • Implementing practices that promote the checking and amendment of stored data.




Course curriculum

  • 1

    Introduction

    • Design and produce spreadsheets

  • 2

    Lesson 1

    • Organise personal work environment

  • 3

    Lesson 2

    • Apply business strategy to work activities

  • 4

    Lesson 3

    • Analyse tasks and determine specifications

  • 5

    Lesson 4

    • Apply work organisation strategies to plan work activities

  • 6

    Lesson 5

    • Tasks automation, macros and templates

  • 7

    Lesson 6

    • Utilise spreadsheet design software functions

  • 8

    Lesson 7

    • Graph numerical data within specified timelines

  • 9

    Lesson 8

    • Enter, check and amend, print and store data

  • 10

    Test your knowledge

    • Instructions before taking the test

    • Next steps

  • 11

    The boring stuff

    • Learning Vault Copyright Notice