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

[@upskilloffice]

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]

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 KZbin. Thanks again!

[@upskilloffice]

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

[@mathijs9365]

Vba better than advance formulas

[@entrustedhub]

Informative ❤

[@kebincui]

👍

[@user-fed-yum]

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]

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.