One way to display figures in an Excel table according to certain time periods is by using filter buttons. However, a better way to do this is to use a timeline, a dynamic filter option that allows you to quickly display data from individual days, months, quarters, or years.

Microsoft Word's AutoCorrect tool saves you a lot of time by correcting common typos and spelling errors, like turning "acheiving" into "achieving". Handily, it also turns shorthand keys into symbols, like converting (c) into ©. Alongside the default options, you can also add your own entries.

Over the years, I've collected a large bundle of items that accompany me every time I head out stargazing. Starting with astronomy-specific tools and finishing with items that will keep you comfortable, here's a checklist of essentials that will help you optimize your stellar experience.

Excel's AVERAGEIF and AVERAGEIF functions let you find the average of a set of data. However, where they differ from the more straightforward AVERAGE function is in their ability to include or discount certain values within the calculation.