A great place to start when refining your Excel processes is our 20 principles for good spreadsheet practice thought leadership. From strategy and planning to designing and building your spreadsheets, as well as managing them when they’re in place, this guidance contains a definitive list of spreadsheet considerations.
The document was produced by the ICAEW Excel Community, which is free to join and offers a plethora of resources to help you develop your skills and stay up to date on the latest Excel developments.
Stuck on something in particular? Community members have access to resources and advice on everything from charts and graphs to data tables, filtering, PivotTables, macros and more. Plus, you’ll receive the latest tips and tricks and gain access to the full Tips & Tricks index.
For detailed reports on how to review a spreadsheet and improve your financial modelling practice, take a look at the Excel Thought Leadership area.
Webinars and events
The community has a vibrant schedule of free events for members, including on demand webinars: A beginner’s guide to automating in Excel using Office Scripts and financial modelling best practices. Plus, the new lunch and learn series of 30-minute visualisation webinars offers new ways to present raw data. Book your place to join in.
You can listen again to our entire webinar back catalogue here. Don’t know where to start? Why not try our four most popular recent webinars:
- Why power query can change your life
- Build dynamic dashboards with Power Pivot
- Excel tips and tricks live
- Harness the potential of power BI
Popular Excel articles
- How to get the most out of one of Excel’s newest functions: checkboxes.
- How useful would some of Excel’s features be if you could employ them in real life?
- What is the most important Excel concept nobody ever told you about? Find out here.
- Looking for help with designing and formatting your spreadsheet? Take a look at our top 10 tips.
- Find out how Excel’s new functions are set to change data analysis forever.
You can read the latest articles here.