Excel Micro Learning Session 3

Tricks and tips for Microsoft Excel 365 including using subtotal instead of sum, identifying duplicates and how to create a drop-down list

In this short 20-minute Micro Learning session we will look at some more of the most useful Tips and Tricks for Microsoft Excel 365 including:

• Using SUBTOTAL as a smart alternative to SUM
• Identifying duplicates so that you have options for further actions.
• Creating a drop-down list to ensure data is entered identically.
• Automatically updating totals when data expands.

Please note that this session is broadcast live but has been recorded previously and there is no practice file as these are quick hints and tips sessions.