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
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 TH-cam. Thanks again!
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.
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.
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
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 TH-cam.
Thanks again!
Thanks for the feedback, it's great to know what people find useful. Best of luck with the redesigned workbook!
👍
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.
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.