Topics Covered

The below list identifies the main learning outcomes for each MicroSession.

Introduction to Office365 & OneDrive

• Identify key aspects of the O365 and OneDrive interfaces
• Understand the difference between client vs online applications
• Upload Files/Files, Share and Revoke Access
• Sync files between OneDrive online and OneDrive desktop

Back to top

Office365 Forms

• How to create a form
• Set question options and change form settings
• Invite others to respond 
• See real-time results, use built-in analytics to evaluate responses
• Export results to Excel for additional analysis

Back to top

Introduction to Microsoft Teams

• Overview of Teams desktop client application
• Create Teams/Channels, add and remove members
• Schedule a meeting in calendar and invite attendees
• Key features of meetings vs live events
• Helpful tips and tricks

Please note this is an introductory session aimed at new or inexperienced Teams users - it is not intended for experienced users, hands-on training, or troubleshooting queries.

Back to top

Excel Basics

• Editing Cells
• Using Autofill
• Calculations using basic Formula & Functions
• Creating and Modifying Charts

Back to top

Excel Page Layout & Formatting

• Page Setup: Margins, Orientation, Scaling, Headers & Footers, Print Titles
• Freezing Panes
• Formatting Rows & Columns

Back to top

Excel Data & Text Features

• Data Validation
• Text to Columns
• Remove Duplicates
• Text Functions e.g. concatenate, upper, lower, proper, len

Back to top

Excel Extra Functions and Features

• Cell Referencing (relative & absolute)
• Working with more than one worksheet
• Paste Special
• Protecting Cells in a Worksheet

Back to top

Excel Pivot Tables

A Pivot Table is an interactive table that contains summarised data. Once a pivot table has been created, you can manipulate it to analyse your data in different ways. This session will cover

• Creating Pivot Tables – learning the basics
• Changing layout and field settings
• Creating Pivot Charts
• Using the Slicer feature

Back to top

Excel Sort & Filter

• Sorting
• Filtering
• Conditional Formatting
• Sparklines

Back to top

Word Essential Formatting

• What are Word Styles and why would you use them
• Generating a hierarchy of headings in your document
• Watermarks
• Inserting and removing hyperlinks
• Inserting graphics and changing how text wraps around them
• Basic Page Numbers

Back to Top

Word Advanced - Create Long Documents

• Understand what a break is, and identify the different breaks - page breaks vs section breaks 
• Know how to add, view, and delete breaks
• Identify various formatting options for individual sections, e.g. vertical alignment, orientation, margins
• Understand how to apply different page numbering formats using section breaks
• Generate a table of contents
• Add referencing

Please note this is an advanced session. Attendees will be expected to have an understanding of the basic Word functions covered in Word Essential Formatting.

Back to top

Introduction to PowerPoint

• Create/Edit slides, Reuse Past Slides, Insert Pictures, text, video, audio
• Manipulating Smart Art/Charts, Screenshots
• Grouping and Arranging Objects
• Design Tab and Design Ideas

Back to top

Pixlr Image Editing

• Image sourcing and copyright
• Accessing Pixlr Image Editor
• Creating a canvas with required dimensions for the web
• Placing, cropping and resizing an image
• Saving the image for use on the web

Back to top

Pixlr Advanced Features

• Making adjustments to photos including:
  • Healing/Removing elements
  • Cloning elements
  • Working with multiple layers
  • Brightness/Saturation/Contrast
  • Gradients for adding text

This is an advanced training session. Attendees are expected to have an understanding of basic image editing with Pixlr as covered in Pixlr Image Editing

Back to top

Teams for Teaching

• Creating a Team
• How to add a list of student names to a team 
• Chat within a Team
• Meetings – inviting students and Meeting options
• Meeting options – recording meeting, record attendees, End for all participants. Also, background, share screen, raise hand.
• Breakout rooms
• Meeting Chat & Meeting Notes
• How students can use teams 

Back to top

Teams for Collaboration

• Creating a Team
• Adding/removing members
• Creating Channels
• Add a Tab in a Channel
• Share and Collaborate on Files
• Online v Client 

Back to top

Teams Breakout Rooms

With breakout rooms, you can have people break out into smaller groups to work on projects or brainstorm

• Overview of breakout rooms
• How to create break out rooms
• Re-joining the larger group again

Some existing knowledge of Teams is required before attending this session. Click here to view recordings of other Teams microsessions.

Note:  If there is a delay with the release of this feature we may need to reschedule this MicroSession.

 Back to Top

Outlook Tips

• Outlook Client v OWA
• Setting up a Signature
• Setting up a Teams meeting using Outlook
• Changing views and settings

Word Bibliography and Referencing

• Creating footnotes and endnotes
• Creating a reference 
• Adding a bibliography

Teams Breakout Rooms

• Setting up breakout rooms
• Adding attendees to rooms
• Returning to main room

Excel using QAT (Quick Anaylsis Tool)

This tool gives the user access to the following features

• Formatting 
• Charts
• Totals
• Conditional Formatting
• Sparklines

Back to top

 PowerPoint Tips *New

• Inserting charts and diagrams

• Action buttons

• Animations and transitions

• Sections and Summary Zoom

• Presenting with Teams

Please note: A basic knowledge of PowerPoint would be helpful before attending this session.  Click here to view Microsoft PowerPoint training.

Back to top

Excel using IF & VLookup Functions *New

Prequisite - a good knowledge of the basic excel functions would be required before attending this session - click here to view recordings of other Excel sessions.

The IF function allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

The VLOOKUP function in Excel finds things in a table or range by row.

This session will cover:

• IF functions with demo & practice file
• VLooking with demo & practice file

Back to top