Data Analysis with Excel & Power BI

Summary

Learn to turn raw numbers into answers people act on. From the Excel skills every employer tests — the formulas that matter, cleaning messy data, pivot tables — to interactive Power BI dashboards that update themselves. You'll analyze real business data from day one and use AI to write formulas and speed up analysis. By the end, you'll have built dashboards worth showing in an interview — the most in-demand office skill in the job market.

Excel
Power BI
AI Tools

hours in Accelarated Training A full weekend sprint to a finished project.

hours in Continued Training 3 months / 12 weeks for intensive full covered training.

Our students are getting hired by top freelnacing companies. We can help you too.

About this training

Every business collects data; very few people can make it speak. That gap is a career. This practical data analysis training in Tétouan is fully hands-on, taught in a small group of 16 students maximum: you work on real business datasets — sales, inventory, expenses — from the first session, first mastering the Excel skills employers actually test, then building interactive Power BI dashboards that impress in any interview.

Whether you take the Accelerated weekend sprint (14 hours) or the Continued 3-month program (~48 hours), you'll leave with dashboards you built — not a folder of exercises.

Choose your format

Both formats are 100% hands-on — the difference is depth and practice time:

Accelerated (weekend sprint, 14 hours): the analysis essentials fast — the Excel formulas that matter (SUMIFS, XLOOKUP, IF), cleaning a messy dataset, and your first pivot-table dashboard answering real business questions by Sunday.
Continued (3 months, ~48 hours): the full analyst path — advanced Excel, data cleaning at scale, Power BI from import to data model to interactive dashboards, sharing reports, and a portfolio dashboard on real data, built with practice between sessions.

View upcoming dates.

What you'll learn

Thinking in data: asking the question before touching the spreadsheet
The Excel formulas that do 90% of the work: SUMIFS, XLOOKUP, IF, COUNTIFS
Cleaning messy real-world data — the skill every analyst uses daily
Pivot tables: from thousands of rows to answers in minutes
Charts that communicate (and the chart mistakes that mislead)
Power BI: importing data and building a proper data model
Interactive dashboards: filters, slicers, and drill-downs that update themselves
Sharing reports the professional way
AI for analysis: writing formulas, explaining errors, and exploring data faster
Presenting findings: turning a dashboard into a decision

What you'll walk away with

Interactive dashboards built by you on real business data
A personal formula and cleaning toolkit you'll reuse at work forever
A portfolio piece that answers the interview question "show me what you can do"
A Freelancers Web Academy certificate of completion (after a solo project)

New to computers or Excel? Start with Computer Skills & MS Office — this course is its natural next step. Want to go further into code-based data work? Python is the path. Speed up your formulas with AI Mastery.

Ready to start? Pick a session below or ask us on WhatsApp.

Prerequisites

Basic Excel familiarity — if you can open a spreadsheet and type in cells, you're ready; our MS Office training covers that if needed. No math beyond arithmetic, no coding. Power BI Desktop is free. Bring a laptop (Windows preferred for Power BI). Sessions are taught in Moroccan Arabic (Darija) with technical keywords in English at our training center in Tétouan, Morocco.