Spredsheet Intro for Teachers

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

In this course we will cover the basics of how spreadsheets work and how you can leverage them to improve your data tracking and analytics

Course Content

Terminology
In this section we'll cover how to talk about spreadsheets, so we're all on the same page.

  • Key terms
    04:47
  • Worksheets
  • References
  • Spreadsheet basic termionlogy

Sharing, collaboration and protection
Here we'll discover how to share your spreadsheet with collaborators, preventing them from accidentally editing the wrong range. We'll also cover how data validation can make your sheets more intuitive for users.

Basic formulas
In this section you'll learn how to do simple maths on cells, and how we can use and re-use formulas for tasks like adding up scores or counting grades.

Visualisation
In this section we'll cover how to add charts and graphs to your sheets for easy visualisation

Intermediate formulas
In this section we'll cover how to make more complex formulas, including VLOOKUP and ImportRange

Conditional formatting
Here we'll learn how to use conditional formatting to make your sheets more intuitive to users.

Pivot charts
In this final part of the course, we'll cover a very powerful but under-used feature: PivotCharts.

Student Ratings & Reviews

No Review Yet
No Review Yet
Scroll to Top