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

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.

I am running into the dreaded "Excel cannot complete this task with available resources" dialog box in Excel while trying to fill a column with a simple VLOOKUP equation. I have one column with ...