MASTERCLASS DETAILS

Microsoft Excel - Tips, Tricks & Shortcuts

This session covers a range of ideas, topics, insights and tips for Microsoft Excel users at all levels.
‍
- Leveraging mouse pointers
- Shortcuts for common tasks
- Graphs
- Transposing data
- Data lists/analysis and trouble shooting including, Text to Columns, Concatenate, Proper, Lower, Upper functions
- Conditional Formatting
- Subtotals
- Overview of Pivot Tables
- Overview of Macros.

Microsoft Outlook and Email Management

This session is designed for everyday users of Microsoft Outlook. It assumes all attendees can send and receive email, file emails and attach files to emails.
‍
- Tips & Shortcuts to fast track email sending, processing, responses and follow up.
- Outlook Automation tips including repetitive emails, Quick Steps and Rules
- Email signatures
- Set up tips that Microsoft’s own staff use to increase productivity with Outlook
- Tips on managing folders
- Donna’s Email SOS strategy to reduce email volume
- Calendar and task tips
- Shortcuts for managing contacts
- Tips on using Tasks in Outlook

Managing School Facilities

An overview of what good facility management looks like in a school and steps that can be taken to achieve this. Incorporates the context and the operational –policy and AIMS.
Understand the terminology and processes for ensuring your school is a safe environment for students, staff and the community.