Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Learn data, code and cloud by doing the work.

        Real exercises in tools built for practice. Pick one below and try it.

        What are you practicing for?

        Pick one and we take you to the right practice.

        Or try an exercise right here

        Practice for the job or exam you want.

        Practice the skills for the job or exam you want.

        Exercises in working copies of the tools, practice tests for real exams, and interviews with an interviewer who follows up.

        Practice the skills for the job or exam you want.

        Exercises in working copies of the tools, practice tests for real exams, and interviews with an interviewer who follows up.

        Excel course
        1. SUM
        2. COUNT
        3. IF
        4. VLOOKUP
        5. INDEX MATCH
        6. XLOOKUP

        Lesson 1 · SUM

        Total the revenue in B5

        1. Click cell B5. The formula is already started.
        2. Finish it so it adds the three revenue cells.
        3. Press Enter or Check answer.

        Lesson 1 done

        Loading free practice details

        Continue the Excel course
        FileHomeInsertFormulasDataReviewView
        B5
        fx
        SalesTargets
        Your turn

        Practice the first unit of every course. No account needed.

        Courses

        All 81 courses

        Analyze data in spreadsheets, SQL workspaces, notebooks and dashboard builders.

        Excel course

        Excel

        For Excel assessments, MO-200

        176 lessonsFree access details

        SQL course

        SQL

        For SQL interviews and tests

        102 lessonsFree access details

        pandas course

        pandas

        For Take-home tasks

        85 lessonsFree access details

        Machine learning course

        Machine learning

        For Data scientist and machine learning interviews

        62 lessonsFree access details

        R course
        Start with

        Vectors, data frames and dplyr verbs

        Build toward

        Joins, tidyr, ggplot2 charts, functions and models

        R

        For Data analyst and data scientist roles that ask for R

        69 lessonsFree access details

        Power BI course

        Power BI

        For PL-300

        99 lessonsFree access details

        Tableau course

        Tableau

        For Desktop Foundations

        87 lessonsFree access details

        Google Sheets course

        Google Sheets

        For Office and analyst roles

        81 lessonsFree access details

        Power Query course

        Power Query

        For Reporting roles, PL-300

        66 lessonsFree access details

        Snowflake SQL course

        Snowflake SQL

        For SnowPro Core

        63 lessonsFree access details

        BigQuery SQL course

        BigQuery SQL

        For Analytics roles, GA4 work

        57 lessonsFree access details

        dbt course

        dbt

        For Analytics engineering

        52 lessonsFree access details

        Databricks course

        Databricks

        For Databricks Data Engineer Associate

        57 lessonsFree access details

        Dagster course
        Start with

        Assets, dependencies and materializing

        Build toward

        Partitions, sensors, automation, asset checks and tested pipelines

        Dagster

        For Data engineer and analytics engineer interviews and orchestration job tests

        64 lessonsFree access details

        Apache Airflow course
        Start with

        Dags, tasks and your first runs

        Build toward

        Scheduling, retries, sensors, assets, dynamic task mapping and tested Dags

        Apache Airflow

        For Data engineer interviews and Airflow certification-style tests

        68 lessonsFree access details

        Apache Kafka course
        Start with

        Topics, partitions and keyed records

        Build toward

        Consumer groups, delivery guarantees, schemas, Connect and stream processing

        Apache Kafka

        For Data engineer interviews and Kafka developer skills assessments

        59 lessonsFree access details

        Alteryx Designer course

        Alteryx Designer

        For Analyst roles and Core-style practice

        49 lessonsFree access details

        Google Analytics 4 course
        Start with

        Reports, events, users and sessions

        Build toward

        Audiences, attribution, the BigQuery export and property audits

        Google Analytics 4

        For Marketing and data analyst roles that use GA4, and the topics of the Google Analytics Certification

        43 lessonsFree access details

        Statistics for data roles course
        Start with

        Averages, spread, percentiles and correlation

        Build toward

        Confidence intervals, hypothesis tests and A/B test design

        Statistics for data roles

        For The statistics rounds of data analyst and data scientist interviews

        27 lessonsFree access details

        Looker and LookML course
        Start with

        Explore fields, filters and warehouse grain

        Build toward

        LookML views, measures, joins, derived tables, access filters and dashboards

        Looker and LookML

        For BI developer, data analyst and analytics engineer job tests

        57 lessonsFree access details

        See how it works

        Every lesson is the same four steps, in whichever tool you pick.

        Open Excel lesson
        1. 1Read the task

          A short explanation, then one clear task.

        2. 2Do it in the tool

          Work in the tool, as you would at your job.

        3. 3Get checked

          At once, with a hint when it's wrong.

        4. 4Move up

          The next exercise, from beginner to expert.

        Free lessons and plans

        Practice the first unit of every course. No account needed.

        Counts are per course. All Access includes every course.

        Practice across 81 courses

        Free

        $0

        Course lessons need no account or card

        Lessons
        Up to 8
        Projects and case studies
        Up to 1
        Timed mock exams
        0
        Start free

        One Course

        $17.99/ month

        Billed monthly, cancel any time

        Lessons
        Up to 176
        Projects and case studies
        Up to 24
        Timed mock exams
        Up to 12
        Choose a course

        All Access

        $29.99/ month

        Billed monthly, cancel any time

        Lessons
        5,280
        Projects and case studies
        681
        Timed mock exams
        176
        Get All Access
        Lessons
        Up to 8
        Up to 176
        5,280
        A practice workspace for every tool, nothing to install
        Every answer checked, with hints
        Projects and case studies
        Up to 1
        Up to 24
        681
        Timed mock exams
        0
        Up to 12
        176
        Typed interview practice
        60 min a day
        60 min a day
        No daily limit
        Dumbbells for spoken interviews
        Buy a pack
        Buy a pack
        30 a month, plus packs
        Interviews built for a real job ad
        With dumbbells
        With dumbbells
        2 a month
        Progress and badges kept in your account
        Compare everything in each plan
        Interview Hub

        Dumbbells for spoken interviews, on any plan

        One dumbbell is one spoken minute. 60 free text interview minutes a month.

        • 60 dumbbells$19.99$0.33 a dumbbell
        • 180 dumbbells$49.99$0.28 a dumbbell
        • 400 dumbbells$99.99$0.25 a dumbbell
        See dumbbell packs

        Questions

        What tools do data analysts use?

        Most use a spreadsheet (Excel or Google Sheets), SQL to get data out of databases, a dashboard tool like Power BI or Tableau, and often Python with pandas. The Work Gym has a hands-on course for each.

        How do I practice for an Excel test for a job interview?

        Do the tasks those tests use, against the clock: lookups, SUMIFS, cleaning data, charts and summaries. The Excel course builds up to exactly that and ends with mock exams in the same style.

        What are common data analyst interview questions?

        Expect SQL queries (joins, GROUP BY, window functions), a spreadsheet task, questions on metrics and a short case. The SQL, pandas and consulting courses each have interview sets built from these.

        Is The Work Gym free?

        Free access details are loading. Visit plans and pricing for current access.

        Do I need to install anything?

        No. The simulators run in your browser, including Python notebooks, SQL workspaces, Linux terminals, Git repositories and a local AWS account.

        How long does a lesson take?

        Most take 5 to 15 minutes: a short explanation and a few exercises. Projects and mock exams take longer, and you can stop and come back.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.