Excel 2010: Level 1 (Win) (Workbook and CD)

Loan

This course is designed for users new to Microsoft Excel 2010 and spreadsheeting.

This course aims to give the new spreadsheet user a thorough grounding in the basics of spreadsheeting and using Microsoft Excel 2010. Particular emphasis is placed on the importance of accuracy, good formula building techniques, and sound formatting and design principles. It is ideal for people who work in offices, clubs or charities where there is a requirement to produce reports, budgets and lists, using formulae for automated calculations and the like.

Watsonia workbook tutorials. Files for the exercises are provided on CDs.

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

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2010. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

• Getting To Know Excel
• Creating A New Workbook
• Working With Workbooks
• Selecting Ranges
• Formulas And Functions
• Copying Data
• Formula Referencing
• Font Fomatting
• Cell Alignment
• Row And Column Formatting
• Number Formatting
• Printing
• Creating Charts

At the completion of this course you should be able to:

• navigate your way around Microsoft Excel 2010
• create a new workbook
• open and navigate within workbooks and worksheets
• understand and work with ranges in a worksheet
• understand, create and work with formulas and functions used to perform calculations
• copy and paste data in Excel
• understand and use formula cell referencing to create more complex formulas
• use font formatting techniques to greatly enhance the look of a worksheet
• align the contents of cells in a number of ways
• format rows and columns in a worksheet
• understand and use the number formatting features in Excel
• print your workbook data
• create effective charts in Microsoft Excel

146 page workbook and CD

Many of the topics in Microsoft Excel 2010 Level 1 require you to open an existing file with data in it. These files can be downloaded from our web site, but are also included on a CD at the back of the book.

Please refer to the information page for self-taught loan courses

• Roger Needham Building
• New Museums Site

Download Course Files

• Excel 2016: Introduction (Self-paced)
• Excel 2016: Introduction
• Excel 2016: Managing Data & Lists
• Excel 2016: Analysing and Summarising Data