Contact me if you want to join, but you'll need to be patient as I already have a waiting list.

Class 1
Data in Excel and formatting
Basic formulas and functions
Keyboard Shortcuts

Class 2
Pivot Table and Chart
Sorting and Filtering (Basic & Advanced)
Deleting Duplicates

Class 3
Importing Text and other file types
Text to Column
Simple Charts

Class 4
Review

Class 5
Advanced Charting
Professional Reports
PowerPoint Presentation

Class 6
Conditional formatting
Dashboard
Advanced formulas and functions

Class 7
Excel VBA

Class 8
Review


My previous job required having a Postpaid Airtel line, it was compulsory.
At first, I thought it was ridiculous and that it would only make me spend more money on calls as I am no longer restricted to the value of my last recharge voucher.

Now in my second year of using a postpaid line, I can boldly say its benefits are enormous. I no longer hunt for recharge cards, I get a detailed record of my monthly calls and SMS, I get to pay anytime (nearly so) and extremely cheap call (and SMS) rates. But the best part is my calls don't get unexpectedly terminated.

In fact, my BIS runs on my postpaid line so it never expires. And with Airtel's unrestricted 1GB data bundle that comes with the NGN1,400 BB complete pack, I have permanently solved my data needs.

I hope I have been able to convince you and not confuse you that having a postpaid line is extremely cool, cooler than a prepaid line. Thank you!
Well just in case you still do not realize that I am typing this post on a Linux OS. Checkout the following screenshot.

Yes, I am typing out this post from my Ubuntu Linux OS, and I also have OpenSUSE, Windows 7 RC & Windows 8 RC (no $ to buy commercial version) all running on the same laptop, my venerable SONY VAIO.

So how did I learn to use Linux?

For me this is definitely good news.

Very soon, I will be able to enjoy the unparalleled chat experience of blackberry messenger on my Samsung Galaxy S2 and Apple iOS device.

Anyway, here is the full gist from Blackberry official blog -

"
If you’re already a fan of BlackBerry Messenger (BBM), we’ve got some exciting news designed to make it easier for you to connect with your entire mobile social network. BlackBerry plans to make BBM, our wildly popular mobile messaging service, available for the first time to iOS® and Android™ users this summer, (subject to approval by Google Play and the Apple App Store, as applicable). This means that, once available, you can welcome your friends and family using these other mobile platforms to connect over BBM and share in the Team BlackBerry love.
As we’ve chronicled on our Inside BlackBerry blog for some time now, BBM set the standard for mobile instant messaging with fast and reliable service and an added layer of engagement with delivered and read statuses. You’ve shared with us your stories about how BBM has kept you connected when it mattered most to you. Upon release of the multi-platform BBM service, you can broaden that real-time connection to friends and colleagues on other supported mobile platforms.
In the first version of multi-platform BBM, iOS and Android users are expected to be able to experience the following BBM features:
  • The immediacy of BBM chats
  • Multi-person chats
  • Voice note sharing
  • BlackBerry Groups, where BBM users are able to set up groups of up to 30 people and share calendar, photos, files and more
The team here at BlackBerry has definitely been working hard to bring the much-adored BBM experience to a wider group of mobile users. In a recent press release at BlackBerry Live 2013, Andrew Bocking, Executive Vice President, Software Product Management and Ecosystem, at BlackBerry had this to say:
“For BlackBerry, messaging and collaboration are inseparable from the mobile experience, and the time is definitely right for BBM to become a multi-platform mobile service. BBM has always been one of the most engaging services for BlackBerry customers, enabling them to easily connect while maintaining a valued level of personal privacy. We’re excited to offer iOS and Android users the possibility to join the BBM community.”

BBM Quick Facts:

  • More than 60 million monthly active users
  • More than 51 million daily active users who are connecting with friends or colleagues an average of one and a half hours every day.
  • BBM users send and receive more than 10 billion messages each day, nearly twice as many messages per user per day as compared to other mobile messaging apps
  • Almost half of BBM messages are read within 20 seconds of being received; indicating how truly engaged BBM customers are
Today, BlackBerry also announced BBM Channels, a new social engagement platform within BBM that will allow customers to connect with the businesses, brands, celebrities and groups they are passionate about. BlackBerry plans to add support for BBM Channels as well as voice and video chatting for iOS and Android later this year, subject to approval by the Apple App Store and Google Play. If approved by Apple and Google, the BBM app will be available as a free download in the Apple® App StoreSM and Google Play store. Additional details about system requirements and availability will be announced closer to the launch.
That’s some pretty big news, indeed. Be sure to share your thoughts with us in the comments below, who will be the first person from your extended network that you introduce to BBM?
"
I know Apple will not want to approve the app, but Google will be glad to.


After reading lots of books on Personal finance and Investment, I decided to put my vast knowledge to work. 

I currently work at a job I love but which leaves me with little money at month-end. I daily take a record of all my expenses; I know where every single kobo of my salary goes. I know exactly how much I spend in a month.

The following are the Personal Finance measures I implemented –

1.       Pay myself first

In 2011, I set up a direct debit order in my salary account to transfer a certain amount of money every month to a Mutual fund account.

Now I plan setting up two others to transfer some cash monthly to my Brokerage account and quarterly to my Fixed Income fund account.

2.       Have an Emergency fund

I currently have the cash equivalent of my three months living expenses stashed away in a High Yield savings account. I have lost my job once and resigned from another too. In both situations, I encountered numerous unplanned expenses and ended up spending a lot. Having an emergency fund can greatly help to tackle unforeseen emergencies. I never touch it unless there is an emergency, and I replenish it as soon as I can.

3.       NSD, LSD and HSD

Increase your No Spending Days, never reduce your Low Spending Days and reduce your High Spending Days in a month. I try to achieve this by staying home on most holidays to increase my NSD, cut-back on unnecessary daily expenses like chewing gums and in between meal snacks to increase my LSD, and I only buy necessities to reduce my HSD.

Recently, my Sony VAIO laptop motherboard went bad and I couldn’t find a replacement. Rather than buy a new laptop, I bought a similar but dead Sony VAIO laptop and replaced the bad parts with the ones in mine that fitted and bought the other parts that needed fixing. I ended up with another Sony VAIO that cost a fraction of the new one.

Anything I can do without for a month, doesn’t make it to my list. For instance, a new suit, an iPad, another wrist watch and movies.

4.       70 – 30 investment rule

Since, I’m investing for the long term (over 30 years horizon), I put 70% of my investment cash in stocks and 30% in Fixed Income and bonds. As a small investor, I rely on fixed income fund. But I follow the stock market like a true Chelsea FC fan follows his club, I know nearly all the important figures and trends. I research stocks, burrow through financial statements from 7 years back and make some crazy financial calculations. I manage my own brokerage account without any professional help, I buy stocks of companies I’m convinced (after my calculations) will grow at over 15% year-on-year and sell the ones I believe have derailed (regardless of their stock price movement).

Result: Though, at first, I lost money after money, I have recouped all my loses and have found an investment style that works great (so far).

5.       Delay my big expenses

I don’t plan buying a car anytime soon.

6.       Create multiple income streams

Though I make money from my investments, I run 3 monetized blogs and have a part-time consultancy biz. Currently, my blog is yet to generate a profit and my consultancy biz is still in its infancy, but I know that with time and efforts invested I will be able to cover my living expenses from their earnings.

7.       I’m my biggest asset

The premium on skills (hard and soft) is huge. That is why our parents make us start school as early as possible, knowing that one day someone will be willing to give us a fat pay slip just to have us around him.

Though I consider MSc and MBA luxuries, I have been reading several MBA course materials. I spend a lot on books, very expensive books too, on everything that interests me – swimming, business analysis, java programming, php and sql programming, MS Excel and VBA, French, Linux, Personal finance, Investment, Self development, Spanish, German, novels…

Last year, I took an online diploma course in Stress Management by a UK school. And this year, I have already enrolled for a Finance course, Data Analysis course and History course via Coursera. I just recently concluded my video classes on History of the world since 1300AD, and learned that there was a time when skilled workers were kidnapped. This reinforced my decision to become skilled in as many things as I can.

While at the university doing my degree in Electrical Electronics Engineering, I spent most of my library time reading books on Psychology. I discovered that the brain doesn’t function like a bag, in which you’ll have to push some things out to make space for new things. The brain simply doesn’t get filled, the more you use it the logically bigger and more intelligent it becomes. That was why Leonardo da Vinci could become an expert in nearly all the known human disciplines of his days. He used his brain. Since I discovered this, I stopped trying to focus on only just one field of knowledge.


Thanks for checking out my blog. Don't forget to subscribe and receive useful tips via e-mail.


French is the hardest thing I’m learning.
In September 2009, I embarked on the arduous journey of learning French language. I got a pocket sized French-English dictionary, then a very big French-English dictionary, then a complete secondary school textbook series on French and a handbook on conjugation. I started buying French novels and taking formal French classes. Out of frustration, I dug into my life savings and went for an immersion course in a French speaking country.
Now, I daily listen to French radio and music. Yet, I’m still very far from being fluent. In fact, I can barely carry on a French conversation beyond “Comment ca va?”
Have you tried learning a new language? Please share your experience, you might be helping a frustrated bloke.
Chapter 2, Part 1 here

The Beginning here

Today is Monday.

For me, school days are good days. The schools here are not the regular ones, and are referred to as Jelosimi. The primary schools have only 7 teachers, one to each class. Due to the extra resources Kindergarten classes require, most primary schools only run Nursery 1 – 2 and Primary 1 – 5. The curriculum is also not the regular one. The schools can’t afford a Music teacher and a French Language teacher, you get to learn only what the teacher assigned to your class teaches you. But as long as the teacher is not a Primary school dropout, you’ll get to learn everything in the Government approved textbooks for the subjects he takes you. Nevertheless, Primary school is fun. Every morning, we sing like it’s the end of the world.
Though, I am now in my third year in Secondary school (JSS 3), I still miss my Primary school days. How, together with the other students, we sing at the top of our voices the best songs in the world, annoying the quack doctor in the two room hospital beside the school building. I remember the day he threatened to get our headmistress arrested, the following day, we didn’t sing any song. Then it dawned on the headmistress that she, too, can get him arrested for being a quack. The next day, the hospital shook as the teachers joined us en masse in singing from the top of their voices.
In the Secondary school, we only sing the National anthem and the school anthem. The only time we sing loudly is when singing our own version of the school anthem, driving our Principal insane. But Secondary school is also fun. We’ve got a teacher for each subject. We get our fun from making fun of the teachers, doing crazy hairstyles/haircuts and having crushes. For me, only making fun of the teachers has been fun. My mum won’t let me do any crazy haircut and I always end up having a crush on the wrong girl. My best days at school are the exam days. I play the hardest then, I always make it to every team, football or basketball, as players are scarce then. I don’t study hard and still come out top of the class. And I get to sit beside any girl I want during exams.
Today is not an exam day. We are just past the middle of the school term. But today, I have made up my mind to sing that new Celine Dion song to Lola. I have already memorized the song for about a week now, it’s having to sit facing her, holding her hands tightly and looking her into her eyes while singing the song that has been my insurmountable mountain. I find it hard to look into any girl’s eyes, especially the ones I find very attractive. Even Mary, my self-proclaimed girlfriend, I hardly look her in the eyes. But some boys find this very easy, easier than looking at the pages of their school books. And Tunde is a genius at this. He does it perfectly well and nearly every week too, until he had sung to every girl besides big Bose. Now he waits till a new girl joins our class.
Unfortunately, Lola didn’t come to school today. At first, I was very sad but as the day progressed I felt relieved. Maybe, she isn’t the right person for me. I’ll teach Sadiq the song, he’s own mountain is having to sing an English love song. His head is saturated with Fuji, Apala and Alujo, none of which is in English.

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.