Welcome to Mastering Microsoft 365, your dedicated section for unlocking the full potential of the Microsoft tools you use every day.
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 tools and programs.
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 these tips, you can find ways to improve productivity and make day-to-day tasks even easier.
Tip of the week
Each week, a new ‘Tip of the week’ will be introduced, offering you the opportunity to further develop your skills and take full advantage of all that the Microsoft 365 suite has to offer. This regular feature is designed to support your ongoing learning and ensure you are always making the most of the available tools.
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.
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.
Forms
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.
IM Online Learning
IM Online Learning is a digital skills learning platform developed by NHS Informatics Merseyside (IM) Digital Skills Training Service
Want to improve your Microsoft 365 knowledge?
Our Digital Skills Sessions are designed to showcase the main features and benefits of each app, helping you apply them effectively to enhance your work.
Neurodiverse colleagues
We are committed to supporting Neurodiverse learners to ensure they get the most out of their training sessions. One-on-one training sessions provide personalised support and guidance tailored to the individual's need, whether face to face onsite, in a classroom or virtually.
Please fill out our form to request a call from our Training Service team, so we can discuss any additional support you may need before your training
Contact us
For help and support, please contact the IM Digital Skills Training Service.