DATA ANALYSIS AND REPORTS PREPARATION WITH EXCEL TECHNIQUES

Class Description

OBJECTIVE

The objective of the training is to equip participants with the knowledge and practical skills on using Excel functionalities and techniques to perform Data Analysis and Report Preparation.
TARGET GROUP
This course is specifically designed for Data Analysts, Financial Analysts, Accountants, Business Intelligence Professionals, Project Managers, Budget Officers, Risk Analysts, and any professionals involved in data analysis, reporting, or decision-making processes in organizations.

COURSE CONTENTS:
i. Overview of MS Excel for Professionals
ii. Data Modelling and Analysis (Track Financial Performance, Detect Anomalies, and Mitigate Risks)
iii. Data Conceptualization, Visualization and Forecasting (Pivot Table, Power Pivots, Charts, and Dashboards)
iv. Data Transformation
v. Designing, Creation, Management and Sharing of Data Analysis Reports
vi. Apply MS Excel in Budget Analysis
vii. Big Data Analytic using MS Excel

FEES

The fee for each participant is TZS 1.0 million or USD 1000 for non-residents, covering tuition, course materials, lunch, and mid-session refreshments. Participants will be responsible for their travel costs and upkeep. Please make the payment of your fees using the following channel:

Local Participants from Commercial Banks

Bank Transfer through TISS Transferee Bank: Bank of Tanzania

Account Number: 9944713006

Account Name: Course Fees

SWIFT CODE: TANZTZTXXXX

Local Participants from Government Agencies

Transferee Bank: Bank of Tanzania

Account Number: 9924191003

Account Name: Bank draft Issued

SWIFT CODE: TANZTZTXXXX

Foreign Participant Account Details

Bank Name: Citibank

Bank Swift Code: CITIUS33

Account Holder: Bank of Tanzania

Account Number: 36113007

MODE OF APPLICATION

Send a letter, e-mail, or phone the Academy through any of the mentioned contacts below. The course will accommodate 25 participants, and the first come, first served principle will apply. Applications should reach us at least two (2) working days before the commencement of the course.

All applications should be addressed to:

The Principal,

Bank of Tanzania Academy,

P.O. Box 131, Capri-Point,

MWANZA

+255 (0) 28 2 500 982/709/983 +255 (0) 28 2 503 380

Email: academy@bot.go.tz