Overview: Microsoft Excel 97 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 introduces customising Excel preferences, using & managing large worksheets, 3D formulas, paste special, using outline, working with named ranges, using names in formulas, using 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