Search Current Jobs:

MS Excel Level 1

     

Course Description:

This course will provide participants with the necessary skills to create basic spreadsheet documents and workbooks using Microsoft Excel 2007. Training will cover creating a new workbook, adding and editing data, working with basic formulas, turning your data into charts and printing documents.

Course Duration:

Cost:

Prerequisites:

Whilst this course is designed for participants who have never created spreadsheets and workbooks, some knowledge of personal computers and some experience in the use of a keyboard and mouse in Microsoft Windows are required.

Methodology:

This course is delivered in a classroom style learning environment. All work is hands on and participants will work through interesting examples and scenarios as part of their learning process.

Learning Outcomes:

At the completion of this course, participants will be able to:

  • Have an understanding of the basic Excel environment
  • Create a new workbook
  • Navigate within workbooks and worksheets
  • Make changes to existing data in a workbook
  • Use basic formulas to perform calculations
  • Understand ranges
  • Move data within a workbook
  • Format data within a workbook
  • Print the workbook
  • Create basic charts

Course Outline:

  • What does Excel look like?
  • Create a new workbook
  • Moving around a workbook
  • Basic editing techniques
  • Developing basic formulas
  • Selecting areas and ranges within a workbook
  • Copying data
  • Basic formatting techniques
  • Cell alignment
  • Printing
  • Creating basic charts