The SUM function in Excel provides a quick and convenient way to calculate a total for a row or column of numbers. Users do this so frequently that Microsoft has… read more →
Excel Autosave periodically saves changes to your spreadsheet so you don’t lose all of your work if your computer crashes or you close an Excel file without saving changes. This… read more →
Excel Autofill provides users with a quick way to copy data, duplicate formatting, or create a fill series for a range of cells. To use Autofill, a user would position… read more →
Sparklines are tiny charts displayed inside individual cells in your spreadsheet. Introduced in Excel 2010, they provide a convenient way to quickly compare data sets and analyze trends. If you’re… read more →
The Excel IF function lets you incorporate “decision making” into your spreadsheets. Think about a restaurant offering take-out food. They would likely add a charge for any order being delivered… read more →
Most of us use Excel at work. It’s a powerful application that lets you track and manage all kinds of data. One of the main things we do in Excel… read more →
The concept of absolute cell references comes up in several of our Excel courses. Initially, people may find the concept a little hard to understand but, in many cases, absolute… read more →
VLOOKUP is one of the most powerful and useful functions in Excel and, if you understand how it works, it’s easy to use… but don’t tell anyone. Let your coworkers… read more →
Microsoft Excel is an amazing program. It can be used to track and manage all kinds of information including text, numbers, and dates - but, if you’re like most people… read more →
Excel is a powerful program. While its interface has evolved and gone through many changes over the years, there have always been two ways to work in Excel. You can… read more →