Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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...
Financial Cell Formatting in Excel – using it to format your data specifically
Financial Cell Formatting in Excel - how can I use this formatting in my spreadsheets? Watch the video to learn moreThis week's hint and tip is on financial cell formatting in Excel. This looks at this specific type of cell formatting and how it can be used in...
XLOOKUP and Filter Functions – new to you in a 365 update!
XLOOKUP and Filter Functions in Excel - how can I use these newer functions in my spreadsheets? Watch the video to learn moreThis week's hint and tip is about XLOOKUP and Filter functions in Excel. This looks at these newer functions in Excel and how they can be used...
Ways to View a Formula in Excel – 3 different ways to see what is in a formula
Ways to view a Formula in Excel - how can I see what is actually in my formulas? Watch the video to learn more This week's hint and tip is about ways to view a formula in Excel. This is mentioned in our Basic course but we decided to create a hint and tip on it to go...
Creating Signatures in Outlook – setting up an email signature
Creating Signatures in Outlook - how can I set up a signature to use in my emails? Watch the video to learn moreThis week's hint and tip is about creating signatures in Outlook. This looks at how to create signatures for when you send emails as well as how to set up...