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.

        Excel projects for your portfolio

        Realistic Excel work, from a monthly sales report to a budget against actuals, done in a working spreadsheet and checked step by step. Each finished project ends in a record you can share.

        Projects that move between tools

        One company brief, worked through each tool in turn. Your own tables carry from one stage to the next, and you finish with a written readout. Every brief is free to read.

        Hearthline
        ExcelSQLpandasPower BI
        ProjectFree

        Why is profit falling when sales are up?

        Your first week as Hearthline's data analyst. Turn a messy order export into gross profit in Excel, roll it up in SQL, measure what each discount code costs in pandas, chart the margin in Power BI and tell your manager what to change.

        5 stages · 2 h 30 minView brief
        Greenbasket Market
        ExcelSQLPower BI
        Project

        Did the summer promotions pay?

        Marketing ran eight promotions this summer and wants to plan the fall. Turn the offers into numbers, measure each one against the weeks before it, total the extra sales and write the memo.

        4 stages · 2 h 30 minView brief
        Greenbasket Market
        SQLExcel
        Case study

        Why did September revenue drop?

        The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.

        3 stages · 1 hView brief
        Greenbasket Market
        ExcelSQLPower BIGoogle SheetsTableau
        Journey

        Your first 90 days as a data analyst

        You've joined Greenbasket's two-person analytics team. Review the summer promotions, find the stores running out of stock, then explain a bad month to the CFO.

        4 chapters · 5 h 40 minSee the journey
        Quillfield
        SalesforcePower AutomateExcel
        Project

        Find the leads nobody is calling

        Demo requests from the Central region have gone quiet since August. Fix the Salesforce rule that sends them to a rep who left, build the flow that tells each owner about a new lead, and report conversion by owner in Excel.

        4 stages · 1 h 50 minView brief
        Marlow & Pike
        AccountingExcelPower BI
        Project

        Close October and explain the cash

        October looks profitable, yet cash ended well below forecast. Post the adjusting entries, put each cash line next to its forecast in Excel, build the CFO's view in Power BI and write the month-end note.

        4 stages · 1 h 40 minView brief
        Ashgrove Engineering
        Resource planningExcel
        Project

        Staff a new programme without burning anyone out

        Ashgrove has won eight weeks of bridge inspections. Find who can really take the work in the resource planner, after leave, part-time hours and other jobs, then show everyone's load in Excel and tell operations whether to hire.

        3 stages · 1 h 15 minView brief

        Projects and case studies in the Excel course

        19 briefs inside the course, each a realistic task checked step by step in the tool.

        What you can show at the end

        A record with a verification code. Each project, case study and mock exam you finish gets a record that says what you did and when. Anyone you share the code with can check it.

        A portfolio page. Your records collect on one page you can link from a CV or a LinkedIn profile. Check a record

        Projects over exercises

        An exercise tests one skill. A project gives you a messy file and a person who wants an answer, and leaves the order of steps to you. That’s closer to the job, and it’s what an interviewer means by “tell me about something you built in Excel.”

        Each project in the Excel course starts from a brief: who asked, why, what the data is and what done looks like. You work in the spreadsheet with the ribbon, formula bar and shortcuts you’ll use at work, and each step is checked before you move on. The checks look at the result, so any formula that gets there counts.

        Talking about your project

        In an interview, pick one project and describe the decision it fed, not the functions you used. Saying which departments ran over budget, and on what, tells the interviewer more than “I used SUMIFS.” The spoken Excel task talk-through in the Interview Hub lets you rehearse exactly that, with follow-up questions.

        Next steps

        Excel is rarely the only tool a job uses. The projects in the library above carry your own sheet into SQL and Power BI. For the exams, see the MO-200 and MO-201 style mock exams at the end of the Excel course, and for more projects across tools, data analytics projects.

        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.

        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.