Event Information

Share this event

Date and Time



Friends Who Are Going
Event description


In today’s modern businesses, there is hardly anything as luck. What is more realistic is the ability to make accurate financial and business decisions at the right time.

This program covers the Intermediate to the Advanced Stage of Microsoft Excel and PowerPoint. This will help to improve your reliability and quality of your decision making.

Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

It's intended for Accountants, Sales and Reporting Staff, Financial Analysts, Business Analysts, Data Analysts, Audit and Control Personel,HR Executives and power Excel users.

Training Details

Date: Dec 3,4,10,11 (Two Weekends)

Time : 9.00 – 4.30 pm (Saturday)

12.00 -4.30 pm (Sunday)

Venue: National Library

Central Busines District


Fees: 35,000

Payment Details: Account Name : Jplus System Solutions

Bank: StanbicIbtc

Account Number: 0013842678

Discount: 10% Group discount for organisation sponsoring 3 or more participants

To participate, all payment made on or before 28th of November 2016 and payment details send to

Invitation Letter: Available on Demand

Participants are to come with their laptop

In-House Training: for in-house Training call 08141575331

For registration and enquiry call Jide on 08141575331 or Tope -08060875359

Deliverables: Certificate on completion, Training Manual, Cds (Data/video)

The training will be facilitated by Buoye Jide and Others. Jide is a season facilitator in Excel, Audit Command Language, Active data for Excel, Idea, Dashboard design and implementation.

He has a good working knowledge of CAAT tools for financial analysis, detection of control weaknesses, and identification of suspicious transactions and profiling of channels/branches for enhanced profitability

At Jplus system Solutions he has since been actively involved in Training and IT consultancy services for some of the clients listed below

Lagos Chamber of Commerce and Industry, Abuja Electricity Distribution Company, Office of the Budget of the Federation, Colgate Palmolive Nigeria, Great Nigeria Insurance (Audit Unit), Redeemed Christian Church Of God Olive Parish Banana Island, Kehinde Karim Chartered Accountants & Co, MBH Power Limited, Nigeria Life Provident Company, Platinum Stream Consulting etc.

Training Outline

Data List Management

  • Create an Excel data list
  • Use the Excel List Tools
  • Use Auto filter
  • Sort the Data
  • Use the Advanced Filter
  • Add Subtotals to a list
  • Apply Data Validation to keep data clean
  • Group and Outline your data
  • Use the Data Form
  • Inport and Export
  • Name range
  • Linking and Manipulating multiple sheet

Lookup & Information Functions

  • Build the Vertical Lookup (Vlookup) function
  • Build the Horizontal Lookup (Hlookup) function
  • Build the Match and Index functions
  • Build and use Database Functions
  • Practical applications of Lookups for reconciliation of two worksheet, Detecting Duplicate and Matching Sales

Pivot Table & chart

    • Create A Pivot Table
    • Change the PivotTable layout
    • Manipulate PivotTable fields
    • Format the PivotTable and apply Styles
      • Group & Ungroup items
      • Filter data in the PivotTable
      • Insert calculated fields
      • Change calculation options
      • Change PivotTable Options
      • Display and hide data in fields
      • Consolidation of Mutiple Ranges using Pivot Table/Pivot Chat wizard
      • Create a PivotChart from report
      • Manipulate PivotChart fields
      • Creating Pivot Chart
      • Add labels and axes to chart
      • Show specific Data Points
      • Save custom chart types
      • Change the default chart type
      • Using the Chart Wizard

      What If Analysis Functions

      • Create and manipulate Scenarios
      • Create and change Custom Views
      • Build scenario Reports
      • Use the Goal Seek tool
      • Use Solver & Advanced Solver Features
      • Build Data Tables
      • Use If Statements, Nested If
      • Use And, Or, Not
      • Nesting If, And, Or, Not
      • Use the Sumif , Countif, Averageif
      • Countifs

Data Consolidation


Introduction to Dashboard Reporting

Microsoft PowerPoint

Share with friends

Date and Time


Save This Event

Event Saved