MICT-Microsoft Office Excel Basic

  • Overview
  • Outcome
  • Content
Course Duration: 2 Days
Download course outline →

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

Course Duration: 2 Days
Download course outline →

After completing this course, the learner will be able to:

  • Define spreadsheet in terms of its purpose and use.
  • Name examples of spreadsheet programs
  • Provide examples of spreadsheets that can be produced using a spreadsheet application.
  • Explore MS Excel
  • Explain the benefits of using a spreadsheet application for producing and working with spreadsheets.
  • Identify and describe the properties of a spreadsheet.
  • Explain the performance of work elements within set standards and procedures.
  • Create a spreadsheet.
  • Edit a spreadsheet.
  • Format a spreadsheet.
  • Check and print the spreadsheet.
Course Duration: 2 Days
Download course outline →
  • Define spreadsheet in terms of its purpose and use
    • Nature of electronic information
    • Implications of application and formatting settings
  • Name examples of spreadsheet programs
  • Provide examples of spreadsheets that can be produced using a spreadsheet application
  • Explain the benefits of using a spreadsheet application for producing and working with spreadsheets
  • Explore MS Excel
    • Locations and functions of menu items in MS Excel
    • OneDrive
    • Terms used in MS Excel
    • Preserving documents
  • Identify and describe the properties of a spreadsheet
  • Explain the performance of work elements within set standards and procedures
    • Comply with organisation standards and procedures
    • Comply with ethical codes of relevant professional bodies
    • Comply with the laws of South Africa
    • Comply with time and cost requirements expected
    • Class Activity: Understand the principles of spreadsheets
  • Create a spreadsheet
    • Open MS Excel
    • The differences between data cells, label cells, and formula cells
    • Methods of moving the cell cursor in order to move about the spreadsheet
    • Close the spreadsheet
    • Open and close an existing spreadsheet
    • Create/produce a new spreadsheet
      • Use spreadsheet specifications
      • Set out conventions used in a given scenario
    • Enter formulae
      • Addition
      • Subtraction
      • Division
      • Multiplication
      • Sum
    • Demonstrate practices to ensure the integrity of the data
      • Check totals and Audit formulae
      • Set properties in order to protect the integrity of the file
      • Password protect a workbook
      • Track Changes
    • Save a spreadsheet
      • To save a workbook
      • Using Save As to make a copy
      • The benefits of saving a spreadsheet in different formats
      • Save a spreadsheet in a different format
    • Close MS Excel
    • Class Activity: Create a spreadsheet
  • Edit a spreadsheet
    • Open an existing spreadsheet
    • Select and de-select cells for manipulation
    • Manipulate cells
    • Use the automatic fill feature to automatically enter data in cells
    • Locate and replace text in a spreadsheet
    • Class Activity: Edit a spreadsheet
  • Format a spreadsheet
    • Format cells using formatting features
      • Font
      • Alignment
      • Style
      • Number formatting
      • Background color
      • Built in styles
    • Format rows
      • Format row height
    • Format columns
      • Format column width
      • Automatic fit - columns
    • Class Activity: Format a spreadsheet
  • Check and print the spreadsheet
    • Set up the dictionary to be used for spelling and word usage (grammar)
    • Check text for spelling and grammar and make corrections
      • Check spelling and grammar all at once
    • Add words to the custom dictionary
    • Enter and correct text automatically while entering
    • Print a spreadsheet
      • Print the active sheet
      • Print the entire workbook
      • Change the Printing Settings
      • Print gridlines
      • Select a row to print on each page of the printed spreadsheet
    • Being proficient in MS Excel
    • Class Activity: Check and print the spreadsheet
Dates → Enquiries → Make a booking →