Excel Tricks to Clean Data

Add to Favorites
Author:

[Download files from the side column or bottom of the page.]

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
Excel ToolTips on Mouse Hover for Buttons and Shapes
Tutorial: Excel trick to add ToolTips to any of your shapes when a user hovers over them in a works...
Sort Data With Headers in Ascending Order in Excel
Macro: Macro that sorts data that has headers in ascending order in Excel. This macro assumes tha...
Sort Data that Doesn't Have Headers in Ascending Order in Excel
Macro: Sort data that doesn't have headers in ascending order in Excel with this macro. This is a...
Sort Data that Doesn't Have Headers in Descending Order in Excel
Macro: Sort data in Excel that doesn't have headers using a macro. This Excel macro assumes that ...
SORTBY() - New Excel 365 Function to Sort Data
Tutorial: Learn Excel's New Function to Sort Data! This is the SORTBY() function for Excel 365 and ...