How to Create a Simple Assignment Tracker in Google Sheets | Easy Step-by-Step Tutorial

📌 Get the the TEMPLATE here: https://mondaygoalgirl.gumroad.com/l/xbmbgs 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/xbmbgs 📌 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