PMP Study Tracker: Free Google Sheets Setup in One Hour

Arjun Patel

Arjun Patel writes about tech certification prep methods from a self-study perspective. Bangalore-based · cert…

Visual representation of the voice · not a photographic portrait

Quick answer: Use a free Google Sheet that lists every task from the PMP Exam Content Outline with a 1 to 5 confidence score, plus tabs for study hours, mock exam scores by domain and wrong answers. Schedule study blocks in Google Calendar and review the sheet weekly to see when you are ready.↗ Share on X

The simplest way to track your PMP exam prep for free is a three-part system: a Google Sheets tracker listing every task in the official PMP Exam Content Outline with a confidence score from 1 to 5, a Google Calendar with fixed study blocks, and a mock exam log that records your score by domain after every practice test. Update the sheet after each study session and review it once a week. When most tasks sit at 4 or 5 and your recent full-length mock scores are steady and consistent, you are close to ready. Everything below shows you how to set this up in about an hour, with no paid apps.

Why track progress at all instead of just studying?

READ ALSOPick the Right English Tense for Daily Life Easily →AWS Cloud Practitioner vs Solutions Architect: Pick by Job →How to Choose the Best Tech Certification for Your Career →

PMP prep usually takes weeks or months of part-time study. Without tracking, two things happen:

1. You study what you already like. Most people keep rereading topics they feel good about and avoid the hard ones.

2. You cannot tell if you are ready. You end up booking the exam based on a feeling, not on data.

A tracker fixes both. It shows your weak spots in plain numbers, and it tells you when to stop studying and book the exam.

What should I track?

Track four things. More than that and you will stop updating it.

Step 1: How do I build the main tracker in Google Sheets?

READ ALSOFirst Cloud Certification With No Coding: Pick in 4 Steps →AWS Exam Rescheduling Rules: How to Keep Your Exam Fee →Cloud Cert Study Log: Track Focused Hours That Count →

First, download the current PMP Examination Content Outline (ECO) from the PMI website. It is free. It lists the exam's domains and the tasks inside each one. PMI updates the outline from time to time, so make sure you have the version that matches your exam date.

Then create a sheet with these columns:

1. Domain (for example, People, Process, Business Environment — use the names in your version of the outline)

2. Task (copy each task name from the outline)

3. Confidence (1–5)

4. Last studied (date)

5. Source (which book chapter, video or course section covers it)

6. Notes

Use this confidence scale and stick to it:

• 1 — I don't understand this yet.
• 2 — I've read about it but couldn't explain it.
• 3 — I can explain it, but I miss practice questions on it.
• 4 — I get most practice questions on it right.
• 5 — I could teach this to someone else.

Add color. Select the Confidence column, go to *Format → Conditional formatting → Color scale*. Set red for 1 and green for 5. Now one glance shows your weak areas.

Add a summary. In a corner of the sheet, use `=AVERAGEIF(A:A,"People",C:C)` to get the average confidence for each domain. Change "People" to each domain name. Watch these numbers climb week by week.

Step 2: How do I schedule study time so it actually happens?

Open Google Calendar (or any free calendar app) and:

1. Pick a target exam window, for example 10 to 12 weeks from now. Do not book the exam yet unless you work well with a hard deadline.

2. Create recurring study blocks. For example, 1 hour on Monday, Wednesday and Friday evenings, plus 2–3 hours on Saturday morning.

3. Name each block with the topic, pulled from your weakest tasks: "PMP — risk responses" is better than "PMP study".

4. Add one weekly review block of 30 minutes, ideally Sunday. This is when you update your tracker and plan next week.

In your Google Sheet, add a second tab called Hours with two columns: *Week* and *Hours studied*. Fill it in during your weekly review. If you miss your planned hours two weeks in a row, change the plan instead of feeling guilty — fewer, shorter blocks you actually do beat long ones you skip.

Step 3: How should I log mock exams?

Practice tests are your best readiness signal. Create a third tab called Mocks with these columns:

1. Date

2. Source (which practice test bank)

3. Number of questions

4. Total score (%)

5. Score per domain (%)

6. Time used

7. Top 3 weak topics

Some tips:

• Take a short diagnostic test early (week 1 or 2). Expect a low score. Its job is to show your starting point, not to judge you.
• Take full-length timed mocks later, under real conditions: one sitting, a quiet room, timed, breaks only where the real exam allows them. Check PMI's current exam details for the real number of questions, time limit and break rules.
• Do not reuse the same question bank over and over. You will start remembering answers, and your score will look better than your real level.
• Use a free line chart. Select your Date and Total score columns, then *Insert → Chart → Line chart*. A rising line is great motivation; a flat line tells you to change your study method.

Many PMP prep providers offer free sample questions or a free mini mock exam. PMI's own study resources are also worth checking. Be careful with random free question sites: some have outdated or wrong answers.

Step 4: How do I track wrong answers so I stop repeating them?

This is the step most people skip, and it often makes the biggest difference.

Create a fourth tab called Mistakes:

Use the "Why I got it wrong" column honestly. Most mistakes fall into a few types:

1. Didn't know the concept. → Study it again.

2. Misread the question. → Slow down; underline words like "first", "next" or "best".

3. Chose a real-world answer, not the PMI answer. → Review how PMI expects a project manager to act (collaborate first, follow the process, avoid jumping to escalation).

4. Ran out of time. → Practice timing on shorter sets.

After each mock, count which type shows up most. That tells you *how* to study, not just *what* to study.

Which other free tools help?

• Anki (free on desktop and Android): a flashcard app that shows you cards right before you are likely to forget them. Great for terms, formulas like earned value calculations, and agile roles.
• Trello or Notion free plans: if you prefer boards to spreadsheets, make columns called *To study*, *In progress*, *Review*, *Confident*, and move each ECO task card across.
• A simple timer (phone or a free Pomodoro app): study in 25-minute focus blocks with 5-minute breaks to keep sessions efficient.
• Free study groups: online PMP communities and local PMI chapter events can help with motivation and tricky questions.

You do not need all of these. Start with Google Sheets and Google Calendar. Add others only if you feel something is missing.

How do I know when I'm ready to book the exam?

There is no official passing score published that you can aim for, so use several signals together:

1. Most tasks in your tracker are at 4 or 5, and none are at 1 or 2.

2. Your full-length timed mock scores are steady or rising across your last few tests from good-quality sources — not one lucky high score.

3. Your domain scores are balanced. One very weak domain is a real risk.

4. You finish mocks within the time limit with a few minutes to spare.

5. Your Mistakes tab shows fewer "didn't know the concept" errors over time.

If you meet most of these, book your exam a few weeks out and use the remaining time for timed practice and review of your weakest tasks.

Your next step

Set aside one hour today. Download the current PMP Exam Content Outline from PMI, copy the tasks into a new Google Sheet, and give each task an honest confidence score from 1 to 5. Then block three study sessions in your calendar for this week, each named after one of your red (score 1 or 2) tasks. By the end of week one, you will know exactly where you stand.

FAQ

Where do I get the list of PMP exam topics?

Download the PMP Examination Content Outline from the PMI website. It is free and lists every domain and task on the exam. Make sure your version matches your exam date, because PMI updates it from time to time.

How often should I take a full mock exam?

Take one short diagnostic test early, then full-length timed mocks in the later weeks of your plan. Space them out so you have time to study the weak areas each one reveals, and avoid reusing the same question bank.

Do I need a paid app to track PMP study progress?

No. Google Sheets and Google Calendar cover tracking and scheduling. Free tools like Anki for flashcards and the free plans of Trello or Notion are optional extras.