Excel intermediate Course
This course teaches intermediate Excel skills for data cleaning, analysis, and reporting, focusing on sales data to create reproducible BI-ready outputs.

from 4 to 360h flexible workload
valid certificate in your country
What will I learn?
The Intermediate Excel Course assists you in swiftly converting raw sales files into clean, dependable reports. You will learn to import CSVs, correct data types, standardise categories, and record cleaning processes. Construct organised tables, summary formulae, and time-related metrics, then develop pivot tables, slicers, charts, and straightforward summary sheets to ensure your work is reproducible, precise, and prepared for sharing with stakeholders.
Elevify advantages
Develop skills
- Build clean Excel data models: import, type-fix, and structure BI-ready tables.
- Analyse sales with pivots: slicers, multi-field layouts, and time-series views.
- Create robust formulas: structured refs, IFERROR, and multi-condition aggregations.
- Evaluate discount impact: per-unit metrics, buckets, and weighted price insights.
- Deliver BI-grade reports: summary sheets, clear labels, logs, and exportable files.
Suggested summary
Before starting, you can change the chapters and the workload. Choose which chapter to start with. Add or remove chapters. Increase or decrease the course workload.What our students say
FAQs
Who is Elevify? How does it work?
Do the courses have certificates?
Are the courses free?
What is the course workload?
What are the courses like?
How do the courses work?
What is the duration of the courses?
What is the cost or price of the courses?
What is an EAD or online course and how does it work?
PDF Course