Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,036,519 members, 7,447,146 topics. Date: Thursday, 01 June 2023 at 01:40 PM

Program And Budget Analysis Using Microsoft Excel Course. - Events - Nairaland

Nairaland Forum / Entertainment / Events / Program And Budget Analysis Using Microsoft Excel Course. (427 Views)

Financial Analysis And Modelling Using Excel Course / Cost-benefit Analysis Using Microsoft Excel Course / Program And Budget Analysis Using Microsoft Excel Course (2) (3) (4)

(1) (Reply)

Program And Budget Analysis Using Microsoft Excel Course. by IndepthResearch: 9:58am On Nov 03, 2017
Event: Program and Budget Analysis Using Microsoft Excel Course.

Venue: Indepth Research Services, Nairobi, Kenya.

Event Date: 04th-07th December 2017



Budget analysts 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.

4 days

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.

• 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

• 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 is arranged upon request. For reservations contact the Training Officer.
Email: outreach@indepthresearch.org
Mob: +254 715 077 817
Tel: 020 211 3814

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

(1) (Reply)

Teal Green Bow Tie Needed / Economic Summit 2018 / EXCLUSIVE EVENT ; Launching Of The Pinkberry Yoghurt In Nigeria ( PHOTOS )

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2023 Oluwaseun Osewa. All rights reserved. See How To Advertise. 26
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.