Excel — Data Analysis & Reporting
Learn to ask useful questions, prepare data and deliver reliable reports. Three in-depth levels connect analysis, dashboards and reproducible updates.
The right level. A practical goal.
Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.
Beginner
Understand what the data represents before producing a first report.
Prerequisites: Everyday computer skills; essential Excel operations are covered.
01Framing the business question
- Audience and expected decision
- Scope and period
- Defining a metric
02Reading a dataset
- Row granularity
- Columns and units
- Keys, categories and dates
03Preparing a clean dataset
- Structured tables
- Types and missing values
- Detecting duplicates
04Calculating and checking
- Sums and averages
- Ratios and denominators
- Checking a sample
05Creating a first summary
- Sorting and segmentation
- A simple pivot table
- Comparing consistent periods
06Explaining without misleading
- A chart suited to the message
- Titles, units and source
- Limits of the analysis
Prove it through practice.
Analyse a sales dataset: a column dictionary, data checks and a summary answering three business questions.
Success criteria- Each row represents a defined event
- Missing values and duplicates are recorded
- Every number can be traced to its source
Intermediate
Produce reproducible periodic reports and explain observed changes.
Prerequisites: Be able to structure a table and produce a basic summary, or complete the beginner level.
01Defining a metric contract
- Revenue, cost and margin
- Weighted ratios and averages
- Rounding and scope rules
02Consolidating multiple sources
- Importing CSV and workbooks
- Normalising columns
- Checking keys before joining
03Explaining variances
- Targets and actuals
- Change and contribution
- Segmenting without double counting
04Going further with pivot tables
- Grouping and slicers
- Value fields and formats
- Consistent filters across views
05Designing a clear report
- Information hierarchy
- Comparison charts
- Comments, alerts and context
06Standardising updates
- Monthly checklist
- Reconciliation checks
- Deliverable and assumption log
Prove it through practice.
Create a sales and margin report: targets, actuals, variances, segments and comments tied to the data.
Success criteria- Targets and actuals use the same scope
- Percentages are recalculated from totals
- Updates follow a reproducible procedure
Advanced
Build an auditable reporting pipeline from source files to decisions, and prepare a move to BI.
Prerequisites: Intermediate reporting, pivot tables and basic Power Query; advanced features depend on Excel version.
01Designing a data pipeline
- Source, preparation and presentation layers
- Parameters and conventions
- Column contracts and anomaly logs
02Advanced Power Query
- Reference queries
- Parameters and simple M functions
- Handling schema changes
03Modelling for analysis
- Facts, dimensions and calendar
- Relationships and uniqueness
- Power Pivot and measures where available
04Building scenarios
- Explicit assumptions
- Sensitivity and simulations
- Distinguishing forecasts from observations
05Auditing performance
- Reducing repeated calculations and oversized ranges
- Testing volume and refresh time
- Checking measures after filtering
06Preparing a BI transition
- Dictionary and business rules
- Mapping Excel to a BI model
- Documentation, acceptance and handover
Prove it through practice.
Build an executive reporting system: multi-file consolidation, an analytical model, scenarios, a control log and a Power BI handover pack.
Success criteria- Refresh is tested with missing or invalid files
- Analyses respect model granularity
- Another analyst can maintain the report from the handover pack
Recent desktop Excel recommended. XLOOKUP, LET, dynamic arrays, Power Query, Power Pivot and automation depend on version, operating system and licence; alternatives are confirmed before the session.
Start with a real lesson.
Before the chart, define what the figure measures.
An explained concept, a diagram or example, then an exercise to work through yourself.
Read the free lessonWhat you will learn to do
- Define and document business metrics
- Check quality before calculating
- Produce reproducible reporting
- Prepare a transition to Power BI
Skills across the programme
01Metric definitions and granularity
02Quality, cleaning and consolidation
03Analysis and pivot tables
04Reporting, variances and visualisation
05Power Query and analytical modelling
06Audit, scenarios and BI transition
Start with the right foundations
Prerequisites
Choose the level matching your experience; each level has detailed prerequisites.
Language and format
Discovery resources are available in French and English. Contact us to confirm the teaching language, format, materials and support for your chosen programme.
Connect knowledge to a project
Build a validated, documented reporting pipeline that refreshes from business data.
Before you enrol
| Preview lesson | Free · no account |
| Full programme and materials | As confirmed for the session |
| Official exam | Separate registration |
| Cloud environment costs | Check for each lab |
The best way to find out?
Start learning.
One lesson, a real concept and an exercise. Discover our approach, without an account and at your own pace.