Login
Complete Mathematics/Efficient use of Excel
Buy now

  • £16.67

Efficient use of Excel


As a teacher, if you have ever spent hours on Excel thinking “there must be a quicker way” then this course is for you.

By taking the time to learn some of the most useful functions and features of Excel, you can turn a job that used to take an hour into a couple of clicks.

This course will demonstrate some of the most useful Excel tips and tricks I have picked up of my 15+ years of using Excel as a classroom teacher. The time you invest into this course now will pay for itself many times over as you save yourself, and probably your colleagues, hours of Excel related headaches!
Buy now

Contents

Introduction

This course will demonstrate some of the most useful features and functions of Excel to save you time when creating and maintaining individual teacher markbooks or departmental spreadsheets.
1.0 Introduction
  • 1 min
  • 3.79 MB
Preview

String Manipulation

In this section of the course we look at how we can use Excel to efficiently manipulate data and save time.
Text to Columns
  • 3 mins
  • 17.3 MB
Preview
Concatenate
  • 3 mins
  • 13.5 MB
Upper, Proper, Lower
  • 2 mins
  • 8.28 MB
Summary of case functions
  • 2 mins
  • 4.84 MB
Left, Mid, Right
  • 5 mins
  • 18.8 MB
String Manipulation - Example
  • 3 mins
  • 13.4 MB
Your Turn - Examples
  • 15.7 KB

Data Analysis

In this section of the course we look at some useful functions in Excel to efficiently analyse data. 
CountIf
  • 2 mins
  • 8.32 MB
Count - Summary
  • 3 mins
  • 11.4 MB
Using the IF function
  • 4 mins
  • 15.5 MB
Nested IF
  • 4 mins
  • 14.8 MB
Averages and range
  • 3 mins
  • 10.4 MB
XLookup Grade Boundaries
  • 4 mins
  • 13.3 MB
VLookup Grade Boundaries
  • 2 mins
  • 7.87 MB
Index-Match Grade Boundaries
  • 2 mins
  • 7.05 MB
Your Turn - Examples
  • 16.9 KB

Formatting

In this section of the course we learn how to set up and validate common useful departmental spreadsheets and protect them from unwanted alterations.
Simple QLA
  • 7 mins
  • 29.7 MB
Conditional cell rules
  • 3 mins
  • 12.7 MB
Data Validation
  • 3 mins
  • 21.7 MB
Filtering data
  • 3 mins
  • 12.8 MB
Locking and protecting sheets
  • 4 mins
  • 17.5 MB
Your Turn - Examples
  • 23.7 KB

Summary

A brief summary of the Efficient use of Excel course.
Exit Video
  • 1 min
  • 2.42 MB
Examples - All
  • 39.7 KB