Upload your Business Profile and Training Courses for FREE.. 100% FREE….     Video Ad and Banner Ad for N5,000Per Month ’ Contact us 234-818-5588771 or 234-818-5588772     FREE 2 mins Video for all Premium Members. Contact us 234-818-5588771 or 234-818-5588772    Buy Email database up to 50,000 cleaned email addresses available... Contact us 234-818-5588771 or 234-818-5588772

News & Events

INDEPTH MICROSOFT EXCEL TRAINING (INTERMEDIATE – ADVANCED)

0
Capture1112

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 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: Nov 19,20,26,27 (Two Weekends)
Time : 9.00 – 4.30 pm (Saturday)
12.00 -4.30 pm (Sunday)
Venue: Web Academy
16, Yunusa Adeniji Street
Off Toyin Street
By Muslim Avenue
Ikeja Lagos

Fees: 40,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 15th of November 2016 and payment details send to jplusssystem@yahoo.com
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
www.jplussystem.com
www.facebook.com/jplus.systems
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, 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
• Rank

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
• 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
Functions
• Use If Statements, Nested If
• Use And, Or, Not
• Nesting If, And, Or, Not
• Use the Sumif , Countif, Averageif
• Countifs
Data Consolidation
Macros
Introduction to Dashboard Reporting

June 20, 2017 |
Copyright @ . All right reserved by Nigeria Training Network
Subsidiary of NTN Associates