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: Microsoft Excel, Tips for Windows Users
Format Painter in Excel Most people who know about Format Painter think of it in relation to Microsoft Word. They don’t realise that there is a Format Painter option in Microsoft Excel as well. Not only that, it exists whether you are using Excel on Windows or Mac. The video tutorial below shows you how […]
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, Office365
How to make a workbook a favourite Do you have a selection of Excel workbooks that you need to work with frequently? Do you spend time finding those workbooks you need to open and wishing there was an easier way? Help is at hand In Office 365 and in Office 2013 separately, you can pin […]
Read MoreCategory: IT Quick Tips, Microsoft Excel, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 You need to add a worksheet to your Excel Workbook. It might be for a different product category, or perhaps you need one worksheet per month? Here is how to insert Worksheets in Microsoft Excel 2010. To insert a worksheet using the icon. 1. Click on the New Worksheet icon […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel, Tips for Windows Users
How to Customise the Ribbon in Microsoft Excel 2013 In Excel 2013 you can customize the Ribbon itself. This means you can have a whole ribbon tab with your own icons and groups of icons, or you can just change one of the pre-set Ribbon tabs to suit. Customize the Ribbon Click File Click Options […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel, Tips for Windows Users
How to use the SUMIF Function in Microsoft Excel 2013 This function will add the value of cells that meet a certain criteria. For example, suppose we want to calculate the total salary cost of all females: Figure – Sumif adds up all the rows that meet your criteria If the range B2 to B7 […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
