Newsletter
Log in
Courses
Basket
Start learning
Course Content
Section 1 – Introduction
Learn the basics of Excel and start making your spending tracker
0/7
How to use DigiQuick
04:43
Introduction
06:58
Getting started with Spreadsheets 1
05:14
Getting started with Spreadsheets 2
15:13
Getting started with Spreadsheets activity
06:11
Layout
14:27
Data Validation and number formats
11:44
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
04:33
Sum formula introduction
09:30
Sum formula activity
05:59
Implementation
06:51
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
03:23
Sumif formula introduction
08:49
Sumif formula activity
06:56
Implementation
08:34
Section 4 – Finishing up
Learn how to use conditional formatting to put the final touches on your spending tracker
0/1
Conditional formatting
07:27
Quiz
Test your knowledge with this quiz!
0/1
Single grant spending tracker quiz
Single Grant Spending Tracker (Excel version)
About Lesson
Learn what a spreadsheet is, where to find them and how to open one.
0%
Complete
Mark as Complete