This is going to be a lifesaver for a lot of people. In this MVP post, I will show you how to copy any tabulated data from PDF documents to Excel and still retain the tabular form. And this works for scanned documents, ones you can't even copy the text in the PDF. So let's start! Below is a screenshot of an equivalent of a scanned document containing a company's financial data. As ...
Do you work with lots of data, track KPIs, make sales projections, make Excel based reports, do business data Analysis and make data-centric PowerPoint presentations? I have a training package customized just for you. It is for Excel power users who want to do the nearly impossible, become a demi-god at work and automate reports. If you're interested you can call me on 08089382423 or ...
There have been times I needed to transpose a table and through experience I have discovered two ways - the easy way, using copy paste special transpose, and the sure way, using formula. In this post I will show you both ways. As usual, I have generated a sample data. Shown below. Now let's transpose this tabl ...
Hi there! This is a very special how-to, you don't get to see this just anywhere. In fact, lots of people aren't aware that this feature exists in Excel. Yet it can make your spreadsheet life a lot easier. Just imagine you have a sales report to work on, having the sales persons in column A, the months in row 1 and the sales figure in the other cells. And then you discover that the months ...
Hello there! Welcome to my 12th post in the MVP series, and today I'm going to show you how to highlight duplicate entries in a Microsoft Excel table and delete the duplicates (leaving only unique entries). So, let's start. I have put together a sample table for this demonstration. You will notice that several companies are repeated. How about I show you how to highlight all ...
What's the use of a postpaid line if you still have to go queue at an Airtel customer service center just so you can pay your bill? Well, you can guess the answer. For the first 3 months of using my Airtel postpaid line, I was the biggest mumu in Lagos. I would take a bike in expensive VI to go queue at an Airtel customer service center to pay my Airtel postpaid bill. And on those days, I always end up spending the entire afternoon there. I won't forget one particular day, I got there and the crowd ...
I remember the first DSTV re-subscription payment I made. The first subscription had come with the initial installation and set-up. It would be 30 days the next day and my subscription was going to expire. Immediately it was 12noon, I rushed my lunch and took a motorbike from Adeola Odeku to Tiamiyu Salvage just to pay my DSTV subscription. And when I saw the crowd outside, and the one inside too, I told myself, "This is it, I had better call Sam and tell him to shutdown my PC when he's leaving. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
vtiger CRM is very easy to use and very robust. You can read my previous post on how amazing vtiger CRM is. However, in this post I'll be sharing with you the steps to deleting a vtiger user and transferring ownership of his resources to another user. So login to the vtiger CRM. You'll be taken straight to the Home page. Look to the upper right, to the symbol right next to your name, ...
Hi there! In this post I'll be sharing with you two amazing slides that reveal the secret behind Dropbox's success. I'll advise you get a note and a pen 'cos these are life lessons you are about to learn. Here we go! Dropbox Startup Lessons Learned from gueste94e4c Dropbox startup lessons learned 2011 from Eric Ries ...
Hi there! I've got some good news to share. I recently got several English Grammar books, I'm working on brightening my grammar. I'm finally biting the bullet and admitting that my grammar needs fixing. For about 2 years now, I always cringe at the thought of reading my previous posts especially the ones I wrote at the start of my blogging pseudo-career. The grammatical blunders I come ...
I'm sharing with you the presentation by the founder of LinkedIn, the world's biggest in its niche. This is the most inspiring presentation I have ever come across. Start-up of You, Visual Summary from Reid Hoffma ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
This is not a regular post, it's a life saver for anyone who encounters the same problem I encountered on my smf forum. I recently started a forum, www.nigerianelite.com a few months ago and installed all the mods I thought would be extremely useful ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Welcome to my Nigerian Stock Exchange series! To view the reports of companies listed on the Nigerian Stock Exchange and Investment analysis reports, click NSE series. ...
Hello there! In this Excel MVP post I will show you the cool use of conditional formatting to show instant data insight. So let's use a fictitious data. Company XYZ sells 4 products and have independent sales people working across the country. The company gives sales target to them and for the last evaluation period, a target of 700 sales per product was given. Below is the table ...
Hi. In this post I'll share with you the list (+ screenshots) of the websites I visit nearly daily. 1. Blogger Yeah, blogger, my blog's platform. I go there daily to view my yesterday's page views, make new posts and edit my blog layout. I recently created a new website, a forum hosted by siteground.com It cost me over 4 times the cost of running this blog (on Blogger) and since I use ...
There has been so much confusion regarding the data allowance on Etisalat BIS plans, some people claim it is unlimited, some say its 1GB and others, 3GB. Well, here is the truth and can be verified from Etisalat's official site. Nunmber 31. S/N TIME DATA ALLOWANCE 1 Daily 50MB 2 Weekly 500MB 3 Monthly 3GB So that's it. The cold ...
You want to prevent your Etisalat BIS from auto-renewing or you simply want to deactivate it? Here is what you have to do - dial *399*2# Voila! That's it. This is a straight to the point post. You might also want to check these too - Glo Nigeria Blackberry (BIS) plans,subscription codes and price Airtel Nigeria Blackberry (BIS) plans,subscription codes and price MTN Nigeria Blackberry ...
