Paul Wherly

Did I make a profit on that?

Category: IT Training Blog, Microsoft Excel

Did I make a profit on that? In this week’s tip, I will show you how to find out if you made a profit. Simply put, you make a profit if the money you take in is more than the money you pay out. So the formula looks like this: Income – Expenses = Profit […]

Read More

Paul Wherly

Simple statistical functions

Category: IT Training Blog, Microsoft Excel

Simple statistical functions Excel provides access to a range of simple statistical functions from the AutoSum button drop-down list. The Sum function Excel is often used in a business process situation to keep a list of expenses, e.g. travel expenses, coffee, and meeting fees. A list has been created containing headings and then the relevant […]

Read More

Paul Wherly

Sort and Filter a list in Excel 2010

Category: Microsoft Excel

How to sort and filter your list  Last week we saw how to set up a list in Excel and I hope that you have set up your first list successfully.  Now that you have some data in the list, you may find that you need to do a few different things. Specifically you may […]

Read More

Paul Wherly

Create a List in Excel

Category: Microsoft Excel

How to set up a list in Excel Last week I introduced the idea of using a list in Excel to keep track of your meetings or phone calls with prospective new clients. So I thought that this week I would provide a step by step guide to setting up that list. I will document the […]

Read More

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.

More