Excel for Teachers

Module 1: Work Faster and Better in Excel

20% Complete

Introduction

In this module, we will learn some essential skills in Excel that will allows us to work with teaching-related spreadsheet in a more accurate and efficient manner.

If you have any questions or comments, please enter your comments in the "Discussion Area" below the videos.  We learn better through discussion and mutual support!

Topic: Quick navigation with Ctrl (⌘) + Arrow keys

Topic:  Quick fill with Ctrl (⌘) + Enter

Topic: Absolute and relative referencing with $

Topic: Sort and Filter data

Topic: Work with texts

Topic: Assign Grades with VLOOKUP

Topic: SUMPRODUCT and SUMIF

Download Excel File  (Note: the video above uses a different file. The key learning is the same.)

Topic: COUNTIF

Download Excel File (Note: the video above uses a different file. The key learning is the same.)