Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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...
IT Training Herefordshire – creating a Pivot Table..how do you do it?
IT training Herefordshire - how do you create a pivot table and chart? Find out how this week below... One of the most useful and powerful features companies can use in Excel is the ability through Pivot Tables to analyse and summarise data. We deliver the following...
Excel training basics – BODMAS…do you remember this from Excel?
Excel training basics - the BODMAS 'concept' BODMAS. The word that tends to divide a room of people on one of our Excel courses up in to one of four groups: Have no idea what we are talking about and never heard of BODMAS Vaguely remember being told about it and...
Excel names – how to name cells and ranges in Excel
Excel names – using naming cells and ranges within formulas and calculations In this weeks hint and tip we are going to be looking at the concept of Excel names. This concept is where you are able to name a cell or a range of cells to then use them within a formula or...
PowerPoint basics slides – inserting a new slide in your presentation
PowerPoint basics slides - how to insert a new slide in to your presentation We are starting off some new hints and tips where we will be looking some of the packages within Microsoft Office and giving hints and tips on specific actions you can do in them; starting...
Publisher page sizes – using page sizes & publication types for your work
Publisher page sizes – how to use page sizes & publication types Publisher is a package that can sometimes be forgotten about or overlooked, with Word being most people’s first point of call for creating documents. However, sometimes Publisher comes up on top in...
Excel meaning – Understanding and fixing Excel Errors
Excel meaning - What the errors mean in Excel and how do you go about fixing them? We’ve all done it, typed a calculation or formula in Excel, hit enter and an error message appears! The problem we then have is “What does that error message mean?!?” This weeks hint...
Excel Symbol Meanings…what do they mean? Find out here!
Excel Symbol Meanings - have you ever wondered what they do? What they mean? Further to a blog we did in May 2017 on Excel Symbols we thought we would give you a further insight into 5 more Excel symbol meanings. There are a number of different symbols used within...