Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells. They are simple functions that go by the names of MIN() and MAX(). This lesson shows you how to use them. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides.
Learn Clever Excel Tricks
Anyone can learn the basics of Excel and get the job done, but if you really want to power ahead, try some of these clever Excel tricks. If you use Excel a lot, just one of these lessons could end up taking hours off your week, leaving you with more time to get other stuff done.
1 comment
Excel offers a couple of handy functions that you can use to calculate the smallest and largest values in a range of cells. They are simple functions that go by the names of MIN() and MAX(). This lesson shows you how to use them. It also introduces SMALL() and LARGE(), functions which duplicate what MIN and MAX do, plus more besides.
1 comment
The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the value of sales of a specific product by a given sales person (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.
47 comments
Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Here's a quick technique for selecting a range of cells in Excel.
1 comment
The SUMIFS function in Excel allows you to sum the values in a range of cells that meet multiple conditions, or criteria. For example, you might use the SUMIFS function in a sales spreadsheet to to add up the value of sales of a specific product by a given sales person (e.g. the value of all sales of a microwave oven made by John). This lesson explains how to use SUMIFS.
47 comments
One of the last keyboard shortcuts I mastered in Excel was moving between worksheets. Fortunately it's easy, and you don't need to wait as long as I did.
When printing in Excel 2010 for Windows, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page.
12 comments
Entering the same formula or value into multiple cells can be time consuming and boring. Most people, if they want to enter the same formula into a row or column of data, will enter the formula in the first cell, then copy and paste it into the rest of the cells where they need the formula. This lesson shows you an even faster way to do it.
5 comments
When printing in Excel 2010 for Windows, it is sometimes useful to print a set of rows (e.g. column headings) on each page in the print out. There is nothing worse than having a printout that runs to multiple pages, with the column headings only printed on the first page. This lesson shows you how to get header rows printing at the top of every page.
12 comments
If you have a range of cells, of which some contain values and some are blank, and you want to select just the blank cells, there is a quick way to select those blank cells that doesn't involve manually clicking on every one.
1 comment
Pages |
