23+ Years of Professional Service – Fully Accredited, Quality Guaranteed!
MS-Excel2018-10-18T03:29:26+00:00

MS-Excel

This program is provided at Basic, Intermediate and Advanced Level.
Please see the Course Outlines
Also note the Prerequisites [Course Readiness Requirements – What Learners need to already know without struggle]

MS-Excel is a powerful electronic spreadsheet program used to streamline, organize, calculate, forecast; and convert raw data into meaningful information, easily projected as useful and notable documents. The strength of this application is in its analytical features; used in business; and in achieving student learning outcomes and preparing them for real business environment.

MS-Excel is rich in numerous categories of features and functions; not limited to the following:
Formula and categories of functions; sort and filter data; evaluating and cleaning dirty data; data entry validation and custom messages; Lookup functions; Pivot Table and Charts; Import and Export; Automatic Reports; Dashboards etc…

MS-Excel also provides suitable content-related predesigned built-in templates; relevant to all fields of business, education, and even home environment.
Templates are electronic forms, which serve the PC-Users, like free-hand capable assistants; to reflect intended tasks effectively and produce demanded documents more professionally. The ranges of built-in templates are from Budgets and Invoices, to a variety of Forms and even Calendars and Time-related electronic documents…

Just about every career has some use for MS-Excel. Learners who take this Course find it useful in all aspects of their career, especially when it comes to professional spreadsheets, reports and charts – Eg. Accounting data, Employee timesheets…

Best suited, but not limited to: Data Capturers, Bookkeepers and Financial Positions, Sales Reps, Engineers, Receptionist, Personal Assistant, Office Administrators, Students, Teachers, Head of Departments, Managers, Supervisors, and any home users who would like to perform any of the above…

Hot News

If you want the people to fully focus on formulas and features of Excel Basic ensure two up-to-date Courses or Refreshers are taken prior to taking MS-Excel Basic. These two essential, high recommended courses are:

  • CURRENT VERSION of Intro to Modern-PC; and
  • CURRENT VERSION of MS-Word Basic

Don’t Assume! Make sure where Learner stands – benefit our Assessment options!
Read More

Microsoft Excel: Is It An Important Job Skill for Students?

Reflected on ‘Information Systems Education Journal (ISEDJ) – ISSN: 1545-679X – 15 May 2017’:

Previous studies have found several skills such as communication and relationship building skills to be necessary in the workplace, while 80% of middle-skilled jobs have been found by online recruiters to require at least a basic understanding of MS-Excel skills.

Learning MS-Excel professionally, would assist a student to be successful in acquiring a job, in long term; and be better productive in service.

According to Geiger (2015) 78% of middle-skilled jobs require digital skills like MS-Excel. Middle-skilled jobs are fast growing job categories that place more emphasis on actual skills.

Course Outline: MS-Excel 2007/2010/2013/2016: Basic

Aligned with SAQA Unit Standard 116937 / 116940 / 116943 [& MOS / ICDL]

Prerequisites

Intro to Modern-PC, MS-Word Basic, or equivalent experience

Outline

Spreadsheet terminology – Discussing spreadsheet terminology

– Exploring the Excel window – Examining Excel window components
– Getting Help – Using Help
– Navigating workbooks – Navigating a worksheet

Entering and editing text and values
– Entering text and values
– Editing text
– Using AutoFill to fill a series

Entering and editing formulas
– Entering a formula by typing
– Entering cell references with the mouse
– Editing a formula

Working with pictures
– Inserting and modifying a picture

Saving and updating workbooks
– Saving a workbook
– Changing and updating a workbook
– Using the Compatibility Checker

Moving and copying data
– Moving data in a worksheet
– Copying data in a worksheet
– Moving and copying data by using drag-and-drop
– Copying data by using the Clipboard

Moving and copying formulas
– Moving a formula
– Copying a formula
– Using AutoFill to copy a formula

Absolute and relative references
– Observing the limitations of relative references
– Using absolute references

Inserting and deleting ranges, rows, and columns
– Inserting a range
– Inserting rows
– Deleting a range

Entering functions
– Entering a SUM function
– Using the mouse to enter a function argument
– Inserting a SUM function

AutoSum – Using the AutoSum button

Other useful functions
– Using AVERAGE
– Using MIN
– Using MAX
– Using COUNT and COUNTA

Formatting text
– Using the Font group to format text
– Formatting non-contiguous ranges
– Using the Format Cells dialog box to format text

Formatting rows and columns
– Changing column width and row height
– Applying color to a row
– Setting alignment
– Applying borders to ranges
– Using the border-drawing pencil
– Using the Paste Special option
– Removing a border

Formatting numbers
– Using the Number group to format numbers
– Exploring the Number tab

Conditional formatting
– Creating a conditional format
– Editing and deleting a conditional format

Copying formats and applying table formats
– Copying formats
– Using AutoFill to copy a format
– Applying cell and table styles
– Using Find and Replace to change cell formats

Preparing to print
– Checking spelling in a worksheet
– Using the Research task pane
– Finding and replacing text
– Previewing a worksheet

Page Setup options
– Setting page orientation
– Setting margins
– Creating and editing headers and footers
– Hiding gridlines and headings

Printing worksheets
– Printing a worksheet
– Working with the print area

Chart basics
– Creating a chart
– Moving a chart within a workbook
– Examining chart elements
– Using an embedded chart

Modifying charts
– Changing a chart type
– Applying Quick Layouts and Quick Styles
– Formatting chart elements
– Modifying an embedded chart

Printing charts

Viewing large worksheets
– Using the Freeze Panes command
– Splitting a worksheet into panes
– Hiding and unhiding columns and worksheets
– Minimizing the Ribbon

Printing large worksheets
– Setting print titles
– Adjusting page breaks

Using multiple worksheets
– Navigating between worksheets
– Naming worksheets and colouring tabs
– Working with multiple worksheets
– Previewing and printing multiple worksheets

Overview on “What is New” in MS-Excel 2013/2016

Download Basic Course Outline

Course Outline: MS-Excel 2007/2010 /2013/2016: Intermediate

Aligned with SAQA Unit Standard 116937 / 116940 [& MOS / ICDL]

Prerequisites

MS-Word and Excel Basic, and MS-Powerpoint Basic/Intermediate; or equivalent experience

Outline

Using multiple workbooks
– Switching between workbooks
– Copying a worksheet to another workbook

Linking worksheets with 3-D formulas
– Creating 3-D formulas
– Adding a Watch window

Linking workbooks
– Examining external links in a worksheet
– Creating external links in a worksheet
– Editing links

Managing workbooks – Creating a workspace

Using special number formats
– Applying special formats
– Controlling the display of zero values
– Creating custom formats

Using functions to format text
– Using PROPER, UPPER, and LOWER
– Using SUBSTITUTE

Working with styles
– Creating and applying styles
– Modifying styles

Working with themes
– Changing to a different theme
– Saving new colours and themes

Other advanced formatting
– Merging cells
– Changing the orientation of text in a cell
– Splitting cells
– Transposing data during a paste
– Adding and deleting backgrounds
– Adding a watermark

Outlining and consolidating data
– Creating an outline
– Using the Consolidate command

Creating subtotals
– Creating subtotals in a list
– Using multiple subtotal functions

Creating and using names
– Naming and selecting ranges
– Using names in formulas
– Using the Create from Selection command
– Applying names to existing formulas

Managing names
– Modifying and deleting named ranges
– Defining and applying 3-D names

Examining the structure of a list

Sorting and filtering lists
– Sorting a list
– Filtering a list by using AutoFilter
– Using cell colour and attributes to sort and filter data

Advanced filtering
– Using Custom AutoFilter criteria
– Using the Advanced Filter dialog box
– Copying filtered results to another range

Working with tables
– Creating a table
– Formatting a table
– Adding and deleting rows and columns
– Applying structured referencing
– Naming tables
– Creating functions with [#This Row]

Saving workbooks as Web pages
– Making Web commands available
– Saving a workbook as a Web page
– Using the Publish as Web Page dialog box

Using hyperlinks
– Inserting and editing hyperlinks

Distributing workbooks
– Saving a workbook as a PDF file
– Using e-mail to share a workbook

Chart formatting options
– Adjusting the scale of a chart
– Formatting a data point

Combination charts
– Creating a combination chart
– Creating a trendline

Graphic elements
– Adding graphic elements
– Formatting a graphic element
– Adding a picture to a worksheet

Auditing features
– Tracing precedent and dependent cells
– Tracing errors

Comments in cells and workbooks
– Viewing comments in a worksheet
– Adding a comment to a cell
– Adding comments to a workbook

Protection
– Password-protecting a worksheet
– Protecting part of a worksheet by unlocking cells
– Restricting permissions to a workbook
– Discussing digital signatures

Workgroup collaboration
– Sharing a workbook
– Merging workbooks
– Tracking changes in a workbook
– Using the Document Inspector
– Marking a workbook as final

Exploring Application settings

Built-in templates
– Using a downloaded template

Creating and managing templates
– Creating a template
– Modifying a template
– Specifying an alternate template location

Overview on “What is New” in MS-Excel 2013/2016

Download Intermediate Course Outline

Course Outline: MS-Excel 2007/2010 /2013/2016: Advanced

Aligned with SAQA Unit Standard 116943 [& MOS / ICDL]

Prerequisites

MS-Word Basic; MS-Excel and MS-Windows Basic/Intermediate, or equivalent experience

Outline

Logical functions
– Using the IF function
– Using OR, AND, and NOT as nested functions
– Using nested IF functions
– Using the IFERROR function

Math and statistical functions
– Using SUMIF
– Using COUNTIF
– Using AVERAGEIF
– Using SUMIFS, COUNTIFS, and AVERAGEIFS
– Using ROUND

Financial functions – Using the PMT function

Displaying and printing formulas – Showing, printing, and hiding formulas

Using lookup functions
– Examining VLOOKUP
– Using VLOOKUP to find an exact match
– Using VLOOKUP to find an approximate match
– Using HLOOKUP for exact matches
– Using HLOOKUP for approximate matches

Using MATCH and INDEX
– Using the MATCH function
– Using the INDEX function

Creating data tables
– Creating a one-variable data table
– Creating a two-variable data table

Validating cell entries – Observing data validation

Exploring database functions
– Examining the structure of database functions
– Using the DSUM function

Working with PivotTables
– Creating a PivotTable
– Adding fields to a PivotTable

Rearranging PivotTables
– Moving fields
– Hiding and showing details
– Refreshing the data in a PivotTable

Formatting PivotTables
– Formatting by using a Pivot style
– Changing field settings

PivotCharts
– Creating a PivotChart

Exporting and importing text files
– Exporting Excel data to a text file
– Importing data from a text file into a workbook
– Converting text to columns
– Removing duplicate records

Exporting and importing XML data
– Using the XML Source task pane
– Importing XML data into a workbook
– Exporting data from a workbook to an XML data file
– Deleting an XML map

Querying external databases
– Using Microsoft Query to get data from an external database
– Discussing the Web query feature
– Using a Web query to get data from the Web

Goal Seek and Solver
– Using Goal Seek to solve for a single variable
– Installing Solver and the Analysis ToolPak
– Using Solver to solve for multiple variables

The Analysis ToolPak
– Using the Sampling analysis tool

Scenarios
– Creating scenarios
– Switching among scenarios
– Merging scenarios from another worksheet

Views
– Creating views
– Switching among views

Running and recording a macro
– Running a macro
– Recording a macro
– Assigning a macro to a button

Working with VBA code
– Observing a VBA code module
– Editing VBA code

Creating functions
– Creating a custom function

Conditional formatting with graphics
– Creating data bars
– Using colour scales
– Creating icon sets

SmartArt graphics
– Inserting a SmartArt graphic
– Modifying a SmartArt graphic

New Features for Learners using MS-Excel 2010 in our PC Lab

Using Spark Lines and Illustrate Data Trends

Use the PivotTable command to create PivotTable; and use Slicers to filter PivotTable Data

Create PivotCharts directly from datasheet

Overview on “What is New” in MS-Excel 2013/2016

Download Advanced Course Outline