Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
SUMIF and COUNTIF Functions in Excel – what do they do?
SUMIF and COUNTIF Functions in Excel - how can I use these functions in my worksheets?This week's hint and tip is about the SUMIF and COUNTIF functions in Excel and how you can use them in your worksheets. These are covered on our intermediate Excel course but we...
NETWORKDAYS.Intl Function in Excel – what is it and how do I use it?
NETWORKDAYS.Intl Function in Excel - how can I use this function in my worksheets?This week's hint and tip is about the NETWORKDAYS.Intl function in Excel and how you can use it in your worksheets. This isn't covered on any of our courses so we decided to do a hint...
Word Document Protection – how to prevent editing in part of a document
Word Document Protection - using features to protect part of your documents from being edited, have you done this before? Watch the video to learn more This week's hint and tip is on Word documents protection. In this hint and tip we are looking at a way in which you...
Word Shortcuts Part 1 – F9, F7 and Shortcuts for Open and Search/Find
Word Shortcuts Part 1 - the F9 and F7 function keys and the open and find shortcut keys, have you used them? Watch the video to learn moreThis week's hint and tip is on Word shortcuts part 1. Part 1 of these shortcuts covers the function buttons F9 and F7 and also the...
PowerPoint Useful Features Part 1: Text to SmartArt and Morphing Transition
PowerPoint useful features part 1 - do you know any of them? Watch the video to learn moreThis week's hint and tip is on PowerPoint useful features part 1. PowerPoint allows for some really smart features but they can be quite hidden away. In part 1 we are covering...
Formula Conditional Formatting in Excel – using formulas to apply it
Formula Conditional Formatting in Excel - how can I use formulas to apply conditional formatting in my worksheets?This week's hint and tip is about formula conditional formatting in Excel and how you can use it in your worksheets. This is covered in our Master Class...
Excel Green Triangle Errors – what do these mean?
Excel green triangle errors - have you ever come across these errors/notifications before? Watch the video to learn moreThis week's hint and tip is on Excel green triangle errors. This blog is to help you understand a little more about the little green triangle which...
RANK and XLOOKUP in Excel: using these in spreadsheets
RANK and XLOOKUP - how can I use both of these my worksheets?This week's hint and tip is about the functions RANK and XLOOKUP in Excel and how you can use them in your worksheets. In this hint and tip we are showing you how you can use Excel for sporting and other...
Excel Shortcuts Part 2 – F2, F4 and cut, copy and paste shortcut keys
Excel Shortcuts Part 2 - the F2 and F4 function keys and cut, copy and paste shortcut keys, have you used them? Watch the video to learn moreThis week's hint and tip is on Excel shortcuts part 2. Part 2 of these shortcuts covers the function buttons F2 and F4 and also...
Excel Shortcuts Part 1 – F1, F11 and undo/redo shortcut keys
Excel Shortcuts Part 1 - the F1 and F11 function keys and undo/redo shortcut keys, have you used them? Watch the video to learn moreThis week's hint and tip is on Excel shortcuts part 1. Part 1 of these shortcuts covers the function buttons F1 and F11 and also the...
Creating a beep sound in Excel – how to make a beep appear on command!
Creating a beep sound in Excel - did you know you could make the sound appear on 'command'? Watch the video to learn moreThis week's hint and tip is on creating a beep sound in Excel. Recently John was at a customers site carrying out some development in Excel and a...
Word Useful Features Part 3 – have you heard of any of these?
Word useful features part 3 - do you know any of these? Watch the video to learn moreThis week's hint and tip is on Word useful features part 3. In this third part we are covering the find and also the replace options. These are covered in our courses but we decided...
Word and PDF’s – a warning about protection settings in Word
Word and PDF - how does the new feature of PDF to Word cause issues when protecting Word documents PDF to Word is a newer feature in Office and initially can be seen as a great feature! This feature allows you to open up a PDF document into Word format so that it...
Inserting Icons in Word – have you used the icons option before?
Inserting Icons in Word - what are icons and how can I insert them in my document? Watch the video to learn moreThis week's hint and tip is about inserting icons in Word. It covers what an icon is and how to insert it into your document. This is on our Intermediate...
SORT Function in Excel – using this newer function in your spreadsheets
SORT Function in Excel - how can I use this function in my spreadsheets? Watch the video to learn moreThis week's hint and tip is on the SORT function in Excel. It looks at this function and how it can be used in spreadsheets. This isn't covered specifically in our...
Excel Useful Features – using flash fill and text to columns in spreadsheets
Useful Excel Features - how can I use the flash fill and text to columns features in my spreadsheets? Watch the video to learn moreThis week's hint and tip is on the some Excel useful features. The features we take a look at are flash fill and text to columns and how...
Top 5 YouTube Videos by views:
| Rank Number | Video Name |
|---|---|
| 1st | SUBTOTAL vs. SUM in Excel |
| 2nd | Pivot Table from an Excel Table |
| 3rd | XLOOKUP & Filter Functions in Excel |
| 4th | Conditional Formatting in Excel |
| 5th | Absolute References in Excel |