45 free lesson minutes · Start now, no credit card needed
Shiur Prati

Private Excel for Data Analysis lessons with AI

Excel for Data Analysis with a live private lesson: the teacher talks with you out loud and explains on a shared board, moving at your pace through a clear plan, lesson after lesson.

Live 1:1 lesson with an AI teacher

Teacher: Noam

  • Course updated 11/2026
  • Hebrew, and 5 more languages
  • 3 levels
  • 36 lessons · about 20 hours of lessons

Excel for Data Analysis

Excel for Data Analysis with a live private lesson: the teacher talks with you out loud and explains on a shared board, moving at your pace through a clear plan, lesson after lesson.

12 lessons · 4 modules · Live private lesson with the teacher on the board

What you'll learn

  • Worksheet and Data Basics
  • Formulas, References and Core Functions
  • Organizing Data: Sorting, Filtering and Tables
  • First Charts
  • Data Cleaning
  • Conditional Summaries
  • Lookups and Joining Tables
  • Pivot Tables
  • Conditional Formatting
  • Modern Formulas: Dynamic Arrays
  • Power Query: Automated Import and Cleaning
  • Data Model and DAX
  • What-If Analysis
  • Professional Dashboard

What's included

  • Live 1:1 lessons with an AI tutor on a shared board
  • 20 hours of live one-on-one lessons
  • 36 lessons on a shared board, each with a clear goal
  • Practice and a understanding check in every lesson
  • A summary after every lesson, saved in the history
  • A completion certificate for each level
  • Computer, tablet or phone
  • Hebrew, plus 5 more languages

Course plan

3 levels · 14 modules · 36 lessons · 19 hr 40 min total

BeginnersExcel for Data Analysis — Beginner: From a Blank Sheet to Formulas, Filtering and First4 modules • 12 lessons • 6 hr 15 min

Mapped to exam: MO-200 Microsoft Excel (Associate) — domains 1-5 at basic depth

  1. Worksheet and Data Basics2 lessons • 1 hr
    1. 1Workbook, Sheet and Cell: What a Good Data Table Looks LikeTrial lessonabout 30 min
    2. 2Data Types and Number Formats: Text, Number, Dateabout 30 min
  2. Formulas, References and Core Functions5 lessons • 2 hr 40 min
    1. 3First Formulas: Equals Sign, Operators and Referencesabout 30 min
    2. 4Copying Formulas: Relative, Absolute and Mixed Referencesabout 35 min
    3. 5Summary Functions: SUM, AVERAGE, MIN, MAX, COUNTabout 30 min
    4. 6Decisions in Formulas: IF and Logical Comparisonsabout 35 min
    5. 7When Formulas Break: Error Values and Debuggingabout 30 min
  3. Organizing Data: Sorting, Filtering and Tables3 lessons • 1 hr 30 min
    1. 8Sorting Data: Single, Multi-Level and Custom Sortabout 30 min
    2. 9Filtering Data: AutoFilter and Focused Questionsabout 30 min
    3. 10Excel Tables: Smart Ranges That Growabout 30 min
  4. First Charts2 lessons • 1 hr 5 min
    1. 11Which Chart for Which Question: Column, Line and Pieabout 30 min
    2. 12A Chart That Tells a Story: Titles, Axes and Labelsabout 35 min
IntermediateIntermediate: From Raw Data to Business Answers5 modules • 12 lessons • 6 hr 30 min
  1. Data Cleaning3 lessons • 1 hr 35 min
    1. 1Text Functions: TRIM, Splitting and Joining Columnsabout 35 min
    2. 2Fixing Data Types: Numbers as Text and Broken Datesabout 30 min
    3. 3Duplicates and Data Validationabout 30 min
  2. Conditional Summaries2 lessons • 1 hr 5 min
    1. 4COUNTIFS, SUMIFS, AVERAGEIFSabout 35 min
    2. 5Advanced Logic: AND, OR, IFS and IFERRORabout 30 min
  3. Lookups and Joining Tables3 lessons • 1 hr 35 min
    1. 6VLOOKUP: Exact Match and Its Limitsabout 30 min
    2. 7XLOOKUP: Flexible Lookup, Missing Values and Tiersabout 35 min
    3. 8Real-World Joins: Keys and Two-Criteria Lookupsabout 30 min
  4. Pivot Tables3 lessons • 1 hr 40 min
    1. 9First Pivot Table: Rows, Columns, Values, Filtersabout 35 min
    2. 10Pivot Depth: Date Grouping and Show Values Asabout 35 min
    3. 11From Business Question to Pivot: Refresh, PivotChart and Pitfallsabout 30 min
  5. Conditional Formatting1 lesson • 35 min
    1. 12Conditional Formatting: Built-in and Formula Rulesabout 35 min
AdvancedExcel for Data Analysis — Advanced (Professional)5 modules • 12 lessons • 6 hr 55 min

Mapped to exam: Microsoft MO-211 Excel Expert (Microsoft 365 Apps); Power Query ומודל הנתונים לפי PL-300

  1. Modern Formulas: Dynamic Arrays2 lessons • 1 hr
    1. 1Dynamic Arrays: FILTER, SORT, UNIQUE and Spillabout 30 min
    2. 2LET and LAMBDA: Readable Formulas and Custom Functionsabout 30 min
  2. Power Query: Automated Import and Cleaning3 lessons • 1 hr 45 min
    1. 3Power Query: Data Import as a Repeatable Processabout 35 min
    2. 4Reshaping Data: Unpivot, Split and Custom Columnsabout 35 min
    3. 5Merge and Append: Combining Tables and Folder Filesabout 35 min
  3. Data Model and DAX2 lessons • 1 hr 15 min
    1. 6Data Model: Star Schema and Relationshipsabout 35 min
    2. 7DAX Measures: SUM, DIVIDE and CALCULATEabout 40 min
  4. What-If Analysis2 lessons • 1 hr 5 min
    1. 8Goal Seek and Data Tablesabout 30 min
    2. 9Scenario Manager and Solverabout 35 min
  5. Professional Dashboard3 lessons • 1 hr 50 min
    1. 10Dashboard Design: KPIs, Layout and Advanced Chartsabout 35 min
    2. 11Interactive Dashboard: Slicers, Timelines and Connected Chartsabout 35 min
    3. 12Capstone: From Raw File to a Refreshable Dashboardabout 40 min

What you need

  • No prior knowledge needed for beginner level: the teacher checks what you already know and starts from there
  • For higher levels: what you learned at the level before (you can skip it if you already know it)
  • A computer, tablet or phone with a microphone, and a browser

Who it's for

  • Any age: the teacher adjusts the explanation to the learner

Exams and certifications

  • Beginners: MO-200 Microsoft Excel (Associate) — domains 1-5 at basic depth
  • Advanced: Microsoft MO-211 Excel Expert (Microsoft 365 Apps); Power Query ומודל הנתונים לפי PL-300
  • Coding for kids

    with Noam

    Live 1:1 lesson with an AI teacher2 levels
  • Programming in Python

    with Noam

    Live 1:1 lesson with an AI teacher3 levels
  • Web Development

    with Noam

    Live 1:1 lesson with an AI teacher3 levels
  • DevOps

    with Noa

    Live 1:1 lesson with an AI teacherabout 24 hours42 lessons3 levels
  • Cloud computing

    with Noa

    Live 1:1 lesson with an AI teacher3 levels
  • Data and SQL

    with Noa

    Live 1:1 lesson with an AI teacher3 levels
See all courses in High-tech

Your teacher

NoamNoamAI private tutor, in a live lesson on a shared board

A private AI teacher who teaches in a live conversation: asks, listens, draws on the board, and lets you solve it yourself with hints. Remembers what you've learned and starts each lesson where you left off.

What's a lesson like?

  • Your child talks with the teacher out loud, like a video call, and asks about anything unclear.

  • The teacher explains, writes and draws on a shared board, and your child solves along on the same board.

  • Snap a photo of a worksheet or homework and work through it, one problem at a time.

  • Parents get a report: study time, what went well and what needs more practice.

Lesson rules

  • Just Learning

FAQ

How does a private Excel for Data Analysis lesson work?
Pick Excel for Data Analysis and a level, then talk with the teacher out loud. The teacher asks what you already know, explains, writes and draws on the board, and lets you solve on your own with hints until it's clear.
How long does the Excel for Data Analysis course take?
12 lessons of about 31 minutes at the first level, at your own pace. You can pause, go back, or skip what you already know.
Do I need prior knowledge?
Not for beginner level. At the start of the first lesson the teacher checks what you already know and adjusts the level, and you can jump straight to an advanced level.
How do I start for free?
Sign in with Google or a code sent to your email, enter your child's name and grade, and the lesson starts right away. Every family gets 45 free lesson minutes in any subject, counted by actual lesson time, with no credit card. Then choose a paid plan and cancel anytime.
What device do I need?
Any computer, tablet or phone with a browser and a microphone. You can also install the site as an app on your home screen.

Want to try it?

Sign in, enter your child's name and grade, and the lesson begins. 45 free lesson minutes, no credit card.

Start for free

Shiur Prati with AI: what it is and how it works

Excel for Data AnalysisThe first 45 minutes are free

Private lessonStart free