Real skills. Solid foundations.Kénitra, MoroccoQuestions? Let’s talk.
Analytics & Reporting

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.

Beginner → advanced6 modulesFR / EN · website & free lessons
YOUR PROGRESSION, LEVEL BY LEVEL

The right level. A practical goal.

Start at the level matching your experience. Every stage has prerequisites, workshops and a validation project.

01
LEVEL 01

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
VALIDATION PROJECT

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
Choose this level
02
LEVEL 02

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
VALIDATION PROJECT

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
Choose this level
03
LEVEL 03

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
VALIDATION PROJECT

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
Choose this level
Software & environment

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.

GENIUS NOTES / FREE PREVIEW6 MIN

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 lesson

What 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
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
03Analysis and pivot tables
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
04Reporting, variances and visualisation
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
05Power Query and analytical modelling
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.
06Audit, scenarios and BI transition
Proposed module: concepts, practical cases and knowledge checks. Details are confirmed for your chosen session.

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

EXAMPLE TARGET PROJECT

Build a validated, documented reporting pipeline that refreshes from business data.

Before you enrol

Preview lessonFree · no account
Full programme and materialsAs confirmed for the session
Official examSeparate registration
Cloud environment costsCheck for each lab
TRY BEFORE YOU CHOOSE

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.

Open a free lesson
GENIUS NOTES / 001
CLOUD ARCHITECTURE

A reliable architecture starts with the right questions.

6 min · Reading & exerciseRead the lesson

Your next chapter starts here.

A goal, a question, a project? Let’s talk about your learning path.

Let’s talk about your goals