A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
The theme of today’s episode is about finding better ways to get the job done. And nothing helps take the Excel community towards this end better than sharing of Excel knowledge. To demonstrate this, Oz will be describing one of his own experiences from the early days.
Oz started the episode with Alex Powers’ (of IT’S NOT ABOUT THE CELL) Facebook comment about a blog post. He mentioned that experts in the Excel world spend a lot of time doing the wrong things. This helps share knowledge with others to enable them to do the right things. Hence, this sharing of knowledge helps shorten the learning curve tremendously for many Excel users.
Oz mentioned one of his own experiences from the start of his career.
He had two reports: one containing thousands of transactions for the month and the other had name and id data of customer service representatives. His job was to match the two reports to calculate the bonuses to be paid. He sorted, filtered, copied, pasted and manually highlight cells, but eventually the job got done.
Turns out, the report Oz was handed was not the latest extract. And that he’d have to do all this all over again. 2-3 hours of effort completely wasted.
But he had discovered VLOOKUP in time for the second iteration. Now doing the work all over again hardly took a few minutes. The lesson to take away from all this: always ask yourself if there is a better way to get things done. Stop doing things the wrong way!
An entertaining section on vlogging (or video blogging) awaits you at the end of the video. Enjoy!
If something is taking a lot of time, try to find out if there is a better, faster way to do it. You have all the knowledge Excel experts have shared freely to leverage.
Write your thoughts to us in the comments section below. And do not forget to share this video with your friends and colleagues.
And while you are at it… Check out all the great Excel videos on Oz’s Youtube channel. He’s on Fire.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.