Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
Replicating your spreadsheet layout…surely there must be a quick way?
Replicating your spreadsheet layout...surely there must be a quick way? This week's hint and tip is about replicating your spreadsheet layout in Excel. These are topics mentioned on both our Basic and Intermediate Excel courses and are firm favourites with attendees....
Borders and Fill Colour, do you use them in your spreadsheets?
Using Borders and Fill Colour in your spreadsheets to make them stand out This week's hint and tip is about using borders and fill colour in your spreadsheets. This is a section in our Basic Excel course and both can be used effectively to make your spreadsheets stand...
Text manipulation in Excel, how to do it in your spreadsheets
Text manipulation in Excel, how to do it and how it can save you time working in your spreadsheets! This week's hint and tip is on Text Manipulation in Excel. This is a section which is covered in our Advanced Excel course. On this course we look at other features...
Formula Auditing in Excel: Two ways in which you can use it
Formula Auditing in Excel: two ways in which you can use it for checking formulas in your worksheets This week's hint and tip is on Formula Auditing in Excel. This section is covered briefly in our Intermediate Excel course. It isn't covered in a lot of detail as it...
Publisher Basics Pictures – inserting a picture, learn how here
Publisher Basics Pictures – inserting a picture, do you know the steps to do it? This week’s hint and tip follows the series that we have been doing on basics in the Microsoft Office packages. This week is looking at inserting pictures in Publisher. Inserting a...
IF Statement in Excel – do you know how to create one?
IF Statement in Excel - do you know how to create one? Watch our video hint and tip to learn how This week's hint and tip is about looking at the IF Statement. Some of you might have heard of the it before, but for some of you this might be a new territory in Excel....
SUM function in Excel – the different ways to generate it
SUM function in Excel - the different ways to generate it, have you tried them all? This week's hint and tip is about the SUM function in Excel and the different ways that you can go about creating it. This function is covered on the Basic Excel course and we are...
Three Simple Excel Tips – have you heard of these before?
Three Simple Excel Tips - there are lots in Excel, but have you heard of these three? Whilst training Excel in Worcestershire and Herefordshire recently, we had a good chat on the course with the people attending about shortcuts. There are many in Office let alone...
Excel Visio Add in – a new add in called ‘Visio Data Visualizer’ in Excel
Excel Visio Add in - the new Visio Data Visualizer add-in that has appeared in a recent Microsoft Office update This hint is for those people who are Office 365 subscribers and want to know what’s around the corner. Nowadays most people have the 365 version of...
Word Track Changes Feature – have you ever used it in documents?
Word Track Changes Feature - how it can help you in your documents This week's hint and tip is about the Word track changes feature. This is a section in our Advanced Word course and covers how you can use this feature in your documents. We are currently undertaking...
Absolute References in Excel – do you know what they are?
Absolute References in Excel - do you know how to make a cell reference absolute in your spreadsheets? In an Excel spreadsheet (technical name - worksheet) there are many cell references that are used in calculations and formulas. A cell reference is created where a...
Excel 365 Maps Features – more maps options have been added in Excel!
Excel 365 Maps - didn't maps appear before in Excel? You might be thinking, "hang on, they've spoken about maps before in Excel haven't they?" Well you would be right to think that as we have! However, in Excel 365 there are a few more options that you can use too...
Word Basics Defining New Bullet Points – how to change it…
Word Basics – defining new bullet points... I can change the bullet point? Last time we looked at how to insert a bullet point into a Word document. In this week’s hint and tip we are taking it a step further and looking at how you can create your own bullet point...
Word Basics Bullet Points – step by step on how to insert them
Word Basics Bullet Points - how do you insert them again? This week we are looking at bullet points in Word and how you can use them in your documents. Bullet points can be used for a number of reasons in a document, from creating a list of instructions to summarising...
BODMAS test – do you know what the answer is to it? Let us know
Many of you might have seen this ‘test’ before doing the rounds on the internet or for some of you it might be completely new! It has divided people everywhere up into groups as to what their answer was for the last line. Have you tried it? What do you think the...
Excel Tables – how you can use one of their many uses!
Excel Tables - how you can use them within Excel to make named ranges more flexible This week’s hint and tip is about creating a table from your data in Excel and how it makes named ranges more flexible this way than just selecting and naming the range of cells. The...