Microsoft Excel Intermediate Course​

Overview

This Microsoft Excel Intermediate Course is intended for people who need to enhance spreadsheet appearance using a Graphical User Interface (GUI)-based spreadsheet application either as a user of computers or as basic knowledge for a career needing this competency, like the ICT industry.

The qualifying learner will be capable of:

  • Create and edit a graph/chart
  • Load data from an external data source to produce a given spreadsheet result
  • Insert and edit objects in a spreadsheet

Training Outcomes

  • The major graph types are defined in terms of their purpose. Graphs to be defined are the pie chart, bar graph, column graph, line graph, scatter plot and area plot.

  • A graph is created from a given data source.

  • A graph is edited. Properties to be edited include but not limited to graph title, axis titles, data labels, background colour, line or bar colour.

  • The graph type is changed.

  • A graph is copied and moved based on given specifications.

  • A graph is resized.

  • A graph is deleted from a spreadsheet.

  • The external data file is checked to ensure that the input into a spreadsheet will achieve the required results.

  • The format of the input file is determined to ensure correct input into a spreadsheet.

  • The data is copied into the spreadsheet.

  • The resulting spreadsheet is in accordance with the given spreadsheet result.

  • Insert an object like a picture, image, chart, auto shape into a spreadsheet.

  • A selected object is manipulated in a spreadsheet.

  • Use a drawing tool to draw an object in the spreadsheet.

Add These Skills To Your Skill Set

Register Now