I've been working with Excel for 30 YEARS. Here are my 10 steps for building great spreadsheets

Поділитися
Вставка
  • Опубліковано 22 гру 2024

КОМЕНТАРІ • 8

  • @upskilloffice
    @upskilloffice  Місяць тому +2

    European Spreadsheet Risks Interest Group:
    eusprig.org/about/about-eusprig/
    eusprig.org/research-info/horror-stories/
    The FAST Standard Organisation:
    www.fast-standard.org/the-fast-standard/
    ICAEW 20 principles for good spreadsheet practice (2024):
    www.icaew.com/technical/technology/excel-community/20-principles-for-good-spreadsheet-practice-2024-edition
    GOV.UK - creating and sharing spreadsheets:
    www.gov.uk/guidance/creating-and-sharing-spreadsheets
    Spreadsheet quality assurance - a literature review
    (2024 study stating 94% of spreadsheets have errors):
    link.springer.com/article/10.1007/s11704-023-2384-6

  • @stevenlagoe7808
    @stevenlagoe7808 Місяць тому +8

    Thank you for sharing these steps. They're invaluable!
    I'm completely self-taught in Excel, and I'm the only one in my company that is Excel literate. When I arrived, the admin was a complete mess, so off my own bat I designed a multi-user spreadsheet to handle record-keeping. At that time, I wasn't aware of some of the advanced functions of Excel, but I was very familiar with VBA, so I wrote all the analysis in code using my experience of SQL.
    The spreadsheet has proved a boon but that was two years ago, and it's now time for me to write a new one based on everything I've learned in the meantime: VBA only when it's absolutely necessary, tables rather than named ranges, formulae in easy to understand steps rather than ones that look like the first paragraph of a book - very slick, but an utter nightmare to debug, consistency across all sheets, and future-proofing every aspect.
    I've learnt so much from people like yourself and the other Excel professionals on UA-cam.
    Thanks again!

    • @upskilloffice
      @upskilloffice  Місяць тому

      Thanks for the feedback, it's great to know what people find useful. Best of luck with the redesigned workbook!

    • @mathijs9365
      @mathijs9365 24 дні тому

      Vba better than advance formulas

  • @entrustedhub
    @entrustedhub Місяць тому +1

    Informative ❤

  • @kebincui
    @kebincui Місяць тому +1

    👍

  • @user-fed-yum
    @user-fed-yum Місяць тому +2

    A great, fun, sophisticated tool until a mistake inadvertently creeps in. Friends don't let friends use Excel for anything that matters. Think of a spreadsheet as something you will throw away in a few days time, so you know it's not for anything important.

    • @upskilloffice
      @upskilloffice  Місяць тому +2

      Interesting point of view, but in the real world of business Excel gets used for 'things that matter' all the time. Doesn't mean it's right (and I touch on this in the video), but it's often out of necessity.