CALL FOR APPLICATION ON Advanced Excel Formulas and Functions

ABOUT SKILLS HUB INTERNATIONAL (SHI) LTD

SKILLS HUB INTERNATIONAL (SHI) LTD is a subsidiary of ONCG GLOBAL HOLDINGS LTD a multidisciplinary consulting group operating across African continent. SHI Ltd is registered in Rwanda since 2013, to offer a wide range of world-class training services and employment services to both corporate and individual clients.

It also offers cutting edge business and management customized training programs. Our training services include Professional training services, Executive Training, In-house training services and Special Training services for specialized industries like banks, insurers and others. Training services are provided via two schools namely School of Business Professionals and School of Business Executives. Our trainings range from one day-certificate to three-months training certificate for proficiency.

In addition, SHI as a Capacity building specialized supplier, offers Employment related services such as Recruitment services, headhunting, Job-Connect and Refresher course services to both employers and job seeking community.

COURSE OVERVIEW AND OBJECTIVES

The course focuses on those aspects that are important in everyday day operation of organization. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, Pivot Charts and management Dashboards. The program explores an advanced approach t data validation and excel. Participants will be able to boost them excel reporting expertise as a result of this training program.

Objectives:

At 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

INDICATIVE CONTENTS

1. LOGICAL FUNCTIONS

• Understanding Logical Functions
• Using IF with Text
• Using IF with Numbers
• Nesting IF Functions
• Using IFERROR
• Using TRUE and FALSE
• Using AND
• Using OR
• Using NOT
• SUMIF & SUMIFS
• COUNTIF & COUNTIFS

2. LOOKUP FUNCTIONS & PROJECT PLAN (GANTT CHART)

• Understanding Data Lookup Functions
• Using CHOOSE
• Using VLOOKUP
• Using VLOOKUP for Exact Matches
• Using HLOOKUP
• Using INDEX
• Using Match
• Understanding Reference Functions
• Using ROW and ROWS
• Using COLUMN and COLUMNS
• Using ADDRESS
• Using INDIRECT
• Using OFFSET

3. WHAT-IF ANALYSIS

• Scenario Manager
• Goal Seek
• Data Table

4. FORMULA AUDITING

• Show formulas
• Errors checking
• Evaluate formula
• Trace precedents
• Trace dependents
• Remove arrows

5. SOLVER

• Understanding How Solver Works
• Installing the Solver Add-In
• Setting Solver Parameters
• Adding Solver Constraints
• Performing the Solver Operation
• Running Solver Reports

6. VALIDATING DATA

• Validating Data
• Understanding Data Validation
• Creating a Number Range Validation
• Testing a Validation
• Creating an Input Message
• Creating an Error Message
• Creating a Drop-Down List
• Using Formulas as Validation Criteria
• Circling Invalid Data
• Removing Invalid Circles
• Copying Validation Settings

7. DATA CONSOLIDATION

• Understanding Data Consolidation
• Consolidating Data with Identical Layouts
• Creating a Linked Consolidation
• Consolidating Data with Different Layouts
• Consolidating Data Using the SUM Function

8. PIVOT TABLES & DASHBOARD MANAGEMENT

• Understanding Pivot Tables
• Recommended Pivot Tables
• Creating Your Own PivotTable
• Defining the PivotTable Structure
• Filtering a PivotTable
• Clearing a Report Filter
• Switching PivotTable Fields
• Formatting a PivotTable
• Understanding Slicers
• Creating Slicers
• Inserting a Timeline Filter
• Dashboard Management

9. TIME SERIES SALES FORECASTING USING ADVANCED EXCEL

• Understanding Time series concept
• Historical sales data management
• Historical data analysis
• Time series plot
• Understand trend components
• The irregular component in time series
• Design with graph quarterly time series forecasts

10. INTRODUCTION TO MODELS IN EXCEL

• Definition
• Keys Models and Use
• Practical Exercises

11. BUSINESS ANALYTICS USING EXCEL

• Solver Addin
• Histogram
• Goal Seek
• Data Table
• Scenario Manager
• Descriptive Statistics

12. STATISTICAL ANALYSIS USING EXCEL

• Testing hypothesis
• ANOVA
• Covariance
• Correlation
• Regression

13. EXCEL VBA

• Msg Box
• VBA variables
• Events
• Array
• VBA functions
• Application Object

14. POWER BI

• Power Pivot
• Power View
• Power Query
• Power Map

DATE AND VENUE

The course will Start by 2^nd to 16^th /September/2024. Training will take place at SHI professional Training Center Offices located at KIMIRONKO-GASABO, TRIUMPH HOUSE 3^RD Floor.

SESSIONS AND days of Training

The training Program will last for 28 hours and will be delivered in three different sessions as follows:

For registration download the registration form on the following link:

https://www.skillshubinternational.com/Assessment/2024file3ae95eaa75cd9328eed38cf22a0691acsgfs.pdf

A properly filled form shall be sent on of our email as follows:

skillshubinternational@gmail.com

kemmanuel@skillshubinternational.com

For more information, you can contact us on:

+250 780 343 116; +250 780 344 361; +250 788303061or using above emails.

COURSE FEES & PAYMENT MODEs

The amount of fees per course On Advanced Excel Formulas and Functions is 70,000 Rwf Paid via our bank accounts; 4003200725206 at EQUITY BANK RWANDA PLC, *182*8*1*097137# Using Mo-Mo Pay.

The fees will cover tuition, training materials refreshment and Certificate.

CERTIFICATE of completion

A certificate will be issued at the end of the program to every trainee who completes the course.