University Information Services - Digital Literacy Skills course timetable

This 1:1 workshop is for those with a specific questions about using Microsoft Office, Teams or SharePoint. We will work with you using your files to explore if we can answer questions or suggest a more efficient way to achieve results.

When you book in the Special Requirements field, please enter a description of what you want to discuss and, if relevant, have a copy of your own files available so we can test some ideas. Please anonymise the data if it is sensitive or personal.

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

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

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 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 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 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 instructor-led online course, taught via a Microsoft Teams meeting, is for people who need to learn how to create charts in Excel and assumes a basic knowledge of the software. At the completion of this course you should be able to:

• Create effective charts in Microsoft Excel
• Create a range of common charts
• Use a range of elements and features to enhance charts

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.