Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

If you want to find and fix Circular References in Microsoft Excel, then this guide will help you get the job done with ease.

By using the Highlight Cells Rules, you can highlight duplicate cells in your Excel worksheet to avoid confusion and mistakes.

Open the Excel worksheet and select the range of cells that you want to search for duplicate items. For example, you might want to click a column header to select a column of telephone numbers.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.