Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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...
FV Financial Function in Excel – using financial functions for working out calculations
FV Financial Function in Excel - how can I use this financial function in my spreadsheets? Watch the video to learn more This week's hint and tip is on the FV financial function in Excel. This looks at the financial function which is applicable to home as well as...
Dependent List Data Validation in Excel – using dependent lists to make it more advanced
Dependent List Data Validation in Excel - how can I use this more advanced example of data validation in my spreadsheets? Watch the video to learn more This week's hint and tip is about dependent list data validation in Excel. This looks at how you can use data...
Time Calculations in Excel – using cell formatting to allow use of these in spreadsheets
Time Calculations in Excel – how can I use cell formatting to allow use of these in spreadsheets? Watch the video to learn moreThis week's hint and tip is about time calculations in Excel. This looks at how you can use custom cell formatting to enable you to carry out...
PDF Data into Excel – using the ‘Get Data’ feature in Excel to save you time!
PDF Data into Excel - how can I use the 'Get Data' feature in my spreadsheets? Watch the video to learn moreThis week's hint and tip is about getting PDF data into Excel using the 'Get Data' feature. This option isn't on any of our courses so we decided to do a hint...
Publisher Useful Features – have you used either of these before?
Publisher useful features - do you know either of them? Watch the video to learn moreThis week's hint and tip is on Publisher useful features. In this hint and tip we are covering how to change character spacing and how to easily select multiple objects in one go....
View Tab features in Word – using them to compare documents
View Tab features in Word - do you know either of these? Watch the video to learn moreThis week's hint and tip is on some view tab features in Word. In this hint and tip we are covering the Split and the View Side by Side option. These are both not necessarily covered...
Word Useful Features Part 2 – how about these, heard of any of them?
Word useful features part 2 - do you know any of them? Watch the video to learn moreThis week's hint and tip is on Word useful features part 2. In this second part we are covering the increase/decrease indent buttons and the hyphenation button. These are both not...
Word Useful Features Part 1 – have you heard of or used these before?
Word useful features part 1 - do you know any of them? Watch the video to learn moreThis week's hint and tip is on Word useful features part 1. In part 1 we are covering the increase/decrease font size buttons, the change case button and the format painter button....
VBA Input message boxes in Excel – something to stretch your knowledge
VBA Input Message Boxes - how can I create them in my spreadsheets?This week's hint and tip is about VBA input message boxes in Excel. It looks at how to make an Excel worksheet more interactive by using a macro with input message boxes. We also did an earlier video...
Text Wrapping in Word – how to use it plus some extra features
Text wrapping in Word - how do I use this? Watch the video to learn moreThis week's hint and tip is about how to use text wrapping in Word when inserting. This is not covered really on our Word courses in detail, so we decided to do a post on it. We are going to go...
Inserting slides in PowerPoint – how to do it and the different layouts
Inserting slides in PowerPoint - how do I do this? Watch the video to learn moreThis week's hint and tip is about how to insert slides in PowerPoint into your presentations. This is on our Basic PowerPoint course and it covers where the options are found and how to...
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 |