1. Getting the Most Out of Ranges

Other than performing data-entry chores, you probably spend most of your Excel life working with ranges in some way. Whether you’re copying, moving, formatting, naming, or filling them, ranges are a big part of Excel’s day-to-day operations. And why not? After all, working with a range of cells is a lot easier than working with each cell individually. For example, suppose that you want to know the average of a column of numbers running from B1 to B30. You could enter all 30 cells as arguments in the AVERAGE ...

Get Excel 2016 Formulas and Functions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.