July 22, 2022, 4:41 a.m. | Olaoluwakiitan Olabiyi

Towards Data Science - Medium towardsdatascience.com

A comprehensive blueprint on getting started with data analysis in Microsoft Excel

Photo by UX Indonesia on UnsplashWelcome to tutorial #2 of the Excel Series. Click HERE to read tutorial #1. Otherwise, proceed to tutorial #2 below.

The data cleaning techniques to cover in this tutorial are;

  1. Resize columns
  2. Get rid of leading and trailing spaces.
  3. Remove line breaks from cells
  4. Remove Duplicates
  5. Deal with blank rows and cells
  6. Standardize sentence case

The datasets used are fashion datasets from …

analytics data data analytics data science excel fashion microsoft-excel series

AI Research Scientist

@ Vara | Berlin, Germany and Remote

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Lead GNSS Data Scientist

@ Lurra Systems | Melbourne

Senior Machine Learning Engineer (MLOps)

@ Promaton | Remote, Europe

AI Engineering Manager

@ M47 Labs | Barcelona, Catalunya [Cataluña], Spain