+44 (800) 555-9876

learn@kyndo.co.uk

Spreadsheets and Handling Data

Featured

Build real confidence with spreadsheets — formulas, sorting and charts that make data make sense.

(1)

4 Students

5 Lectures

Robert Ransdell

Instructor

What Will You Learn?

Build formulas that calculate for you

Sort and filter to find what matters

Draw charts that make data clear

Present results for science and geography work

About This Course

Spreadsheets turn up everywhere in school, from science results to a geography survey. This course takes students from an empty grid to confidently building formulas, sorting and filtering, and drawing charts that actually communicate something.

It covers the skills the computing curriculum expects at Key Stage 3, and the practical ones that make coursework and science write-ups far less painful.

Works with Excel, Google Sheets or LibreOffice — the ideas are the same in all three.

Requirements

A computer or tablet with an internet connection

No previous experience needed

About twenty minutes at a time, somewhere quiet

Trusted by Schools & Families

Chosen by families and schools who want their children learning with confidence.

FAQ

Check the frequently asked questions about this course.

What is the course level?

This is a course for beginners so you will get familiar with the topic from scratch.

Is it a supported course?

Yes, you can get in touch with the instructor using the support system.

Can I have a private meeting with the instructor?

Yes, you can reserve a 1 to 1 meeting with the instructor using the instructor profile.

Robert Ransdell

(4)

10 Courses

8 Students

Robert teaches English literature and language to GCSE in south London, and runs his school's creative writing club. He is happiest prising open a poem with a class until they find something in it nobody expected. His courses cover the set texts properly, but always with an eye on helping students write something they are actually proud of.

Curriculum Overview

This course includes 2 modules, 5 lessons, and 1:30 hours of materials.

Introduction

2 Parts

Getting Started

Free

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).

Volume 4.10 MB

Halfway Check

Check your progress and understanding of key Excel concepts with this mid-term quiz during the course.

Questions 5

Duration 10 Minutes

Passing Grade 60/100

Total Grade 100

Attempts 0/4

Spreadsheet Fundamentals

3 Parts | 1:30 Hours

Introduction

Start Date 20 Mar 2023 | 17:00

Duration 30 Minutes

Your First Formulas

Microsoft Excel has the basic features of all spreadsheets,[6] using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.

Start Date 25 Mar 2023 | 15:00

Duration 30 Minutes

Turning Numbers into Charts

Excel supports charts, graphs, or histograms generated from specified groups of cells. It also supports Pivot Charts that allow for a chart to be linked directly to a Pivot table. This allows the chart to be refreshed with the Pivot Table.

Start Date 28 Mar 2023 | 16:30

Duration 30 Minutes

Certificates

1 Parts

Certificate

Quiz Certificate

You will receive this certificate after passing the “Halfway CheckZ” quiz.

Type Quiz Certificate

Passing Grade 60/100

Please log in to leave a comment.

Jade Harrison

Parent

9 Jul 2021

I have already taken another course with this teacher. His teaching method is excellent.

Robert Ransdell

Instructor

9 Jul 2021

Thanks a lot for your comment, Best regards.

4.75

1 Reviews

Content Quality (5)

Instructor Skills (5)

Value for Money (4)

Support Quality (5)

Jessica B. Gray

13 Jul 2021 23:16

Definitely recommended for anyone starting out excel. If you are familiar with the basics and have only been using excel as a calculator this will help you realize how versatile it is and how to use it effectively.