If your Excel file does not have the , add it yourself. Color code S1 words Green (go), S2 words Yellow (slow), and S3 words Red (stop/harder). This gamifies your learning.
: An Excel file can be easily imported into SRS (Spaced Repetition System) apps like Anki or Quizlet. Key Resources for the List
| Word # | Word | | --- | --- | | 1 | a | | 2 | and | | 3 | the | | ... | ... | | 3000 | ... |
(The full list continues to 3,000 – see note below for complete file) Longman Communication 3000 Words In Excel
Filter your spreadsheet to show only words. Focus on the top 10 words daily. Move them to "In Progress" once you memorize the definitions, and test yourself at the end of the week. Target Weaknesses via Filtering
Track your retention with an automated review formula. If you want to review "In Progress" words every 7 days, set your column to: =IF(G2="In Progress", TODAY()+7, "") Strategic Study Workflows
Create new columns in your sheet: (e.g., 1-5 scale), "Last Reviewed" (date), and "Notes" (for mnemonics or example sentences). Use Excel's conditional formatting to color-code words by their difficulty level, turning your weakest words into visual cues for review. If your Excel file does not have the , add it yourself
For educators, researchers, or advanced learners, the Excel file is a goldmine for data analysis. You can use pivot tables and charts to identify trends:
If you want to remember the words forever, type them yourself. Open the back of a used Longman dictionary (cheap on eBay) and manually type the 3,000 words into Excel. This takes 10 hours, but you will remember 50% of them just from the physical act of typing.
Analysis of the Excel data often reveals that high-frequency spoken words (S1) include discourse markers ( actually, basically ) and response tokens ( mm, yeah ), which are often absent from written frequency lists. : An Excel file can be easily imported
: Instead of memorizing obscure vocabulary, students focus on high-frequency terms Compleat Lexical Tutor Comprehension
If you possess the raw text data, import it into Excel using the "Text to Columns" feature with "Space" or "Tab" as the delimiter.