Excel Level 1
18 Nov 2020 [change course]

  1. 1: Course
  2. 2: Attendees
  3. 3: Terms
  4. 4: Confirm & Pay

Register for this Course


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)

Course Price per Person GBP exc. VAT Attendees
Excel Level 1
18 Nov 2020
Price per Person: £245.00 exc. VAT
Promo Code:
Subtotal: -
Promo Code
Net Total: -