Business intelligence blog

    Excel and the Art of Confusion


    In this guest blog, we're proud to welcome Mike Holtzer of www.mikeholtzer.com. 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.

    excel formulas can be tricky

    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

    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.
    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.
    Phocas_Executive-KPIs-eBook-cover
    FEATURED EBOOK

    Top 7 KPIs and metrics for mid-market executives

    Download eBook

    Leave a reply

    Your email address will not be published. Required fields are marked *

    Related posts

    Phocas is the GetApp category leader in business...
    2 MIN

     

    GetApp is an independent online platform that people use to review, evaluate, and compare business software. Get...

    How to ensure you have proactive data analytics
    2 MIN

    Business people often approach data from a reactive stance, in other words, make decisions and then turn to data and...

    Inside sales versus outside sales: How BI helps...
    3 MIN

    Business sales teams vary in how they leverage inside sales versus outside sales. Whether these teams work...

    Subscribe to our blog

    Sign up to get the latest news and insights from Phocas experts