Data Analysis

Remove Duplicates in Excel


Need to remove duplicates in Excel? Excel 2007 introduced the Remove Duplicates command on the Data tab of the ribbon. 1. Before you start… Make a copy of your data, since the command will delete the duplicate rows. 2. Select one cell in your table 3. Data, Remove Duplicates 4. Initially, all columns are checkmarked.(…)

Dueling Excel – “Show Baseball Innings as 7.1”: Podcast #1755


Baseball Statistcal Averages and Microsoft Excel – on The Same Team.

Learn Excel – “Drag & Drop to Values, An Excel Daily Paper and Trending XL”: Podcast #1754


So much going on you’ll just have to read today’s Learn Excel post…

Learn Excel – “Excel Latitude to Map Hyperlink”: Podcast #1753


Link your Excel Data to Geographic Locations.

Learn Excel – “Summarize Dates by Month and Year” – Podcast 1752


An Easy Read for 10 Years of Data…

Learn Excel from MrExcel