Microsoft Excel Beginners Course​

Overview

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:

Training Outcomes

  • 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.

Add These Skills To Your Skill Set