Data Analysis and Report Preparation with Excel Techniques
Course Feature
Class Description
| OBJECTIVES
The course aims to equip participants with a practical knowledge and skills on data analysis and report preparation using excel techniques. TARGET GROUP This course specifically designed for staff involved in data management, analysis, and reporting functions across various departments. It is particularly relevant for officers working in finance, accounting, budgeting, research, planning, monitoring and evaluation, as well as administrative and operational roles that require data-driven decision-making and report preparation. COURSE CONTENTS: i. Mastering Text Formula ii. The Specials- GOTO and Paste iii. Function and Formula Basics iv. Unlocking the Power of Look-up Functions v. Exploring Power Query vi. Harnessing Power Pivot vii. Advanced Formatting Techniques viii. Conditional Formatting for Insights ix. Working with Date Functions x. Pivot Table Analysis xi. Automating Excel Tasks xii. Data Visualization xiii. Working with Tables COURSE FEE The course is offered at TZS 1.0 million for resident participant and TZS 2.7 million for non-resident. This fee covers tuition, course materials, lunch, and mid-session refreshments. PAYMENT DETAILS 1. Local Participants from Commercial Banks 2. Local Participants from Government Agencies 3. Foreign Participant Account Details MODE OF APPLICATION
Apply Now |