Excel 2007: Level 2 (Win) (workbooks)

This course shows you how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions, and to use the sorting and filtering features to manage and analyse data. This course is intended for current Microsoft Excel 2007 users who wish to extend their knowledge and skills beyond building simple workbooks.

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

Microsoft Excel 2007 Level 2 is designed for current Excel users who can build basic workbooks. It is assumed that the user will know how to create and save a workbook, enter simple formulas, and print and chart data.

• Filling Data
• Formula Referencing
• Cell Alignment
• Working With A Worksheet
• Finding And Replacing
• Page Setup
• Headers And Footers
• Sorting Data
• Charting Techniques
• Chart Object Formatting
• Logical Functions
• Lookup Functions
• Formula Techniques
• Setting Excel Options
• Filtering Data

• Use the fill operations available to fill a data series
• Understand and use formula cell referencing to create more complex formulas
• Align the contents of cells in a number of ways
• Work with various elements of a worksheet
• Use a range of find and replace techniques
• Apply a variety of page setup techniques
• Create and work with headers and footers
• Sort data in a list in a worksheet
• Use a range of techniques to enhance charts
• Use a range of logical functions
• Use a range of lookup and reference functions
• Use a range of formula techniques
• Modify excel options
• Filter data in a table

• Office 2010
• Spreadsheets