From Confusion to Clarity: How Excel Data Analysis Has Transformed My Skills.

Introduction: The Dataset That Changed Everything I will be honest. When I first opened the Jumia Kenya product dataset, I had no idea where to begin. There were 115 rows of product data, but the prices were buried inside text strings like "KSh 1,525", the ratings were written as "4.5 out of 5", the review counts were all negative numbers, and a full 50 per cent of the rows had no rating information at all. It looked less like a dataset and more like a problem waiting to punish me. That experience — the confusion, the slow process of fixing each issue one by one, and the moment when the data finally came alive — is exactly what this article is about. Learning Excel data analysis did not just teach me a set of formulas. It changed the way I think, the way I approach problems, and the way I trust my own conclusions. This is my story of how that happened, told through the real data I cleaned, interpreted, and turned into a working dashboard. Step One: Working on Messy Data The first thing