This course sets out essential concepts and skills relating to understanding the concept of spreadsheets and using a spreadsheet to produce accurate work outputs. 

After completing this course you will be able to: 

  • Work with spreadsheets and save them in different file formats, locally or in the cloud. 
  • Use available help resources, shortcuts and the go to tool to enhance productivity. 
  • Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data. 
  • Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets. 
  • Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognise error values in formulas.
  • Format numbers and text content in a spreadsheet and use available auto-format/table styles. 
  • Choose suitable charts, and create and format charts to communicate information meaningfully. 
  • Adjust spreadsheet page settings and check and correct spreadsheet content before printing. 

Please note examinations are not included as part of the course fee. These need to be purchased and arranged with your nearest ECDL Testing Centre. Please click here to find your nearest centre. 


  • 01

    Course Files

    • Course Files To Download

  • 02

    Using The Application

  • 03


    • Insert and Select Cells

    • Edit and Sort Cells

    • Copy, Move and Delete Cells

  • 04

    Managing Worksheets

    • Rows and Columns

    • Worksheets

  • 05

    Formula's and Functions

    • Arithmetic Formulas

    • Functions

  • 06


    • Numbers and Dates

    • Contents

    • Alignment, Borders and Effects

  • 07

    Create Charts

    • Create Charts

    • Edit Charts

  • 08

    Prepare Outputs

    • Setup

    • Check and Print


Richard Walters is one of NILC's senior level Microsoft Office trainer's and has more than a decade of experience in IT and Business Skills training. Richard has an advanced-level understanding of all Microsoft Office packages and specialises in Excel, Word, PowerPoint, Visio and Project.

Richard Walters

Senior Microsoft Application Instructor


  • When does the course start and finish?

    The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

  • How long do I have access to the course?

    How does 1 years access sound? After enrolling, you have unlimited access to this course for 365 days - across any and all devices you own.

  • What if I am unhappy with the course?

    We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 14 days and we will give you a full refund.