Students on a laptop

Get to grips with IT

Improve your digital skills for free with free training courses on Google, Excel, Word and more

The IT Training Team provides lots of free training sessions, available throughout the year, to help you get to grips with different software.

This page contains information about the courses we currently offer. Simply find a course that interests you, check the calendar to see when it is being delivered and email IT Training to book your place. all training is currently being delivered via zoom.

Training Courses

Courses Content

Adobe Acrobat logo

This introductory course will cover how to use Adobe Acrobat DC to edit and combine PDF documents. The training will include:

  • An overview of Adobe Acrobat DC
  • Familiarisation of the Adobe Acrobat interface
  • Combining multiple documents to create one PDF
  • Extracting a page from a PDF
  • Inserting a page into a PDF
  • Editing an existing PDF
  • Adding headers and footers into a PDF
  • Adding and customising bookmarks in a PDF

You do not need any prior knowledge of Adobe to join this course.

Instructions on how to download Adobe Acrobat DC which is part of Adobe Creative Cloud are available on the Access and Download Software article

Keep logo

This course will explore techniques and functionality in MS Word to enable the creation of accessible documents. The training will include:

  • An exploration of the term Accessibility
  • A brief overview of legislation relating to Accessibility
  • Explanations and demonstrations of the following techniques:
    • Use of styles to add structure to a document
    • Use of numbered and bulleted lists
    • Adding Alternative Text to images
    • Creating meaningful hyperlinks
    • Inserting accessible tables
    • Using the Microsoft Office Accessibility checker
  • Saving a Word document as a PDF
  • Checking a PDF for accessibility

Powerpoint logo

This course will explore techniques and functionality in MS PowerPoint to enable the creation of accessible presentations. The training will include:

  • An exploration of the term Accessibility
  • A brief overview of legislation relating to accessibility
  • Explanations and demonstrations of the following techniques:
    • Selecting and using default layouts for slides
    • Ensuring each slide has a title placeholder
    • Use of numbered and bulleted lists
    • Adding Alternative Text to images
    • Creating meaningful hyperlinks
    • Inserting accessible tables
    • Checking reading order
    • Checking Colour Contrast
    • Using the Microsoft Office Accessibility Checker

Google Calendar logo

In this course will you discover a range of functionality which will enable you to manage your Google Calendar. The training will cover:

  • Screen layout and customisation options
  • Creating an event and displaying event details
  • Managing an Event
  • Sharing a Calendar
  • Setting notification on calendars
  • Creating an event on behalf of someone else
  • Create new calendars
  • Configuring settings
  • Making bookable appointment slots

You do not need any prior knowledge of Google Calendar to join this course.

Google Docs logo

In this course you will discover the functionality available in Google Docs to create documents. The training will include

  • Creating and setting up a Google Doc
  • Formatting the contents of a Google Doc
  • Working with a multipage document
  • Inserting a table into a Google Doc
  • Insert an image into Google Doc
  • Create a drawing using the canvas tool
  • Inserting a chart into a Google Doc
  • Inserting equations using the Equation Editor
  • Checking the accessibility of the Google Doc using Grackle
  • Sharing and Collaborating a Google Doc

You do not need any prior knowledge of Google Docs to join this course.

Google Drive logo

In this introductory course you will discover how to save documents into Google Drive and how to collaborate on and share a Google Doc. The training will include:

  • Creating folders to organise your Google Drive
  • Using your Priority Drive
  • Searching in your Google Drive
  • Uploading documents to Google Drive
  • Creating and Sharing a Google Doc
  • Accessing Version Control on a Google Doc

You do not need any prior knowledge of Google Drive to join this course.

Google Drive logo Google Slides logo Google Sheets logo Google Froms logo

If you are new to Google Drive this course is for you. In this course you will be introduced to Google Docs, Google Sheets, Google Slides and Google Forms. The training will include:

  • Creating a basic Google Doc
  • Creating a basic Google Sheet
  • Creating a basic Google Slide Presentation
  • Creating a basic Google Form

You do not need any prior knowledge of Google Apps to join this course.

Google Froms logo

This course will cover how to create an online Google form. The training will include

  • Creating a Google Form
  • Adding the following question types to a Google Form
    • Multiple Choice
    • Short Answer
    • Paragraph
    • Checkboxes
    • Drop-down
    • Linear Scale
    • Multiple Choice grid
    • Tick box grid
    • Date
    • Time
  • Formatting the appearance of a Google Form
  • Sharing a Google Form
  • Viewing form responses

You do not need any prior knowledge of Google Forms to join this course.

Google Mail logo

This course will cover the functionality in Google Mail. As well as email basics you will discover how to organise your inbox using labels and how to create filters. The training will include:

  • Screen layout
  • Managing your inbox using labels
  • Searching for an email
  • Creating Filters to organise emails
  • Using Conversation View
  • Composing Emails
  • Adding Contacts
  • Using Groups to send emails
  • Using Templates
  • Configuring Settings
  • Using Chat

You do not need any prior knowledge of Google Mail to join this course.

Google Sheets logo

This course will cover the core skills needed to create a Google Sheet. The training includes:

  • Creating Google Sheets
  • Inserting and formatting data
  • Using Conditional formatting to enhance the appearance of data
  • Creating basic formulas to calculate results
  • Use basic functions to analyse data (sum, min, max, average, count, If)
  • Using relative and absolute cell references in formulas
  • Techniques to enforce data validation on a Sheet

You do not need any prior knowledge of Google Sheets to join this course.

If you need to create a project or thesis this is the course for you. The course will cover techniques you can use to organise your content and create a long document using MS Word. The training will cover:

Keep logo

Using Google Keep

  • Setting up a note
  • Creating a list
  • Adding people to collaborate with
  • Synch with Keep on a smartphone

Keep logo

Setting Pinned tabs in Chrome

  • Set up Group tabs in Chrome
  • Colour coded tabs and moved them around

Keep logo

Features in MS Word

  • Tour of the MS Word Ribbon
  • Selection techniques
  • Show/hide button
  • Set up a document in Outline View and defined a master page
  • Open and use the Navigation Pane
  • Add and customise Heading styles
  • Insert captions
  • Apply bookmarks and cross-references to text
  • Add footnotes and endnotes
  • Discuss techniques for adding citations
  • Creating an index, table of images and a table of contents
  • Adding headers, footers, and page numbering using page and section breaks

MS Word: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS Word, the Access and Download Article contains more information on how to do this.

This course is suitable for anyone who wants to know the basics of creating a MS PowerPoint presentation. The training will include:

  • Creating a presentation
  • Inserting text and images
  • Working with images and shapes
  • Applying transitions between slides
  • Adding animations
  • Setting up a custom slide show
  • Delivering a presentation

You do not need any prior knowledge of MS PowerPoint to join this course.

MS PowerPoint: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS PowerPoint, the Access and Download Article contains more information on how to do this.

In this course you will discover how to use more advanced MS PowerPoint techniques. The training will include:

  • Using the Slide Master
  • Linking slides using action buttons and hyperlinks
  • Linking to web pages, files and email
  • Inserting videos
  • Creating a screen recording
  • Creating a Video from the PowerPoint
  • Using SmartArt and Triggers

We recommend that you have a basic knowledge of MS PowerPoint before joining this course.

MS PowerPoint: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS PowerPoint, the Access and Download Article contains more information on how to do this.

Excel logo

This course is suitable for anyone who has not used or has very limited knowledge of Microsoft Excel. The training will include:

  • An overview and explanation of the main areas on an Excel spreadsheet
  • Creating a new Excel workbook
  • Entering, editing and deleting data in a Excel workbook
  • Formatting text and numerical data
  • Creating basic formulas to add, subtract, divide and multiply numeric data
  • Using basic functions such as sum, min and max to perform calculations

The IT Training Team offer several different MS Excel courses. To ensure this is the correct course for you please complete this Training Needs Analysis Form before you book onto the course. Once completed a member of the training team will get back to confirm your booking.

MS Excel: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS Excel, the Access and Download Article contains more information on how to do this.

Excel logo

This course will introduce core MS Excel functionality such as creating formulas, creating and formatting charts and filtering data. The training will include:

  • A review of basic formulas and functions
  • Using relative and absolute cell references in formulas
  • Using the order of precedence in formulas (BODMAS)
  • Applying conditional formatting to enhance the appearance of data
  • Creating and formatting charts
  • Filtering data to create a subset of data
  • Integrating MS Excel with MS Word

The IT Training Team offer several different MS Excel courses. To ensure this is the correct course for you please complete this Training Needs Analysis Form before you book onto the course. Once completed a member of the training team will get back to confirm your booking.

MS Excel: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS Excel, the Access and Download Article contains more information on how to do this.

Excel logo

This course will build on the functionality covered in the MS Excel Intermediate course by introducing techniques such as Lookup functions, IF Statements and Pivot Tables to analyse data. The training will include:

  • Linking Excel Worksheets and Workbooks
  • Creating IF statements to return values if a condition is met or not
  • Using V Lookup functions to retrieve values
  • Using Subtotals to return an aggregate result
  • Creating Pivot tables to summarise and analyse data
  • Creating a simple macro
  • Methods for protecting a worksheet

The IT Training Team offer several different MS Excel courses. To ensure this is the correct course for you please complete this Training Needs Analysis Form before you book onto the course. Once completed a member of the training team will get back to confirm your booking.

MS Excel: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS Excel, the Access and Download Article contains more information on how to do this.

Excel logo

This course will cover how to create and customise a Pivot Table in MS Excel. Pivot Tables are used to summarise, sort, group and perform calculations on data stored in a MS Excel workbook. The training will include:

  • An overview of Pivot Tables and why they are useful
  • Creating a basic Pivot Table
  • Filtering and Grouping data
  • Adding Slicers and Timelines
  • Grouping and summarising data
  • Enhancing the appearance of a Pivot Table
  • Creating a Pivot Chart
  • Updating data in a Pivot Table

We recommend that basic knowledge of MS Excel before booking onto this course. Please email IT Training if you would like more information.

MS Excel: As a student at the University of Portsmouth you can download a 4 year subscription for MS Office 365 which includes MS Excel, the Access and Download Article contains more information on how to do this.

MS Viso logo

This course will cover how to use MS Visio to easily create Flowcharts, Timelines and Organisational Charts. The training will include:

  • An overview of Microsoft Visio and typical uses
  • Locating and opening existing diagram templates
  • Creating a Flowchart
  • Creating a Timeline
  • Creating an Organisational Chart
  • Formatting and printing charts

You do not need any prior knowledge of MS Visio to join this course.

Prezi logo

Prezi is a web based tool for creating presentations. This introductory course will guide you through the creation of a basic presentation. The training will include:

  • An overview of Prezi
  • Familiarisation of the Prezi dashboard
  • Creating a Prezi from a template
  • Adding and deleting topics
  • Entering content into a Prezi
  • Viewing a Prezi

You do not need any prior knowledge of Prezi to join this course.

Zoom logo

This introductory course will cover how to participate in, host and schedule a Zoom meeting. The session will include demonstrations of functionality such as breakout rooms and polls as well as configuring meeting settings in the web portal and desktop client. The training will include:

  • Using the features available as a host in a Zoom meeting
  • Using the features available as a participant in a Zoom meeting
  • Accessing the Zoom web portal to:
    • Configure key settings
    • Schedule meetings
    • Run and view reports.
  • Accessing the Zoom desktop client to:
    • Review settings
    • Check for updates

Our Training Schedule

How to book a training session

Firstly check the course profile of the session to make sure it is relevant for you.

Then check the dates on the calendar and email the details of the session you wish to attend to ittraining@port.ac.uk.

IT Training and digital skills consultations

IT Training also offer personalised 1-1 coaching to assist with developing IT and digital skills.

For further information please contact ittraining@port.ac.uk.

This site uses cookies. Click here to view our cookie policy message.

Accept and close