Join the free pilot
Course Content
Section 1 – Introduction
Learn the basics of Google sheets and start making your spending tracker
0/7
How to use DigiQuick
04:43
Introduction
05:33
Getting started with Spreadsheets 1
04:23
Getting started with Spreadsheets 2
14:45
Getting started with Spreadsheets activity
06:11
Layout
09:13
Data Validation
11:16
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
0/4
Introduction
02:05
Sum formula introduction
08:27
Sum formula activity
03:53
Implementation
06:30
Section 3 – Amount spent by category
Learn how to use the Sumif formula to automatically caluclate the amount spent from each grant category.
0/4
Introduction
02:12
Sumif formula introduction
14:03
Sumif formula activity
04:40
Implementation
06:53
Section 4 – Finishing up
Learn how to use conditional formatting to put the final touches on your spending tracker
0/1
Conditional formatting
05:26
Single Grant Spending Tracker (Google Sheets version)
Previous
Next
0% Complete