Excel and the Art of Confusion

1 min to read
Excel and the Art of Confusion

In this guest blog, we're proud to welcome Mike Holtzer. Mike is a highly talented executive, with over 25 years of Executive Management experience in the retail industry spanning over three continents: Australia, North America and Europe.

If you want to find the most over-complicated area of your business, find the largest spreadsheets and the department that creates them. Departments that run off of huge spreadsheets create a black box of mystery and job security.

If you have ever created big spreadsheets you understand that everyone creates them differently. The logic makes sense to the creator, but may not make sense to anyone else. When the person that created the spreadsheet leaves it gets handed over to someone else and much of the knowledge of how it works goes with the person leaving.

excel-and-confusion-540x300Further to this, it is very easy to make a mistake in excel (a bad equation, an accidental hard code, a broken link, a circular error) and it is very hard to find the error. Even the original creator can have difficulty in finding an error. And yet we make major business decisions using these spreadsheets.

Where does the data come from? Is it keyed in (which is riddled with potential errors)? Does it pull from one of the systems? Do you understand what it is downloading and how it is mapped?

In addition, there is hidden logic in a large spreadsheet. How is stock turn actually calculated? What is included in profit margin? It often makes it very difficult to truly understand what you are looking at and the decisions that are derived from it.

Beware of departments that are heavily reliant in excel. There is a place for excel, which is an extremely useful tool; however as much as possible should be done within the proper IT systems. If your systems can’t do it, you should look at upgrading or replacing them.

To see how you could analyze your data with incredible flexibility, speed and accuracy that everyone can use, watch this short video about data discovery.

Watch Demo

FEATURED EBOOK

Top 7 KPIs and metrics for mid-market executives

Phocas_Executive-KPIs-eBook-cover
Phocas Software

Download eBook

Fill out the form below to download the eBook.

Written by Mike Holtzer

Highly talented Executive, with over 25 years of Executive Management experience in public and private companies spanning over three continents: Australia, North America and Europe. His proven leadership and operational management skills have assisted multiple wholesalers and retailers around the globe. His no-nonsense approach gets things accomplished quickly and efficiently. With his experience and pragmatic approach, Mike is able to identify the source of an issue and develop clear and concise solutions. Whether it is simplifying processes, building for the future or getting things back on track, Mike understand the tools needed and the levers to pull.

Browse by category
Key data in one easy to understand view
Get a demo

Find out how our platform gives you the visibility you need to get more done.

Get your demo today
Phocas Software

Let’s talk

Are you interested in becoming a Phocas partner?

Phocas Software

Contact us

Fill in the form below, and we will get back to you as soon as possible.

Phocas Software