Longman Communication 3000 Words In Excel Guide

Create 3 columns: , Recall 1 Week , Recall 1 Month . Test yourself. If you can recall the word after 1 month, delete the row. Your goal is to shrink the spreadsheet from 3,000 rows to 0 rows (meaning you have mastered them all).

When pasting the list from web sources, use . This eliminates messy source styles, broken hyperlinks, and erratic font sizes. 3. Use Data Validation for Status Tracking Prevent messy typing by locking down your status column: Select the entire Status column. Navigate to the Data tab and click Data Validation . Set the validation criteria to List . Source the values: New, In Progress, Mastered . Advanced Excel Techniques for Language Learners Longman Communication 3000 Words In Excel