Get free IT training

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

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

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

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.

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.

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.

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.

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.

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.

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:

Using Google Keep

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

Setting Pinned tabs in Chrome

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

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 will will get you quickly up to speed with the basics of creating and delivering a presentation. The training will include:

• Navigating the PowerPoint interface
• Working with slides
• Adding content (text, images, tables, charts, smart art diagrams)
• Adding slide transitions
• Printing a presentation
• Presenting a PowerPoint 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.

This course will introduce some of the functionality that will make your PowerPoint presentation even more engaging. The training will include:

• Adding Videos to a presentation
• Using Zoom to create a summary slide
• Setting up master slides
• Turning your presentation into a video
• Creating a screen recording
• Adding animation
• Using 3D models in presentations

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.

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.

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.

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.

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.

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

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