Have you ever been frustrated staring at two lists trying to find the differences between them? Well if you have those lists in Excel it’s a simple job. If both lists are numbers you don’t even need to know any special functions, just subtract the number in one column from the number in the other […]

Have you ever wanted to add up only certain numbers within a list? Maybe it was sales over a certain dollar amount. Or you you have a list of payments and you want to know the total of all payments with a payment type of “Check”. If you only have one criteria for selecting the […]

A watch window lets you monitor cells from different parts of a spreadsheet all in one spot.

Last month I talked about how you can freeze rows or columns in an Excel workbook so that your headings stay visible on screen.  This month I’ll show you how you can choose rows or columns to appear on every page when you print. This lets you print a report heading and/or column/row headings on […]

Freeze Panes lets you keep row and columns headings visible as you scroll through a large spreadsheet.

Learn how to rank list entries in Excel without resorting your data.

See how to easily copy or move tab within or between workbooks.

Tired of looking up information on one spreadsheet just to manually enter it on another? You need to learn about VLOOKUP.

Excel’s Flash Fill is an amazing tool that combines elements of text-to-columns, concatenate, and find & replace. Not only is it powerful but it’s unbelievably simple to use.

Sometimes page breaks fall at inconvenient places in your spreadsheet. But you can do more than just adjust your margins. Excel allows you to insert and even move page breaks. I’ll show you two methods for controlling page breaks in your Excel workbooks. First we’ll cover the old-school method. It’s simple but effective. Just put […]