3. Subject Progress (Sheet: Subject Progress)

• Columns:
  • Subject (Text): Name of academic discipline.
  • Total Tasks (Number): Count from Task Tracker sheet.
  • Completed Tasks (Number): Dynamically calculated via formula.
  • % Complete (Percentage): Formula-driven, auto-updates.
  • Total Study Hours (Number): Sum of "Hours Spent" per subject.
  • Last Review Date (Date): Track last time a subject was revisited.
• Data Type: Number, Percentage, and Date formats used throughout.

Formulas Required for Dynamic Functionality

To maintain automation and real-time updates, the template uses several essential Excel formulas across sheets:

=COUNTIF(TaskTracker!$C$2:$C$100, "Math")          // Counts total tasks in Math subject
=COUNTIFS(TaskTracker!$F$2:$F$100, "Completed", TaskTracker!$C$2:$C$100, "Math")  // Counts completed Math tasks
=% Complete (in Subject Progress): 
    =IF(COUNTIF(TaskTracker!$C:$C,"Math")=0, 0,
        COUNTIFS(TaskTracker!$F:$F,"Completed",TaskTracker!$C:$C,"Math")
        / COUNTIF(TaskTracker!$C:$C,"Math")
    )

For the Dashboard:

=SUMPRODUCT((TaskTracker!$F2:$F100="Completed")*1)  // Total completed tasks
=AVERAGEIF(TaskTracker!$G2:$G100, ">=1", TaskTracker!$H2:$H100) // Avg hours per task

Dynamic date logic ensures that "Today" is auto-highlighted in the Weekly Schedule using:

=IF(WEEKDAY(TODAY()) = 2, TRUE, FALSE)  // For Monday highlight

Conditional Formatting (Visual Intelligence)

The template uses conditional formatting to enhance readability and provide visual cues:

• Overdue Tasks: Red fill with bold text for tasks where Due Date < TODAY().
• Prioritization Color Coding: High priority = red; Medium = yellow; Low = green.
• Status Indicators: Green checkmark (✅) for Completed, amber clock (⏰) for In Progress.
• Progress Bars: Conditional formatting via "Data Bars" in Subject Progress to visually show % complete per subject.

User Instructions

To begin using this Study Organizer Weekly Planner:

1. Open the Excel file. Enable macros if prompted (for interactive features).
2. Navigate to the "Weekly Schedule" tab. Enter your study topics for each day in corresponding time slots.
3. Add new tasks in the "Task Tracker" tab—assign subjects, due dates, priority levels, and estimated hours.
4. Update task status daily: mark as In Progress or Completed after sessions.
5. Review the Dashboard: Monitor completion rates, overdue tasks alerts, and weekly study hour totals.
6. Use the "Notes & Resources" sheet to store summaries, formulas, or links to lecture videos.
7. Export or print your weekly planner at the end of each week for reflection and goal setting.

Example Rows (Task Tracker)

Recommended Charts & Dashboard Components (Dashboard View)

The primary Dashboard View includes:

• Gauge Chart: "Weekly Completion Rate" showing % of tasks finished this week.
• Histogram: Weekly study hours per subject (bar chart).
• Pie Chart: Task distribution by priority level (High/Medium/Low).
• Progress Bar Chart: Visual representation of each subject’s completion %.
• Status Heatmap: Color-coded weekly calendar for quick visual tracking of study activity.

This template is not just a planner—it's an interactive Study Organizer, offering students the power to monitor progress, identify bottlenecks, and maintain consistent academic momentum throughout the week using a smart, Dashboard View that brings clarity to complex study routines.