Browse or search for courses

An interactive workshop, focusing on providing service for both internal (colleagues) and external (readers) customers.

Microsoft Excel is great for storing and organising your data, but it can be time-consuming and frustrating to find the information you need.

This workshop will show you how to use Excel's powerful tools to quickly retrieve, view and summarise information in numerous ways.

We will cover:

• Ensuring accurate data entry with data validation
• Time-saving filters
• Visually explore and analyse data using conditional formatting
• Create interactive filters in PivotTables
• Present your information as a chart
• Dos and don'ts when working with data
• Time-saving tricks and shortcuts

The course includes access to a month's free support on any of the topics covered.

Microsoft Excel has lots of underutilised features that can help to save time and improve productivity. The primary objective of this workshop is to show you how to use these features and to demonstrate their effectiveness, challenging you to do things differently.

We will cover:

• Working with Formulas and Functions
• Save time and apply Formulas and Functions to your everyday tasks
• Search for a value in one place and insert it in another using lookup functions
• Avoid the 'pitfalls' of relative cell references
• Test certain conditions and return one of two entries
• Work with named cells to work faster and smarter with your formulas
• Managing large workbooks
• Trace and audit formulas in a worksheet
• Create a simple dashboard
• Produce summary reports from different worksheets
• Merge data from multiple users by linking workbooks

The course includes access to a month's free support on any of the topics covered.

This course aims to provide trainers with guidance and tips for developing and delivering training in bioinformatics, exploring a range of methods appropriate to different learning styles and examining the requirements for a successful course (both scientific and logistic).

This event is organized as part of the Horizon 2020 ELIXIR-EXCELERATE project.

The training room is located on the first floor and there is currently no wheelchair or level access available to this level.

Please note that if you are not eligible for a University of Cambridge Raven account you will need to Book or register Interest by linking here.

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

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.

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.

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 .

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

This course covers recording macros which provides automated steps to produce outcomes. This course does not teach VBA programming, if you want to learn VBA 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.

This is an essential course if you carry out data analysis in Excel. You will work with tools and learn new skills that saves time when analysing and summarising data and plotting this on Charts.

• This is the In Person Face to Face version of the Live Online Excel Analysing and Summarising 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 hands-on course is a follow up from the Excel 365: For Beginners and Improvers course which comes in 2 forms:

• In Person Face to Face
• Live Online

• See Related Courses below to take your skills further

This is an essential course if you carry out data analysis in Excel. You will work with tools and learn new skills that saves time when analysing and summarising data and plotting this on Charts.

• This is the Live online version of the In Person Face to Face classroom based instructor led course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information.

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 hands-on course is a follow up from the Excel 365: For Beginners and Improvers course which comes in 2 forms:

• In Person Face to Face
• Live Online

• See Related Courses below to take your skills further

This is course will 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, however those that use Excel at a basic level will also learn new tricks and tips which will serve them well in saving time day to day and increasing knowledge.

• This is the In Person Face to Face version of the Live Online 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.

• See Related Courses below to take your skills further

This course will 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).

• This is the Live online version of the In Person Face to Face classroom based instructor led course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information.

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.

• See Related Courses below to take your skills further and also to see what other alternative self study options there are to this course.

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.

• This is the In Person Face to Face version of our Live Online 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.

• See Related Courses below to take your skills further

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.

• This is the Live Online version of the In Person Face to Face 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.

• See Related Courses below to take your skills further

Want to make it easier and more efficient when working with data in Excel? You'll e surprised how much you can do with Excel when managing your data. You will learn tips and tricks that will save you time over the course of your studies/career which can be transferred to home live too.

• This is the In Person Face to Face version of the Live Online 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.

• See Related Courses below to take your skills further

Want to make it easier and more efficient when working with data in Excel? You'll e surprised how much you can do with Excel when managing your data. You will learn tips and tricks that will save you time over the course of your studies/career which can be transferred to home live too.

• This is the Live online version of the In Person Face to Face classroom based instructor led course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information.

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.

• See Related Courses below to take your skills further

This course offers an introduction to the power and time-saving value of PivotTables and will appeal to anyone who analyses data in Excel, come and explore their magic. People who get Pivot Table under their belt cannot imagine the usage of Excel without them. If pivot tables and their capacity are a mystery to you, this course is for you.

• This is the In Person Face to Face version of the Live Online Excel: Pivot Tables 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.

• See Related Courses below to take your skills further

This course offers an introduction to the power and time-saving value of PivotTables and will appeal to anyone who analyses data in Excel, come and explore their magic. People who get Pivot Table under their belt cannot imagine the usage of Excel without them. If pivot tables and their capacity are a mystery to you, this course is for you.

• This is the Live online version of the In Person Face to Face classroom based instructor led course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information

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.

• See Related Courses below to take your skills further

This instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Excel. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.

• This is the In Person Face to Face version of the Live Online Excel: Top Tips

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.

• See Related Courses below to take your skills further

This instructor-led course is for people who want to keep up to date with newer or the lesser-known features of Microsoft Excel. It is a quick fire succession of topics at a fast pace and aimed at those who are comfortable using computers.

• This is the Live online version of the In Person Face to Face classroom based instructor led Excel: Top Tips course.

Please note that the course is taught using Microsoft Teams and you must have Teams installed on your computer to participate. See System requirements below for more information.

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.

• See Related Courses below to take your skills further

Delegates will learn how to use shortcuts in Excel to improve their productivity, and also techniques for analysing complex data quickly by using pivot tables.

Ndunge will provide an insight on utilising data-driven approaches to enhance workforce inclusivity through EDI initiatives, fostering an environment of excellence and equality.

Please note that this session will be recorded and details will follow after the session. There will be an opportunity to discuss points and ask questions once the recording has ended.

A recommended course by the Digital Literacy Skills Programme as part of the University of Cambridge's subscription to LinkedIn Learning.

The course can be accessed here.