UCL Learning Portfolio

These campus-based workshops take a new approach to learning by presenting you with a problem to be solved and encouraging you to use your prior experience, web searches, in-application help, and fellow participants to find a solution to the task.

By the end of the session you will have improved problem-solving skills, increased knowledge of the topic, a suggested solution to the problem you worked on and some resources and guidance for further learning.

PREREQUISITES:

You must have completed Excel Essential Skills - WORKSHOP 2 before participating in this workshop.

Once you have been invited to enrol, and enrolled, please check that you have received a confirmation email from MyLearning. You will also receive an email with location details at least one day before the session.

Please arrive 10 - 15 minutes prior to the start of the course to allow time for logging in and downloading resources.

For more details on how to book, cancel and join sessions please visit our practical course information page .

• Name a cell or range of cells and make changes to names
• Use conditional formatting
• Use aggregate functions to find minimum, maximum and average values
• Use Excel's Quick Analysis tool
• Use the IF and AVERAGE IF functions
• Use Excel's Insert Function wizard
• Perform calculations involving dates
• Use a function to round values up or down