Course Details: Certificate in Advanced Excel
Duration: 3 Months
Mode: On-Campus
Tuition Fee: USD 150 (Full Course)Location: Meridian Computer Training Center (MIHS), Juba
Course Overview
The Certificate in Advanced Excel equips professionals with high-level spreadsheet modeling and data visualization skills. Designed for corporate staff, project managers, and finance officers, this course transforms raw data into dynamic management dashboards and automated analytical tools.
Key Learning Areas
- Advanced Formulas (VLOOKUP, XLOOKUP, INDEX/MATCH, Nested IFs)
- Pivot Tables, Dynamic Charts & Interactive Dashboards
- Data Validation, What-If Analysis, and Basic Macro Automation
Career Paths
- Data Specialist
- Financial Analyst
- Logistics Officer
- Operations Manager
Curriculum
Month 1: Advanced Formulas & Data Management
- Mastering lookup functions (XLOOKUP, VLOOKUP, INDEX/MATCH) and dynamic arrays
- Advanced logical conditions (NESTED IF, IFS, SUMIFS, COUNTIFS) and error handling (IFERROR)
- Text functions (TEXTJOIN, CONCAT, SEARCH) and date/time calculation functions
- Data cleansing techniques, advanced sorting/filtering, and strict data validation rules
Month 2: Data Analysis & Dashboard Design
- Building dynamic Pivot Tables, Slicers, Timelines, and Pivot Charts
- Data modeling with Power Query to extract, transform, and merge multi-source datasets
- Designing interactive management dashboards with conditional formatting and KPI cards
- Analytical modeling: What-If Analysis (Goal Seek, Data Tables, and Scenario Manager)
Month 3: Automation, Financial Modeling & Reporting
- Financial and project modeling best practices (cash flow, budgeting, forecasting)
- Intro to VBA and Macro Recording for automating repetitive data workflows
- Spreadsheet protection, password controls, auditing tools, and performance optimization
- Final practical project: Developing a fully automated executive dashboard and reporting tool
Fees
Tuition Fee: USD 150 (Full Course)