Free Spreadsheet to Track Cloud Cert Study Hours by Domain
Quick answer: Create a Google Sheet with one row per study session: date, minutes, exam domain, activity and practice score. Add a summary tab with SUMIF formulas that totals hours per domain against a target based on the official exam guide weights.↗ Share on X
To track your cloud certification study hours with a free spreadsheet, open Google Sheets (or Excel Online), make one row per study session with five columns: date, minutes, exam domain, activity, and practice score, and then add a small summary table that totals your hours per domain and compares them to your target. That is it. In about 20 minutes of setup you get a tracker that tells you three things every week: how many hours you really studied, which exam topics you are neglecting, and whether your practice scores are rising fast enough to book the exam.
Below is the exact layout, the formulas to copy, and how to set a realistic target for AWS, Azure, or Google Cloud exams.
Why track hours at all?
Tech Cert Roadmap for Full-Time Workers: A 12-Week Plan →
How to Explain Cloud Certification Gaps in Interviews →
AWS Exam Questions: Read Them Fast and Cut Wrong Answers →Most people who fail or keep postponing a cloud exam don't lack talent. They lack visibility. Three common traps:
- "I studied all week" turns out to be four sessions of 30 minutes.
- Comfort topics get all the time. You keep reviewing compute because you like it, and skip networking or security because they are harder.
- No clear "ready" signal. Without numbers, you either book the exam too early or keep pushing the date.
A tracker fixes all three. It is not about logging for the sake of logging. It is about making decisions with data.
Level up — free guides in your inbox
Step 1: Set up the log sheet
Create a new spreadsheet and name the first tab Log. Add these headers in row 1:
| Column | Header | What to enter | Example |
|---|---|---|---|
| A | Date | Day of the session | 2026-10-20 |
| B | Minutes | Real focused minutes, not time at the desk | 45 |
| C | Domain | Exam domain from the official exam guide | Security |
| D | Activity | Video, reading, lab, practice test, flashcards | Lab |
| E | Score % | Only for practice tests, else leave blank | 68 |
| F | Notes | One line: what was hard | IAM policies confusing |
Tips that make the data useful:
1. Use a dropdown for Domain and Activity. In Google Sheets: select column C, go to *Data > Data validation*, choose *Dropdown*, and type your domains. This stops typos like "Securty" from splitting your totals.
2. Copy the domains straight from the official exam guide. Every major cloud provider publishes an exam guide listing the domains and their weight (the percentage of questions from each area). Use those exact names.
3. Log minutes, not hours. It is more honest. A 25-minute session counts, and you won't round 40 minutes up to "an hour."
Step 2: Build the summary tab
AWS Cloud Practitioner vs Solutions Architect: Pick by Job →
How to Choose the Best Tech Certification for Your Career →
First Cloud Certification With No Coding: Pick in 4 Steps →Create a second tab called Summary. List your exam domains in column A, starting in A2. Then:
| Column | Header | Formula (row 2) |
|---|---|---|
| A | Domain | type the name, e.g. Security |
| B | Exam weight % | type it from the exam guide, e.g. 30 |
| C | Target hours | `=B2/100*$H$1` |
| D | Hours done | `=SUMIF(Log!C:C,A2,Log!B:B)/60` |
| E | % of target | `=IF(C2=0,0,D2/C2)` |
| F | Last practice score | `=IFERROR(INDEX(FILTER(Log!E:E,Log!C:C=A2,Log!E:E<>""),COUNT(FILTER(Log!E:E,Log!C:C=A2,Log!E:E<>""))),"-")` |
In cell H1, type your total target hours for the whole exam (see Step 3). Drag the formulas down for every domain.
The `FILTER` formula in column F works in Google Sheets and in Excel 365. If you use an older Excel, skip column F and check scores on the Log tab instead.
Then add two cells at the top:
- Total hours: `=SUM(Log!B:B)/60`
- Hours this week: `=SUMIFS(Log!B:B,Log!A:A,">="&TODAY()-WEEKDAY(TODAY(),2)+1)/60`
The second formula counts from Monday of the current week.
Step 3: Pick a realistic total target
There is no official number of hours for any cloud certification. The right target depends on your experience. Use this as a starting point and adjust after two weeks of real data:
| Your situation | Entry-level exam (e.g. AWS Cloud Practitioner, AZ-900) | Associate exam (e.g. AWS Solutions Architect Associate, AZ-104) |
|---|---|---|
| New to IT | Plan on the higher end and add more lab time | Consider passing an entry-level exam first |
| Some IT experience, new to cloud | Moderate plan | Long plan, heavy on labs |
| Already using the cloud at work | Short plan, focus on practice tests | Moderate plan, fill domain gaps |
Practical rule: set a target, then watch your practice test scores, not the clock. The hours tell you whether you are putting in the effort. The scores tell you whether it is working.
If you study 1 hour a day on weekdays and 2 hours on Saturday, that is 7 hours a week. Divide your target by 7 and you have a realistic number of weeks. Put that date on your calendar before booking the exam.
Step 4: Add a visual progress bar (optional but motivating)
In the Summary tab, select column E (% of target), then:
1. Go to *Format > Conditional formatting*.
2. Choose *Color scale*.
3. Set the minimum to red, the midpoint (50%) to yellow, and the maximum (100%) to green.
Now you can see at a glance which domains are red. That is where your next session goes.
For a simple chart: select columns A and D, then *Insert > Chart > Bar chart*. You get hours per domain in one picture.
Step 5: Use a weekly 10-minute review
The tracker only helps if you look at it. Every Sunday, spend 10 minutes and answer four questions:
1. Did I hit my weekly hours? If not, what got in the way? Move study to a different time of day.
2. Which domain has the lowest % of target? Schedule two sessions on it this week.
3. Is my practice score going up? Look at the last three practice tests.
4. Am I doing enough labs? Filter the Activity column. If labs are less than about a quarter of your time for an associate exam, add more. Hands-on practice is what makes scenario questions easier.
When are you ready to book the exam?
Use your tracker data, not a feeling. A simple checklist:
- [ ] Every domain is at least near its target hours.
- [ ] Your last three full practice tests are consistently above the passing level stated by the provider, with some margin.
- [ ] No single domain has a practice score far below the others.
- [ ] You can explain, in your own words, why the wrong answers on your last test were wrong.
If you check all four, book the exam for two to three weeks out. Use that time for review and one or two more practice tests, not new material.
Common mistakes with study trackers
- Logging passive time as study. A video playing while you cook doesn't count. Only log focused minutes.
- Making the sheet too complex. If logging a session takes more than 30 seconds, you will stop doing it. Five columns are enough.
- Never updating the target. If your first practice test shows you are strong in one domain, lower its target and shift hours to weak areas.
- Only tracking hours. Hours without practice scores is like counting gym visits without checking if you got stronger.
Bonus: track multiple certifications in one file
If you are following a roadmap (for example, an entry-level exam, then an associate, then a specialty), add a column G: Certification to the Log tab. In the Summary tab, change the formula in column D to:
`=SUMIFS(Log!B:B,Log!C:C,A2,Log!G:G,"AWS SAA")/60`
Make one Summary tab per certification. Your full history stays in one place, which is handy when an employer asks how you prepared.
Your next step today
Open a blank Google Sheet now. Create the Log tab with the six columns from Step 1, and download the official exam guide for your certification to copy the domain names and weights. Log today's session, even if it is only 20 minutes. Next Sunday, build the Summary tab with the formulas above and do your first 10-minute review. After two weeks of real data, adjust your total target hours and pick your exam date.
FAQ
How many hours should I study for a cloud certification?
There is no official number. It depends on your experience and the exam level. Set a starting target, track two weeks of real data, and let practice test scores tell you when you are ready.
Can I use Excel instead of Google Sheets?
Yes. All formulas work in Excel 365. In older Excel versions, skip the FILTER formula for the last practice score and check scores on the Log tab.
When should I book the exam?
When every domain is near its target hours and your last three full practice tests are consistently above the passing level with some margin. Book two to three weeks out and use that time for review.