Here are December's Excel posts. Excel Community and IT Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".
The Excel Tip of the Week
266 - Keyboard shortcuts advent calendar (public)
A fun collection of keyboard shortcuts - designed to be revealed once each day over the Christmas period. Come see how it's all done with conditional formatting!
267 - Creating dynamic ranges
See how to make Excel named ranges that change in shape automatically as your data grows.
268 - Using quotation marks in formulas
Putting text into formulas can be a pain - see how it's done and why quotation marks are necessary with this Tip.
269 - Revisiting form controls
Form controls can make a dashboard or userform easier to use and more accurate. See how to make the most of them.
Excel Community Christmas quiz
Simon Hurst's series of festive quizzes challenge you to identify a literary work from an Excel clue - and teach you a little bit along the way. See how many you can get! Each one contains the solution to the previous:
Introduction (public)123456789101112131415Final solution / wrap-up
Part 43 - ALTernative Excel in an instance
Modeller Liam Bastick explains how opening a second instance of Excel works, and its advantages and disadvantages.
Part 44 - Aggregating aggravating time periods
A comprehensive look at how to model with unusual time periods.
Modern Excel - Error handling
David Benaim continues his series with a look at the options for handling errors added in recent versions of Excel.