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