SSSVEDA DAY 3 – Peek Inside My Excel Work Environment

There is always a set of problems we repeatedly run into as data analysts. We promise ourselves to fix them one day but that day never comes. Well, today might just be your lucky day. Oz is here to share with us some tips and tricks that has helped him smooth out his workflow.

Let’s get to them.

1 – Protecting Raw Data

It is very tempting to clean/modify the data right where it resides. But often we realize we need to roll back to the original data and start all over again. So, if you overwrote the only copy of the data you had, be prepared to look stupid in front of your colleagues or client.

It’s always better to keep the raw data in a separate sheet and never touch it. Color the tab red as a precaution.

2 – Night Mode

For the nocturnal analysts amongst us, there is a skin in Excel that can prove useful while working in dim lighting. Go to File > Options > General > Office Theme. Now select dark gray or black. Cool, right? Notice how the red colored raw data tab just pops out in these settings.

Now, what about the cells? Well, color them gray as well! If that seems like a hassle, especially when you’d want to revert to white later, try to explore settings of Home > Cell Styles > Normal. You’d find a good, easy solution there.

3 – Two Views

Go to View > New Window. Now you have two views of the same file, simple as that. It is very helpful especially when you have two screens. And since the two views are of the same file, all changes get updated in real-time in both views simultaneously.

4 –  Two Mice!

That’s right, the secret to Oz’s productivity is his ambidexterity with a computer mouse. Hence, he uses two. Left-hand, right-hand, crap data can’t win!

5 – Bigger View

Instead of zooming in and out, another way to increase view of your sheets is to hide the Ribbon. Just double-click on the name of the active tab and it will be hidden away. Double-click on it again to unhide it.

Note: the Ribbon is still functional and can be used while its hidden.

6 – Sample Data

We tend to use some tricks / techniques repeatedly. It is always a better idea to automate them end-to-end. In achieving this, a repository of rich datasets can be quite helpful. For example, a list of names or drinks of various sorts. You may use CHOOSE, RAND and RANDBETWEEN functions combined to sample from them.

These random datasets are also good to showcase products you’ve developed in Excel, such as a cool analytics tool, to persuade your potential clients into buying your services.

What’s next?

Let us know which of these tips you found helpful in the comments section below. And do not forget to share this page 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.

Jamani Arsalan


You may also like

April 9, 2011

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

October 26, 2014

Monte Carlo Simulation Formula in Excel – Tutorial and Download

September 17, 2012

The Excel Rollover Mini FAQ
  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Free 24 Excel Tips Guide

    Discover the secrets to Excel efficiency with our free guide: '24 Proven Microsoft Excel Tips to Help You Save Time'

    A humble gift from us to you, to make your Excel journey smoother and more productive. Grab your copy now and start mastering Excel like never before!