Excel 365: for Complete Beginners - (Live Online using MS Teams)

BeginnersPrerequisites

This is an online instructor-led course to 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).

For those who prefer to self-study there is an online course from LinkedIn Learning, the course can be accessed here. Sign in with your CRSid@cam.ac.uk email and Raven password.

• All current Cambridge University members (departments and colleges)
• Further details regarding eligibility criteria are available

• Basic computer skills i.e. familiarity with using a keyboard and mouse will be assumed.
• The course is aimed at beginners - no previous knowledge or experience of the software is assumed.

Number of sessions: 2

Session 1

• Building a new workbook (data entry and simple formulae)
• Modifying an existing workbook
• Enhancing the appearance of a worksheet

Session 2

• Data Formatting
• Worksheet Techniques
• Page Setup for Printing

Instructor-led, hands-on, working from a workbook.

The course will be taught using Excel on a Windows PC, but will also be suitable for Apple Mac users. It is helpful to use two screens attached to your computer if available, the Teams meeting should be on one screen and the learning materials on the other screen. Please contact your instructor if you need advice regarding your computer set up.

Two hours.

• LiL: Excel - 2019 Essential Training (Online)
• Excel 365: Managing Data & Lists (In Person Face to Face)
• Excel 365: Analysing & Summarising Data (In Person Face to Face)
• Excel 365: Pivot Tables (In Person Face to Face)

• Office 365
• Spreadsheets