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

Loan

Microsoft Excel 2010 Level 2 is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

Microsoft Excel 2010 Level 2 is the second of a 3-Level study program for Microsoft Excel 2010. This level extends the learner's basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks. Files for the exercises are provided on CDs.

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

Microsoft Excel 2010 Level 2 is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

• Filling Data
• Moving Data
• Formula Techniques
• Number Formatting Techniques
• Conditional Formatting
• Applying Borders
• Page Setup
• Working With A Worksheet
• Worksheet Techniques
• Finding And Replacing
• Sorting Data
• Filtering Data
• Charting Techniques
• Chart text Formatting

At the completion of Microsoft Excel 2010 Level 2 you should be able to:

• use the fill operations available to fill a data series
• move the contents of cells and ranges within and between workbooks
• work with logical function in Excel
• use a range of formula techniques
• apply a range of number formatting techniques to data
• apply conditional formatting to ranges in a worksheet
• apply borders to cells and ranges
• apply a variety of page setup techniques
• work with various elements of a worksheet
• use a range of techniques to work with worksheets
• use a range of find and replace techniques
• sort data in a list in a worksheet
• filter data in a table
• use a range of techniques to enhance charts
• apply formatting techniques to text on charts

180 page workbook and CD

Many of the topics in Microsoft Word 2010 Level 2 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