University Information Services - Digital Literacy Skills course timetable

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 courses that build on these fundamentals to extend your skills including Part 2 of this course.

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 @cam.ac.uk email and Raven password.

• 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 is an online instructor-led course following on from Excel for Complete Beginners - Part 1.

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 @cam.ac.uk email and Raven password.

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

Need to get up to speed with Teams? Then join us in this friendly, slow-paced, introductory session to learn how to get up and running. This is Part 1 of 4 courses that provide you the opportunity to get a hands on and in-depth insight into Teams. If you prefer a quick overview of Teams then consider joining the Fast Track course instead. Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate.

You will:

• Understand Teams, Channels and an overview of what is possible in the application
• Chat in a group or one-to-one
• Collaborate with colleagues. In Teams you can access, share, and edit Word docs, PowerPoint, and Excel files in real time

If you book:

• Add the event to your calendar by following the link in your booking confirmation email and click Add to Calendar.
• Install the Microsoft Teams app. (It is possible to join using Edge or Chrome but there is less functionality when using a browser).
• Important: The instructor cannot troubleshoot access to Microsoft Teams on the day of the course. If you are in an institution that is managing their own Teams tenancy (CAMENT, JBS, medschl and some of the colleges) then you may not have access to the files or calendar used in the course. Please contact the instructor in advance to discuss this.
• If you are using Hermes for your email you will not be able to access the Teams calendar used in the course.
• It's advisable to make a test call in advance of the session.
• The course will start promptly at the time shown but will be open up to 30 minutes beforehand should you wish to check your audio and visual setup or meet your instructor.

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

Want to extend your knowledge of Teams? Then join us to learn how to use applications to record notes, create a Wiki, manage a small project and create online forms or surveys. This is Part 3 of 4 courses that provide you the opportunity to get a hands on and in-depth insight into Teams.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate.

You will:

• Know how to add documents and apps in a tab and when you might benefit from using them.
• Practice using applications that you need to work with i.e. Connectors, OneNote, Wiki, Planner, Forms and Lists.

If you book:

• Add the event to your calendar by following the link in your booking confirmation email and click Add to Calendar.
• Install the Microsoft Teams app. (It is possible to join using Edge or Chrome but there is less functionality when using a browser).
• Important: The instructor cannot troubleshoot access to Microsoft Teams on the day of the course. If you are in an institution that is managing their own Teams tenancy (CAMENT, JBS, medschl and some of the colleges) then you may not have access to the files or calendar used in the course. Please contact the instructor in advance to discuss this.
• If you are using Hermes for your email you will not be able to access the Teams calendar used in the course.
• It's advisable to make a test call in advance of the session.
• The course will start promptly at the time shown but will be open up to 30 minutes beforehand should you wish to check your audio and visual setup or meet your instructor.

An online workshop on how to develop your first MATLAB code.

In this session, you will be introduced to the MATLAB environment and programming language. We will discuss the basic operations and core concepts that form the building blocks of any scientific programme.

An introduction to using the bibliography program EndNote to store references and notes and use them to achieve correct referencing in your documents without re-typing. This course covers EndNote Desktop which is available free to members of Cambridge University via the Academia website

The course will consist of a demonstration, followed by a practical session working through the course handout. If you are unable to install EndNote before the course then you will not be able to do the practical but you should still find the demonstration useful and can try the practical later in your own time.

Using EndNote will enable you to keep a note of references as you research online so that you will always be able to document your sources correctly. It can save you time as you should never need to retype references and you can alter their layout with a couple of mouse-clicks.

Want an insight into Teams? Then join us in this friendly, fast-paced, session to learn how to get up and running. This course would suit people that are comfortable using computers and who would be confident referring to the course materials after the session to consolidate the detail.

However, if you would prefer a more in depth and slower paced course with more opportunity for practice then attend Teams Parts 1 - 4 instead (see Related courses below).

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate.

You will:

• Understand Teams, channels and gain an overview of what is possible in the application.

In Teams you can:

• video/audio chat or message colleagues one-to-one or in a group
• arrange and attend meetings
• collaborate in real time with colleagues - access, share, and edit Word docs, PowerPoint, and Excel files
• add applications that you need to work with e.g. OneNote, Planner, Forms/surveys.

If you book:

• Add the event to your calendar by following the link in your booking confirmation email and click Add to Calendar.
• Install the Microsoft Teams app. (It is possible to join using Edge or Chrome but there is less functionality when using a browser).
• Important: The instructor cannot troubleshoot access to Microsoft Teams on the day of the course. If you are in an institution that is managing their own Teams tenancy (CAMENT, JBS, medschl and some of the colleges) then you may not have access to the files or calendar used in the course. Please contact the instructor in advance to discuss this.
• If you are using Hermes for your email you will not be able to access the Teams calendar used in the course.
• It's advisable to make a test call in advance of the session.
• The course will start promptly at the time shown but will be open up to 30 minutes beforehand should you wish to check your audio and visual setup or meet your instructor.

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

Are you migrating from Hermes to Exchange Online and are using Outlook 365 desktop as your client for the first time?

If so join us in this friendly, introductory session to learn how to get up and running with Outlook 365 Email and Calendar using the Desktop application for Windows, where we will take you through the basics of the Outlook 365.

This course does not cover the Hermes migration tool or in-depth technical questions regarding Outlook and Exchange. For this information please see the Further Information for IT staff webpages.

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 Outlook 365 for Windows desktop application installed on your computer. Participants using Microsoft Outlook 365 for Mac or the online version via a web browser will find some of the functionality missing.

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

Are you a Team Owner? This course teaches how to manage your team effectively and answers the many questions that you will have. Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate.

You will:

• Learn how to create teams, channels and add members
• Practice configuring settings for your team and its members
• Have the opportunity to ask questions about team management