IT MicroSessions

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 Jul-Aug 2020

IT MicroSessionDate and TimeBook
O365 Forms Thu 16 Jul 11:00-11:45 Book
Intro to Microsoft Teams Tue 21 Jul 11:00-12:00 Book
Excel Pivot Tables Thu 23 Jul 11:00-11:45 Book
Word Page and Section Breaks Tue 28 Jul 11:00-12:00 Book
Excel Page Layout and Formatting Thu 30 Jul 11:00-11:45 Book
Pixlr Image Editing Tue 04 Aug 14:30-15:30 Book
Excel Data & Text Features Thu 06 Aug 11:00-11:45 Book
Excel Sort & Filter TBC  
Excel Extra Functions and Features TBC  
Word Styles, Tables of Content and Graphics TBC  
Intro to Powerpoint TBC  
Intro to Office365 & OneDrive TBC  

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

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

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

Top