skip to navigation skip to content
Self-taught course

Provided by: University Computing Service


Booking

This course is self taught (Materials may be loaned out).

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



Booking / availability

Excel 2003: 4 levels (work books + CDs)
Loan


Description

SVI workbook tutorials on the spreadsheet package Microsoft Excel 2003. Files for the exercises are provided on CDs.

Introduction

This module covers the basic features of Microsoft Excel. Topics covered include building a new worksheet, modifying an existing worksheet, using worksheet shortcuts, enhancing the worksheet's appearance, enhancing the printed output.

Intermediate

Topics covered include using Excel functions, creating a custom table, using absolute cell references, creating a chart, working with a database, controlling the worksheet display, using Excel Internet features.

Advanced

Topics covered include linking worksheets within a workbook, linking multiple workbooks, using range names, customizing Excel, using the Scenario Manager, using logical and lookup functions, using financial functions, manipulating text strings, analyzing data and using Excel's drawing tools.

Macros

Creating and using macros, using Visual Basic to write macros, placing controls on a worksheet, creating a custom macros toolbar, creating a custom macros menu, using the Visual Basic Help system.

Theme
Spreadsheets

Booking / availability

Override user: