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 36
Courses per page: 10 | 25 | 50 | 100
Clear search

Excel 2016: Analysing and Summarising Data Tue 3 Mar 2020   09:30   [More dates...] [Places]

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

3 other events...

Date Availability
Wed 5 Feb 2020 09:30 [Standby]
Thu 14 May 2020 09:30 [Places]
Thu 25 Jun 2020 09:30 [Places]
Excel 2016: Functions Thu 5 Mar 2020   09:30   [More dates...] [Places]

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.

3 other events...

Date Availability
Fri 7 Feb 2020 09:30 [Standby]
Wed 20 May 2020 09:30 [Places]
Tue 30 Jun 2020 09:30 [Places]
Excel 2016: Introduction Tue 14 Jan 2020   09:30   [More dates...] [Places]

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.

2 other events...

Date Availability
Thu 7 May 2020 09:30 [Places]
Wed 10 Jun 2020 09:30 [Places]
Excel 2016: Introduction (Self-paced) Wed 22 Jan 2020   09:30   [More dates...] [Places]

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 .

1 other event...

Date Availability
Tue 16 Jun 2020 09:30 Not bookable
Excel 2016: Managing Data & Lists Tue 12 May 2020   09:30   [More dates...] [Places]

3 other events...

Date Availability
Tue 28 Jan 2020 09:30 [Full]
Tue 25 Feb 2020 09:30 [Standby]
Thu 18 Jun 2020 09:30 [Places]
Excel 2016: Recorded Macros Fri 14 Feb 2020   09:30   [More dates...] [Places]

This course covers recording macros which provides automated steps to produce outcomes. This course does not teach VBA programming in full though you will gain an insight into what VBA is and how it relates to macros. if you want to learn VBA as a programming language then please see the self-taught course Programming in VBA - Using Microsoft Excel 2013. Not all chapters will be taught in full due to time constraints but are included for self-study.

3 other events...

Date Availability
Tue 10 Mar 2020 09:30 [Places]
Thu 28 May 2020 09:30 [Places]
Wed 1 Jul 2020 09:30 [Places]

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.

3 other events...

Date Availability
Wed 11 Dec 2019 09:30 Not bookable
Thu 30 Apr 2020 09:30 [Places]
Thu 18 Jun 2020 13:00 [Places]
How to Excel - Part 3 (For Finance Staff) Thu 23 Jan 2020   09:30   [More dates...] [Places]

The session will look at more advanced formulas and macros using the recorder and VBA tools.

The formulas covered in this course include SUMIF, COUNTIF and INDEX MATCH which will enable the user to quickly summarise data.

Macros will enable the user to automate tasks within excel. During this session, we will use the example of needing to analyse, sort, split and send data to specific email contacts. Users will be introduced to a series of macros to reduce this process to a few simple steps.

2 other events...

Date Availability
Wed 25 Mar 2020 09:30 [Places]
Wed 3 Jun 2020 09:30 [Places]

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.

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.

1 other event...

Date Availability
Thu 4 Jun 2020 09:30 [Places]

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.

A thorough awareness of issues relating to research ethics and research integrity are essential to producing excellent research. This session will provide an introduction to the ethical responsibilities of researchers at the University, publication ethics and research integrity. It will be interactive, using case studies to better understand key ethical issues and challenges in all areas. There are three sessions running, you need attend only one.

1 other event...

Date Availability
Fri 15 May 2020 10:00 [Places]
Develop your Career: Interview Techniques Mon 3 Feb 2020   09:30 [Full]


This course prepares you to excel at interview. You will learn how to anticipate questions you will be asked and plan how to answer them successfully. You will also learn how to project yourself positively and feel as calm and in control as you will look.

This course is highly participative and will include a short mock interview as well as an opportunity to share experiences with other course members.

The focus of the course is to provide participants with the generic skills necessary to succeed at interview in a variety of contexts.

Looking back at your experience of education you can probably remember those teachers and lecturers who were excellent. We remember the ones who were good because they have left a lasting impact on us; shaping both our learning in the past and our approach as teachers. Supervising undergraduate students at Cambridge can be one of the most rewarding activities for PhDs and Postdocs and this course is designed to make sure that you can offer your best and hopefully be one of those memorable teachers for someone else.

This blended workshop incorporates personal reflection on teaching practice, discussion of real teaching scenarios, a chance to ask questions of an experienced supervisor and access to practical information about organising and carrying out your supervisions.

This training is required by many colleges before you can carry out supervisions and is always a popular course.

1 other event...

Date Availability
Fri 3 Apr 2020 10:00 [Places]

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.

[Back to top]