Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Training on Business Analytics with Excel

By: Data-Afrique Consultants

United Arab Emirates

22 - 26 Aug, 2022  5 days

Follow Event

  

USD 1,000

Venue: DUBAI, UAE

Other Dates

Venue Date Fee  
NAIROBI, KENYA, Kenya 26 - 30 Sep, 2022 USD1000
MOMBASA, KENYA, Kenya 24 - 28 Oct, 2022 USD1000
NAIROBI, KENYA, Kenya 21 - 25 Nov, 2022 USD1000
MOMBASA, KENYA, Kenya 19 - 23 Dec, 2022 USD1000

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.

Course Objectives

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

  • Understand business analytics and its importance to business
  • Learn the functions of excel analytics
  • Learn the use of different datasets using slicers and pivotal tables
  • Understand solving of problems 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 results
  • Learn the use of Power BI

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 Excel.

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

  • 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.

 

DUBAI, UAE Aug 22 - 26 Aug, 2022
NAIROBI, KENYA, Kenya 26 - 30 Sep, 2022
MOMBASA, KENYA, Kenya 24 - 28 Oct, 2022
NAIROBI, KENYA, Kenya 21 - 25 Nov, 2022
MOMBASA, KENYA, Kenya 19 - 23 Dec, 2022
USD 1,000.00
USD 2,990.00
(Convert Currency)

DUNCAN KARIUKI +254723360025

DATA-AFRIQUE CONSULTANCY

Related Courses

Training on Quantitative Data Management and Analysis with Stata Training on Quantitative Data Management and Analysis with Stata

5 days, 22 - 26 Aug, 2022 

2022-08-22 12:08:00 2022-08-22 12:08:00
United Arab Emirates

Data-Afrique Consultants

STATA refers to statistical software which is used in the management of data, analysis and graphics. It comprises of advanced functions which includes forecasting, survival analysis, data analysis, ...

Training on Promoting Entrepreneurship and Agribusiness Development Training on Promoting Entrepreneurship and Agribusiness Development

5 days, 22 - 26 Aug, 2022 

2022-08-22 12:08:00 2022-08-22 12:08:00
United Arab Emirates

Data-Afrique Consultants

The Agribusiness sector is dwindling due to the lack of support from governmental and non-governmental corporations. The Entrepreneurship and Agribusiness Development course seeks to revive the ...

Training on Project Information Management System For Development Organizations and NGOs Training on Project Information Management System For Development Organizations and NGOs

5 days, 19 - 23 Dec, 2022 

2022-12-19 12:12:00 2022-12-19 12:12:00
Kenya

Data-Afrique Consultants

The goal of information management is to ensure that the right information reaches the right stakeholders at the right time. Project stakeholders, donors, partners, and beneficiaries depend on good ...

Training on Cyber Crime and Digital Risk Training on Cyber Crime and Digital Risk

5 days, 22 - 26 Aug, 2022 

2022-08-22 12:08:00 2022-08-22 12:08:00
United Arab Emirates

Data-Afrique Consultants

This facilitated workshop is designed for all bank employees. A mixture of recent real cases and scenario analysis, including previously imposed legal penalties, fines, business limitations and ...