Pilot – Single Grant Spending Tracker with Google Sheets

About Course

In this course you will learn to use Google Sheets to create a spending tracker for one grant.

This course is perfect for people who have never used spreadsheets before and will help make grant reporting a breeze.

The total time for this course is 1 hour 45 minutes.

Skills you will learn in this course:

Accessing Google sheets
Key terminology in spreadsheets
What to do if you make a mistake in a spreadsheet
Basic spreadsheet skills
Number formats
Data validation
The Sum formula
The Sumif formula
Conditional formatting

Course Content

Pilot – Introduction
Learn how the DigiQuick pilot works

Welcome and introduction

01:08

Section 1 – Introduction
Learn the basics of Google sheets and start making your spending tracker

Section 2 – Total spent, Total left, Amount left
Learn how to use the Sum formula to automatically calculate the: - total spent - total left - amounts left in each category

Section 3 – Amount spent by category
Learn how to use the Sumif formula to automatically caluclate the amount spent from each grant category.

Section 4 – Finishing up
Learn how to use conditional formatting to put the final touches on your spending tracker

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

Emily

1 month ago

Really useful course. Loved the short lessons and arrows pointing at key elements. Thank you

Pilot – Single Grant Spending Tracker with Google Sheets

About Course

Course Content

Pilot – Introduction
Learn how the DigiQuick pilot works

Welcome and introduction

Section 1 – Introduction
Learn the basics of Google sheets and start making your spending tracker

Introduction

Getting started with Spreadsheets 1

Getting started with Spreadsheets 2

Getting started with Spreadsheets activity

Layout

Data Validation

Section 2 – Total spent, Total left, Amount left
Learn how to use the Sum formula to automatically calculate the: - total spent - total left - amounts left in each category

Introduction

Sum formula introduction

Sum formula activity

Implementation

Section 3 – Amount spent by category
Learn how to use the Sumif formula to automatically caluclate the amount spent from each grant category.

Introduction

Sumif formula introduction

Sumif formula activity

Implementation

Section 4 – Finishing up
Learn how to use conditional formatting to put the final touches on your spending tracker

Conditional formatting

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson.

Thank you and next steps

About Course

Course Content

Pilot – Introduction Learn how the DigiQuick pilot works

Welcome and introduction

Section 1 – Introduction Learn the basics of Google sheets and start making your spending tracker

Introduction

Getting started with Spreadsheets 1

Getting started with Spreadsheets 2

Getting started with Spreadsheets activity

Layout

Data Validation

Section 2 – Total spent, Total left, Amount left Learn how to use the Sum formula to automatically calculate the: - total spent - total left - amounts left in each category

Introduction

Sum formula introduction

Sum formula activity

Implementation

Section 3 – Amount spent by category Learn how to use the Sumif formula to automatically caluclate the amount spent from each grant category.

Introduction

Sumif formula introduction

Sumif formula activity

Implementation

Section 4 – Finishing up Learn how to use conditional formatting to put the final touches on your spending tracker

Conditional formatting

Pilot – Close and next steps Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson.

Thank you and next steps

Student Ratings & Reviews

Pilot – Introduction
Learn how the DigiQuick pilot works

Section 1 – Introduction
Learn the basics of Google sheets and start making your spending tracker

Section 2 – Total spent, Total left, Amount left
Learn how to use the Sum formula to automatically calculate the: - total spent - total left - amounts left in each category

Section 3 – Amount spent by category
Learn how to use the Sumif formula to automatically caluclate the amount spent from each grant category.

Section 4 – Finishing up
Learn how to use conditional formatting to put the final touches on your spending tracker

Pilot – Close and next steps
Thank you for being a part of this pilot. Learn how to give us some feedback and access your bonus lesson.