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.