University Information Services - Digital Literacy Skills course timetable

• This is the online version of our popular face to face classroom based instructor led Excel: Functions course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

The course files and slides can be downloaded here

This course is an introduction to the CHRIS system and will cover an overview of key elements of the system that you will interact whilst undertaking HR tasks.

Prior to attending please check that you can log into the CHRIS system successfully.

• This is the Live online version of the In Person Face to Face classroom based instructor led CHRIS Introduction course.

Please Note: that you will require Microsoft Teams installed and VPN access to CHRIS setup to participate on this course. See System requirements below for more information.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

• See Related Courses below to take your skills further

This is an online instructor-led course to help you get to grips with spreadsheet basics using Microsoft Excel. It will be taught in a small group and no previous knowledge is assumed. Following on, we offer further online instructor-led courses that build on these fundamentals to extend your skills (see Related courses below).

For those who prefer to self-study there is an online course from LinkedIn Learning, the course can be accessed here. Sign in with your CRSid@cam.ac.uk email and Raven password.

This course will show you basic principles and processes for creating accessible documents in Microsoft Word and PowerPoint and PDFs.

Want to practice giving Teams Live Events? Then join us in this informal introductory session to manage and deliver a webinar. The course is not about presentation skills, it is to master the mechanics of managing the smooth transition between different presenters and content. The maximum number of participants for this course is limited to 2.

You must have the following items installed or available on your computer to participate:

1. The Teams desktop app installed on your computer.
2. The Teams Calendar available on the Teams interface. (You must be using Microsoft Exchange Online for your email to enable the Teams Calendar). Details on how to migrate from Hermes to Exchange can be found here.
3. The button on the Teams Calendar interface necessary to create a Teams Live Event. (To enable the button on your system you need to request the ability to create Live Events via the Self Service portal). Note! this can take up to 48 hours for the change to come into effect.

You will also need a working webcam, speakers (or headset) and mic.

You will:

• Learn about Teams Live Events
• Practice schedulling and delivering a Live Event. Please have a short PowerPoint and one other application ready to demonstrate, e.g a web site with video content

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

This is an online instructor-led course to help you get to grips with spreadsheet basics using Microsoft Excel. It will be taught in a small group and no previous knowledge is assumed. Following on, we offer further online instructor-led courses that build on these fundamentals to extend your skills (see Related courses below).

For those who prefer to self-study there is an online course from LinkedIn Learning, the course can be accessed here. Sign in with your CRSid@cam.ac.uk email and Raven password.

This course is for those who are new to the Recruitment Administration System (RAS) or those who wish to have a refresher.

• This is the Live online version of the In Person Face to Face classroom based instructor led RAS course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

• See Related Courses below to take your skills further

• This is the online version of our popular face to face classroom based instructor led Excel: Data & Lists course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

At some point during your career or job role, you may have to make or present a PowerPoint slide show. This course offers something for everyone, whether you have used PowerPoint before or you’re an absolute beginner. You will be taken through the best way of working starting with Templates and inserting text and images and all the way through to transitions, animations and exporting.

• This is the Live online version of the In Person Face to Face classroom based instructor led PowerPoint: Part 1 course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

• See Related Courses below to take your skills further

This course will show you basic principles and processes for creating accessible documents in Microsoft Word and PowerPoint and PDFs.

This course will cover the most essential features and concepts of Drupal Content Management Service through hands on activities.

• This is the online version of our popular face to face classroom based instructor led Excel: Data & Lists course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

This course is mainly aimed at students writing their thesis but is also suitable for staff who need to write a long document. It is designed to give an insight and hands on practice into the more advanced features of Microsoft Word that are relevant to producing substantial reports.

At some point during your career or job role, you may have to make or present a PowerPoint slide show. This course offers something for everyone, whether you have used PowerPoint before or you’re an absolute beginner. You will be taken through the best way of working starting with Templates and inserting text and images and all the way through to transitions, animations and exporting.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft PowerPoint 365 for Windows desktop application installed on your computer. Participants using Microsoft PowerPoint 2016 or 2019, Microsoft PowerPoint 365 for Mac or the online version via a web browser will find some of the functionality missing.

This course is designed for Training Administrators of a new provider on the University Training Booking System (UTBS) and it will take them through theory and practicals on how to administer their training programme on the UTBS. The course is taught using Microsoft Teams and you must have Teams installed on your computer to participate.

• This course offers an introduction to the power and time-saving value of PivotTables and will appeal to anyone who analyses data in Excel.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

The course files and slides can be downloaded here

• This is the online version of our popular face to face classroom based instructor led Excel: Analysing and Summarising Data course.

Please Note: It is important that when you book on this course, on your booking confirmation page, click on Add to Calendar to start the process to import the course appointment into your calendar. This contains the link to the MS Teams course meeting under Joining Instructions that you will use to join on the day of the course.

To fully participate in this course you will need to have the Microsoft Excel 365 for Windows desktop application installed on your computer. Participants using Microsoft Excel 365 for Mac or the online version via a web browser will find some of the functionality missing.

This course is an introduction to reference management using the free, open-source program, Zotero. Zotero is a free, open-source program which allows you to collect and store references from online sources; add your own annotations and finally use your stored references to insert correct citations into a Word, Libre/Open Office, or LaTeX document.

Zotero is essentially a helper; it will enable you to collect references as you review online databases in a web browser and then interact with Word, Libre/Open Office or LaTeX to cite your references as you write your document.

This one-hour instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Teams. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.

The link to join the course is sent in the booking and reminder emails.