Below you'll find a list of all posts that have been categorized as “Excel”
📋 Situtation Have you ever find yourself using way too many columns to describe your data? It almost feels like data spanning across 26 columns (column A to Z) were still not enough to describe everything. Worst still, the proliferation of columns could go beyond double alphabets (52 columns and counting), making your spreadsheet very hard to view even with …
Having been deep dived into data cleaning these days, I found that some cells were filled with zeros when it should be blank. The following explain why there are differences between filling a cell with 0 and leaving it blank to describe your observation in Excel. More importantly, why this means two utterly different things when presenting your data. To …
Cleaning data in Excel is something that I enjoyed very much these days (don’t judge). While I am pondering on writing something more in-depth about how to organise your data for management and analysis, it seems much easier to write about Excel errors first as a warm up. So, here goes: ###### Problem: This is not even an error. It …