Skills
Advanced spreadsheets and quantitative analysis
The spreadsheet remains the most widespread tool in any organisation, and the most under-used. Nested formulas, pivot tables, automation and dashboards: four moves turn a passive file into a steering instrument consulted every week.
The fastest lever in a working role
No skill pays back this fast. A reconciliation done by hand every Monday morning becomes a formula; a report rebuilt every month becomes a pivot table that refreshes itself; repetitive data entry becomes a macro. The time returned is counted in days per quarter, and the team sees it at once. That is why the course runs over two months and is aimed first at people already in a role.
- Build a lookup and control formula spanning several sheets
- Analyse a dataset with pivot tables and slicers
- Automate a recurring task with a recorded then refined macro
- Assemble a monthly dashboard that refreshes itself
The scale of the learning
You run a department dashboard single-handed and automate the processes that feed it each month. Four figures are enough to place a skill: blocks, hours, credits and certified outlets.
- teaching blocks
- 5
- of taught instruction
- 300 h
- credits in total
- 30
- professional qualifications concerned
- 4
Catalogue rule: one credit is twenty-five hours of work, ten of them taught.
- Advanced Excel
- 40 (13 %)
- Business Management programme — Bac+3 level
- 260 (87 %)
Where it is trained
Each row is a block from the official catalogue. The taught volume and the year of study are those of the filed programme, reproduced as they stand.
| Teaching block | Programme | Taught hours | Year |
|---|---|---|---|
| Advanced formulas | Advanced Excel | 10 h | Year 1 |
| Data analysis | Advanced Excel | 10 h | Year 1 |
| Automation | Advanced Excel | 10 h | Year 1 |
| Dashboards | Advanced Excel | 10 h | Year 1 |
| Management control | Business Management programme — Bac+3 level | 260 h | Year 3 |
The frameworks that carry it
The framework lists the blocks to be validated. This skill appears there as a professional requirement.
| Professional qualification | Target occupation | Level | Taught volume |
|---|---|---|---|
| SME Administrative Officer | administrative officer, all-round assistant | 4 · Skilled employee and operative | 600 h |
| Accounting Assistant | accounts assistant | 4 · Skilled employee and operative | 600 h |
| Executive Assistant | executive assistant, office assistant | 5 · Senior technician and supervisor | 700 h |
| Secretary and Administrative Assistant | secretary, administrative assistant | 4 · Skilled employee and operative | 600 h |
Durations, volumes and fees
Everything is shown here, with no quote and no prior call. The amount you read is the amount you pay.
| Programme | Level | Duration | Fees |
|---|---|---|---|
| Advanced Excel | Short course | 2 months | 900 000 GNF in total |
| Business Management programme — Bac+3 level | Bachelor's degree | 3 years | 4 800 000 GNF per year |
Explore next
- Data qualityData preparation and quality at IHETC: cleaning, reconciliation, control rules and documentation. 200 taught hours in business intelligence.
- Applied statisticsApplied statistics at IHETC: 240 taught hours in data science, plus spotting misleading analysis in the executive certificate. Programmes, levels and target roles.
- Machine learningMachine learning at IHETC: 200 taught hours of training, evaluation and interpretability, grounded in the mathematics of the field. Programmes and roles.
- Deep learningDeep learning and language models at IHETC: 400 taught hours, from network architecture to document-grounded generation. Programmes and roles.
- MLOpsMLOps at IHETC: model deployment and monitoring, containers, versioning, drift and compute cost. Taught hours, programmes and roles concerned.
- DashboardsDashboards and reporting at IHETC: indicator selection, chart design, refresh and executive readability. Taught hours and target roles.