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
Смотрите видео How to Create a Simple Assignment Tracker in Google Sheets | Easy Step-by-Step Tutorial онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь MondayGoalGirl 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,791 раз и оно понравилось 170 людям.