The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Learn how to extract specific data from Excel cells using formulas, tools, and techniques to clean and organize messy datasets.

Most function-key shortcuts also work in Google Sheets, but you may need to enable compatible spreadsheet shortcuts from the Help menu to access some familiar Excel shortcuts.

Learn how to use Excel’s XLOOKUP function to simplify data retrieval, save time, and master spreadsheets with this quick beginner’s guide.