Categories: Business

10 Excel Tips

Had a sick day…now unable to sleep after sleeping too much.  At least I don’t feel too sick anymore.  So I decided to try and get rid of some of my 38 open tabs in Chrome on my laptop (my phone has 100+, so that will take a while).  While cleaning up I came across a really good collection of tips for using Excel (in Dutch).  Dutch isn’t a language for you?  You know what Google translate is, right?

https://financieel-management.nl/artikel/10-excel-wetten-dashboard-maken-excel

Wish I had read these before starting my internship, especially the tip about standardizing your excel model’s structure.  I had already begun to recognize the need of this myself and was trying something like:

  1. Data Input (raw/manual data)
  2. Data Transform
  3. Analyze

But I think in a lot of situations the suggested standardized tabs make more sense:

  1. Input (raw/manual data)
  2. Calculate
  3. Variables
  4. Output (Analyze)

Thought:  Why is stuff like this often not being taught in Universities/College?  As businesses become increasingly data-driven (unless they are interested in becoming bankrupt), there should be way more focus on professional use of Excel.  It is easiest to understand for average users and can be learned most quickly (vs. SQL and other non-GUI oriented solutions).

Some music:

Eric

Recent Posts

For those who like details

My work mainly focused on generation of KPIs or on business process improvement. Creation and…

3 years ago

BLS US Employment by Industry

https://public.tableau.com/profile/eric.a.stalee#!/vizhome/BLSUSEmploymentbyIndustry/Dashboard1 The Index of Employees by Industry shows an Industry's relative growth in employees since…

4 years ago

Why I consider advertising to be one of the more evil aspects of Marketing.

https://www.theregister.co.uk/2019/01/30/azure_sql_delete/

5 years ago

Ring Around the Debt

http://www.reuters.com/article/us-eurozone-future-idUSKBN18Q23I One idea in the paper that did not involve any mutualization of debt was…

7 years ago

Doomed?

https://www.youtube.com/watch?v=pbeuHRdZWlc "I have, therefore, chosen this time and place to discuss a topic on which…

7 years ago

The goal of ‘Islamic’ terrorism and the danger in failing to understand it.

I think many people have the idea that violence committed by extremists of Islam (i.e., less…

7 years ago