website by UTD Web Design, Waterford, Ireland

Description: Introduction to Microsoft Excel Training Course

Contents

The objective of this course is to become familiar with basic spreadsheet production and editing

The Fundamentals
  • What is a spreadsheet
  • Typing in Excel
  • Saving
  • Print Preview and Print
  • Finding, Opening, Managing Files
Formulae
  • Operators
  • Fill right and down
  • Using Autosum
  • Subtraction, Division, Multiplication
  • Average, Maximum & Minimum, Count
  • Absolute Cell References
Formatting
  • Text and Number Formatting
  • Merge & Centre
  • Currency 
  • Lines, Borders, Columns and rows
  • Margins and Page Setup
  • Headers & Footers
Charts
  • Creating a chart with Excel data
  • Enhancing your chart
  • Linking Chart to a Word document
  • Printing your chart

Note: Where possible, courses can be tailored and designed to meet the needs of the participant/group in order to maximise the knowledge gained from the programme.

Duration: