Advance your skill-level in of the fastest growing field in IT.

Course Overview

Improve your efficiency and boost productivity with our instructor-led training on ADVANCED EXCEL. Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. You would learn new excel skills like using pivot tables, VLOOKUP, Conditional Formatting and calculations. This course is suitable for Data entry, Data management. Accounting, Data and Business Analysis.

Courses Included are:

Chapter 01 – Getting Started with Microsoft Office Excel 2016

Chapter 02 – Performing Calculations

Chapter 03 – Modifying a Worksheet

Chapter 04 – Formatting a Worksheet

Chapter 05 – Printing Workbooks

Chapter 06 – Managing Workbooks

Chapter 01 – Working with Functions

Chapter 02 – Working with Lists

Chapter 03 – Analyzing Data

Chapter 04 – Visualizing Data with Charts

Chapter 05 – Using PivotTables and PivotCharts

Chapter 06 – Working with Graphical Objects

Chapter 07 – Using Array Formulas

Chapter 01 – Working with Multiple Worksheets and Workbooks

Chapter 02 – Using Lookup Functions and Formula Auditing

Chapter 03 – Sharing and Protecting Workbooks

Chapter 04 – Automating Workbook Functionality

Chapter 05 – Creating Sparklines and Mapping Data

Chapter 06 – Forecasting Data

Chapter 1 – Understanding unlevered free cash flow.

Chapter 2 – Forecasting free cash flow.

Chapter 3 – Forecasting terminal value.

Chapter 4 – Present value and discounting.

Chapter 5 – Understanding stub periods.

Chapter 6 – Performing sensitivity analysis.

₦ 10,000


  • Days: Mon/Wed/Fri
  • Time: 4pm
  • Start Date: 1st June, 2022

What Will I Gain From This Program?

By the end of this training you would be confident enough to work on Microsoft Excel. You would be able to apply the learned skills into any of:

  • Data Entry and Storage.
  • Collection and Verification of Business Data
  • Accounting and Budgeting
  • Data Analysis

What Our Students Have to Say

The training was detailed and very easy to comprehend. Our Instructor was apt. He took time to explain and answered all our questions. I am really impressed with the teachings. I will not hesitate to recommend your training center to friends.
Christian Onyezewe
Flexible class … Interactive class Understand and easygoing teacher Well informed course outline and recording.
Louisa Tare Louis
Some Of our Content Partners
Scroll to Top
× How can we help you?