by admin | Jan 17, 2013 | Excel Path - Step by Step
In part one of this series, I looked at list preparation and in part two, I suggested that you convert your list to a table. Assuming you have done that, in this part we are going to look at constructing our first pivot table. In the video below I will show you how to...
by admin | Jan 16, 2013 | Excel Path - Step by Step
This is part two of my introduction to pivot tables. You can have a look at part one here. A new feature in Excel 2007 is called the table. While it is not essential to convert your list to a table, doing so means that you can then work more efficiently with your data...
by admin | Jan 8, 2013 | Excel Path - Step by Step
This is the first in a series of blog posts about pivot tables in Excel. A pivot table is a tool in Excel which allows you to move around your data so you can see it under different headings e.g it can take a list of sales and allow you to show you sales by country,...
by admin | Nov 1, 2012 | Excel Path - Step by Step
There is a number of ways to password protect your Excel file – you can protect part of it or restrict what people can do with the data e.g. they can view it but not change it. And I will cover that in another blog post later…but here’s how you...
by admin | Oct 23, 2012 | Excel Path - Step by Step
In today’s tutorial we are going to look at how to use the PMT function in Excel to calculate mortgage repayments. In another post, I’m going to show you how to use the PMT function with another Excel feature (called Data Tables) to very quickly generate a...
by admin | Sep 19, 2012 | Excel Path - Step by Step
So first of all what does this mean and why would you bother? Let me give you two examples =sum(a1:a10) or =sum(salaries) Which do you think looks easier to read and understand? Yes, the second one. So a very useful way to help document and clarify your spreadsheet is...
