University Information Services - Digital Literacy Skills course timetable

• 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 - 5 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.
• To make a test call in advance of the session, in Teams select your profile picture, then Manage account>Settings > Devices>Make a test call.
• The course will start promptly at the time shown but will be open up to 15 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 is an online instructor-led course to help you get to grips with word processing basics using Microsoft Word. 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 Skills for Document Layout.

For those who prefer to self-study there is an online course from LinkedIn Learning, the course can be accessed here for Mac and for Windows users. 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.

This is an online instructor-led course to help you get to grips with word processing basics using Microsoft Word. 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 Skills for Document Layout.

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

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

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

This course is aimed at those who want to improve their skills when laying out Word documents. You will learn key topics that will enhance your work with the opportunity for hands on practice on the essential features of Microsoft Word relevant to producing well laid out reports.

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

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.

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

Do you keep hearing the term collaborating online and are wondering if you and your co-workers should be doing it, or if you are doing it correctly? If so, this one-hour instructor-led course is for you. The session will blast through the jargon of OneDrive and SharePoint to explain how working online together can improve productivity, and it will give you hands on practice collaborating in real time using Word and Excel. By the end of the session your questions will be answered and you'll be working online with confidence.

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

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.

• 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 cover the most essential features and concepts of Drupal Content Management Service through hands on activities.