A Level Revision Planner Excel: A 2026 Guide for UK Students
16 August 2026
Download our A level revision planner Excel template for 2026. Track subjects, countdown to exams, and boost your UK study plan.
Why Use an Excel Planner for A Level Revision?
Excel gives you total control over your A level revision. Unlike paper planners, you can easily shuffle topics, duplicate weekly layouts, and automate progress tracking. For UK students juggling three or four A levels, Excel helps you balance workload across subjects like Biology, Chemistry, and English Literature. You can colour-code by priority, link to your exam timetable (from AQA, OCR or Edexcel), and instantly see how many hours you’ve logged. Best of all, it’s free if you already have Microsoft Office, and works on your laptop, phone or tablet – so you can update your plan during study leave or on the bus.
Key Features to Include in Your Revision Planner
A powerful A level revision planner Excel needs a few core tools. Start with a dashboard tab showing your upcoming exams and days left. Add a weekly timetable grid with time slots for each subject. Create a topic tracker where you list every specification point – for example, the AQA A level Psychology topics – and rate your confidence from 1 to 5. Use a progress log to record daily revision hours and completed past papers. Finally, add conditional formatting that turns cells green when you’ve mastered a topic, yellow when you’re still working, and red if you’re falling behind. That visual cue makes it obvious where to focus next.
How to Structure Your Excel Planner (Subjects, Topics, Priorities)
Start by listing all your A level subjects in one column. Next to each, note the exam board, the number of papers, and the final exam date. Then break each subject into its syllabus modules – for example, OCR A level Physics has six modules; split them into separate rows. Add a “Priority” column using a simple 1-3 scale: 1 means you need urgent revision, 2 is moderate, 3 is confident. Use a filter to view only priority 1 topics. Then allocate blocks in your weekly timetable to those high-priority areas. This method ensures you’re always working on the topics that will boost your grade the most.
Using Formulas and Conditional Formatting to Stay on Track
Excel formulas turn your revision planner from a static timetable into a live study tool. Use =COUNTIF(range,"Completed") to count how many topics you’ve finished. Use =SUM(C2:C10) to total your revision hours each week. To calculate days until an exam, use =DATEDIF(TODAY(),D2,"d"). Conditional formatting is your best friend: highlight cells in red when you have less than 30 days to an exam, or when your weekly hour target (like 25 hours) isn’t met. You can even create a bar chart within Excel to visualise progress per subject. These features make it easy to see what’s working – and what isn’t – before mocks.
Where to Find Free UK Templates and How to Adapt Them
There are many free A level revision planner Excel templates online, but check they’re aligned with the UK system – some international planners don’t include A* grades or UCAS deadlines. The best places to find them are student forums like The Student Room, or revision blogs by UK teachers. Once you download one, adapt it: change the exam dates to your own timetable, add your specific subjects, and adjust the daily time slots to fit your school hours. If you prefer to build from scratch, search for “A level revision planner Excel” on YouTube for step-by-step tutorials. Or use Office’s built-in planner template and customise it – it’s easy.
FAQ
Excel is more flexible and easier to update than paper. You can move topics around, add new rows, and use formulas to track progress automatically. Paper may help you avoid screen distractions, but Excel lets you quickly see gaps and adjust your plan. Many UK students use both – paper for daily focus, Excel for the overall strategy.