Microsoft Excel Introduction

COURSE CODE SP110

 

COURSE OBJECTIVE

This course covers the concepts and techniques of spreadsheets using Microsoft Excel. On accomplishing the course, delegates will be able to produce spreadsheets using the full range of Excel features including graphs.

WHO SHOULD ATTEND

The course is well-suited for those with little or no previous experience of spreadsheet concepts. The course is also suitable for delegates who are familiar with other spreadsheets packages but need to migrate to Excel.

COURSE OUTLINE

• The Excel Spreadsheet
  • The Excel Screen
  • Pull Down Menu Options
  • Direction Keys
• Saving and Retrieving a Spreadsheet
  • Filenames and Directory Listings
  • Default Settings
• Printing
  • The Print Options
• Creating a Spreadsheet
  • Types of Data
  • Headers, Footers and Margins
  • Guidelines for Entering Data
  • Large and Multiple Documents
  • Partial Documents
  • Alignment in Worksheets
• Deleting and Changing Cells
  • Entering Array Formula
  • Arithmetic Formulae
  • Copying Formulae
• Excel Charts
  • Creating Simple Charts
  • Chart Formatting
• Creating a Pivot Chart
• Formatting a Spreadsheet
  • Adding, Deleting and Matching
  • Adjusting Column Widths, Heights and Records
• Inserting and Deleting Columns
• Hiding, Freezing and Redisplaying Columns
• Using Date and Time Formats
• Currency Formatting
• Excel Database
  • Editing and Searching the Database
  • Sorting a Database
• Advanced Excel
  • Creating macros
  • Importing and Exporting Data

Axiom-MSS   
Tel: 01903 266675, email: axiom.mss@tiscali.co.uk