Call for Application for a Professional Training on Advanced Excel

Course Overview

This course is designed to help MS Excel users discover advanced features and settings while developing practical skills in data management, accounting, and statistical analysis. Participants will learn how to conduct data analysis, generate evidence-based reports, and make informed decisions using Excel's powerful tools.

Advanced Excel plays a vital role in structuring and presenting data effectively. This training teaches participants the various formulas used in Excel, how to debug and audit them, and when to use specific formulas for particular situations, including alternative solutions for common problems.

The training is highly practical, with participants working on real datasets throughout the course.

Course Details

• Course Code: EPRN12/PT/26
• Dates: 23rd February to 2nd March 2026
• Schedule: Evening program, 5:30 PM – 8:30 PM
• Location: EPRN Training Center, University of Rwanda, Gikondo Campus
• City: Kigali, Rwanda

Course Content

• Introduction to Advanced Excel: Learn how modular templates create consistent and efficient spreadsheets, customize the Excel interface for quick access to essential tools, and build in checks and controls from the start.
• Hyperlinking and Protection: Explore effective collaboration strategies for shared workbooks, safeguard data through password protection, and securely manage Excel file access.
• Data Validation: Master extended uses of data validation, work with validation formulas to ensure data accuracy and consistency, and set up data validation rules and restrictions for cell entries.
• Preparing Your Data for Analysis: Master lookup functions including INDEX and related tools for effective data preparation.