TRAINING COURSE ON BUSINESS ANALYTICS WITH EXCEL
Details
Start Date: 21/02/2022 End Date: 25/02/2022 for 5 days
Organizer: DATA-AFRIQUE CONSULTANCY
Course fee: USD 1,000
INTRODUCTION
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
DURATION
5 Days
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
- Look up and Reference Functions
- VLOOKUP Function
- Statistical Function
- SUMIFS Function
- HLOOKUP Function
- MATCH Function
- COUNTIFS Function
- INDEX and OFFSET 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
- Descriptive Statistics
- Data Table
- Scenario Manager
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
Schedules
Weekdays | 08:00 AM — 04:00 PM |
Weekdays | 08:00 AM — 04:00 PM |
Weekdays | 08:00 AM — 04:00 PM |
Weekdays | 08:00 AM — 04:00 PM |
No. of Days: | 5 |
No. of Participants: | 100 |
Data-Afrique has collaborated with Government ministries, agencies and departments, UN agencies, Non-Governmental Organizations, from Europe, Africa, Asia, Middle-East and the Caribbean.
We have also worked with academic institutions, international research organizations, financial institutions and private companies from across the globe. By nurturing a culture of collaboration, we attract the highest calibre of people who have the ability and desire to influence and shape the future.