call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: Microsoft Excel, Tips for Windows Users
Create a Column Chart in Excel At Coffee Island which is a chain of coffee shops we have a spreadsheet with weekly takings. In order to show stakeholders what this looks like in a chart format, I need to create a chart. In this short video tutorial you will learn how to create a columnar […]
Read MoreCategory: Excel Training, Microsoft Excel 2010, Tips for Windows Users
Find the Average Minimum or Maximum Excel When working we often have long lists of figures in a spreadsheet. If you have a list of shops that sold coffee you might want to find out which was the smallest sales figure in the list, or perhaps you want to find out what the average sales is […]
Read MoreCategory: IT Training Blog, Microsoft Excel, Tips for Windows Users
Autofill in Excel I think I have shared this before, but it is such an important and handy feature that it warrants repeating. Ultimately once you know how to use this, you will find that you wondered what you did before and it will save you oodles of time. Autofill in Excel helps you when […]
Read MoreCategory: IT Systems, Microsoft Excel
How to use Excel to improve your Management reporting Introduction One of most common uses for Excel is management reporting. So I thought I would spend some time explaining key features of Excel that can improve the way that this information can be generated. Inputs That old adage “Garbage In – Garbage out” especially holds […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel, Tips for Windows Users
How to use Paste Special in Microsoft Excel 2013 Microsoft Excel 2013 normally copies all the information in the range of cells you select when you paste the data. Use Excel’s Paste Special command to specify other options, such as pasting only the cell contents (without the formatting) or only the formatting (without the cell […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel
In this blog I show you how to the IF Statement in Microsoft Excel 2013 IF Function (IF Statement) An If function asks Excel to consider if something is true or false. If it is true it will return one answer, if it is false it will return a different answer. For example: Can my company afford to […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel
You know how sometimes you need to work with other people on a project of some sort. You have an Excel spreadsheet and perhaps you need someone else’s input or approval. There are a few ways to share the workbook with them and in this blog I will introduce you to three ways of how […]
Read MoreCategory: IT Quick Tips, Microsoft Excel
Count or Sum the entries if your criteria are met – Excel 2007,2010 and 2013 Here is a list of the CDs in a collection and their cost: =SumIF The SUMIF function adds up a list of figures based on the criteria that you set. In my example above I want to add up the […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
