Find what you need, at the tip of your fingertips.

Welcome     Call 0112178825      Follow us

Image Alt

Courses

  /    /  Course Outline’s  /  MICROSOFT EXCEL ESSENTIALS
MICROSOFT EXCEL ESSENTIALS

R1,700.00

Category:

Description

COURSE OUTLINE:
COURSE NAME: MICROSOFT EXCEL ESSENTIALS
(This course is unit standard aligned but ONLY a certificate of Attendance will be issued – NO assessment option)
US ID: 116937
US Title: Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets
NQF LEVEL: 2 – Basic
NQF CREDITS: 4
COURSE LENGTH: 1 Day

COURSE DESCRIPTION:
Using Microsoft Excel to produce spreadsheets

LEARNING ASSUMED TO BE IN PLACE:

  •  Read, write, communicate and comprehend at least at GET level.
  •  Operate a personal computer system.
  •  Use generic functions in a Graphical User Interface (GUI)-environment. (PC’s and Windows Essentials)

TEACHING METHODOLOGY:

  •  Interactive learning based on outcome-based education approaching
  •  Facilitation approach during classroom training
  •  Visual aids – the use of multiple visual aids are promoted incl. slides, whiteboard, flipchart, video, audio
  •  Questioning techniques used – open-ended questions, discussions, analyzing, comparisons, own opinions, conflict resolution, work-based examples, clarifications

COURSE OUTLINE:
Learning unit 1: Spreadsheet Principles
Module 1: What is a Spreadsheet?
Module 2: What documents would you produce using a spreadsheet?
Module 3: Why use a spreadsheet application?
Module 4: What are the names of some spreadsheet programmers?

Learning unit 2: Starting with Spreadsheets
Module 1: Starting the programme
Module 2: Understanding the Screen
Module 3: The Mouse Pointer
Module 4: Using the keyboard to move around the screen
Module 5: Entering data on a spreadsheet
Module 6: Regional Settings
Module 7: Editing data on a spreadsheet
Module 8: Entering data using the automatic fill

Learning unit 3: Working with File commands
Module 1: Saving a workbook
Module 2: Closing a workbook
Module 3: Opening an existing workbook
Module 4: Starting a new blank workbook
Module 5: Saving changes to a workbook
Module 6: Saving a workbook with a Different Name
Module 7: Saving an Excel file in a different file format
Module 8: Deleting an Excel workbook file
Module 9: Exit the spreadsheet programme

Learning unit 4: Formatting Spreadsheets
Module 1: Selecting cells for changes
Module 2: Formatting Columns
Module 3: Formatting Rows
Module 4: Aligning data
Module 5: Changing Number Formats
Module 6: Changing Fonts, Sizes, Styles and Colours
Module 7: Setting Borders

Learning unit 5: Producing Spreadsheets with formulas
Module 1: Entering Formulas
Module 2: Filling Formulas
Module 3: Using Functions
Module 4: Checking your work

Learning unit 6: Editing Spreadsheets
Module 1: Inserting or Deleting Rows or Columns
Module 2: Cutting and Copying
Module 3: Using the Clipboard

Learning unit 7: More features
Module 1: Check your spelling
Module 2: Auto Correct
Module 3: Finding and replacing text
Module 4: Getting Help

Learning unit 8: Printing a Spreadsheet
Module 1: Previewing the spreadsheet
Module 2: Page settings
Module 3: Margin settings
Module 4: Header and Footer settings
Module 5: Sheet settings
Module 6: Printing a worksheet

Learning unit 9: Create and edit a graph/chart
Module 1: Why do we use charts/graphs?
Module 2: Chart Terminology
Module 3: Creating a Chart
Module 4: Setting the Chart type
Module 5: Chart Titles
Module 6: Chart Location
Module 7: Moving, Resizing and Deleting charts as Objects
Module 8: Formatting a Chart
Module 9: Printing charts

Reviews

There are no reviews yet.

Be the first to review “MICROSOFT EXCEL ESSENTIALS”

Your email address will not be published. Required fields are marked *

User Registration

You don't have permission to register

Reset Password