MandE NEWS Training Forum

Please use this Forum to:
  • Publicise upcoming M&E training events: PS: Off-topic posts will be deleted
  • Post comments or questions about any particular training events that have already been posted
Advice:
  • Try to include the date, location and title of the training event in the heading of your post
  • If you want to include a working web link in your message, you need to sorround the link within HTML code. This is easy. For the basics of how to do this go to http://www.w3schools.com/html/html_links.asp 
Here is an online survey into training needs. Participate in the survey to let people know what kind of training you need.
 
Look at the results if you are providing some type of M&E training, and you want your training to address people's needs.
 
Here is a list of M&E training providers, organised country by country. If you want your organisation to be included in the list, post a message using the Comment form at the bottom of that page.

CAVEAT: The listing of events on this page does not imply any form of endorsement by MandE NEWS of the accuracy of the information provided, the quality of the events, or their relevance to your needs.

REQUEST: This service is provided by Rick Davies pro bono. Please do not waste my time by posting irrelevant material, ether about non-M&E jobs or about other unrelated matters.

General Forum
Start a New Topic 
Author
Comment
Training on Business Analytics with Excel (May 14,2018 - May 18,2018)

About the course

Microsoft Excel is the most commonly used analytics, reporting and strategy software. This course will equip the participants with data analytical skills using Excel’s features. The participants will be taught some statistical concepts on how to get insights from data and take data driven decisions using Excel.

The participant will also acquire skills in Excel pivots and their use to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. The course will also include Power BI, which is the latest and the best tool provided by Microsoft for analytics and data visualization.


Target Participants

Business Analytics with Excel course is highly recommended for professionals who are want to build their capacity in the field of analytics. The course is best suited for people who currently use Excel at work and will benefit from improved Excel skills for reporting, presentation and analysis.


Course duration

5 Days


What you will learn

By the end of the course you will be able to:

Understand importance of business analytics in business
Understand fundamentals of excel analytics functions and conditional formatting
Analyze with complex datasets using pivot tables and slicers
Solve analytical problems using tools like scenario manager, solver and goal seek
Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel
Represent your findings using charts and dashboards
Use Microsoft Power BI


Course Outline

Introduction to Business Analytics

What is Business Analytics?
Analysis vs Analytics
Types of Analytics
Areas of Analytics

Conditional Formatting using Excel

Custom Formatting
Conditional Formatting

Excel Functions

Logical Functions
Look up and Reference Functions
VLOOKUP Function
HLOOKUP Function
MATCH Function
INDEX and OFFSET Function
Statistical Function
SUMIFS Function
COUNTIFS Function

Analysis Data using PIVOT Tables

Pivot Table Introduction
Grouping in Pivot Table Introduction
Custom Calculation
Calculated Field and Calculated Item
Creating a Slicer

Dashboard in Excel

What is a Dashboard?
Dashboard Design
Chart Formatting
Interactive Dashboard with Form Controls
Interactive Chart

Business Analytics using Excel

Histogram
Solver Addin
Goal Seek
Scenario Manager
Data Table
Descriptive Statistics

Statistical Analysis using Excel

Hypothesis Testing
ANOVA
Covariance
Correlation
Regression

Excel VBA

MsgBox
VBA variables
Events
Array
VBA functions
Application Object

Power BI

Power Pivot
Power View
Power Query
Power Map


Certification

Upon successful completion of this course, participants will be issued with a certificate.


Tailor-Made Course

We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more:

training@devimpactinstitute.com

Phone: +254 714349537


Payment

The training fee covers tuition fees, training materials, lunch and training venue. Accommodation and airport transfer are arranged for our participants upon request.

Payment should be sent to our bank account before start of training and proof of payment sent to training@devimpactinstitute.com

Event Properties
Event Date May 14,2018, 8:30 am
Event End Date May 18,2018, 4:30 pm
Cut off date May 11,2018, 5:00 pm
Individual Price $800.00
Location Nairobi

Organisation Devimpact Institute

Country: Kenya