Insert a Pivot Table to see your learning patterns at a glance.
You will quickly see if you are neglecting W3 words or if 70% of your vocabulary is still "Red."
You have two options:
Option A – Excel printout
Option B – Flashcards on paper
Option C – Word lists by band
Print Band 1 separately (must-know), then Band 2, then Band 3.
Here is where you truly excel at the Longman 3000. longman 3000 words excel
Formula 1: Progress Tracker
Add a separate sheet for statistics. Use =COUNTIF(Table1[Status], "Mastered")/3000 to see your overall percentage. Format as a percentage. Create a progress bar using conditional formatting.
Formula 2: Spaced Repetition Scheduler
In the Review Date column, enter:
=IF([@Status]="Learned", TODAY()+3, IF([@Status]="Mastered", TODAY()+14, "")) Insert a Pivot Table to see your learning
Formula 3: Random Word Selector (The Quiz Feature)
=INDEX(A:A, RANDBETWEEN(2, 3001)) – Press F9 to get a new random word. Test yourself without scrolling.