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