skip to navigation skip to content
Reset
Filter by

Course type

Show only:



Dates available




Places available




Training provider



Filter search

Browse or search for courses


Showing courses 1-25 of 33
Courses per page: 10 | 25 | 50 | 100
Clear search

Excel 2016: Analysing and Summarising Data Thu 25 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

This hands-on course is a follow up from the Excel: Introduction course.

Excel 2016: Functions Tue 30 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

This course covers some of the more challenging functions such as IF, SUMIFS and VLOOKUP. Not all chapters will be taught in full due to time constraints but are included for self-study.

Excel 2016: Introduction Wed 10 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Apple Mac and PC. This is an instructor-led course for absolute beginners. There is a self-paced Excel Beginners course for those who prefer to learn at their own pace.

Excel 2016: Introduction (Self-paced) Tue 16 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

Microsoft Excel is the chosen spreadsheet package as it is a popular choice, both on Macintosh and PC. This is a self-paced Excel Beginners course for those who prefer to learn at their own pace, there is an instructor present to support you if you have questions. The same course is taught as instructor-led for those who prefer this approach to learning Excel Introduction .

Excel 2016: Managing Data & Lists Thu 18 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

How to Excel - Part 1 & 2 (For Finance Staff) Thu 18 Jun 2020   13:00 CANCELLED

NOTE This classroom-based course may not go ahead depending on the circumstances at the time. You can join our VIRTUAL course, delivered via Microsoft Teams, at https://www.training.cam.ac.uk/fin/course/HTE+1+and+2

This course will enable the participants to practice existing spreadsheet skills and develop more advanced skills within the context of UFS data. There will be the opportunity to extract data from the system and learn to manipulate, analyse and use it for reporting purposes. The course runs over two sessions and participants will need to attend both of these sessions.

LiL: Excel - Learning Excel Online (Office 365) Self-taught Booking not required

A curated LinkedIn Learning course on the most relevant tools to use for remote working, provided by the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2013. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like PivotTables and goal seeking.

The skills and knowledge acquired in Microsoft Excel 2013 - Level 3 (with Challenge Exercises) are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, macros, and much more.

Microsoft Excel 2016 - Data Analysis Add-Ins will show you how to use the data analyis add-ins of Microsoft Excel 2016, including using Power View to create interactive data visualisations, using Power Pivot to create a data model for use with Excel tools such as pivot tables and pivot charts, using Get & Transform to import and combine data from a variety of sources such as databases and web sites and using Power Map to visualise geographic data.

Microsoft Excel 2016 Functions new Self-taught Not bookable

Microsoft Excel 2016 - Functions will show you how to use a variety of Excel functions, including logical functions, math functions, date and time and financial functions. It is a reference manual and is designed to be used by someone already familiar with how functions are used in Excel.

Microsoft Excel 2016 - Level 1 is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

Microsoft Excel 2016 - Level 2 enables users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Microsoft Excel 2016 - Level 3 enables users to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

  • The Microsoft Office 365 Training Centre offers a range of introductory training videos and tutorials for Microsoft Excel.
  • Please note: The majority of the training available is also applicable to Microsoft Excel 2016.
Office 2016: Excel, Word and PowerPoint Top Ten Tips Thu 4 Jun 2020   09:30 CANCELLED

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

Haven't had the time to fully explore all that Excel, Word and PowerPoint has to offer? If so, now's your chance to pick up a few handy tips that you may not have discovered yet. You can save a lot of time and effort working with Excel, Word and PowerPoint if you know a few tricks and shortcuts.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

The skills and knowledge acquired in this course are sufficient to be able to create real life working VBA applications within Excel. The learner will be able to work with VBA within the Excel environment to program and automate worksheet operations.

This course will enable the participants to practice existing spreadsheet skills and develop more advanced skills within the context of UFS data. There will be the opportunity to extract data from the system and learn to manipulate, analyse and use it for reporting purposes. The course runs over two sessions and participants will need to attend both of these sessions.

2 other events...

Date Availability
Tue 9 Jun 2020 09:30 Not bookable
Tue 14 Jul 2020 09:30 Not bookable

Need to get up to speed quickly with Teams? Then join us in this friendly, fast-paced, introductory session to learn how to get up and running. If you prefer a slower pace with more opportunity for practice then consider attending Teams Parts 1 - 4 (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.

Introduction to Personal Computers - Using Windows 10 and Microsoft Office 2016 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

Introduction to Personal Computers - Using Windows 8.1 and Microsoft Office 2013 is designed for users who are keen to extend their understanding of how to use computers. The skills acquired are sufficient to use the software to perform tasks including starting applications, creating folders, copying and moving files, and personalising Windows.

Mapping the Past new Fri 22 May 2020   11:00 In progress

This intensive workshop is split into two online chats and two 1-hour sessions. Participants will first learn to collect and process geospatial data from historical sources and process it using geographical information systems from Google Earth to QGIS.

The first online session introduces research techniques for collecting, arranging and mapping geospatial data from historical sources, and is taught by Dr Oliver Dunn. His session is split into two parts: Part A will introduce both online sessions by showing some of our own research that makes use of Google Earth, 3D Maps in Excel, and historical GIS. In Part B you will be asked to locate a set of Scotland’s historical lighthouses on historical maps online and map their location and other attributes in Google earth and 3D Maps.

The second online session introduces students to mapping humanities data using Q-GIS which is a free GIS (Geographical Information System) software platform. Course participants will need to download and install QGIS on their laptops before 5th of June. On the 1st of June there will be further details concerning downloading QGIS, a chat forum where we can discuss why you might wish to use GIS, and whether GIS is the right choice for you, and a release of course teaching materials. On 5 June you will be taken through the map creation process step-by-step. This session will be taught by Max Satchell.

The skills and knowledge acquired in Microsoft Access 2013 - Level 1 (with Challenge Exercises) are sufficient to be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.

[Back to top]