Microsoft Excel Beginners Course
This Microsoft Excel Beginners Course is intended for people who need to create and edit spreadsheets using a Graphical User Interface (GUI)-based spreadsheet application either as a computer user or as basic knowledge for a career needing this competency for example the ICT industry.
The qualifying learner will be capable of:
The spreadsheet is defined in terms of its purpose and use.
Examples of spreadsheets that can be produced using a spreadsheet application are provided.
The benefits of using a spreadsheet application for producing and working with spreadsheets are explained.
Examples of spreadsheet programs are named.
Properties of a spreadsheet are identified and described in terms of its purpose and use.
The spreadsheet application program is opened.
A new spreadsheet is created.
Methods of moving the cell cursor are demonstrated in order to move about the spreadsheet.
Saving spreadsheets is explained in terms of their purpose and the destination of the saved file.
- The spreadsheet is saved with a specific name in a specific folder.
The spreadsheet is closed.
An existing spreadsheet is opened and closed.
The spreadsheet application program is closed.
A spreadsheet is produced with the required data from the given specification. Types of data include text, numbers, and dates.
A formula is entered to achieve the given specification. Types of formulae that will be assessed include addition, subtraction, division, multiplication, and sum.
The differences between data cells, label cells, and formula cells are explained.
The spreadsheet is in accordance with the given specifications.
Practices are demonstrated to ensure the integrity of the data.
The benefits of saving a file in different formats are explained. Formats include text, CSV, HTML, other software versions, other software types.
A spreadsheet is saved in a different format.
An existing spreadsheet is opened.
Cells are selected for manipulation and de-selected. This includes selecting a single cell, cell range, an entire column, an entire row and an entire spreadsheet.
Cells are manipulated.
Use the automatic fill feature to automatically enter data in cells.
Text is located and replaced in a spreadsheet by using features of the application.
Cells are formatted using the formatting features of the spreadsheet application.
Formatting features include the following: Style, Alignment, Font, Background colour, at least one option listed out of each formatting feature must be performed: Style (Text, number, date, currency, percentage), Alignment (left, centre, right, justified, text direction), Font (type, size, style – italic, bold, underlined, colour, strikethrough, superscript, subscript), Background colour.
Rows are formatted. Formatting features include height and automatic fit.
Columns are formatted. Formatting features include the width and automatic fit.
The dictionary to be used for spelling and word usage is set up.
Text is entered and corrected automatically while entering.
Text is checked for spelling and grammar and corrections made based on judgement.
Words are added to the custom dictionary.
The printing of gridlines is altered.
A row is selected to print on each page of the printed spreadsheet.
Different ways of printing sheets within a spreadsheet are demonstrated, according to given specifications.