Excel 2016: Introduction

BeginnersPrerequisites

Bookings for this course are placed on hold in response to the rapidly changing events due to COVID-19. The status of these courses will be reviewed towards the end of April 2020. See the University's COVID-19 page for up to date information.

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.

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

• Basic computing skills

• Building a new workbook (data entry and simple formulae)
• Modifying an existing workbook
• Worksheet shortcuts (AutoFill, copying and moving cells, inserting and deleting rows and columns, AutoSum)
• Enhancing the appearance of a worksheet
• Preparing for print

• Presentations, demonstrations and practicals

Excel 2016 on MCS Windows

• This course will be taught using Excel 2016 on PCs but Excel 2010/2013 and Macintosh users of Excel 2011 should also find it useful
• Anyone wishing to copy the course exercise files should bring a USB memory stick or they can be downloaded here

• One half day session

• Excel 2016: Analysing and Summarising Data
• Excel 2016: Functions
• Excel 2016: Introduction (Self-paced)
• Excel 2016: Managing Data & Lists
• Excel 2016: Recorded Macros
• Office 2016: Excel, Word and PowerPoint Top Ten Tips
• Office 365, Office Online and OneDrive: An introduction