MicroNugget: How to Save Time in Microsoft Excel

In this video, Chris Ward covers two quick tips to save time and become more efficient when using Microsoft Excel 2013. Although Excel is an incredibly powerful program, one of the most common questions people ask is how to make it quicker and easier to use. Two foundational shortcuts include naming cells and copying formulas.

Chris begins by diving into cell references. On simple spreadsheets, you can just use the alphanumeric cross-section. On larger, complicated sheets, however, it’s much easier to name the cells. This makes formulas easier to understand and maintain, and you can even define names for cell ranges, functions, constants, or entire tables.

The second tip Chris talks about is how to copy formulas so you don’t have to type them in each time. Manual typing is not only inconvenient, but it also drastically increases the probability that you’ll introduce errors. He’ll walk you through the simple steps you need to execute so you can take advantage of this robust function.

Start learning with CBT Nuggets: