Start learning
5.00
(2 Ratings)

Single Grant Spending Tracker (Google Sheets version)

Categories: Finances, Google Sheets
Wishlist Share
Share Course
Page Link
Share On Social Media

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
  • Your feedback is invaluable to DigiQuick! Share your thoughts with the feedback form on the lesson homepage, or leave us a 5-star review if you enjoyed the course.

Course Content

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

Quiz

Student Ratings & Reviews

5.0
Total 2 Ratings
5
2 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
PJ
Portland Jones
3 months ago
this worked well for me. got there in the end
E
Emily
8 months ago
Really useful course. Loved the short lessons and arrows pointing at key elements. Thank you