Excel Community round-up - December 2019

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 2
Part 3
Part 4
Part 5
Part 6 (public)
Part 7
Part 8
Part 9
Part 10
Part 11 (public)
Part 12
Part 13
Part 14
Part 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.

Modern Excel

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.