Digital Next Steps

• Explore the more advanced features of Microsoft Excel to enhance how data is created and evaluated in your spreadsheets
• 2 hours
• Remotely – workshop setting

Objectives

1. Using charts to display figures visually
2. Learning how to use common functions e.g. date & time, today, now and SUMIF
3. Understand cell referencing and absolute cell referencing 
4. Using conditional formatting and custom number formats
5. Know how to use sorting and filtering to manipulate data in Excel
6. Creating and using tables.