Hi! Welcome to the fifth post in my Excel MVP series.
In this tutorial, I will show you my most used (and very useful) Microsoft Excel keyboard shortcuts. 

Do note that CTRL + C means press CTRL key and while keeping it pressed, press C key. While, ALT, H, V, V means press ALT key, release it and press H, release it and press V, release it and press V.

1. CTRL + up arrow: This will select the first entry in a column within a table, the first after a blank cell or the first cell in that column. But in most use cases, you'll want to select the first entry in a column and as long as your table has no blank cells, that's what this keyboard shortcut will do.

2. CTRL + down arrow: This will select the last entry in a column within a table, the last before a blank cell or the last cell in that column.

3. CTRL + left arrow: This will select the first entry in a row within a table, the first after a blank cell or the first cell in that row.

4. CTRL + right arrow: This will select the last entry in a row within a table, the last before a blank cell or the last cell in that row.

5. CTRL + SHIFT + up arrow:  This will select all the cells from current cell to the first entry in that column within the table, the first cell in that column or the first cell in that column.

6. CTRL + SHIFT + down arrow: This will select all the cells from the current cell to the last entry in that column within a table, the last before a blank cell or the last cell in that column.

7. CTRL + SHIFT + left arrow: This will select all the cells from the current cell to the first entry in that row within a table, the first after a blank cell or the first cell in that row.

8. CTRL + SHIFT + right arrow: This will select all the cells from the current cell to the last entry in that row within a table, the last before a blank cell or the last cell in that row.

9. CTRL + END: This will take you to the last entry in a table or the last cell in the excel sheet.

10. CTRL + SHIFT + END: This will select from the current cell to the last entry in a table or the last cell in the sheet.

11. CTRL + C: To copy current cell or selected cells

12: CTRL + V: To paste

13: ALT, H, V, V: To paste values only

14: ALT, H, V, S, T: To paste formats only. Very useful for maintaining a uniform format across multiple tables, even in separate workbooks.

YouTube is a global video library, a free and easily accessible one too.
You'll find videos on anything on YouTube. So, maybe it's time you join the league of content providers on YouTube and upload that video you've been so proud of, whatever it may be.

Here are the simple steps to making your first YouTube video upload -
1. Go to www.YouTube.com 


Click on Sign In at the upper right corner

2.On the Sign In page that opens, click on Create An Account at the upper right corner


"Huh? Really?"
Yeah! You can do your online banking on your android phone. In fact, I have been making fund transfer to third parties on my android phone for years now. And not just that, I have been checking my investment accounts (which requires adobe flash player on a computer), paying my DSTV subscription, making Skype calls and downloading YouTube videos on my android phone.
Believe me, there is nothing you can do on your Internet Explorer (Firefox, Chrome, Safari and Opera) browser that you can't do with just your android phone, and even much more. I can easily change my IP address to show that I'm in USA or UK, so I can buy things online more easily or watch Netflix and Google Movies. I can also change my Network provider to TMobile USA so that I can install exclusive applications that are not available in my country, like Amazon Kindle and online video rental apps.
There is no end to what you can do on your phone, internet-wise.

In this post I will show you screenshots, lots of them to convince you.
As an example, I'll show you how to access your online banking facility for GTB as if you are working from a personal computer. Just go to your bank's website (in this case, www.gtbank.com) and click on Login.


Hey! Welcome to the 4th post in my MVP series.



In this video I'll show you -

1. How to make a simple Excel dashboard using Combo Box and Index function
2. How to enable the Developer tab
3. How to enhance the visual look of your workbook - rename sheets, color sheet tab and hide gridlines

Don't forget to checkout MVP #5!


Need any help? Drop me a note in the comment box.
Hey! Welcome to the 3rd post in my MVP series.




In this video I show you -
1. How to use Vlookup function to populate a table's field from another table,
2. Concatenate two or more texts and/or numbers
3. Useful keyboard shortcuts

Don't forget to checkout my MVP #4!

Also drop me any question in the comment box.
Hey! Here is the second post in my MVP series. And fortunately for you, it is a very handy, easy to watch or download video tutorial, so you will be able to follow through without any headache (unlike text tutorials).



In this video I show you how to -


1. How to enter data in Microsoft Excel, especially telephone numbers beginning with the digit zero (0)

2. How to auto adjust the cell widths to show the entire cell content
3. How to add border to a table
4. How to sort a table using more than one field entry
5. How to filter a table to show only certain entries
6. How to remove a filter
7. How to copy and paste values via keyboard shortcut
8. How to join two cell entries as one in another cell.

Don't forget to checkout MVP #3!
Chapter 1, last part here

The Beginning here

Today, breakfast is beans and pap, a combination of my most disliked foods. If it was Akara and pap, I will gladly do with the Akara alone. Now I have to skip breakfast. Fortunately, the midnight meal I had is yet to fully digest. And mum isn't going to notice, she is in her usual Sunday morning frenzy, hurrying us all to be ready for church on time. The only day she succeeded in getting us to church early was a year ago, and that Sunday, unknown to us, service had been shifted to evening because all the church leaders had gone for an emergency meeting at the national headquarters the day before. Though, we, for once, got to church before start of service, we missed the entire service because my dad, out of annoyance, made us all go back home immediately. That Sunday has been one of my best.
Today, I plan to stay at home. I really don't feel like going to church. I am already forfeiting my breakfast and going to church will completely ruin my day. The issue is, our church is over 10 streets away and the service is five hours long. Even after we are lucky to reach the church 1 hour late, we still have four gruesome hours to spend there. I am forced to stay at the youth church, and treated like a six year old by the youth church leaders who keep referring to everyone as children and never stop telling us what not to do - do not steal, do not lie, do not fight, do not shout, do not look sideways... For the over five years I have been there, none of them has ever considered telling us what to do with our lives. The only silver lining is that all the leaders like me, they consider me to be the ideal child - not even a bit troublesome, intelligent and godly. So, I always get to represent the church at all youth inter-church quiz competitions. But I am not more godly that the ever troublesome Chuks or more intelligent than every other kid. I am just naturally quiet and extremely quiet when unhappy, which makes me an angel when compared with the other kids. Truly I am intelligent, but Tinu is much more intelligent, the words that come out of her mouth never cease to amaze me. She can recite memory verses after reading them once. If not that she ruins the whole effect by not knowing when to stop talking, it would have been obvious that I am less intelligent. Here, silence is truly golden. Tinu is always my partner at all the two-man team quiz competitions, and she always answers more questions than me. But I have developed a marvelous trick that makes everyone believe I actually tell her every answer she gives. At the very moment she cocks her head in readiness to give the answer, I nudge her and ask her if she's sure, than I nod my heard vigorously to assure her that it's the correct answer. But the effect I create on the audience is that of me telling her the answer and nodding to assure her that I'm very sure of its correctness. And on more than one occasion, the compere awarding the prize shook my hand vigorously and patted my back with his left hand as a way of showing that he saw me give Tinu all the answers. But these fun times hardly come more than thrice a year.
I am not in a mood to walk to church this morning, in fact, until last month I hated the fact that my parents chose a church that is more than ten streets away. It was what Mrs Helen said that changed my mind. I had come home at noon like every other Fridays, schools close much earlier on Fridays. But this Friday, I was surprised to meet my mum at home. Soon I became sad, the rest of the day was now ruined as I wouldn't be able to get out of the house to visit my friends. She was not alone in the living room, there was Mrs Helen discussing with her. My mum and Mrs Helen had suddenly become friends three weeks ago, when Mrs Helen lost her father. She wanted my mum to supply the laced clothes she would sell to everyone attending the burial. That day my mum was showing her all the designs she had. As I walked in, she had just chosen the one she preferred and was discussing the price with my mum. Since her father died, she seemed to me to have never been happier. In fact, I was beginning to doubt it until I asked Mariam. Mariam's mum is infamously known as the community radio, the only radio that runs on blood and not batteries. She goes from house to house and dawn to dusk discussing the latest happenings in the neighbourhood. And the frightful truth is that her health depends on it. There was a time, some of her husband's friends in the neighbourhood complained bitterly to him about this full-time vocation of his wife, and one, actually, ridiculed him. He, in turn, threatened to withdraw his wife's daily stipend if she doesn't put an end to this infamous act of hers. Two days later, she fell critically ill. It was so bad the landlord was bothered, and begged all the other tenants to take turn in visiting her and telling her about the recent happenings in the neighbourhood. Then, she recuperated fully in two days. But Mariam knows much more than her mother. She debriefs her mum every night and gleans extra information from other children in the neighbourhood. So I had to ask Mariam for the inside story of Mrs Helen's new circumstance. But to my disappointment, Mariam confirmed that Mrs Helen recently lost her 67 years old father and that she is the fourth child by his third wife.
So, after I walked in and saw her, I decided to remain in the living room and eavesdrop on her conversation with my mum, perhaps, I will get the clue to unraveling the mystery behind her unusal happiness. She noticed I was still in the room as my mum was about to tell her the maximum discount she would give her, she interjected and changed the discussion to something entirely different.
"Mama Akin, I want to change my church. I hear your church is on John Martins street. Can you take me and my husband along on Sunday?"
"Really? But why?", asked my mum
Then she proceeded to narrate the story that changed my mind.
"You know the church at the end of this street, beside Mama Julie's house?" My mum nodded in the affirmative. "That's the church I go, and have been going since I moved into this neighbourhood eight months ago. The problem is, ever since the other church members found out that I sell notebooks, pens and other school materials, they have getting them from me, for their children, without honoring their promise to pay."
"Then stop selling to them on credit!", interjected, my mum.
"Exactly! That is what I have been doing for two months now. Well, as you know, schools just resumed a new academic term two weeks ago. This past Sunday, the Pastor called me aside after church service and told me that he wants me to supply the church 100 notebooks, 100 pens, 50 Mathematics textbook spanning all the primary school classes and 50 English textbooks spanning all the primary school classes. I asked him what the church needed Mathematics and English textbooks for, and he told me that it is to help the needy in the church. So, I summed the total cost and wrote it on a paper for him. He looked at it and said that I should go bring the books and pens today, and that he will pay me next Sunday. Imagine that!"
"So did you give him the books?"
"Me?! God forbid! I thanked him and promised to bring them in the evening. There and then, I made up my mind to never go back to that church. Mama Akin, you are lucky that your church is not on the same street as your house. Or by now, you will be bankrupt. Never sell on credit to your fellow church member!"
So that day on, I considered it a good thing that our church is far from our house and that our church members live too far off to consider buying anything from my mum. It was reinforced by the fact that Mrs Helen ended up reselling the clothes at more than double the price she got it from my mum and is yet to pay my mum for the clothes. Eventually, I found out the mystery of her sudden happiness, it was because of the huge gain she was going to make off the burial ceremony of her father. If only my mum had learned from her church story - never to sell on credit to your fellow (or aspiring) church member.

Next Part

Oh no! Not again!! I look through the window again and see nothing. Everywhere, outside the window and within the room I share with my siblings, is of thick embraceable darkness. Fortunately, I always keep a torch under my pillow, so, I pull it out and shift the control slider to the ON position. Then, I beam its light on the wall clock, it's two pointers indicate 01:37. A sick feeling creeps into my stomach, very much like the one I felt at nearly this same hour 7 months ago.
It was a Monday and rather than go to school in the morning, I was lying on my bed shivering and sweating at the same time. My mum was very worried and kept trying to feed me my breakfast which I involuntarily threw up. After a short argument, she finally prevailed on my dad to get Nurse Ijeoma, the owner of the drugstore two streets away. Twenty minutes later, my dad not only arrived with Nurse Ijeoma, but also with Mrs Alabi and Mary (her daughter and my self-proclaimed heartthrob). Nurse Ijeoma, despite Mary's sudden torrent of tears, looked at me with piercing indifference, like there was a TV screen between us and I was playing perfectly to some director's script. Then, she pulled my dad aside, spoke with him for some minutes, and left. 
Mary clinched her mum and continued sobbing aloud. My mum has now stopped trying to feed me my breakfast, and my dad is looking extremely worried - more from the fact that he would arrive work very late. Then after what seemed like an eternity of silence mingled with Mary's sobs, Nurse Ijeoma came in. She brought with her, two IV drip bags, some bottles of injections, four tourniquets, a funny-looking needle with wings and one very long tubing with adjustable clamp. She tied the two IV drip bags side by side at the top of the window beside my bed, fixed the long tubing to one of the bags, made a hole in that bag with a needle and syringe, left the needle in the bag, inserted the winged needle into a vein in my left arm and I felt a sharp pain shoot from my left arm through my entire body. She inserted the other end into the long tubing, shook 3 injection bottles one after the other, and injected their contents into the bag. Finally, she adjusted the clamp in the long tubing till the fluid in the bag was trickling slowly down the long tubing into my arm.
Then, she placed her right hand on my forehead and left it there for about 5 minutes. She faced my mum and told her to not worry as it was a mild case of malaria and that she'd be leaving. She showed my mum how to close the clamp and instructed her to close it when the bag is fully emptied, and she should send Mary (thinking she's my sister) to call her. I glanced at my dad and noticed him shifting uncomfortably in his chair, and when our eyes locked, he stood up, thanked the Nurse and followed her out of the house.
At about 2:00pm, the bag was done emptying its injection laden fluid into my body. My mum closed the clamp, woke Mary, who was now asleep beside me, and told her to go call Nurse Ijeoma. 10 minutes later she was back, panting, and said Nurse Ijeoma says she is very busy and will come later in the day, and that I should go have my shower, drink yogurts and read my schoolbooks. I only did two of her three suggestions.
At exactly 5:00pm she came, and connected the second bag, added Piriton and some other injections. Not too long after that, I slept. When I woke up, the first thing I noticed was this thick darkness everywhere, I put my right hand under my pillow and pulled out a torch. I beamed its light on the wall clock, it reads 2:05. I looked at the bag and it was empty, I closed the clamp. Then, suddenly, I felt a bitter taste in my mouth and a sick feeling in  my stomach. I tried to sleep again, but it wasn't until dawn that I succeeded.
I now feel that same sick feeling in my stomach, but instead of a bitter taste in my mouth, my mouth feels dry. It must have been that second bottle of Chelsea dry gin I took. I stand up, with the torch in my hand, and tiptoe to the kitchen. I pour myself a mixture of garri, sugar and water in a bowl. I, then, tiptoe to the living room to get the bottle of groundnuts dad brought home two days ago. I tiptoe back to the kitchen and finds a dome of wet sugar sitting comfortably on swollen garri. I hurriedly pour some groundnuts on top and sat on the kitchen floor with the bowl between my legs. I, then, spend the next couple of minutes swallowing the ill-mixed garri, sugar and groundnuts. Some parts have more sugar than garri and groundnuts combined, while others only have garri.
I carefully rinse the bowl and tiptoe to return the bottle, and finally tiptoe back to the room. My stomach is now bulging, and it does not take me long to fall sleep.

Next part

This is going to be a very long how-to post, so I'll ditch my usual long intro.

To install the Cyanogenmod custom ROM on the Samsung Galaxy S2, you'll go through three easy steps. Unfortunately, most blogs have managed to make it extremely hard to do - it's either they didn't put up any step-wise screenshots supported post or they write it out like a help/documentation file. So, I have decided to make the ultimate how-to guide and you can be sure you won't brick your phone.
Have you met Microsoft Excel?
I remember my first encounter with her 6 years ago, while in my 3rd year in the university. Our most geeky lecturer told us to make a GPA calculating sheet in Excel. That day, he moved up significantly in the disliked lists of most of us. In fact, I attributed my not-too-good grade in his course to that assignment. Then, I believed MS Excel is a specialist software like AutoCAD or Matlab, to be used by some industry and research geeks for some esoteric work. And that as long as I don't land a finance job, my world will be much better without MS Excel.

I was right. I didn't get to use Microsoft Excel until I landed a Business Analyst job doing some finance stuff day in day out (+ holidays and some weekends). And my corporate world has never been brighter. Monday to Friday are now my favourite days of the week, and holidays aren't really that special anymore. I now see myself as a magician, doing the seemingly impossible with data (of all sorts), saving the company money, making the company money and getting better at it. Now, I experience what career experts say - Find a job you love and work will be fun.

So, meet Microsoft Excel -


I prefer to split the entire MS Excel window into - menu bar, body and footer.

A close friend and colleague at work once asked me, "Michael, why are your blog posts more of - 'how I became...' and 'my...'?"

I have no premeditated reason for it. As I blogged more, I felt more comfortable expressing myself in my usual offline conversational tone. But, before you conclude that I must be narcissistic, kindly read the following disclaimer - whatever idea of me you come up with has got nothing to do with me.

So much for the preliminary, now to the main post - My journey to becoming Nigeria's first MS Excel MVP.

I hope you've read my post on How I became a Microsoft Excel Consultant
So, to rev up my reputation, I am working on making Microsoft award me the prestigious Excel Most Valuable Professional. And till anyone can prove otherwise, I'm gonna add Nigeria's first before the award title.

The most interesting part is I will be explaining the miracles of Microsoft Office Excel from the basics (what are rows and columns) to the most complex VBA I have written (over 1000 lines of code). And I am giving you the exclusive right to interrupt me and demand a post written specifically to solve any Excel issue you are facing. But you will need to be a little patient with me though, juggling work and going to work is already killing me. I might be very slow in granting your request, but I can assure you that I'll definitely grant it and even over-deliver on your expectations.


I've got to hit the sacks now, I need to wake up 4hours 10mins from now, or I'll get to work by mid-day.
Chapter 1, Part 1 here

The Beginning here

However, today hasn't been all bad. In fact, the drowning of our family albums has been the only sad occurrence today. And to be sincere, today has turned out to be a very good day. Fatai, one of the single-room tenants in the 40-room apartment adjacent to our house, won a lottery yesterday evening. And today, he is celebrating it. He has been playing Baba-Ijebu every evening for the past 8 months, since his bosom friend won N50,000. And yesterday was his own lucky day, after the evening prayers, he went straight to the lotto stand, and ended up picking the winning number that bagged him a whooping N250,000.
The noise from the 4 feet tall locally made speakers, 5 of them, is deafening. Since noon, there has been a big party, all the youths in the neighbourhood are sitted, standing and waltzing from end to end in the empty space that separates our house and Fatai's. I have been having a swell day too, for the first time in my life I not only tasted beer, I also drank an entire bottle of Star Lager beer and two 20cl bottles of Chelsea dry gin. And argued with some six other boys on who has drunk the most alcohol. Being the most scientific, I have been proving to them that a single 20cl bottle of dry gin has got more alcohol than a 60cl bottle of beer. But they were too vain and lousy to listen or understand. And not too long into the argument, I began to feel sleepy, my speech became slurred and I became very scared, and immediately staggered into the house and headed straight for the bed.
This wasn't the first time someone in the neighbourhood won a lottery. Four months ago, Jide, another single-room tenant living in the 26-room apartment opposite our house, won in a Coca-cola raffle draw. He won a Volkswagen Golf, but since he could not drive, he sold it to Emeka (his next door neighbour) and bought the biggest air conditioner I have ever seen. After installing the air conditioner, taking up the entire lower half of his window, he bought a very noisy generator to power the air conditioner on most nights. The generator was so noisy, three other tenants moved out of the apartment when they could not prevail on him to change the engine. If only they had been more tolerant, because just three days after the last of the three moved out, Jide decided to service the generator. And Yusuf, a co-tenant who works full-time as a generator repairer, is still servicing the generator, for six weeks now. Some people say that he has never serviced a generator that big, others say he is trying to get at Jide for not giving him the contract of purchasing the generator. And now, every night for the past 8 days, Jide has been threatening Yusuf. He screams every night at the top of his voice that he is going to get Yusuf arrested by the police and locked up forever if the generator is not restored to a working condition by month end.
Life in these multi-room apartments is a strange mix of comedy and tragedy. Just last week, Tunde married his next door co-tenant, Jumoke. And now, they have broken a portion of the wall separating their rooms, to install a door between the two rooms. Tunde's room is now the living room and Jumoke's room is the bedroom. It's the cheapest house upgrade I have ever seen, I just hope Jumoke won't mind continuing the rent payment for the room, considering that Tunde now sleeps there. Just yesterday, there was a mother of all fights in Fatai's apartment. Soji had just come back from a friend's birthday bash, and went straight to the shared toilet. God knows what he ate at the birthday party, but he used up an entire hour offloading his bowels, and locking out twenty people waiting to use the toilet. When he finally came out, there was a free-for-all fight, as all the twenty people tried to enter the toilet at the same time. It was so terrible, Tinu lost half a crate of empty Pepsi bottles, six people were stabbed with broken bottles, four had knife cuts and two were beaten senseless with blows. In the end, several of them had to go visit their friends in other apartments just so they could use their toilets. Every morning there is always a long queue in front of the toilet and bathroom, some tenants wake up as early as 3am just to beat the queue. But only Mallam Ali has successfully developed a winning scheme, he takes his daily bath only at nights.
But living in such an apartment has its unique advantages. There is always ample audience/participants for every event you do - from an in-house football competition to the burial of a grand-mother nine states away. And you are never short of a helping hand - be it people to help put out a fire at 2am or  to help with the cooking and event set-up at your wedding.
Though my parents are against me befriending the other children living in those apartments, I have managed to put them in the dark as regards my blooming friendship with most of them. Every late afternoon, when my parents are not yet back home, I shuffle between several of those apartments visiting my numerous friends. They excite me with the stories of the day-to-day happenings in the apartments and I help them do their school assignments. My closest friend is John, he lives in the apartment adjacent to ours. He moved in there with his mum, four months ago, after his father kicked them out of his 6 bedroom mansion without a divorce notice or severance pay. The father claimed he has found a new love and wants to start his married life afresh. John is the only boy in the neighbourhood that is as intelligent as me, and his spoken English is way better that mine. But I beat him hands-down when it comes to written English. In fact, he occasionally bribes me with some chewing gum he steals from his mother's store, to make me do his English essay assignments. But what I love the most about him is that he doesn't shout and curse like the other boys. The other boys are very vain, they have swapped out every greeting and common words with swear words.
Even though today's party is at John's apartment, he didn't join us in drinking beer and dry gins. And when we teased him and called him mummy's pet, he simply stayed silent and watched us. He is really the best behaved boy in the neighbourhood.

Next Part
It's amazing how I can't remember any of my primary school friends, and dumbfounding that the only people in the first decade of my life who have made it in my memory to my thirteenth birthday (two months ago) are - my parents, my two sisters, twelve relatives and three family friends.
We had moved from Ile-Ife to Lagos when I was just 8 years old, and it was more than a location change. The rapid behavioural adjustments I had to make, no doubt, precipitated this amnesia, and not until after two years in Lagos was I able to make a new friend.
But today, something terrible has happened and now I have truly lost a decade. It has consistently being raining at midnight for the past four days, and today's rain came around 1:00am . As expected, our two bedroom flat became a mini dam, taking in water from under the two exit doors at the peak of the rainfall and letting it out after the rainfall. But the unexpected happened too, today's in-house dam reached a new height and flooded the lowest drawer of a cabinet that houses the entire family photo albums. And all my childhood photos are now ruined, the faces I'm struggling to remember are all gone, perhaps, forever.
Our family albums have joined the ever expanding list of casualties claimed by this recurrent flood. The first was our beautiful cream color saxony carpet, just two months after we moved in from our rented three-bedroom apartment in the same suburb, barely a year ago. Initially, I blamed my dad for this, for building on a parcel of land right in the middle of a valley. Then my mum explained to me that this parcel of land wasn't actually the one my dad wanted, that this was sold to us at one and half the original price to pay off the financially strait owner and compensate us for the loss of the parcel we had earlier bought. The parcel my dad really wanted and earlier bought was snatched from him when a banker suddenly showed up and took us to court claiming he had bought that same parcel of land 8 months before it was sold to my dad by the same land agents. And so for the first time in my life, I learnt the hard lesson: If the desired is not available, the available becomes desirable.


Next Part

Very few people can give you a better first hand information on the terrible-ility of Lagos traffic.

I work a regular 8 - 5 job (gone are the days of 8 - 4 or 9 - 5), so I actually spend 8hrs (minus-ing the 1hr lunch break) on the job. But believe you me, I wake up 4am daily and get back home at 9pm (upwards). So I spend 17hours every weekday on an 8hr weekday job!
So where the f did the other 8hrs (taking back the 1 hr lunch break) go to?! Well, it went to rushing to beat the traffic and getting stuck in the traffic.

But thatz not what this post is about.
Rather, I want to show you how to made hours spent in traffic something to look forward to.

Have you watched Steve Jobs' 2005 Stanford University commencement address? If yes, then you'll remember his talk about connecting the dots backward. It can't be more true than in my life!


I have this black-hole sort of mind, that never stops absorbing everything around me (currently seeking satisfaction in books written centuries ago). So like Mr Jobs did say, "You can never connect your life's dots forward but only backward". I have stopped trying to streamline my learning/reading and stopped trying to connect my life's dots forward. Now I simply learn all that interests me and overfeed my ravenous mind.


The latest result, is that I have somehow morphed into a Microsoft Excel Consultant. 

And in this post I intend to connect the dots backward to show how this remarkable change occurred. 

You're probably like me, with a Blackberry phone and BIS subscription and have a separate Internet modem to surf the net on your computer.

Well, I'm going to show you how I surf the net via my MTN Fastlink and my Android phone without any extra charge, just by using my Airtel SIM with NGN1,400 BIS complete subscription plan. And I download heavy files and do all sorts online without any extra charge or buying a data plan. The NGN1,400 BIS complete gets you 1GB data bundle you can use on any device or internet modem of your choice. In fact, if it's exhausted before the 30days plan coverage period, no problem you don't need to wait out the expiration, just follow the how-to here and you can subscribe 12 times in a month (if want). But, if you don't want your BIS plan to auto renew, easy, just follow the how-to here.

And believe me it is crazy simple! And you'll nearly hit yourself for never trying it.


Just make sure you have configured Airtel internet settings on your MTN Fastlink modem. Then insert the Airtel SIM that is already subscribed to BIS plan.

Click connect on your MTN Fastlink software, and VOOM! You'll be surfing the net for free!

In fact, I am writing this blog post via it and have already downloaded 100MB earlier today without a single kobo charge!

I hope you've read my I need more money post, where I talked about how I live from payslip to payslip.

You see, I'm one of those guys who find it nearly impossible to have a savings. I only save to buy some fancy gadget, I find it extremely hard to stash away cash just for the sake of having a savings. I can barely do that for more than two months, 'cos every night my mind will keep coming up with auto-suggestions of what to do with the money.

What ruinous mind I've got!


So, how do I get the best out of my salary?

Well, everything with a bad side definitely has a good side too. Fortunately for me, my mind that makes it hard for me to have a savings also made it extremely easy for me to pursue a wholesome lifestyle, one that is devoid of (nearly) all bad habits I know. So, I end up spending money on just the real necessities of life and one luxury hobby (Swimming). The only time I spend money unwisely is when I have a savings.
At the onset of my working career I tried saving and ended up plunged into a vicious loop of living frugal in the middle of the month and extravagantly after pay-day and the beginning of the month. And believe me, I really tried to break out of the loop but it seemed beyond me to accomplish.

But with the help of my hard-working, though still ruinous mind, I found a great workaround. I found out that I love taking risks. My first swimming experience was in a big river; I put (nearly) an entire year scholarship grant into stocks (and happily lost all); spent my entire free cash after school on a DSLR camera right in the heat of my job search; went to Cotonou for a one-month French language immersion without having any contact there (and got robbed too)... And I'm mighty proud of taking those risks, without the tiniest feeling of remorse.


So back to the main question - how I get the best out of my salary?

I recently got a Samsung Galaxy S2, costing me more than my two months free cash, and though there is now a Samung Galaxy S3 yet S2 is still a very highly rated android smartphone. In fact, it was named the best smartphone at the Mobile World Congress this year 

I won't bore you with the details of all the great timeless features of the phone that makes it a kill. But I will be stunning you with the crisp screenshots that show you all my choice applications on the phone and my widget filled homescreens.

 HomeScreen 1



HomeScreen 2



HomeScreen 3



Have you noticed that we keep making the same mistakes, and content ourselves with finding new excuses?
Well, I have a friend* who while we were at the University was weekly misplacing his copy of the room key. Nearly every week we were either searching a restaurant, turning the next room upside down, mowing a lawn with our hands, upturning his shirts and trousers, aimless walking round the reading room or just thinking of where next to search. I remember a day, after managing not to misplace the key for two weeks, his mind couldn't adjust to this unusual event and made him believe he has misplaced a key that was safely tucked in his left pocket. That day, we went to every room and restaurant we had been to, we left no sand unseen along the paths we took. And when he heaved and put his hands in his pockets out of exhaustion, the key was found.

Life is like a game of monopoly, no one ever gets rich living on his paycheck alone. And for me, I have been barely surviving on my paycheck. The truth is that I have been living from paycheck to paycheck, so bad that whenever my pay is delayed by 2 or 3 days, I feel extremely pressurized and like I will need a loan to come to work the following week. Yeah, it's that bad, everyone in the office notices and they even try to assure me that delay is with the bank.

So, how have I been trying to fix this?
Whenever you search the web for "Best iPhone Apps", "Must have iPhone Apps" or "Most popular iPhone Apps", you'll definitely end up with sites telling you about apps you'll hardly find useful on a day-to-day basis.

So I have decided to put up the list of apps I have found most useful for me, apps I spent most of my iOS hours on. 
How we hold some few in high regard
All because of their family
The deeds of a long gone ancestor
Concerned more about the family line
Than the man's own line
Basing a man's worth on another's deeds
Bestowing nobility on a day old baby

Birth is so much like a lottery
You cannot choose your family
Nor your location and society
Your beliefs, religion and dreams
Your education, learning and hopes
Your fortune, health and dignity
Your opportunities, expectations and capabilities
Are so much determined by birth

Yet there are some brave hearts 
Who against numerous odds
Being ill fortuned from birth
Steered their own course in life
Overcoming lack of proper parents
Lack of formal education
Lack of societal support
Lack of the basest opportunities
Forging their survival in great heat
And still made a huge mark on earth

It is for people on that route
That we should reserve our high regard
People who can't readily dream of a future
Too embroiled in trying to see tomorrow
People who lack life's necessities
Yet good natured and industrious 
People who spend their first decades 
Trying to make up for their ill luck
In the grand lottery of birth 

As one of my friends often say - it is better to know what you don't need than to need what you don't know.
In the video above, I have shown an invaluable trick that teaches you a Microsoft Windows skill you will nearly hate yourself for when you need it and you can't seem to have a grasp on it.

It is simple (but consequentially great) - how to rename a file extension. Now you may say - that is pretty easy, just select the file and press F2. But I bet you, you'll grow older than Methuselah if you think that will work for all (in fact, most) files.

Ok, lets put this to a try! Open Notepad, type some considerable gibberish and save the file as gibber. Now try renaming the file as gibber.doc

Oh no! I just lost, or did I? If you double clicked  on the gibber.doc and Notepad came up, you only changed the file from gibber.txt to gibber.doc.txt
Right click on the file and select properties to see the hidden (non-changing) .txt file extension. And that is what I want you to change to .doc, such that whenever you open the gibber.doc file, Microsoft Word will come up.

If you are able to do that, thumbs up! Otherwise, go watch the video above.


Damn it! That download was at 98% and now I have to start all over, why did you close the laptop lid!!
What the F! Installing updates 1 of 98...!!

I can reel off more, but I don't wanna use more swear words. Sticking with the default Microsoft Windows settings can give you some easily avoidable headaches. And in the video above, I have taken pain to explain a couple of settings change I recommend you make.

However, you can ignore some you prefer at the default settings, like the Updates setting and Lock.