Skip to Main Content

Data Cleaning with Excel

Through this guide you will learn tricks and tips to better clean and organize tabular data using Microsoft Excel.

Load the Analysis Toolpak

Much like the tabs of this guide, your options in accessing the features of Excel are arranged in tabs along the top ribbon. Choose the data tab and look at the section all the way on the right to see if you have the Data Analysis Toolpak installed.

Screenshot of the Data Analysis button on the Data Tab of the Excel ribbon

If you don't see the Data Analysis link, go to the File tab, choose Options (the last choice in the left-hand margin), then choose Add-ins (the second-to-last choice in the left hand margin). Among the Add-ins you should see one called Analysis Toolpak or Analysis Toolpak VBA. Choose the latter if you use Visual Basic; otherwise, choose Analysis Toolpak.

Screen Clipping of the Excel Options screen, showing the Analysis Toolpak option under Add-ins. The Excel Options screen is accessible from the File Tab.

If you don't see the Analysis Toolpak as an Add-in option, you may need to contact FSMIT to help you install this feature. Additional guidance can be found on this Microsoft Support page.