Saturday, 8 November 2014

How the IF Function works-4

Yesterdays traffic in Lagos is what Prof. Wole Soyinka would call "A mysterious millipede, moving towards a waling wake-keep". Permit me to liken yesterday's traffic experience to what i faced when i started my data analysis career years back in the university. By chance (knowledge of Excel) I found myself handling student's result (mine inclusive). My relationship with my employer was based firstly on trust, afterwards was the fact that i knew excel inside-out as i could compute an entire session without touching the mouse. 

I was good with shortcuts and that earned me more respect than others 'cos i deliver in lesser time, all the time. I ended up automating the manual result, i saved students from manually computed extra years (due to errors), i saved jobs for those with outstanding results and I got myself employed by my department whilst a student and stopped depending on my parents for monthly allowee. I became more responsible to people's lives (results) and as a result, never sat for any aptitude test (with serious mind) because i already had a job right before graduating. In 2003 (still a student), I sold the automated Excel result for N150k. I wanted to die!

But i didn't die bcos i knew "IF" i die, someone else will spend the money and bcos i also knew the "IF Function", i sold same application and made more money. With the combination of majorly the "IF" and "VLOOKUP" function, i delivered a fully automated student result that generates result slips and also used same concept to build a salary payroll package for N250k in 2005. That was when my focus shifted from accounting to IT, with flair for applications and databases. The "IF" function is the most powerful 1st function to learn in Ms Excel and the mastery of same will give you needed joy and some level of peace + confidence at your workplace. It is simple to know + use and I would like to teach you how, "IF" and only " IF" you want to know it. Excel with Excel. CIAO.

No comments:

Post a Comment