Efficient use of Excel

£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

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

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

Preview

Concatenate

Upper, Proper, Lower

Summary of case functions

Left, Mid, Right

String Manipulation - Example

Your Turn - Examples

Data Analysis

In this section of the course we look at some useful functions in Excel to efficiently analyse data.

CountIf

Count - Summary

Using the IF function

Nested IF

Averages and range

XLookup Grade Boundaries

VLookup Grade Boundaries

Index-Match Grade Boundaries

Your Turn - Examples

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

Conditional cell rules

Data Validation

Filtering data

Locking and protecting sheets

Your Turn - Examples

Summary

A brief summary of the Efficient use of Excel course.

Exit Video

Examples - All