## Excel 2013 – Printing the Whole Worksheet

In this tutorial I explain how I solved a customer’s problem. She wanted to print the whole worksheet and Excel would only print part of it. The worksheet had a print area defined and she didn’t know how to remove it.

## How Much Can I Borrow? Let Goal Seek Work It Out

Here’s a typical scenario we all face…you need a loan. You have a fixed interest rate and a fixed number of repayments. You can afford to pay back \$200/month. So how much can you actually borrow? This video shows how Goal Seek will provide the...

## Count Rows in a Table Matching Criteria – Part2

This is the last part of a 4-part series about counting in Excel. In the previous tutorial, I explained how to count the number of rows in a Table that match a given criteria. However, I did it by adding an extra column into the Table. In this tutorial I show an...

## Count Rows in a Table Matching Criteria – Part1

This is the third part of a 4-part series about counting in Excel. This short tutorial demonstrates how to count the number of rows in a table that match a given criteria. The screenshot above is taken from an Excel file that contains a list of tutorials on this...

## How to Count the Number of Rows in a Table

This is the second part of a 4-part series about counting in Excel. This short tutorial demonstrates how to automate counting the number of rows in a Table.

## How to Count The Number of Items in a List

Using the COUNT and COUNTA functions, this short tutorial demonstrates how to count the number of items in a list in Excel