title-img-TooManyColumnsIsBad

Benefits Of Using Less Excel Columns Than For More

📋 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 …

TitleImage-Excel-zeroORblank

Should You Put Zero or Leave it Blank in Excel?

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 …

thesis development

Mentoring Student’s Thesis

Just came back from another round of tutorial in thesis development. Have that eureka moment on how we could help student in developing their thesis, could look like this: Stage I – Let Their Minds Run Free –  I don’t intervene much at this early stage of development. It is after all, students’ thesis, not mine! More importantly, is to pay attention to students’ aspiration …