₦airaland Forum

Event: Financial Data analysis Using Microsoft Excel

Venue: Indepth Research Services, Nairobi, Kenya.

Event Date: 19th March – 23rd March 2018

NITA CERTIFIED

RECENT CLIENTS

Introduction
This course is designed to instruct participants on the principles of data analysis while demonstrating the value of Microsoft Excel and its ability to help budget analysts and consultants make effective program and agency decisions. Participants will learn how to validate data, construct financial models, perform what-if scenarios, evaluate financial alternatives, perform cost-volume analysis, solve linear programming problems, and analyze waiting lines using queuing theory models.

DURATION
5 days

TOPICS TO BE COVERED
• Working with External Data
• The Push for Analytics and the Need for Valid Data
• Conducting Variance Analysis
• Solving Financial Problems Using Excel’s Financial Functions and Creating Intentional Circular References
• Evaluating the Financial Impact of Projects and the Selection of Alternatives
• Applying Excel’s Goal Seek to Cost-Volume Analysis
• Applying Excel’s Data Table and Scenario Manager Tools to Financial Models
• Applying Excel’s Solver Tool to Financial Problems
• Queuing Theory and Application to Waiting Line Models

Visit our website for more details.

How to participate
• Tailor make your course.
• Register as an individual.
• Register as a group.
• Become one of our partners.
• Purchase software’s
• Frequently Asked Questions (FAQ’s)

View related courses
• Data Management, Analysis, and Graphics using Stata Course
• Research Design, Data Management, Analyses & Use Course
• Data Management, Analysis and Graphics with R Course
• Panel Data Analysis with Stata Course
• Analysis of Complex Sample Survey Data Course
• Data Management and Analysis for M&E in Development Programmes Course
• Using Participatory Action Research to Improve Development Practice Course

The most popular courses
• Food Security Analysis Course
• Diseases Surveillance and Reporting Course
• M & E, Data Management & Analysis for Agriculture & Rural Development Programmes Course
• ICT for Disaster Response Course
• Contingency Planning Course
• GIS Analysis for Health Sector Programmes Course
• Debt Collection and Credit Management Course

View course catalogue in Research Institute
For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814.
Email outreach@indepthresearch.org

ACCOMMODATION
Accommodation is arranged upon request. For reservations contact the Training Officer.
Email: outreach@indepthresearch.org.
Mob: +254 715 077 817
Tel: 020 211 3814

PAYMENT
Payment should be transferred to IRES account through bank on or before C.O.B 12th March 2018.
Send proof of payment to outreach@indepthresearch.org