Digital Literacy Certificate

In today's world it has become absolutely paramount for individuals of this day and age to acquire the basic IT skills to proficiently use a computer.This certificate course is designed to identify, develop and certify individuals with requisite skills and knowledge to utilize a computer in the office, home and school environments. It provides people of all ages with the means to increase their IT skills, prove their expertise, improve their academic performance and advance their professional careers..

Pre-requisite:

No knowledge of computer and/or IT is required to attend this program.

Course Content

The courses that are covered in this program include:
PC/IT Basics
Keyboard Basics
Microsoft Windows
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Internet Basics

For Whom

Secondary School Students
Office Assistants
Secretaries
Personal Assistants
Administrative Officers/Managers
Accountants
Marketing/Sales Offices
Students
Job Seekers or anyone that is required to work with computers on a day-to-day basis.

Duration

Weekdays – 1 1/2 months
Weekends – 3 months

Payment Methods

Interested individuals can pay using the following methods:
Pay at the centre of your choice or Online payment
Pay to the bank using the following bank details
Account Number: 3101175084
Account Name: Ikuejawa Abiola Oladeji
Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)
Installment Payments (First Payment= 60% of Course Fee)


Register Now

Diploma in Information Technology

This IT training course is designed to further develop individuals with requisite IT skills and knowledge to utilize computer in the office, home and school environments. Diploma in Information Technology is designed for individuals who intend to acquire the knowledge of some design packages in-conjunction with the Microsoft Office Suite Packages

Pre-requisite:

No knowledge of computer and/or IT is required to attend this program.

Course Content

The courses that are covered in this program include:
PC/IT Basics
Keyboard Basics
Microsoft Windows
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Internet Basics
CorelDraw
Microsoft Outlook
Microsoft Publisher
Advanced Internet

For Whom

Secondary School Students
Office Assistants
Secretaries
Personal Assistants
Administrative Officers/Managers
Accountants
Marketing/Sales Offices
Students
Job Seekers or anyone that is required to work with computers on a day-to-day basis.

Duration

Weekdays – 2 months
Weekends – 3 months

Payment Methods

Interested individuals can pay using the following methods:
Pay at the centre of your choice or Online payment
Pay to the bank using the following bank details
Account Number: 3101175084
Account Name: Ikuejawa Abiola Oladeji
Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)
Installment Payments (First Payment= 60% of Course Fee)


Register Now

Diploma in Microsoft Advance Excel

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering. In addition, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analysing data, and using Excel data in other applications.
This course is designed for students who already have foundational knowledge, skills and experience working with Excel 2013. The student will now begin taking advantage of some of the higher-level functionality in Excel such as creating macros, working with shared documents, analyzing data, and auditing worksheets.

Pre-requisite:

knowledge of Digital Literacy is required to attend this program.

Course Content

Course Outline – Level 1

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Course Outline – Level 2

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

Lesson 4: Applying Conditional Logic

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

    Use Advanced Chart Features
  • Create Spark lines

For Whom

Secondary School Students
Office Assistants
Secretaries
Personal Assistants
Administrative Officers/Managers
Accountants
Marketing/Sales Offices
Students
Job Seekers or anyone that is required to work with computers on a day-to-day basis.

Duration

2 Weeks

Payment Methods

Interested individuals can pay using the following methods:
Pay at the centre of your choice or Online payment
Pay to the bank using the following bank details
Account Number: 3101175084
Account Name: Ikuejawa Abiola Oladeji
Bank: First Bank

Payment Types

Full Payment (Attracts 5% discount of Course Fee)
Installment Payments (First Payment= 60% of Course Fee)

Register Now