Excel Level 1

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)

1

Show the next months in

Location Dates Price exc. VAT   Status
London 04 Sep 2019 £245.00

London

04 Sep 2019

£245.00 exc. VAT

 

Register Now » Available
Register Now » Available
London 25 Sep 2019 £245.00

London

25 Sep 2019

£245.00 exc. VAT

 

Register Now » Available
Register Now » Available
London 30 Oct 2019 £245.00

London

30 Oct 2019

£245.00 exc. VAT

 

Register Now » Available
Register Now » Available
London 27 Nov 2019 £245.00

London

27 Nov 2019

£245.00 exc. VAT

 

Register Now » Available
Register Now » Available
London 18 Dec 2019 £245.00

London

18 Dec 2019

£245.00 exc. VAT

 

Register Now » Available
Register Now » Available
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