Jul 7, 2014
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.
Jun 9, 2014
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...
Apr 24, 2014
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...
Apr 14, 2014
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...
Mar 29, 2014
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.
Mar 24, 2014
Using the COUNT and COUNTA functions, this short tutorial demonstrates how to count the number of items in a list in Excel
