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

Private AI for Analysts: Excel & AI lessons with AI

AI for Analysts: Excel & AI 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

AI for Analysts: Excel & AI

AI for Analysts: Excel & AI 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

  • Foundations: The Analysis Flow and Working with AI
  • Excel Formulas with AI
  • Data Cleaning
  • Pivot Tables and Capstone
  • Natural-Language Data Analysis
  • Charts and Insights
  • SQL with AI
  • Professional Verification of AI Results
  • Report Automation
  • Data Storytelling

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 · 10 modules · 36 lessons · 19 hr 55 min total

BeginnersBeginner: Formulas, Data Cleaning and Pivot Tables with AI4 modules • 12 lessons • 6 hr 35 min
  1. Foundations: The Analysis Flow and Working with AI2 lessons • 1 hr
    1. 1From Business Question to a Tidy TableTrial lessonabout 30 min
    2. 2Prompting AI for Formulas, and What Not to Pasteabout 30 min
  2. Excel Formulas with AI4 lessons • 2 hr 10 min
    1. 3Aggregation Formulas and References: SUMIFS, COUNTIFSabout 35 min
    2. 4Logic in Formulas: IF, IFS, AND/ORabout 30 min
    3. 5Lookups and Joining Tables: XLOOKUPabout 35 min
    4. 6Don't Trust, Verify: Checking an AI Formulaabout 30 min
  3. Data Cleaning3 lessons • 1 hr 35 min
    1. 7Diagnosing Dirty Dataabout 30 min
    2. 8Cleaning Text and Numbers with AIabout 35 min
    3. 9Repeatable Cleaning: Intro to Power Queryabout 30 min
  4. Pivot Tables and Capstone3 lessons • 1 hr 50 min
    1. 10First Pivot Table: Rows, Columns, Values, Filtersabout 35 min
    2. 11Deeper Pivots, Verified Against SUMIFSabout 35 min
    3. 12Capstone: From Business Question to a Verified Answerabout 40 min
IntermediateIntermediate: Natural-Language Analysis, Charts and SQL with AI3 modules • 12 lessons • 6 hr 40 min

Mapped to exam: Microsoft PL-300 (Power BI Data Analyst) — objectives for analysis and visualization, plus SQL fundamentals

  1. Natural-Language Data Analysis5 lessons • 2 hr 45 min
    1. 1What Happens When You Upload Data and Ask AIabout 30 min
    2. 2Asking a Good Analytical Question: Metric, Segment, Filterabout 30 min
    3. 3Descriptive Statistics the AI Throws at Youabout 35 min
    4. 4Time Analysis: Trend, Seasonality, Year over Yearabout 35 min
    5. 5Analysis Traps: Correlation, Simpson's Paradox, Invented Numbersabout 35 min
  2. Charts and Insights3 lessons • 1 hr 30 min
    1. 6Which Chart Answers Which Questionabout 30 min
    2. 7Honest Charts: Axes, Scales and Misleading Visualsabout 30 min
    3. 8From Chart to Insight: So What and Now Whatabout 30 min
  3. SQL with AI4 lessons • 2 hr 25 min
    1. 9Tables, Schema and Your First AI-Written SELECTabout 35 min
    2. 10GROUP BY and Aggregates — the SQL Pivot Tableabout 35 min
    3. 11JOIN: Combining Tables Without Duplicating Rowsabout 35 min
    4. 12Capstone: Business Question, SQL, Chart and a Verified Numberabout 40 min
AdvancedAdvanced: Verified Analysis, Automated Reports and Data Storytelling3 modules • 12 lessons • 6 hr 40 min
  1. Professional Verification of AI Results4 lessons • 2 hr 10 min
    1. 1Reconciliation and Control Totalsabout 35 min
    2. 2Sanity Checks and Back-of-Envelope Estimatesabout 30 min
    3. 3Reading the Code the AI Ran: Spotting the Bugabout 35 min
    4. 4Audit Trail, Reproducibility and Data Privacyabout 30 min
  2. Report Automation4 lessons • 2 hr 20 min
    1. 5Architecture of a Self-Updating Reportabout 30 min
    2. 6Advanced Power Query: Folder, Merge, Parametersabout 35 min
    3. 7Data Model and DAX Measuresabout 40 min
    4. 8A Dashboard That Checks Itselfabout 35 min
  3. Data Storytelling4 lessons • 2 hr 10 min
    1. 9One Message, One Audience: Story Structureabout 30 min
    2. 10Slides That Speak: Action Titles and Declutteringabout 30 min
    3. 11Presenting Honestly: Uncertainty, Limits and Tough Questionsabout 30 min
    4. 12Capstone: Automated, Verified, Told Monthly Reportabout 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

  • Adults: for work, study, an exam, or just curiosity

Exams and certifications

  • Intermediate: Microsoft PL-300 (Power BI Data Analyst) — objectives for analysis and visualization, plus SQL fundamentals
  • AI & Machine Learning

    with Noam

    Live 1:1 lesson with an AI teacherabout 19 hours35 lessons3 levels
  • Using AI Wisely

    with Noam

    Live 1:1 lesson with an AI teacherabout 12 hours24 lessons2 levels
  • Machine Learning

    with Noam

    Live 1:1 lesson with an AI teacherabout 20 hours36 lessons3 levels
  • Deep learning

    with Noa

    Live 1:1 lesson with an AI teacherabout 18 hours34 lessons3 levels
  • Computer Vision

    with Noam

    Live 1:1 lesson with an AI teacherabout 20 hours36 lessons3 levels
  • Generative AI & Prompt Engineering

    with Noa

    Live 1:1 lesson with an AI teacherabout 19 hours36 lessons3 levels
See all courses in Artificial Intelligence

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 AI for Analysts: Excel & AI lesson work?
Pick AI for Analysts: Excel & AI 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 AI for Analysts: Excel & AI course take?
12 lessons of about 33 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

AI for Analysts: Excel & AIThe first 45 minutes are free

Private lessonStart free