Theme: Digital Literacy

Whether we like it or not, email is one of the main ways we communicate in our day-to-day work. However, you may not be using Outlook to its full potential as it has a number of underutilised tools.

Although we know there are probably easier ways to use Outlook, we often don't have the time or energy to sift through and find the hints and tips ourselves. This 90-minute workshop will guide you through some of the more hidden features to increase productivity.

We will cover:

• Top ten diary management tips
• Decluttering your inbox to prevent email overload
• Finding a needle in a haystack
• Email etiquette dos and don’ts
• Customising and getting the most out of Outlook
• Hidden features to improve your efficiency and increase productivity

The course includes access to a month's free support on any of the topics covered.

Microsoft Excel is great for storing and organising your data, but it can be time-consuming and frustrating to find the information you need.

This workshop will show you how to use Excel's powerful tools to quickly retrieve, view and summarise information in numerous ways.

We will cover:

• Ensuring accurate data entry with data validation
• Time-saving filters
• Visually explore and analyse data using conditional formatting
• Create interactive filters in PivotTables
• Present your information as a chart
• Dos and don'ts when working with data
• Time-saving tricks and shortcuts

The course includes access to a month's free support on any of the topics covered.

Microsoft Excel has lots of underutilised features that can help to save time and improve productivity. The primary objective of this workshop is to show you how to use these features and to demonstrate their effectiveness, challenging you to do things differently.

We will cover:

• Working with Formulas and Functions
• Save time and apply Formulas and Functions to your everyday tasks
• Search for a value in one place and insert it in another using lookup functions
• Avoid the 'pitfalls' of relative cell references
• Test certain conditions and return one of two entries
• Work with named cells to work faster and smarter with your formulas
• Managing large workbooks
• Trace and audit formulas in a worksheet
• Create a simple dashboard
• Produce summary reports from different worksheets
• Merge data from multiple users by linking workbooks

The course includes access to a month's free support on any of the topics covered.

A lively, fast-paced mix of demonstrations - learn how to create professional PowerPoint slides that will keep your audience engaged through the length of your talk - and pick up lots of time-saving tips along the way.

We will cover:

• Adding visual interest to reach your audience
• Understanding and working with SmartArt
• Setting up and reformatting an organisation chart
• Converting existing presentations to create high impact slide shows
• Preventing 'death by PowerPoint'
• Create a "flow" that will hold your audience's attention
• Adding animation effects and timing to slides
• Tailor your presentation to different audiences, using custom slide shows
• Branching to specific slides in a slide show
• Importing an outline document into PowerPoint
• Saving a presentation so that other people can watch the presentation on most computers

The course includes access to a month's free support on any of the topics covered.

Microsoft Word is a widely used and powerful word-processing package. The primary objective of this workshop is to broaden your knowledge of Word and to benefit from its overlooked and underused features in order to increase your productivity.

This 90-minute workshop will guide you through the topics and pick up lots of time-saving tips along the way.

We will be cover:

• Maintaining consistency using Styles
• Save time by applying Styles to text
• Modify a Style for the current document
• Protect your document by setting formatting and editing restrictions
• Working with long documents
• Specify different page layouts by inserting Section Breaks
• Refer to text such as headings and numbered lists using cross-references
• Create an index, listing keywords along with the page numbers
• Add visual interest using pictures, charts and SmartArt
• Create a list of cross-references to pictures, charts and SmartArt

The course includes access to a month's free support on any of the topics covered.

Windows 10 has a wealth of nifty, new features which means you might not be using your computer to its full potential. Although you probably know there are easier ways to use your PC, you simply don't have the time or energy to sift through and find the hints and tips yourself.

This 90-minute workshop will guide you through some of the more hidden features to increase productivity.

We will cover:

• Find a needle in a haystack
• Get organised and declutter
• Dos and don'ts of information management
• Customise Windows and get the most out of your computer
• Discover hidden features to improve your efficiency and increase productivity
• Save time by learning numerous tips and shortcuts

The course includes access to a month's free support on any of the topics covered.

This virtual session will cover the following:

• How we use OneDrive, SharePoint and Microsoft Teams when managing documents at Development & Alumni Relations

• An overview of using OneDrive, SharePoint & Microsoft Teams

• Provide guidance and best practices on how to find, share & manage documents

• Provide guidance and best practices on syncing, using Team Chat, shortcuts and downloading

Many areas of the document management strategy will be covered in the training. However, you may wish to familiarise yourself with the Document management strategy for SharePoint and OneDrive.

We will use MS Teams for the training session. Please use this MS Teams link for the session.

This classroom session will cover the following:

• How we use OneDrive, SharePoint and Microsoft Teams when managing documents at Development & Alumni Relations

• An overview of using OneDrive, SharePoint & Microsoft Teams

• Provide guidance and best practices on how to find, share & manage documents

• Provide guidance and best practices on syncing, using Team Chat, shortcuts and downloading

Many areas of the document management strategy will be covered in the training. However, you may wish to familiarise yourself with the Document management strategy for SharePoint and OneDrive.