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.

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...

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...

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...

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.