Create a pivot table from your master list:

I can provide the exact layout or step-by-step setup tailored to your needs. Share public link

Use data fields to mark words as "Mastered," "In Progress," or "New."

You want your eye to go immediately to the words you need to review today.

: These are your static dictionary columns. Progress Columns (F-H) : These are dynamic columns for tracking your mastery.

Click . This restricts the cells to these exact strings, which is crucial for building accurate formulas later. 2. Status Color Coding with Conditional Formatting

=IF(Status="Mastered", Last_Reviewed+30, IF(Status="Learning", Last_Reviewed+3, TODAY()))

A blank spreadsheet is an invitation to personalize your learning experience. Simply copying a word and its definition from a dictionary is passive, and passive learning is often ineffective. By manually typing information into an table, you engage with the word, creating a stronger neural connection. As one educator noted, by actively adding and compiling the information, an Oxford 3000 Excel file "becomes a personalised vocabulary record for the student".

You can combine this with Conditional Formatting on the column. Set a rule where if a cell value is less than or equal to =TODAY() , the cell turns bright orange, alerting you that the word is due for a quiz. Step 5: Advanced Customization and Filtration

Visual cues make tracking progress intuitive. Use Excel’s Conditional Formatting to color-code your "Mastery Status" column: Highlight Column F ().

Mark words as "Mastered," "Learning," or "Unknown" to focus your energy where it matters most.

Make your spreadsheet scannable by automatically color-coding your words based on their learning status. Highlight your entire dataset. Go to > Conditional Formatting > New Rule . Select Use a formula to determine which cells to format . Enter =$G2="Mastered" and choose a light green fill color.

The Oxford 3000 is a list of the 3,000 most important words to learn in English. According to linguistic experts, mastering this specific vocabulary gives you access to 70-80% of the words used in daily conversations, news articles, and business emails.