INTRODUCTION

Microsoft Excel is the most widely used program for analytics, strategy, and reporting. Participants in this training gain knowledge and expertise in using Excel. The participants in the training will learn how to use Excel effectively to comprehend and interpret data using statistical ideas. The latest and improved Microsoft tool for data analytics and visualization, Power BI, will be integrated into the course.

COURSE OBJECTIVES

By the end of the course, participants will be able to:

• Understand business analytics and its significance to businesses;
• Learn the functions of Excel analytics;
• Understand problem-solving using Excel tools;
• Learn the application of statistical tools and concepts such as ANOVA and regression analysis using Excel;
• Use tables and charts to represent the data;

DURATION

5 Days

WHO SHOULD ATTEND

This course is designed for Excel-using professionals who wish to learn more about reporting, preparation, and analysis. Additionally, the course is intended for those who want to utilize Excel to study business analytics.

COURSE OUTLINE

Business analytics introduction

• Understanding business analytics
• Analytics versus analysis
• Forms of analytics
• Analytics areas

Formatting using Excel

• Custom Formatting
• Conditional Formatting

Excel Functions

• Logical Functions

• Statistical Function
• SUMIFS Function
• HLOOKUP Function

• Look up and Reference Functions

• MATCH Function
• COUNTIFS Function
• INDEX and OFFSET Function
• VLOOKUP Function

PIVOT Tables

• Introduction to Pivotal tables
• Groups of pivotal tables
• Calculations (Custom)
• Differentiation between calculated field and calculated item
• Slicer creation

Excel dashboard

• Meaning of a Dashboard
• Designing a Dashboard
• Chart Formatting
• Interactive Dashboards and Charts

Business Analytics using Excel

• Solver Addin
• Histogram
• Goal Seek

• Data Table
• Scenario Manager
•  Descriptive Statistics

Statistical Analysis using Excel

• Testing hypothesis
• 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

GENERAL NOTES

• Our seasoned instructors, who have years of experience as seasoned professionals in their respective fields of work, will be teaching this course. A combination of practical exercises, theory, group projects, and case studies are used to teach the course.
• The participants receive training manuals and supplementary reading materials.
• Participants who complete this course successfully will receive a certificate.
• We can also create a course specifically for your organization to match your needs. To learn more, get in touch with us at training@dealsontrainers.org.
• The training will take place at DEALSON TRAINERS IN NAIROBI, KENYA in Nairobi, Kenya.
• The training fee includes lunch, course materials, and lodging for the training session. Upon request, we may arrange for our participants' lodging and transportation to the airport.
• Payment must be made to our bank account before the training begins, and documentation of payment should be emailed to training@dealsontrainers.org