call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: IT Training Blog
2015 – How was it for you? Here at The IT Training Surgery it has been a busy old year. We have worked with a selection of fabulous clients and picked up some lovely new ones. What kind of things did we do? We worked with an event management company to empower staff to use […]
Read MoreCategory: 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: Tips for Windows Users
Create your own Ribbon – with your own groups and icons Why would you want to have your own Ribbon? Perhaps you notice that you are jumping all over the show between the Ribbon tabs and that you only use a few icons from each Ribbon. It would be handy to have your own customised […]
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 Word
Quick Styles in Word Quick Styles in Word were introduced in Microsoft Office 2007 and I have blogged about them before. Styles will help you to format your document very quickly whilst adhering to your company branding. If your company has stipulated a particular font for the body text and a set style for headings, […]
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 Training Blog, Tips for Windows Users
Sort in Excel If you need to Sort in Excel then this short video tutorial will show you exactly how to do so using one level of data. This video shows you how to Sort In Excel 2010 – the same instructions work with Excel 2007 and Excel 2013 and Excel 2016 as well. It […]
Read MoreCategory: IT Training Blog, Tips for Windows Users
How do you see those extra lines and spaces in your document? When you are editing a document, you sometimes find that there appear to be extra spaces and blank lines. However you cannot always see them when looking at the typed text. The Paragraph Marks tool shows you where the extra spaces and lines […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
