Budget analysts working in the government and NGOs are charged with tracking expenditures, reporting on the performance of the financial plan, and forecasting future needs. Rather than only relying on superficial comparisons against previous years’ data and simple (often intuitive) adjustments, they need more sophisticated analytical skills. This course enables students to use more sophisticated analytical tools and advanced features of Microsoft Excel to draw useful and reliable conclusions regarding financial performance, and demonstrate that information graphically to superiors. This results in more productive analyses (less time-consuming, while providing more valuable information), which will aid organizations’ efforts to track expenditures and control budget execution. Approximately 85% of the course time will be spent using Microsoft Excel.

DURATION

4 days

WHO SHOULD ATTEND

This course is designed for all program and financial management personnel who want to learn about many of the data analysis tools available in Microsoft Excel to aid in creating more compelling analyses of their programs.

COURSE OBJECTIVES

Navigate the Excel ribbon
Query databases using the Filter tool and the Advanced Filter too
Aggregate and display different attributes of a data set using the Pivotal
Use Excel’s Descriptive Statistics tool to calculate statistical measures of central tendency, variation, and shape
Use the Histogram tool to organize your data and create a frequency distribution
Perform graphical analysis of data
Use the Rank and Percentile tool to calculate a data item’s rank and percentile ranking
Use time series data and Excel’s trend line function to forecast future budgets, costs, and workloads
Learn which trend line (linear, polynomial, logarithmic, or exponential) is the best to use based on R2
Identify cost drivers using Excel’s Correlation tool
Develop simple linear and multiple linear regression models to develop forecasts and predictive equations using Excel’s Regression tool

TOPICS TO BE COVERED

Building Background
Sorting and Querying/Filtering
Excel's Filter Tool
Excel's Advanced Filter Tool
Excel's PivotTable Tool
Building Background
Frequency Distributions
Common Shapes of Frequency Distributions
Descriptive Statistics
Time Series Analysis
Inserting A Trend line
Building Background
Simple Linear Regression
Simple Linear Regression Equation
Excel’s Regression Tool
Regression Statistics
Correlation
Correlation Versus Causality
The Correlation Matrix
Multiple Linear Regression
More Regression Statistics

Visit our website for more details.

Tailor-Made Training

This training can also be customized for your institution upon request to a minimum of 4 participants. You can have it delivered in our training centre or at a convenient location.

How to participate

Tailors make your course.

Become one of our partners.

Purchase software’s

Frequently asked Questions (FAQ’s)

Recent Clients

View related courses

Mobile Phone Based Data Collection Using ODK..
ICT for Disaster Response..
Microsoft Excel for Health Care Professionals..
M & E, Data Management & Analysis for Agriculture & Rural Development Programmes.
Microsoft Excel for Agriculture Professionals..

The most popular courses

Digital marketing (Email & Social Media) and Brand Online Visibility..
Establishing and strengthening farmer organizations..
Advanced Training on Fire Safety and Fighting Marshal..
How to Influence Decision Makers to Take up Research..
Proposal Preparation Using the Logical Framework Approach..
Mainstreaming Disaster Risk Reduction into National Development Process..
GIS Analysis for WASH Programmes..
Strategic Financial Management..

View course catalogue on ICT4D and mobile technologies Institute.

For further inquiries, please contact us on Tel: +254 715 077 817, +254 (020) 211 3814, +254 731240802, +254 735331020.

Email [email protected]

Reviews

Be the first to write a review about this course.

Write a Review

Indepth Research Services (IRES) is a global institutional capacity building, technical and management consultancy firm with its head office in Nairobi, Kenya.

IRES offers technical and management consultancy services as well as education and training services designed for individuals’ and groups from organizations working in public, not for profit and private sectors.

IRES Kenya has identified itself with a niche market that largely comprises of Government ministries, departments and agencies (MDA’s) and UN agencies, Non-Governmental Organizations, from Africa, Europe, Asia, Middle-East and the Caribbean. We have also served academic institutions, international research organizations, financial institutions and private companies from across the globe. As at 2018 we offer our services in more than 15 locations globally.

Our technical and management consultancy services are in the areas of Agriculture, Education, Energy, Oil and gas, Health, Environment and natural resources, ICT for development, spatial planning, Governance, Management and leadership, communication, transport, revenue management, marketing development and environment among others.
Our education and training services are aimed helping individuals improve their professional knowledge, competence, skill, and effectiveness and enable the institutions to get the best out of their workforce. This is achieved through conducting high impact professional diploma and certificate courses, short courses, conferences, workshops and seminars. ...

View Complete Profile

Database & Information Systems