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

This session covers:

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

Excel Data & Text Features

This session will cover:

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

 

Excel Layout & Formatting

 This session covers:

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

Excel Sort, Filter and More

This session covers:

  • Sorting
  • Filtering
  • Conditional Formatting
  • Sparklines

Excel Extra Features

This session covers:

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

 

Excel Pivot Tables

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

This session will cover:

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

Excel QAT (Quick Analysis Tool)

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

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

O365 Forms

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

Outlook Tips

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

This session covers:

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

PowerPoint

 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

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

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

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

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

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

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 Referencing and Bibliographies

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
Top