COURSE OBJECTIVES

Tailored for professionals from the public and private sectors, including financial, construction, logistics, and telecommunication sectors, among others, looking to master excel for handling complex tasks, advanced data management, tracking, and reporting performance. This training will provide the skills necessary to use advanced excel formulas, pivot tables, and various advanced techniques for handling numeric and text data.

KEY TOPICS

• Introduction to Advanced Excel
• Managing data with logical and nested functions
• Pulling data with lookup functions
• Handling text data
• Methods of summarizing data and mapping
• Reports consolidation with pivot tables
• Process automation

LEARNING OUTCOMES

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

• Apply logical functions as decision-making tools for evaluating various data conditions
• leverage on various excel methodologies for extracting and summarising data
• Use excel to develop a dashboard and track organization key performance indicators
• Create a dashboard in Excel to track key performance indicators for an organization.
• Be able to apply various excel methodologies to extract specific data
• Automate repetitive tasks

TARGET PARTICIPANTS

The fee for the course covers materials, course delivery, certificates, and refreshments. All payments should be made to NBC Bank Acc. Name: FACULTY OF COMMERCE Acc. # 040103000924 Swift Code: NLCBTZTX

Offered By : Faculty of Commerce - University of Dar es salaam Business School

OTHER DETAILS

Cost: 600,000

Currently Not Accepting Applications
Cancel