Laureal
Back to the catalogue
Office Software & Productivity

Excel — From Fundamentals to Advanced

This training begins with mastering the fundamentals of Excel, including formatting and the use of relative and absolute references. You will then progress to advanced formulas such as INDEX/MATCH, IFS, IFERROR, and the nesting of complex functions. The program also covers creating pivot tables, using slicers, and designing high-performance charts. You will learn to connect to external data sources using Power Query and to secure your inputs with drop-down menus and data validation rules. Finally, you will apply all these skills through a hands-on case study: designing a Target vs Actual dashboard based on real business data.

Duration
15h
Level
Beginner
Format
Online

What you will learn

  1. 01Master Excel fundamentals: formatting, references (relative and absolute), and essential functions.
  2. 02Write advanced formulas: INDEX/MATCH, IFS, IFERROR, and nested functions.
  3. 03Build and manipulate pivot tables to summarize large datasets.
  4. 04Use slicers and interactive filters to make reports dynamic.
  5. 05Design effective, readable charts that communicate insights clearly.
  6. 06Connect to external data sources using Power Query.
  7. 07Secure data entry using drop-down menus and data validation rules.
  8. 08Build a complete Target vs Actual dashboard as a real-world capstone project.
Who it is for

Business professionals, analysts, managers, and anyone working regularly with spreadsheets who wants to move beyond basic Excel use and produce reliable, professional reports and dashboards.

Prerequisites

Basic familiarity with Excel (entering data, simple formulas like SUM and AVERAGE, simple formatting). No prior experience with pivot tables or advanced functions required.

Instructors

Original Name

Updated bio.

Terms

  • Courses run online or in person, in three-hour sessions, on a dedicated hands-on environment (Linux VM, lab FortiGate, a running dataset depending on the path).
  • Every certification path includes at least one marked mock exam under real conditions, with an individual remediation plan.
  • Registration and sitting fees for the official exams (LPI, Fortinet, Microsoft) are not included in the course price.
  • A tailored quote is drawn up based on the number of participants, the schedule you want and the format, open enrolment or in-house.