Leap Forth

  • About
  • Business Intelligence
  • Accounting
  • Consulting
  • Learning
  • Contact
  • About
  • Business Intelligence
  • Accounting
  • Consulting
  • Learning
  • Contact

Feed the mind

Excel is the most dangerous software in the planet?

28/2/2013

0 Comments

 
"... So that’s one sense in which Excel could be dangerous: that we’ve tens of thousands, hundreds of thousands, of financiers and bankers throwing trillions of dollars around the markets on the basis of their incomplete spreadsheets and their ignorance of how they’re doing it wrong. Pretty scary really".  This was reported in Forbes.com here.

Yes, Microsoft Excel is indeed a very dangerous software - if not used probably.  In the hand of untrained Excel users, it will lead to costly errors that will lead to errors in decision.  Some of the common errors include using the wrong formula, did not update the spreadsheets, did not add up a column or row etc etc.  It may sound like silly mistakes but these are indeed common and costly errors.

Even if it does not lead to error in decision making, untrained Excel users wasted hours in spreadsheet design.  They treat Excel as a manual books with columns using rudimentary formulas, have multiple sheets and cross linked all these sheets, treat dates are words instead of numbers etc etc.  These actions can go on for years without realizing it.  To make it worse, the company employs more staffs to update the spreadsheets - which could have been fully automated in the first place.

Are you or your staffs using Excel? If yes, you need to be aware of how dangerous Excel is.  Here are some of the symptoms that you or your staffs are using Excel dangerously:

1. Spending too much time on spreadsheets (e.g. copy / paste, repetitive formulas etc)
2. Have to enter the same data more than once (usually in multiple sheets or files)
3. Using calculator to double check the spreadsheets (really, it happens)
4. Did not use pivot table (using pivot table is efficient as it does not involve formula)

What is the best way to avoid this dangerous software? The best is to avoid using Excel, if possible.  If your requirements are complex, it is best to invest in a rigorously tested customised software or suitable ERP system (which links your point of sale, inventory, accounting, reports etc).  

If you must use Excel (which is understandable), then make sure that you or your staffs are adequately trained.  In other words, do not just let anymore in your company (especially fresh graduates whom you do not know what to do with them) to design spreadsheets.  Train your staffs or get professional help.

Picture
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    About

    Business, economy, education and current issues.  Providing tips, tricks and tools in managing business.


    Archives

    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    July 2015
    June 2015
    May 2015
    April 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    March 2014
    February 2014
    January 2014
    December 2013
    November 2013
    October 2013
    September 2013
    August 2013
    July 2013
    June 2013
    May 2013
    April 2013
    March 2013
    February 2013
    January 2013
    December 2012
    November 2012
    October 2012
    September 2012
    August 2012
    July 2012
    June 2012
    May 2012


    Tags

    All
    Accountant
    Accounting
    Active Listening
    Aeon
    Alibaba
    Allen Stanford
    Amy Cuddy
    Animation
    Articial Intelligence
    Bernanke
    BI
    Brain Rules
    Brene Brown
    Budget 2022
    Business
    Business Intelligence
    Business Model
    Cash Flow Management
    Ceo
    Change
    Cloud
    Coca-cola
    Collapse
    Covid-19
    Creativity
    Culture
    Daniel Zhang
    Dashboard
    Data Science
    Data Studio
    Digital
    Digital Free Trade Zone
    Disruption
    Dr Eric Berg
    Dr Oz
    Dr Richard Teo
    Economy
    Edmondson
    Edward De Bono
    Ego
    Eric Schmidt
    ESG
    Excel
    Exercise
    Failure
    Farmland
    Finance
    First Article
    Fraud
    Free
    Fund
    Garr Reynolds
    Gaur Gopal Das
    George Carlin
    Global Crisis
    Google
    Google Docs
    Growth
    GST Malaysia
    Harvard
    Harvard Business Review
    Health
    Hubdoc
    Inflation
    Innovation
    Inspiring
    Insurance
    Investment
    Ipo
    Jack Ma
    Jack Welch
    Jim Rogers
    John Kotter
    John Medina
    Kai Fu Lee
    Ken Segall
    Kicc
    Kiss
    KPI
    Leadership
    Liquidation
    M&A
    Machine Learning
    Management
    Managing Cash
    Maradona
    Marketing
    Mastermind
    Maxton
    McKinsey
    Meeting
    Meryl Streep
    Milton Friedman
    Mit
    Mohamed El-Erian
    Motivation
    Napolean Hil
    Negotiation
    Obesity
    Online Education
    Paperless
    Partners
    Peter Drucker
    Pimco
    Pivottable
    Planning
    Play
    Power BI
    Powerpoint
    Presentation Zen
    Princeton
    Procter & Gamble
    Productivity
    Property
    Recovery
    Responsibility
    Rest
    Restructuring
    Retirement Planning
    Reverse Mortgage
    Robinson
    Roubini
    Salary
    Seth Godin
    Simon Sinek
    Simplicity
    Sir Ken Robinson
    Sleep
    Smoking
    Startup
    Stephen Chow
    Steve Jobs
    Strategy
    Stress
    Sugata
    Tan Le
    Tax
    Team Work
    Technology
    Thomas Cook
    Tony Fernandes
    Toys R Us
    University Of Toronto
    Valuation
    Vietnam
    Vistage
    Warren Buffet
    Wealth
    Welcome
    WeWork
    Xero


Powered by Create your own unique website with customizable templates.