Tel:
(+234) 8038437312, 8023262908. E-mail: training@coinmac.org
Our Offices and Locations:
Nigeria, London, India, USA, United Kingdom, UAE & Canada

COINMAC INTERNATIONAL INC
Management Consultant
Multi-disciplinary Trainer
Information Technology Solution Provider

Home Contact Us
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac

Course List
Media/Downloads
Join us on facebook
Registeration for: Advanced Excel Operations
Select Date/Venue to attend
Personal Information
First Name:
Last Name:
Phone No:
E-mail:
Organization's Name:
Director of Org.:
AFTER MAKING PAYMENT, YOU CAN COME TO THIS PAGE AND FILL THIS SECTION BELOW
PAYMENT VERIFICATION FORM
Ref No:
Amount Paid:
Reg No:
Advanced Excel Operations
Category: Computer Application Software Courses

Objectives:
Business Intelligence (BI) is what you get when you analyze raw data and turn that information into actionable knowledge. BI can help your organisation uncover new business opportunities, recognize changing business environments, identify cost-cutting opportunities, identify data anomalies, and create widely accessible reports.
The course objective is to equip participants with the requisite skills needed to make better business decisions by using excel tools to analyze data. The benefits of additional MS Excel training for your employees will give you a more efficient visibility into your operations as well as improve your bottom line.

Expected Learning Outcomes:
At the end of the program, participants will be able to

  • Analyze large amount of data and report those results in a meaningful way
  • Get better visibility into data from different perspective.
  • Add interactive control to show various views
  • Automate repetitive task and processes
  • Create eye-catching visualizations
  • Create impressive Dashboard and What-If analysis
  • Access external data sources to expand your message
  • Be able to communicate the results of models clearly and concisely

COURSE CONTENT
MODULE ONE

Introduction to basic excel techniques
Formulas
CountIf
SumIf
If, Nested If, Choose
Vlookup, Hlookup
Match
Index
Offset
SumProduct
Rows, Columns
SumIfs, CountIfs
IfError, IsError, IsNA
Small, Large
Max, Min
Text Formulas
Formula Debugging

Table structure, filtering, sorting AND advanced filtering
Advanced charting
Excel chart types
Column Chart
Bar Chart
Line Chart
Pie Chart
Scatter Chart
Area Chart
Doughnut Chart
Radar Chart
Surface Chart
Bubble Chart
Stock Chart
Gauge Chart
Comparative Histogram
Combination Chart
Trendline
Handling Missing Data
Using Excel Chart Tools

MODULE TWO
Using Pivot Tables and Pivot Charts
Anatomy of Pivot Table
Customizing Pivot Table
Filtering your Data
Using Pivot Charts
Using Excel Sparkline
Chartless Visualization Techniques
Conditional formatting
Advanced Dashboard and Report
Developing your Data Model
Building data model
Data model best practice
Excel functions for your data model
The VLOOKUP function
The HKOOKUP function
The SUMPRODUCT function
The CHOOSE function
Working with Excel tables
Dashboards
What are Dashboards?
Establish the user requirements
Dashboard design principles
Key questions to ask before distributing your dashboard

MODULE THREE
Creating dashboard components
Component that show trending
Component that group data
Component that show performance against target
Macro-charged reporting
Adding interactive Controls to your Dashboard
Working with outside world
Get External data
Web Query
Microsoft Query
Set up your data source connection
Creating the link between Excel and PowerPoint
Distributing your Dashboard via PDF

DATES:

06 Mar - 10 Mar, 2017,
01 May - 05 May, 2017,
10 July - 14 July, 2017,
18 Sep - 22 Sep, 2017

IMPORTANT NOTE:

FOR MORE DETAILS WITH RESPECT TO COURSE CONTENT E.T.C, PLEASE SEND YOUR REQUEST TO training@coinmac.org or call +2348023262908,+2348038437312
PARTNERS
Our Products and Services
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
HUSIS
MEDICALHEALTH
SCHOOLFEES
RESULT WIZARD
EASYSCHOOL
SCHOOLPORTAL
BULKSMS
JAMBCBT
Enquire Now Testimonials FAQS REGISTER NOW