MicroSessions Recordings

Never miss a MicroSession. Explore below to see recordings of every session delivered by IT Training to date. 

Please note these are recordings from live training sessions, so there are quesstions and interactions with attendees as well as the core content.

Excel Basics

Alternatively, view the Excel Basics IT MicroSession in Streams.

This session covers:

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

Excel Data & Text Features

Alternatively, view the Excel Data & Text Functions IT MicroSession on Stream.

This session will cover:

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

 

Excel Layout & Formatting

Alternatively, view the Excel Layout and Page Formatting IT MicroSession on Streams.

This session covers:

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

Excel Sort, Filter and More

Alternatively, view the Excel Sort, Filter and More IT MicroSession on Stream.

This session covers:

  • Sorting
  • Filtering
  • Conditional Formatting
  • Sparklines

Excel Extra Features

Alternatively, you can view the Excel Extra Features IT MicroSession on Stream.

This session covers:

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

 

Excel Pivot Tables

Alternatively, you can view the Excel Pivot Tables IT MicroSession on Stream.

This session covers:

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

Excel using IF & VLookup Functions

Alternatively, you can view the Excel IF & Vlookup IT MicroSession on Stream.

This session will cover:

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

Excel QAT (Quick Analysis Tool)

Alternatively, you can view the Excel QAT IT MicroSession on Stream.

This MicroSession covers the Quick Analysis Tool, which gives the user access to the following features:

  • Formatting 
  • Charts
  • Totals
  • Conditional Formatting
  • Sparklines

Introduction to Office 365 & OneDrive

Alternatively, you can view the Intro to Office 365 and OneDrive IT MicroSession on Stream.

This session covers:

  • The difference between Office365 and traditional 'Office' (client vs online)
  • What OneDrive is and what it is for
  • Core OneDrive functions - New files, upload, move, delete
  • Sharing files and the different permission options, revoking access
  • Syncing between your online OneDrive and your desktop OneDrive folder

IT Wellbeing

Alternatively, view the IT Wellbeing MicroSession on Stream.

This session covers 

a variety of Outlook and Teams tips and tricks, designed to help improve IT wellbeing.

Outlook:

  • Set automatic repllies (out of office)
  • Turn off notifications
  • Delay and schedule sending emails
  • Amend signature
  • Insights

Teams:

  • Change your status
  • Turn off notifications
  • Activate quiet hours and days

 

O365 Forms

Alternatively, you can view the Forms IT MicroSession on Stream.

This session covers:

  • 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

Lists & Teams Integration

Alternatively, view the Lists & Teams Integration MicroSession on Stream.

This MicroSession covers:

  • What is Lists
  • Creating lists
  • Formatting lists
  • Group, sort and filter lists
  • Sharing Lists
  • Using Lists with Teams

Outlook Tips

Alternatively, you can view the Outlook tips IT MicroSession on Stream.

This session covers:

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

 

Sway: Create and Share a Newsletter

Alternatively, you can view the Creating and Sharing a Newsletter with Sway MicroSession on Stream.

This session covers:

  • What is Sway?
  • How to create a sway with text, media and more
  • Sharing your Sway

SharePoint: Communications Site

Alternatively, you can view the SharePoint Communications Site IT MicroSession on Stream.

Join this session to look at what to do when you have UCC-only content and learn how you can use SharePoint Communication sites to get your information to your internal UCC audience. 

PowerPoint

 Alternatively, you can view the PowerPoint and Teams IT MicroSession on Stream.

This MicroSession covers:

  • 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.

Intro to Pixlr & Image Editing

Alternatively, you can view the Intro to Pixlr & Image Editing IT MicroSession on Stream.

This session looks at:

  • Where to source images for the web
  • Image Composition tips and tricks
  • Copyright considerations
  • Accessing Pixlr image editor
  • Scaling, cropping and adding text to an image
  • Saving an image for the web

Download: Intro To Pixlr Presentation

Pixlr Advanced Image Editing

Alternatively, you can view the Pixlr Advanced Image Editing IT MicroSession on Stream.

This session covers:

  • Image adjustments (brightness, contrast, exposure, hue, temperature)
  • 'Photoshopping' your images:
    • Spot Heal Brush to remove small items and blemishes
    • Clone tool to remove larger objects

Intro to Teams

Alternatively, you can view the Intro to Teams IT MicroSession on Stream.

This broad introduction to Teams covers:

  • Overview of Teams desktop client app
  • Using Chat - @mention, pin a chat, format a chat message
  • Test a call, Make a call
  • Meetings – setting up a meeting and also how to invite external users
  • Meetings – blur/change background, share your screen, raise a hand
  • Teams@UCC

Teams For Teaching

Alternatively, you can view the Teams for Teaching IT MicroSession on Stream.

This look at using Teams in the context of teaching students looks at:

  • Creating a Team
  • How to add a list of student names to a team using a code
  • Chat within a Team
  • Meetings – inviting students via Outlook or Canvas
  • Meeting options – recording meeting, record attendees, End for all participants. Also, background, share screen, raise hand.
  • Meeting Chat & Meeting Notes
  • Teams@UCC

Teams For Collaboration

Alternatively, you can view the Teams for Collaboration IT MicroSession on Stream.

This session focuses on:

  • Collaboration in Teams 
  • Creating, adding, manipulating files
  • Where files are stored and accessing them (channels, chats etc)

Teams Breakout Rooms

Teams: Breakout Rooms

Due to the nature of this feature we were unable to create a good quality recording of this session.

The session covered:

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

Please click Teams Breakout Rooms Training Resources to access links for support, training guide and training video. 

Word: Essential Formatting

Alternatively, you can view the Word Essential Formatting IT MicroSession on Stream.

This Microsession covers:

  • Using styles to generate a hierarchy of headings in your document
  • Creating a table of contents or using the navigation pane to navigate using headings
  • Inserting and arraging images
  • Inserting and removing hyperlinks
  • Inserting a default or custom watermark (image or text)
  • Inserting basic page numbering

Download: Word Essential Formatting Presentation

Download: Word Essentials Worksheet

Word: Section Breaks, Styles and Table of Contents

Alternatively, view the Word Section Breaks, Styles and Table of Contents session on Stream.

This MicroSession covers:

  • 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.

Word Referencing and Bibliographies

Alternatively, you can view the Word Referencing and Bibliography IT MicroSession on Stream.

This session covers:

  • Inserting and formatting footnotes and endnotes
  • Creating, managing, inserting and formatting sources and citations
  • Generating a bibliography
  • Captioning images and generating a table of figures

Viva Insights

Alternatively, view the Viva Insights MicroSession on Stream.

This MicroSession covers:

  • What are Viva Insights?
  • MyAnalytics
  • Viva Insights in Teams
  • Viva Insights in Outlook
Top