Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
Inserting Excel Charts – how do I do this? Learn three ways you can here
Inserting Excel Charts - how do I create a chart in Excel? Watch the video to learn more This week's hint and tip is about how to insert a chart within Excel. This is on our Intermediate Excel course and it covers the different ways in which you can insert a chart...
PowerPoint Custom Animation – how to apply it in your presentations
PowerPoint custom animation - how do I apply it to an object in my presentation? Watch the video to learn more In PowerPoint it is possible to fairly quickly make a presentation using just text and bullet points but it's not very interesting either to create or watch!...
Excel linking – linking within a workbook and between workbooks
Excel Linking - how do I create links between worksheets in a workbook and also between workbooks Excel? Watch the video to learn more This week's hint and tip is about how to create links within Excel. This is for creating links between worksheets in a workbook and...
Excel Filtering – a video on how to filter in your data in Excel
Excel Filtering - how do I use the filter in Excel? Watch the video to learn moreThis week's hint and tip is about how to use the filtering option within Excel. This is on our Intermediate Excel course and covers where the filtering option is found and how to use it....
Nested IF Statements – using them in your data with other functions
Nested IF statements - how do I create a nested IF statement? Watch the video to learn moreThis week's hint and tip is about how to use nested IF statements within Excel. This is on our Advanced Excel course and covers how to create a nested IF statement. The example...
Excel Sorting – a video on how to sort your data in Excel
Excel Sorting - how do I sort my data in Excel? Watch the video to learn moreThis week's hint and tip is about how to use the sorting option within Excel. This is on our Intermediate Excel course and covers where the sorting option is found and how to use it. We are...
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...
Excel Key Content Videos
| Course Level | Topic |
|---|---|
| Basic | Cell Formatting |
| Basic | Shading and Borders |
| Basic | SUM Formula |
| Basic | Relative & Absolute References |
| Basic | Conditional Formatting |
| Intermediate | Inserting Charts |
| Intermediate | Adding Chart Elements |
| Intermediate | Changing Chart Types, Styles & Location |
| Intermediate | Sorting |
| Intermediate | Filtering |
| Intermediate | IF Statements |
| Intermediate | Linking in Worksheets/Workbooks |
| Advanced | Text Functions #1 |
| Advanced | Text Functions #2 |
| Advanced | Nested IF Statements |
| Advanced | VLOOKUP |
| Advanced | Pivot Tables |
| Advanced | Pivot Tables & Charts |