Course Details

  • Course Code: OS-IT-XL4-1D
  • Mode of Delivery: Onsite
  • Duration: 1 Day
  • Price: On Request

Microsoft Excel Level 4

Course Overview

Microsoft Office Excel provides powerful tools that enable you to organize, analyse, manage, and share information easily. The foundation of Excel and locations where you do your work are cells, rows, and columns within a worksheet, and worksheets as part of a workbook. It will also enable participants to streamline repetitive tasks and display spreadsheet data in more visually effective ways.

Anyone who desire to gain the skills necessary to manage worksheets, sort and filter data, creating charts and using Functions. In addition, this course is suitable for those interested to step-up a level with existing knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

  • Microsoft Excel Level 1 & L 2 & L3

Successful candidates will receive a certificate issued by National Training Institute LLC (NTI), attested by the Ministry of Higher Education.

Other Details

Module 1: Advance macros

  • Writing a basic macro
  • Using IF-THEN-END IF Statements
  • Use SELECT CASE-SELECT Statements
  • Using WITH-END WITH Statements
  • Exploring Error Handling
  • Programming the Office Assistant
  • Module review

Module 2: Template Enhancements

  • Hiding Data
  • Use of Cell locking and Protection
  • Creating Styles
  • Use of Excel Event Procedures
  • Module Review

Module 3: On-screen Forms

  • Using Forms Controls
  • Use of ActiveX Controls
  • Modifying ActiveX Control Properties
  • Assigning Macros to ActiveX Controls
  • Module Review

Module 4: Workgroup Features

  • Creating a Shared Workbook
  • Tracking Workbook Changes
  • Distributing a Shared Workbook
  • Resolving Workbook Changes
  • Module Review

By the end of the module the candidate will be able to Understand and explain the principles of:

  • Find and calculate data using lookup, math and statistical functions.
  • Calculate with dates.
  • Manipulate text using calculations and text functions.
  • Import and export data from/to other applications and text files.
  • Carry out “What-If Analysis” using Scenario Manager, Goal Seek and Solver.
  • Create dashboard interfaces using form controls.
  • Create standardised worksheets with the use of templates.
  • Automate common tasks in worksheets by recording macros.
  • Assign macros to the Quick Launch Toolbar, keystrokes and worksheet buttons.
Instructor-led training