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)
1Location | 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