How to Create a Simple Assignment Tracker in Google Sheets | Easy Step-by-Step Tutorial
Learn how to create a simple yet effective assignment tracker in Google Sheets.
This step-by-step guide will teach you to organize your tasks, set deadlines, track progress, and stay on top of your assignments.
Perfect for students, professionals, and anyone who needs to manage their workload efficiently.
Section:
00:00 Intro
00:27 Create Assignment Sheet
00:49 Create Setup Sheet
01:15 Make the Dropdown Menus for Course's Column
01:40 Make the Dropdown Menus for Type of Assignment's Column
02:10 Insert Checkboxes
02:20 Adding Pop-up Calendar for Due Date
02:42 Make the Dropdown Menus for Status
03:14 Make the Dropdown Menus for Priority
03:30 Adding Summary Sections
04:09 Create Strike out when we've selected checkboxes
04:56 Calculate Total Assignment, Completed, and Pending Tasks.
05:40 Calculate the Day Left
06:20 Pie Chart for Completed and Pending Tasks
07:00 Create Helper Columns for the Charts
08:00 Create a Bar chart for Courses
08:30 Create Donut Chart for Status
09:30 Create Column Chart for Type of Assignment
10:18 Adding Filter for the Sheet.
📌 Get the the TEMPLATE here: https://mondaygoalgirl.gumroad.com/l/...
📌 Shop for more Templates and Spreadsheets: https://www.mondaygoal.com
📌 Connect with me: https://mondaygoal.my.canva.site/
📌 Color Codes: https://pin.it/4Wf1ziF3k
My Camera Setups:
📷 https://amzn.to/3BkVozZ
🎤. https://amzn.to/4do8qtL
🔔 Don’t forget to like, comment, and subscribe for more productivity tips and tutorials!
📌 This template is intended for personal use only. Please do not copy, distribute, or resell. Thank you for respecting the work that went into creating this resource!
#GoogleSheets #AssignmentTracker #ProductivityTips #TimeManagement #studytips
Watch video How to Create a Simple Assignment Tracker in Google Sheets | Easy Step-by-Step Tutorial online without registration, duration hours minute second in high quality. This video was added by user MondayGoalGirl 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,791 once and liked it 170 people.