skip to navigation skip to content
Self-taught course

Provided by: University Computing Service


Booking

This course is self taught.

Bookings cannot be made on this course (Course is not taking bookings).



Booking / availability

Excel 2007: Level 2 (Win) (workbooks)

Self-taught course

Description

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.

Prerequisites

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.

Topics covered
  • 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
Objectives
  • 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
Themes

Booking / availability

Override user: