
Certification Study Planner
Certification Study Planner Spreadsheet, IT Exam Study Tracker with Countdown, Weekly Schedule, Topic Checklist and Practice Test Log
- Exam countdown and pace check
- Weighted topic checklist
- Weekly plan that fills itself
- Practice test and error logs
- Spaced review dates and focus list
What you get
- certification-study-planner.xlsxExcel workbook · 237 KB
A study planner spreadsheet for any IT certification exam that publishes its domains and their weights. List the domains and your topics once; the workbook spreads the topics over the days you can study, counts down to exam day, logs every session and practice test, and ranks the topics that carry the most exam weight you are not yet sure of.
What you download
One .xlsx workbook with 9 tabs. Opens in Excel 2010 or later, Google Sheets and LibreOffice Calc. Standard formulas only: no macros, no add-ins, nothing connects to the internet. English. Digital download only; no physical item ships.
Inside
- Dashboard: days and weeks to the exam, study days left, hours studied, ahead or behind plan, topic hours left against the hours you have before final review (with the weekly pace needed), topic progress, practice-test trend against your target, a domain table and a focus list of the ten topics with the most exam points at risk - Setup: exam name and date, study start date, final-review days, target practice score, the hours you can study each weekday, up to 10 domains with their weights, and spaced-review intervals - Topic Checklist, 200 rows: domain, estimated hours, status, confidence 1 to 5, last studied, next review date with a Due flag, hours logged, hours left, missed questions and exam points at risk - Weekly Plan, up to 53 weeks: planned hours for each Monday-to-Sunday week, learning and final-review phases, the topics suggested for each week, hours studied, practice tests taken and a status for every week - Study Log, 1,000 rows: date, topic or domain, activity and minutes - Practice Tests, 200 rows: full timed tests, domain quizzes and practice sets, with score, minutes per question against the exam's pace and points above or below your target - Error Log, 500 rows: every missed question with the reason (didn't know it, misread, ran out of time and more) and the right idea in your own words; the Dashboard counts the reasons - Start Here and Study Method: setup in four steps, how every number is worked out, the confidence scale, how to use practice tests, and an exam-week checklist
How it works
Yellow cells are for typing; everything else calculates, and Check columns point out a missing date, an unknown domain or a duplicate topic. A worked example (a fictional networking exam, three and a half weeks into a twelve-week plan) fills every tab so you can see it working; the guide lists exactly which cells to clear. Vendor-neutral: it suits networking, security, cloud, systems or any other exam with a published list of domains. It contains no exam content and no exam questions, and is not connected with any certification provider.
For your own use; do not resell or redistribute the file. Designed by seller.
Designed by OEFR Digital with AI assistance. Every formula is checked before listing.
Designed by OEFR Digital with AI assistance. Every formula is checked before listing.


