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: Power Excel- Analyzing Data to Make Business Decisions
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:
Power Excel- Analyzing Data to Make Business Decisions
Category: COMPUTER APPLICATION SOFTWARE COURSES

COURSE OBJECTIVES
You Will Learn How To:

  •  Leverage features of Microsoft Excel to facilitate business decisions
  •  Develop intelligent worksheets to quickly identify KPIs
  •  Perform "what-if" analyses for developing budget and project plans
  •  Summarize and analyze large amounts of data using PivotTables and Excel features
  •  Automate Excel processes
COURSE CONTENT

Troubleshooting and Enhancing Professional Workbooks
  • Deciphering and correcting functions for data integrity
  • Accurately interpreting calculations
  • Implementing Names to enhance your workbook model
  • Monitoring KPIs using conditional formatting
Analyzing Data with Functions
Summarizing business data with functions
  • Identifying the correct statistical function to aid analysis
  • Applying basic financial functions
  • Differentiating serial dates and date presentations
  • Calculating the number of working days
Controlling calculations and nested formulas
  • Interpreting data variations with the IF function
  • Streamlining calculations with referencing
  • Developing nested functions for multiple conditions
  • Capturing information with lookup functions
  •  Applying techniques to implement and troubleshoot nested calculations
Optimizing Workbook Models with "What-If" Analysis
Planning for contingencies
  • Managing variables in worksheets with Scenarios
  • Comparing and contrasting different data sets with Scenarios reports
Quantifying variables in a workbook model
  • Determining the magnitude of a variable with Goal Seek to achieve an end value
  • Calculating the optimum variable values in a worksheet model with Solve
Summarizing Business Information
Organizing workbooks and links
• Arranging multiple workbooks with Workspaces
• Managing external links
Consolidating ranges
• Building 3D formulas to analyze worksheet data
• Summarizing multiple sources of Excel information into one worksheet
Formulating Decisions from Database Information
Distilling data sets for data analysis
• Managing multiple data sets on a single worksheet with the Table feature
• Defining an Excel data set to ensure appropriate use of built-in features
• Extracting unique lists of records from an Excel data set with the Advanced Filter
• Analyzing data sets with filters and aggregation
Interpreting and refining data with PivotTables
• Defining data summaries interactively
• Summarizing data sets with grouping and aggregation
• Comparing related totals dynamically
• Filtering details with Report Filters and Slicers
Visualizing and exploring PivotTable reports
• Presenting PivotTable reports effectively with PivotCharts
• Examining data patterns with Sparklines
• Analyzing multiple tables of data with Power Pivots
• Discovering and presenting information with Power View
Enhancing Excel Usage with Macros
Automating repetitive tasks
• Simplifying complex tasks and reducing errors
• Bulletproofing routine editing and formatting
• Invoking macros with Form controls

 

DATES:

05 Jan - 28 Jan , 2018,
05 Feb - 26 Feb, 2018,
05 Mar - 26 Mar, 2018,
Nov 23 - 15 Dec, 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