Excel 2003: 4 levels (work books + CDs) Loan
SVI workbook tutorials on the spreadsheet package Microsoft Excel 2003. Files for the exercises are provided on CDs.
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.
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.
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.
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.
Booking / availability