Duration

One Day

Suitable for

This course is for anyone whowants to gain the skills to create, edit format and print basic MicrosoftOffice Excel worksheets.

Objectives

You will create and edit basic Microsoft Office Excel worksheets and workbooks. You will learn how to create formulas using a function plus an argument to calculate the data on the worksheet.

Programme

Lesson One – Getting Started with Excel

• Identify the Elements of the Excel Interface
• Navigate and Select Cells in Worksheets
• Customise the Excel Interface
• Create a Basic Worksheet

Lesson Two - Performing Calculations in an Excel Worksheet

• Create Formulas in a Worksheet
  • Relative, Absolute and Mixed Cell Referencing
• Use Functions within a Formula
  • Sum, Average, Max, Min and Count

Lesson Three – Modifying a Worksheet

• Edit Worksheet Data
• Find and Replace Data
• Manipulate Worksheet Elements

Lesson Four - Modifying the Appearance of a Worksheet

• Apply Font Properties
• Add Borders and Colours to Cells
• Align Content in a Cell
• Apply Number Formatting
• Apply Cell Styles

Lesson Five – Managing an Excel Workbook

• Manage Worksheets
• View Worksheets and Workbooks

Lesson Six – Printing Excel Workbooks

• Define the Page Layout
• Print a Workbook

Duration (in days)