Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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 (the technical name being a worksheet) there are many cell references that are used in calculations and formulas. A cell reference is created...
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...
Excel Environment – setting it up in Excel to save you time
Excel Environment - setting it up in Excel to personalise the experience you have This week's hint and tip is about setting up the 'Excel Environment'. This is a section in our Basic Excel course and covers a number of options you can use or steps you can take to set...
Excel Basics Conditional Formatting – do you use it in Excel?
Excel Basics Conditional Formatting - how to use it in Excel and the 'Stop if True' option Conditional formatting is an option within Excel that can be used to bring some colour to your spreadsheet and allow you to highlight parts of the data in your spreadsheet. It...
Word Training Worcestershire – Creating Smart Letters and a Table of Contents
Word Training Worcestershire Using Word to create smart letters and using a Table of Contents for easier navigation! Word is sometimes a Microsoft Office package that gets overlooked. After all, it’s just like writing on paper isn’t it? As Word is a package that you...
Publisher Basics Text Boxes – how to insert a text box in a publication
Publisher basics text boxes – want to know how to insert a text box in a publication? Look below! 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 text boxes in Publisher....
Word Basics Watermarks – inserting a watermark in a document
Word Basics Watermarks - how do I insert a watermark in a Word document? There are lots of features that you can use in Word when creating documents, with some being used more frequently than others. One of these features that is sometimes overlooked is a watermark....
PowerPoint Basics Pictures – inserting a picture in a slide
PowerPoint Basics Pictures - how do I insert a picture into a slide in my presentation? This next hint and tip is looking at inserting pictures in to a slide within the PowerPoint package. Insert a Picture There are a couple of ways you can go about doing this which...
SUBTOTAL vs SUM function – which is the best to use in Excel?
SUBTOTAL vs SUM - which do you use in Excel? This week's hint and tip is about looking at the SUBTOTAL function vs. the SUM function. Most of you will have heard of the SUM function and probably use it on a daily basis, but you might not have known that there is...
Excel Charts – Creating a Chart from a Data Subtotals Sheet
Excel Charts - How do you create a chart from a Data Subtotals sheet? This is how... On a course last week, we had a good request from an attendee. They asked how to create a chart from a Data Subtotal sheet but only showing the subtotals and not the details. As it...
Learning Excel through games – Episode 1: macros with some VBA code
Learning Excel through games – Episode 1 Excel is used on a daily basis by people all over the world with most of them constantly learning Excel in their work. It has lots of features that can be used from a basic to a more advanced level, with one of these features...