Excel 2016: Introduction (Self-paced)

BeginnersPrerequisites

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 .

• 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.

• 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

Self-paced hands-on, working from a workbook

Excel 2016 on MCS Windows

• The course will be taught using Excel 2016 on PCs but will also be suitable for Excel 2010/2013 users. Apple Mac users of Excel 2011/2016 should also find it useful
• Participants work at their own pace using a workbook containing notes and exercises
• Most participants will complete the material in the two timetabled sessions during which help and advice are available. However, the length of time taken will vary according to previous experience, so the facilities will remain available for informal use for a further week after the formal sessions; alternatively the course files can be copied to CD or memory stick (not supplied) so that the exercises can be completed on other machines or course files can be downloaded here
• Please note that this self-paced course is generally run alongside the Word 2016 Introduction course as the instructor can assist in both courses

Two sessions of three hours

• Excel 2016: Analysing and Summarising Data
• Excel 2016: Functions
• Excel 2016: Introduction
• 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