Nova - I.T.

Excel

Use Excel as a spreadsheet, database or graphing application. Create sophisticated calculations and formulae to recalculate automatically. 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. Excel can sort lists and select specific pieces of information based on specified conditions.

Introduction level

includes:

  • spreadsheet concepts
  • workbooks and worksheets
  • selecting cells
  • entering and editing data
  • calculations and formulae
  • shortcut techniques
  • moving and copying data
  • printing
  • page setup

Intermediate level

includes:

  • Managing worksheets
  • paste special
  • ranges
  • charts
  • sorting
  • comments

…and more!

Advanced level

includes:

  • outlines
  • database tools
  • advanced filters
  • charts
  • linking workbooks
  • scenarios
  • macros

…and more!

SuperTips

Learn lots of shortcuts and tips to help you speed up your existing knowledge of Excel.

(Back to course list)