Microsoft Hints and Tips
A selection of hints and tips to assist you in you Microsoft Excel Training, or any other Microsoft training.
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...
Inserting text boxes in PowerPoint – how do I insert them in my slides?
Inserting text boxes in PowerPoint - how do I do this? Watch the video to learn moreThis week's hint and tip is about how to insert text boxes in PowerPoint in your presentation slides. This is on our Basic PowerPoint course and we cover how to insert, resize and...
Inserting and Defining Bullet Points in Word – a video on how to do so
Inserting and defining bullet points - how do I do this? Watch the video to learn moreThis week's hint and tip is about how to insert and define a new bullet point within Excel. This is on our Intermediate Word course and it covers where the options are found and how...
Dynamic Arrays in Excel 365 – what is it and how can I use it in Excel?
Dynamic Arrays in Excel 365 - how can I use this in my worksheets?This week's hint and tip is about dynamic arrays in Excel 365 and how you can use it in your worksheets. This feature isn't covered in our courses, so we wanted to create a hint and tip to let you know...
Groups of option buttons in our fun quiz! Have a go and let us know!
Groups of option buttons in our little quiz! How many questions did you get right?This week's hint and tip is slightly different, we are bringing you a Quiz! This quiz has been created using groups of option buttons and you can see how they are used in this post....
Data Validation in Excel – how to apply it to cells in your spreadsheet
Data Validation in Excel - how do I apply this in a spreadsheet? Watch the video to learn moreThis week's hint and tip is about how to apply and use data validation within Excel. This is on our Advanced Excel course and covers where the option is found and how to...
Inserting Pictures in Word – how to do this and some formatting options
Inserting Pictures in Word - how can I insert a picture and apply some formatting? Watch the video to learn moreThis week's hint and tip is about how to insert a picture into a Word document. It also covers some formatting that you can apply once the picture is...
Reveal Formatting in Word – how this command can help you in your documents
Reveal Formatting in Word - how can I use this command in my documents? Watch the video to learn more This week's hint and tip is about reveal formatting in Word and how you can use it in your documents. This feature isn't covered in our courses, so we wanted to...
Quick Parts in Word – how to use them to save you time in documents
Quick Parts in Word - how do I use them in Word to same time in my documents? Watch the video to learn more This week's hint and tip is about how to create a quick part and then how using it can save you time in creating documents. This is on our Basic Word course...
Changing Excel Chart Types – changing types, styles and location
Changing Excel chart types, styles and location - how do I do this? Watch the video to learn more This week's hint and tip is about how to change the type, style and location of your chart within Excel. These are on our Intermediate Excel course and they cover where...
Inserting Excel Chart Elements – adding more details to your chart
Inserting Excel chart elements - how do I add more detail and explanation to my charts? Watch the video to learn more This week's hint and tip is about how to add chart elements to your charts in Excel. This is on our Intermediate Excel course and it covers how to add...
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...