Excel Level 1


One Day

Suitable for

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


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.


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)


Show the next months in

Location Dates Price exc. VAT   Status
Please call us for the next available date for this course. Dates are added regularly and may not appear on this list. Tel: 020 7256 6668