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:
| Day | Task | Minutes | Status |
|---|---|---|---|
| Monday | Write one English paragraph | 30 | Planned |
| Tuesday | Practise adding numbers in Excel | 30 | Planned |
| Wednesday | Revise Monday’s paragraph | 25 | Planned |
| Friday | Format a small Excel table | 30 | Planned |
| Saturday | Review the week and choose next steps | 20 | Planned |
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:
- Each task describes something you can finish.
- Minutes contains numbers.
- The example totals 135 before you change it.
- The total changes when you edit a duration.
- 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:
- Create and format tables
- Use the SUM function to sum numbers in a range
- Wrap text in a cell in Excel
Prepared for EagleHut. Technical references checked on 21 November 2026.