Visitor Counter Started – 20/10/2015

1,468,291,
 

₦35,000.00

Powerpoint Microsoft Excel Training Lagos

Powerpoint Microsoft Excel Training Lagos

Description/Service

Powerpoint Microsoft Excel Training Lagos

With the huge amount of data available to us every day, a well-built and designed dashboard reports is one of the best ways to interpret and communicate large quantities of information.
We are pleas to introduce In-depth Excel with Microsoft PowerPoint for effective, efficient dynamic analytical reporting and Presentation

This program covers the Intermediate to the Advanced Stage of Microsoft Excel with 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: March 11,12,18,19 (Two Weekends)
Time : 9.00 – 4.30 pm (Saturday)
12.00 -4.30 pm (Sunday)
Venue: National Library Abuja
Central Business District

Fees: 35,000

Payment Details: Account Name : Jplus System Solutions
Bank: StanbicIbtc
Account Number: 0013842678

Payment on or before 3rd March 2017 is 30,000 while payment at the venue 35,000
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, 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 , N.N.Fems Industries 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 Choose Functions
Pivot Table & chart
• Create A Pivot Table
• Change the PivotTable layout
• Manipulate PivotTable fields
• Group & Ungroup items
• Filter data in the PivotTable
• Insert calculated fields
• Change calculation options
• Change PivotTable Options
• Consolidation of Mutiple Ranges using Pivot Table/Pivot Chat wizard
• Create a PivotChart
• Manipulate PivotChart fields
• Creating Pivot Chart
• Add labels and axes to chart
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
Introduction to Dashboard Reporting

Microsoft Power Point

Ad Reference ID: 7965941975bc69fd

Leave a Comment ( No Login Required)

Time limit is exhausted. Please reload the CAPTCHA.

Classes/Workshops
advanced-level-sage-50/quickbooks-computer-accounting-training--12348
 

₦20,000.00

Advanced Level Sage 50/QuickBooks C...

  • Business name: Silverdreams Global Communications
  • Category: Classes/Workshops
  • Location: Abuja ,Abuja
  • Posted Date: August 15, 2016

ARE YOU READY TO BECOME A COMPUTER ACCOUNTANT? THEN BE PART OF THIS MAY’...

citrus-training-venue--18236
 

₦20,000.00

Nigeria event training centre

  • Business name:
  • Category: Services
  • Location:Lagos ,Lagos
  • Posted Date: June 9, 2017

Nigeria event training centre citrus training center is a well equipped tr...

promote-your-professional-courses-with-as-low-as-n5,000-a-month--ntn-associate--17769
 

₦60,000

Promote your professional courses

  • Business name: Nigeria Training Network
  • Category: Classes/Workshops
  • Location: ,Lagos
  • Posted Date: June 10, 2017

Promote your professional courses in Nigeria ABOUT US Nigeria Training Ne...

 

₦40,000.00

UPCOMING OIL/GAS TRAINING COURSES I...

  • Business name: Geoken Tech Services Nig Ltd
  • Category: Classes/Workshops
  • Location: Lekki, Ajah ,Lagos
  • Posted Date: June 11, 2017

UPCOMING OIL/GAS TRAINING COURSES IN LAGOS Geoken Tech Services Nig Limite...

in-depth-excel-with-power-point-17070
 

₦35,000.00

Powerpoint Microsoft Excel Training...

  • Business name: JPLUS SYSTEM SOLUTIONS
  • Category: Classes/Workshops
  • Location: Abuja ,Lagos
  • Posted Date: July 1, 2017

Powerpoint Microsoft Excel Training Lagos With the huge amount of data ava...