INTRODUCTION

Microsoft Excel is widely used in business analytics and management reporting. 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 pivot tables 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.

DURATION

5 Days

COURSE OBJECTIVES

At the end of this training, participants 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

TOPICS TO BE COVERED

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

***************************

TRAINING CUSTOMIZATION

This training can also be customized for your institution upon request. You can also have it delivered your preferred location. For further inquiries, please contact us through Mobile: +254 732 776 700 or +254 759 285 295. You can also email us on: training@fineresultsresearch.org

REQUIREMENTS

Participants should be reasonably proficient in English.  During the trainings, participants should come with their own laptops.

TRAINING FEE

The course fee covers the course tuition, training materials, two break refreshments and lunch.

ACCOMMODATION

Accommodation is arranged upon request. For reservations contact us through Mobile: +254 732 776 700/+254 759 285 295 or Email: training@fineresultsresearch.org

PAYMENT

Payment should be transferred to FineResults Research Services bank before commencement of training. Send proof of payment through the email: training@fineresultsresearch.org

CANCELLATION POLICY

• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.