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
Download Course Files
Booking / availability