Microsoft Excel — From Beginner to Advanced

Overview

An Excel course built around real office tasks: structure data, calculate, check, present and automate. You work on examples close to professional situations (sales, expenses, schedules, customer lists) and leave with reusable templates.

Tools : Excel

Who is this course for?

• Professionals
• Accountants
• Administrative staff
• Students
• Entrepreneurs

• You enter or consolidate data in Excel without a reliable method.
• You have to produce regular tables, reports or tracking sheets.
• You want to save time on repetitive calculations and formatting.

What you will be able to do

• Structure clean, usable tables (Excel tables, data validation)
• Use the essential formulas: IF, SUMIFS, COUNTIF, XLOOKUP / VLOOKUP
• Sort, filter and use conditional formatting to spot discrepancies
• Create pivot tables and readable charts
• Prepare a summary report with simple indicators (KPIs)

Practical exercises and projects

1. 1 Analyze a sales file: indicators, pivot table and charts
2. 2 Build an expense or budget tracker with input checks
3. 3 Clean a customer list imported from a CSV file

Program

1. 01 — Basics and data structure

   Data entry, formats, Excel tables, sorting and filters.

2. 02 — Formulas and functions

   Calculations, conditional and lookup functions, error handling.

3. 03 — Formatting and control

   Conditional formatting, data validation, cell protection.

4. 04 — Pivot tables and charts

   Summarize and visualize data.

5. 05 — Automate and deliver

   Reusable templates and preparing a final report.

Prerequisites

Being able to use a computer. No prior Excel knowledge is needed to start; the advanced modules are for those who already master the basics.

Teaching method

80% practice / 20% theory

• Short alternation of theory and exercises: you practice throughout the session.
• Concrete cases and realistic datasets drawn from professional or academic situations.
• Limited group size, with the instructor supporting you during the exercises.
• In-person training in a training room in Marrakech.

Location

📍 Marrakech — in-person training in a training room provided by a partner school. The exact address is given for each session.

Price

The price is set for each session and has not been published yet. Request the next dates to find out.

Frequently asked questions