Welcome to Mastering Microsoft 365, your dedicated area for unlocking the full potential of the Microsoft tools you have access to.
In this area, you will find practical tips, advice, and useful shortcuts specifically designed to help you work more efficiently, collaborate seamlessly, and learn new features within Microsoft 365 apps
Making the most of everyday tools
Many of the tools within Microsoft 365 – such as Outlook and Word – are key to our working day. However, there are always new techniques to discover that can streamline your processes and enhance the way you work. By exploring the tips in this section, you can find ways to improve productivity and make day-to-day tasks even easier.
Latest top tip
You can delay the delivery of an individual message by having it held in the Outbox for a specified time after you select Send.
- While composing a message, select the dropdown next to Send and select Schedule send.
- Select one of the default options, then select Send or choose a custom time and then select Send.
- After you select Send, the message remains in the Draft folder until the delivery time.
Excel
Flash Fill automatically fills data when it detects a pattern without using complex formulas.
Simply start typing the pattern in the column next to your data, and Excel will suggest the remaining values.
Common use of Flash Fill:
- Splitting full names into first and last names.
- Extracting parts of text from a cell.
- Formatting phone numbers, ID information other standard data.
Want to learn more about Excel?
For further help and support with Microsoft Excel, please visit IM Online Learning.
Finding duplicate data
- Select the cells you want to check for duplicates.
Note: Excel can't highlight duplicates in the Values area of a PivotTable report.
- Select Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the box next to values with, pick the formatting you want to apply to the duplicate values, and then select OK.
Remove duplicate data
- Select the range of cells that has duplicate values you want to remove.
- Select Data > Remove Duplicates, and then under Columns, check or uncheck the columns where you want to remove the duplicates.
- Select OK.
Want to learn more about Excel?
For further help and support with Microsoft Excel, please visit IM Online Learning.
Forms
To keep your Microsoft Forms 'on brand', please use the blue colour scheme and upload this left-aligned logo, to give surveys a professional finish.
You can use QR codes to share Forms, so people with Smartphones can access them easily.
1. Open your Microsoft Form.
2. Click 'Collect responses'.
3. Select the QR code icon (three squares).
4. Select 'Download'.
5. Save the QR code to your device. You can now add the QR code to printed or digital materials.
Find out more about Microsoft Forms
To find out more about Microsoft Forms, visit IM Online Learning.
Word
There are many keyboard shortcuts that can be used in Microsoft Word to improve time efficiency.
- Navigation shortcuts: Use Ctrl + Arrow Keys to move through your document word by word. For example, Ctrl + Right Arrow moves the cursor right one word at a time, while Ctrl + Left Arrow does the opposite.
- Delete whole words: Press Ctrl + Backspace to delete an entire word at once, speeding up your editing process.
- Quick formatting: Use Ctrl + Shift + N to apply the "Normal" style to your text, which is great for cleaning up formatting.
Want to learn more about Microsoft Word?
NHS Informatics Merseyside (IM)'s Digital Skills Training Service has many training resources available to you for free on IM Online Learning.