What are IT MicroSessions?

Our IT MicroSessions are short on-line training sessions on various Microsoft applications.

These sessions are intended to be bite-sized training events for small groups of attendees. Each session will cover one or more related topics from our classroom training, such as Pivot Tables from Excel, or Page Layouts and Section Breaks from Word. We are aiming to deliver an online, flexible, and interactive alternative to our self-study and on-campus classroom options.

How Do They Work?

IT MicroSessions are delivered by IT Training using Microsoft Teams and will last 45-60 minutes, during which time the trainer will demonstrate tips and tricks via screen-share.

How Do I Sign Up?

To book into a session, simply click the 'Book' link beside the session in the schedule below and fill out the form.

Session Schedule Sep - Oct 2020

Click on Book and complete the Booking Form(s) for the Session(s) you would like to attend.  Further detail on some of our new MicroSessions coming soon.

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

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

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

Word Page and Section Breaks

• 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

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 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 Sort & Filter

• Sorting
• Filtering
• Conditional Formatting
• Sparklines

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

Word Styles, Tables of Contents and Graphics

• What are Word Styles and why would you use them
• Generating a hierarchy of headings in your document
• Generating and updating a table of contents
• Inserting graphics and changing how text wraps around them

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

Excel Basics

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

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