Microsoft Excel Level 1 Training Course

Overview

This course introduces delegates to the basic functions of Microsoft Excel and will enable them to create worksheets and perform formatting and functions within the worksheet.

Audience

This course is designed for people who wish to gain the skills necessary to create, edit, format and print basic Microsoft Excel worksheets.

Learning Objectives

By actively participating in this course, you will learn about the following:

• Navigate the Excel programme.

• Perform selection, manipulation and formatting techniques.

• Understand and create basic formulas and functions.

• Understand and create basic charts.

• Perform customisations.

Prerequisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer.

Specifically, you should be able to launch and close programs, navigate to information stored on the computer, and manage files and folders.

Course Contents

• Getting started with Excel

• Selection techniques

• Manipulating rows and columns

• Worksheets

• Font formatting

• Alignment formatting

• Number formatting

• Freezing row and column titles

• Formulas

• Functions

• Charts

• Customising Microsoft Excel