Create a Weekly Study Planner in Excel

A study planner is easier to use when each entry tells you what you intend to finish. “Study English” leaves the next step open. “Write a paragraph describing your home” gives you a task you can start and review.

This guide combines a small weekly plan with a beginner Excel exercise. You will enter a table, make longer text readable, and calculate the minutes you have planned. The example works with the English-language version of Excel; menu labels can vary between editions.

1. Begin with four columns

Open a blank workbook. Enter these headings in the first row:

  • A1: Day
  • B1: Task
  • C1: Minutes
  • D1: Status

Use one row for each study session. Keep Minutes as a number, such as 30, so Excel can calculate a total.

Enter this example in rows 2 to 6:

DayTaskMinutesStatus
MondayWrite one English paragraph30Planned
TuesdayPractise adding numbers in Excel30Planned
WednesdayRevise Monday’s paragraph25Planned
FridayFormat a small Excel table30Planned
SaturdayReview the week and choose next steps20Planned

These durations are examples for practising the spreadsheet. Adjust them to fit the time you actually have available.

2. Make the planner readable

Select cells A1:D6, then choose Home → Format as Table. Choose a style and confirm that the selected range includes your five sessions. Tick My table has headers so Excel uses the headings you entered.

Give the Task column enough width to read comfortably. Select its cells and choose Home → Wrap Text to display longer descriptions over multiple lines. If part of a task remains hidden, increase the row height.

Keep the layout simple. Consistent headings and readable text will help you use the planner each day.

3. Calculate the planned time

Click B8 and type Weekly planned minutes. In C8, enter:

=SUM(C2:C6)

Press Enter. The result for the example should be 135. That is two hours and fifteen minutes across the five sessions.

Check the calculation by changing Monday’s duration from 30 to 40. The total should become 145. Change it back to 30 when you have finished the check.

The range C2:C6 identifies the five cells being added. If you later add more sessions, check that your formula includes the new rows.

4. Make each task small enough to assess

Look at the Task column before committing to your week. Can you tell whether each task is finished?

Useful entries describe an action and an output:

  • Write a paragraph of five sentences.
  • Complete three spreadsheet exercises.
  • Read one section and record two questions.
  • Correct the spelling in an earlier draft.

Choose an amount of work that suits your experience. A beginner might spend a session understanding one formula. Someone more familiar with Excel might complete several examples.

Leave room for other commitments. If the total is more time than you have available, shorten or move a task before the week begins.

5. Record progress in plain words

Use the Status column consistently. A small set of labels is enough:

  • Planned: you have scheduled the session.
  • Started: some work is complete.
  • Done: you finished the task as described.
  • Moved: you have rescheduled it.

When you move a task, put it into its new place in the plan so you can find it again.

At the end of the week, review the Started and Moved entries. Was the task unclear? Did it need a resource you had not prepared? Was the available time too short? Use those observations to make the next plan more practical.

6. Save a copy for the next week

Save the workbook with a recognisable name, such as Study-Planner-Week-01.xlsx.

Keep a copy of the completed week before preparing the next one. Comparing a few weeks can help you notice which tasks you regularly finish and which ones need a different approach.

You can extend the sheet later with a Subject or Actual minutes column. Add a column when it answers a question you want to review.

Try it yourself

Build the example, then replace three tasks with your own. Check that:

  1. Each task describes something you can finish.
  2. Minutes contains numbers.
  3. The example totals 135 before you change it.
  4. The total changes when you edit a duration.
  5. You can reopen the saved workbook.

For another practice project, try EagleHut’s guide to building your first spreadsheet budget.

Technical references

The sample plan and review exercise are suggested learning activities. Microsoft documents the Excel features used above:

Prepared for EagleHut. Technical references checked on 21 November 2026.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top