Call for Application for a Professional Training on Advanced Excel
Confidential
CDD
Publiée il y a 1 semaine · Expire dans 1 mois
Description du poste
Call for application for a Professional Training on ADVANCED EXCEL
Course Code:EPRN12/PT/26
Dates: from 23rd February to 02nd March 2026 (Evening program from 5h30pm-8h30pm).
Venue:EPRN Training Center at University of Rwanda, Gikondo Campus
Use this Link to register: https://tgr.li/T1YV
1. Introduction
This course is designed to help MS Excel users to discover some challenges and different settings of MS Advanced Excel and to get enough skills to fulfill the data management & accounting and statistical responsibilities. This course on advanced excel will help trainees on how to conduct data analysis, generate evidence-based reports to inform decisions making.
Advanced Excel plays a very important role in structuring & presenting data so that it looks impressive. Once one has a good understanding of Excel features like tables, cell styles, formatting options, then it is necessary to make awesome excel workbooks and data analysis to inform decisions’ making. The role of this course is to teach participants the various formulas used in Excel, how to debug them, audit them and how to use which formula for which occasion (and also know few alternatives for any given formula problem).
The training will be practical; participants will work on existing datasets for practices.
2. Course content
The course content includes:
Introduction to Advanced Excel: Learn how modular templates can make your spreadsheets more consistent and much quicker to set up, Customizing the Excel interface to put the tools that you need at your fingertips, how to build in checks and controls from the outset).
Hyperlink-age and protection: Explore effective strategies for collaborating with others on workbooks, safeguarding data through password protection, and securely access of Excel files.
Data Validation: Extended uses of Data Validation, working with validation formulae to ensure data accuracy and consistency by setting up data validation rules and restrictions for cell entries.
Preparing your data for analysis: Mastering lookup functions -INDEX, MATCH, creating helper columns using DATE and TEXT functions, Applying NESTED-IF, AND, OR to organize data), managing large datasets.
Methods of Summarizing Data: Using SUMIF(S), COUNTIF(S), AVERAGEIF(S), Advanced uses of PIVOT-TABLE, features like Value Field Settings, Grouping Data and Slicers among others, Calculations and reporting in Power Pivot –an introduction to Data Analysis Expressions (DAX).
Data analysis: using excel for spreadsheet solutions such as loan amortization, sales report, expenses report, etc.), descriptive statistics with their interpretation in normal life, regression models and test statistics for inference decisions.
Report Visualization Techniques in Excel: Report Interactivity -Using Pick Lists, Form Controls like combo box & Excel Camera, effectively using conditional formatting (formula-driven) for reporting, Calculations in Power Pivot.
Graphs and Charts: Create interactive appealing cha...
Course Code:EPRN12/PT/26
Dates: from 23rd February to 02nd March 2026 (Evening program from 5h30pm-8h30pm).
Venue:EPRN Training Center at University of Rwanda, Gikondo Campus
Use this Link to register: https://tgr.li/T1YV
1. Introduction
This course is designed to help MS Excel users to discover some challenges and different settings of MS Advanced Excel and to get enough skills to fulfill the data management & accounting and statistical responsibilities. This course on advanced excel will help trainees on how to conduct data analysis, generate evidence-based reports to inform decisions making.
Advanced Excel plays a very important role in structuring & presenting data so that it looks impressive. Once one has a good understanding of Excel features like tables, cell styles, formatting options, then it is necessary to make awesome excel workbooks and data analysis to inform decisions’ making. The role of this course is to teach participants the various formulas used in Excel, how to debug them, audit them and how to use which formula for which occasion (and also know few alternatives for any given formula problem).
The training will be practical; participants will work on existing datasets for practices.
2. Course content
The course content includes:
Introduction to Advanced Excel: Learn how modular templates can make your spreadsheets more consistent and much quicker to set up, Customizing the Excel interface to put the tools that you need at your fingertips, how to build in checks and controls from the outset).
Hyperlink-age and protection: Explore effective strategies for collaborating with others on workbooks, safeguarding data through password protection, and securely access of Excel files.
Data Validation: Extended uses of Data Validation, working with validation formulae to ensure data accuracy and consistency by setting up data validation rules and restrictions for cell entries.
Preparing your data for analysis: Mastering lookup functions -INDEX, MATCH, creating helper columns using DATE and TEXT functions, Applying NESTED-IF, AND, OR to organize data), managing large datasets.
Methods of Summarizing Data: Using SUMIF(S), COUNTIF(S), AVERAGEIF(S), Advanced uses of PIVOT-TABLE, features like Value Field Settings, Grouping Data and Slicers among others, Calculations and reporting in Power Pivot –an introduction to Data Analysis Expressions (DAX).
Data analysis: using excel for spreadsheet solutions such as loan amortization, sales report, expenses report, etc.), descriptive statistics with their interpretation in normal life, regression models and test statistics for inference decisions.
Report Visualization Techniques in Excel: Report Interactivity -Using Pick Lists, Form Controls like combo box & Excel Camera, effectively using conditional formatting (formula-driven) for reporting, Calculations in Power Pivot.
Graphs and Charts: Create interactive appealing cha...