Overview: Microsoft Excel 2000 is a software application that can be used as a spreadsheet, database, or graphing program. The electronic spreadsheet portion of Excel allows you to perform sophisticated calculations and create formulas that automatically calculate answers. The advantage of using formulas is that when data in the worksheet changes, all the formulas recalculate automatically. This feature assists you in developing budgets, forecasting models, creating sales plans, making financial projections, calculating inventories calculations, generating banking statements, and basically working with any format involving numbers.

The Intermediate course follows on from the Introduction course and covers the more advanced features of this package including customising Excel, working and managing worksheets, sorting data, working with outlines, using name ranges, paste special, other functions and more.

Customising Excel Preferences

Using Large Worksheets

Managing Worksheets

Managing Data - Sorting, Finding, Replacing

Working with Outlines

Using Paste Special

Using Range Names

Working with Labels in Formulas

Using AutoFilter

Using AutoShapes

Using Other Functions

Using Conditional and Custom Formats

Using Multiple Workbooks