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
Events available