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