The ICAEW Blogs & Forums will no longer be updated with new posts. Your community announcements and articles will now be hosted on icaew.com under their respective community areas. This site and its contents will be closed and made available in an archive at the end of October.
Happy new year!
Here is all of December 2019's new Excel content. Excel Community and Tech Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".
Christmas special - the spreadsheet gift that keeps on giving
Simon Hurst brought us a multi-part series that covered a wide variety of introductory tips for anyone wishing to get started with the potent Power Query feature:
Part 1 (public)Part 2Part 3Part 4Part 5Part 6 (public)Part 7Part 8Part 9Part 10Part 11 (public)Part 12Part 13Part 14Part 15
Excel Tip of the Week
318 - Power Query: Unpivoting (public)
Continuing with the Power Query theme, the TOTW explores how to simplify data layouts by "unpivoting" - combining multiple columns back into one.
319 - Revisiting selecting a scenario
Need to pick between different possible scenario inputs? Or even compare sensitivity to a variety of different trial inputs? The TOTW runs through several of the leading options.
320 - Revisiting OFFSET
OFFSET can be used to create a dynamic cell address or cell range, ready for plugging into a formula - but it has its hazards.
321 - Setting an Excel New Year's Resolution
Start your Excel New Year right - whatever your current level.
322 - Quartiles and percentiles
As well as being two fundamental statistical functions, PERCENTILE can also emulate the functionality of a handful of other Excel formulas.
Infographics & Slicers for interactive dashboards
Make your charts, Pivots, and more easy to analyse and drill down on with Slicers, or add more a modern look to your presentation with infographics.
Top 10 new Excel features in the 2010s
David Benaim runs down his list of the top additions to Excel in the past decade.
Excel Tips for Accountants
Exporting data from accounting systems
Tom Edmunds takes a look at dealing with accounting system data in Excel in a clear and reliable way.