Event: Program and Budget Analysis Using Microsoft Excel Course.
NITA CERTIFIED
INTRODUCTION
Budget analyst 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 will enable participants 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. 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 TAKES THIS COURSE
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.
LEARNING 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 PivotTabl.
•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 trendline function to forecast future budgets, costs, and workloads
•Learn which trendline (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
•Warm up and review.
•Querying and Analyzing Data.
•Computing Statistics on Collected Data.
•Time Series and Analysis and Forecasting.
Visit our website for more details.
How to participate
Tailors make your course.
Register individual.
Register as a group.
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.
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. 27th November 2017
Send proof of payment to outreach@indepthresearch.org
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 outreach@indepthresearch.org