Seminar On Business Analytics With Excel
The most common used software for analytics, strategy, and
reporting is the Microsoft Excel. This course imparts knowledge and skills to
participants on the use of Excel. The course will equip the participants on the
effective use of Excel in understanding and interpreting data using statistical
concepts. The course will integrate the use of Power BI, the up to date and
improves tool by Microsoft facilitating analytics and visualization of data.
By the end of this course the participants will be able to:
analytics and its importance to business
Learn the functions
of excel analytics
Learn the use of
different datasets using slicers and pivotal tables
of problems using Excel tools
application of statistical tools and concepts such as ANOVA and regression
analysis using Excel
Use tables, and
charts to represent the results
Learn the use of
WHO SHOULD ATTEND
This course targets professionals who are utilizing Excel
and want to learn more on reporting, preparation, and analysis. The course also
targets individuals who want to learn about business analytics via the use of
Business analytics introduction
Forms of analytics
Formatting using Excel
- Statistical Function
- SUMIFS Function
- HLOOKUP Function
up and Reference Functions
- MATCH Function
- COUNTIFS Function
- INDEX and OFFSET Function
Groups of pivotal
between calculated field and calculated item
Meaning of a
Dashboards and Charts
Business Analytics using Excel
- Data Table
- Scenario Manager
Statistical Analysis using Excel
This course is delivered by our seasoned trainers who have
vast experience as expert professionals in the respective fields of practice.
The course is taught through a mix of practical activities, theory, group works
and case studies.
Training manuals and additional reference materials are
provided to the participants.
Upon successful completion of this course, participants will
be issued with a certificate.
We can also do this as tailor-made course to meet
organization-wide needs. Contact us to find out more: firstname.lastname@example.org
· The training will be conducted at SKILLS FOR AFRICA TRAINING INSTITUTE IN NAIROBI KENYA.
· 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: email@example.com