• Introduction to Computer Applications

Successful completion of Introduction to Computer Applications or equivalent

To upgrade the end user's skill in Excel to an Intermediate level.

At the end of the course, participants will be able to:

• Demonstrate proficiency in Microsoft Excel to an Intermediate Level

• Creating a worksheet
  • Starting Excel
  • The Excel worksheet
  • The Worksheet Window
  • Entering data (text, numbers)
  • Formatting the worksheet
  • Calculating a sum
• Formulae, functions and formatting
  • Order of operations
  • Entering and verifying formulae and functions
• What-if analysis
  • Absolute vs Relative addressing
  • The IF function
• Charting
• Working with large worksheets

Lectures, demonstration practical exercise

Class participation

Written and practical examination

Certificate of successful completion