Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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 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...
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...
Pivot Table from an Excel Table – another way of creating a pivot table
Creating Pivot Tables from an table format in Excel - how can I do this in my spreadsheets? Watch the video to learn moreThis week's hint and tip is on creating pivot tables from a table format in Excel. It looks at pivot tables and how they can be used in...
Dictate Feature in PowerPoint – using this to save time in presentations
Dictate Feature in PowerPoint - how can I use this in my presentations? Watch the video to learn moreThis week's hint and tip is on the dictate feature in PowerPoint. It looks at this feature and how it can be used in your presentations. This isn't covered...
6 MS Office shortcuts in Excel, Word and PowerPoint to save you time
6 MS Office shortcuts that you can use to save you time with your work - have you used any of these? This week’s blog looks at 6 MS Office shortcuts that are ‘must know’! These shortcuts and tips are for the 3 popular MS Office packages: Excel, Word and...
CONCATENATE Function in Excel – using a text function in your spreadsheet
CONCATENATE 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 CONCATENATE function in Excel. It looks at this function and how it can be used in spreadsheets. This isn't covered...
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 |