SSSVEDA DAY 4 – Sharing the Excel Knowledge

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.

Let’s get to it.

1 – Doing the Wrong Things for the Greater Good

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.

2 – His Own Experience

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!

3 – Bonus

An entertaining section on vlogging (or video blogging) awaits you at the end of the video. Enjoy!

What’s next?

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.


You may also like

December 20, 2013

100+ Best Excel Resources And Websites

August 6, 2019

How to Create a Relative File Path in Power Query

April 9, 2011

How to Create a Rollover Effect in Excel: Execute a Macro When Your Mouse is over a Cell

September 17, 2012

The Excel Rollover Mini FAQ

February 17, 2014

It’s time to say “Goodbye,” to Hungarian Notation
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.