call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: IT Quick Tips
Sometimes you have a workbook with many worksheets that feed into a summary sheet. It would be useful to see both the summary sheet and one of the other worksheets at the same time. Excel 2007 Excel 2010 and Excel 2013 make this a very simple exercise. 1. With the workbook open on the screen […]
Read MoreCategory: 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 MoreCategory: 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 MoreCategory: 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 MoreCategory: IT Training Blog, Microsoft Excel
Yes you can! In last week’s blog post I asked if you knew what your business process was and hopefully it gave you something to think about. I promised to discuss some of the topics I raised and so I thought I would start with Excel. I use Excel for many things not least to […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
