Microsoft Office Excel Training

Administrative staff of all levels
Entry level and experienced staff welcome
Basic PC knowledge is required.

Targetted learning makes for effective and quick grasp of the fundamentals!

Objectives:
Upon completion of this course, you will be able to work with Microsoft Excel 2003/2007 effectively for managing data and records, and performing essential work calculations.
These skills will also be applicable to forward versions of MS Excel.

• Introduction to MS Excel
  • The Excel Screen
• Working with Cell and Cell Data
  • Cell references
  • Entering Data
• Managing Data and Content
  • Making amendments
  • Understanding Ranges
  • Formatting tables
• Modify Row and Column Formats
  • Smart Tags
  • Aesthetic adjustments
  • Formatting Text and Colours
  • Merging data
• Managing Workbook
  • Naming and colouring sheets
  • Borders
• Previewing and Printing
• Basic Formula and Functions
  • Calculations
  • Comments
  • Hyperlinks
  • Data protection
• Working with Charts
• Tips & Tricks