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 assignments for practice with checked results

        Three Excel assignments for practice on one fictional dataset: an expense tracker, a budget comparison and a PivotTable report, each with results to check.

        A person practicing on a laptop in a quiet workspace

        Useful Excel assignments for practice give you a workplace task, starting data, and results you can check. Build an expense tracker, extend the tracker into a budget comparison, and create a PivotTable spending report using the same fictional purchases. Then change one expense to test whether the calculations and report update correctly.

        Three projects in a useful order

        Start with individual expenses, move to team budgets, and finish with a summary report. Reusing the source data lets you concentrate on one new skill at a time rather than repeatedly setting up a workbook.

        • Expense tracker: practice recording purchases and checking numeric entries, a task an operations coordinator might perform.
        • Budget comparison: practice comparing actual spending with an allowance, a task a financial analyst might perform.
        • Spending summary: practice grouping records and explaining totals, a task a data analyst might perform.

        These tasks demonstrate specific spreadsheet skills, not readiness for an entire role. The instructions use Excel for Microsoft 365 on Windows, English function names, and comma argument separators. You can copy all starting data directly from the article; no downloadable workbook is required.

        An expense tracker

        An expense tracker records individual purchases and calculates total spending. Open a blank worksheet, rename the worksheet Expenses, and paste the following tab-separated data into cell A1. Keep one purchase per row so each amount belongs to one item and one team.

        Item	Team	Amount
        Hosting	Ops	120
        Travel	Sales	80
        Hosting	Ops	150
        Supplies	Sales	50

        Before reading the solution, calculate total spending and count the numeric expense entries. Put the label Total spending in B7 and Numeric expense entries in B8. Enter your calculations in C7 and C8.

        For a longer budget comparison, try Project: budget versus actual in the Excel course, or a workplace task that runs across tools in Close October and explain the cash. The Work Gym provides practice in working copies of tools in the browser, with automatic exercise checks and a hint naming the mistake.

        For the solution, enter the first formula below in C7 and the second in C8. SUM adds the values in a range, while COUNT counts cells containing numbers.

        =SUM(C2:C5)
        =COUNT(C2:C5)

        Your results should match these checks:

        Measure	Result
        Total spending	400
        Numeric expense entries	4

        Practice what this post teaches

        The count check matters because a plausible spending total can still be incomplete. In a portfolio, keep both checks visible rather than showing only a formatted total.

        A budget comparison

        A budget comparison shows whether each team's actual spending exceeds its allowance. Keep the expense records in A1:C5 and paste the following data into E1 on the Expenses worksheet.

        Team	Budget	Actual	Remaining	Status
        Ops	300
        Sales	100

        Try calculating actual spending for each team before using the solution. The Actual column should add only the expense amounts whose team matches the team in column E. Remaining should equal budget minus actual spending.

        Enter the following formulas in G2, H2, and I2, respectively. Then select G2:I3 and choose Home > Fill > Down to copy the formulas into row 3.

        =SUMIF($B$2:$B$5,E2,$C$2:$C$5)
        =F2-G2
        =IF(H2<0,"Over budget","Within budget")

        SUMIF checks the team names in column B and adds matching amounts from column C. The dollar signs create absolute references, which keep the source ranges fixed when you copy the formula. E2 has no dollar signs, so the copied formula uses E3 for the next team.

        IF selects a label based on a logical test: whether remaining budget is below zero. Under the budget-minus-actual convention, a negative remainder means overspending; zero means the team has used its full budget.

        Team	Budget	Actual	Remaining	Status
        Ops	300	270	30	Within budget
        Sales	100	130	-30	Over budget

        Check that the two Actual amounts add to the expense tracker's total of 400. If a team total is unexpectedly low, inspect the source labels for extra spaces: a trailing space can stop a team name from matching. If the status labels seem reversed, inspect the subtraction order before changing IF.

        A spending summary

        A PivotTable summarizes expense rows by team without requiring a separate formula for each team. A PivotTable is an interactive summary that groups records and calculates totals.

        Your task is to report spending by team and identify the larger spender. On the Expenses worksheet, select A1:C5, choose Insert > PivotTable, choose New Worksheet, and select OK. In the PivotTable Fields pane, place Team in Rows and Amount in Values.

        Check that the Values area shows Sum of Amount. If the summary uses Count of Amount, open the field's Value Field Settings and choose Sum. Also inspect the source amounts for text or mixed data types, which can cause Excel to choose Count.

        Team	Sum of Amount
        Ops	270
        Sales	130
        Grand Total	400

        Count measures records rather than spending, so changing the label alone would not fix the calculation. Confirm both the aggregation method and the values.

        Write a short business observation: Ops spent more than Sales in the supplied records. Do not describe a monthly trend or claim that spending increased. The dataset has no dates or earlier period for comparison.

        A deliberate change test

        A deliberate change test checks whether your workbook responds correctly when a source value changes. On the Expenses worksheet, change the Travel amount in C3 from 80 to 110.

        Predict the results before inspecting the workbook. The Travel expense increases by 30, so total spending and Sales spending should each increase by 30. Ops spending should not change.

        Measure	Expected result
        Total spending	430
        Numeric expense entries	4
        Sales actual spending	160
        Sales remaining budget	-60
        Ops actual spending	270

        Formulas update automatically when Excel uses automatic calculation. If the formula results stay unchanged, check Formulas > Calculation Options > Automatic.

        The PivotTable may still show the original totals because formula recalculation and PivotTable refresh are separate operations. Right-click inside the PivotTable and select Refresh. Sales should now show 160, Ops should show 270, and Grand Total should show 430.

        The workbook has an important limitation: the formulas and PivotTable source cover only the four supplied expense rows. Adding a fifth expense is a separate test. Expanding the source ranges or using an Excel table requires additional setup.

        Portfolio evidence and next steps

        A useful portfolio entry shows the task, your calculation choices, and evidence that the workbook works. Save the source records, budget comparison, PivotTable, and a short note recording both the original results and the change-test results.

        • Use the expense tracker to demonstrate numeric checks and explain why counting entries supports the total.
        • Use the budget comparison to demonstrate conditional totals, fixed source references, and a clear sign convention.
        • Use the PivotTable to demonstrate grouping and reconciliation: checking that independently calculated totals agree.
        • Include the change test to show that the workbook responds correctly, not merely that the original report looks finished.

        An interviewer might ask, “How did you check that your spending report was correct?” A good answer is: “I compared the source total with the team totals, checked that remaining budget meant budget minus spending, and changed one Sales expense. I predicted the new totals, checked the formulas, and refreshed the PivotTable to confirm agreement.” The interviewer is listening for a repeatable checking process, not just function names.

        Learn Excel tables next so you can work with expanding datasets. Follow with date-based summaries, then importing and cleaning larger files. Documentation and books are useful for checking syntax; video courses can demonstrate a workflow. Hands-on practice adds the opportunity to make an error, inspect the result, and correct the workbook yourself.

        At The Work Gym, finished projects produce a practice record with a verification code, and learners can share a portfolio. Keep your own explanation alongside any record so a reader can understand the business task and the checks you performed.

        Common questions

        Which Excel practice project should a beginner build first? Start with the expense tracker because the task introduces numeric entries, SUM, and COUNT without a complicated layout. Check both the spending total and the number of numeric entries before adding the budget comparison.

        Can I complete these projects without downloading a workbook? Yes. Paste the supplied expense data into A1 and the budget data into E1 of a blank worksheet named Expenses. The instructions use Excel for Microsoft 365 on Windows.

        How can I check an Excel project without an answer file? Compare independently calculated totals, count expected numeric entries, and predict the effect of changing one source value. For these projects, the original total is 400 and the changed total is 430.

        Why did my formulas update but my PivotTable did not? Formula recalculation and PivotTable refresh are separate operations. Right-click inside the PivotTable and select Refresh, then compare the refreshed total with the source total.

        What should I include when sharing an Excel project in a portfolio? Include fictional source data, formulas, the summary report, and a short explanation of the business task. Record the original results and the change-test results, and state that the current source ranges cover only four expenses.

        Practice what this post teaches

        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.