Excel Community round-up - December 2018

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)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Final solution / wrap-up

Modelling 101

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.

Other blog

Modern Excel - Error handling

David Benaim continues his series with a look at the options for handling errors added in recent versions of Excel.

Anonymous