Free Excel Practice Sheets & Datasets: 10 Real Workbooks

Dataset note: These are real Excel workbooks containing synthetic, business-style practice data. No record describes a real person, customer, company, or transaction.

The five-row examples below are previews; download the workbooks for the complete synthetic practice datasets. They include multi-sheet exercises you can use to practice spreadsheet analysis.

Use the synthetic records to practice realistic workflows for interviews or portfolio projects. This guide covers ten business-style datasets spanning e-commerce, retail, SaaS, human resources, corporate finance, and operations; the examples do not represent actual company records or production systems.

Before jumping into individual workbook schemas, review the analytical workflow pipeline below to understand how professional analysts transform raw practice records into boardroom-ready models.

+-----------------------------------------------------------------------------+
|               EXCEL ANALYTICAL WORKBOOK ARCHITECTURE PIPELINE               |
+-----------------------------------------------------------------------------+
|                                                                             |
|  [ Raw Practice Data ]                                                      |
|         |                                                                   |
|         v                                                                   |
|  [ Data Hygiene & Ctrl+T ] ---> Lock records into Structured Excel Tables   |
|         |                        (Prevents accidental sort misalignment)    |
|         v                                                                   |
|  [ Relational Lookups ]    ---> Join dimensions with XLOOKUP / INDEX-MATCH   |
|         |                        (Customer master, product pricing tiers)   |
|         v                                                                   |
|  [ Analytical Metrics ]    ---> Aggregate via SUMIFS, COUNTIFS & Arrays     |
|         |                        (Calculate unit economics & variances)     |
|         v                                                                   |
|  [ Multi-Dimensional ]     ---> Pivot Tables, Slicers & Calculated Fields   |
|         |                        (Cross-tabulate segments & cohorts)        |
|         v                                                                   |
|  [ Executive Presentation ]---> KPI Summary Cards, Sparklines & Clean Visuals|
|                                                                             |
+-----------------------------------------------------------------------------+

Master Comparison: Top 10 Excel Practice Datasets

Each dataset below isolates core analytical competencies required by commercial employers. Use this matrix to match your practice goals with the right business domain:

1. E-Commerce Multi-Channel Orders Dataset

The e-commerce order ledger is the cornerstone of retail analytics. It contains transactional line items capturing customer purchases, promotional markdowns, payment methods, and delivery outcomes.

Schema Architecture

Sample Data Rows

Copy and paste these raw records into cell A1 of a fresh worksheet:

Download & Workbook Setup

• Workbook: Download ecommerce-orders.xlsx — 400 synthetic order rows in Orders_Raw (Table_Orders), 105 customer records in Customer_Master, 34 products in Product_Catalog, plus Instructions and Answers_Checks sheets.
• The downloaded data is already formatted as Excel Tables. To practice from a fresh paste, select the range, press Ctrl + T (or Cmd + T on macOS), confirm My table has headers, and name it Table_Orders.

3 Guided Analytics Challenges

Challenge 1: Calculate Realized Net Revenue per Order

In Column K (header: Net_Revenue), write an Excel structured formula that deducts promotional discounts from gross sales.

=[@Quantity] * [@Unit_Price] * (1 - [@Discount_Pct])

Formula Explanation: Using structured references like [@Quantity] ensures the formula propagates automatically down every row without dragging. For Row 2 (ORD-2026-1001), the math evaluates to 2 * 2499 * (1 - 0.15) = 4248.30.

Challenge 2: Lookup Customer City from Dimensional Table

The Customer_Master sheet contains Customer_ID in Column A and City in Column B, enrich your order row with the buyer's home city using XLOOKUP:

=XLOOKUP([@[Customer_ID]], Customer_Master!$A$2:$A$101, Customer_Master!$B$2:$B$101, "Unknown City")

Why Modern Analysts Prefer This: Unlike legacy lookup functions, XLOOKUP defaults to exact match and returns results from a separate return array. See Microsoft’s XLOOKUP reference. If you still use legacy workbooks, read our deep-dive on Excel VLOOKUP vs XLOOKUP Guide.

Challenge 3: Calculate Total Delivered Audio Revenue via SUMIFS

Calculate total net revenue generated exclusively from completed Audio deliveries that received a discount higher than 10%:

=SUMIFS(Table_Orders[Net_Revenue], Table_Orders[Category], "Audio", Table_Orders[Order_Status], "Delivered", Table_Orders[Discount_Pct], ">0.10")

2. Retail Store Daily Sales Dataset

Retail operations teams monitor physical branch foot traffic, basket sizes, and regional sales quotas to spot underperforming locations before month-end.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download retail-store-sales.xlsx — 240 synthetic daily sales rows in Daily_Sales (Table_Retail), store-and-department targets in Region_Targets, plus Instructions and Answers_Checks sheets. The data is already formatted as an Excel Table.
• Ensure Sales_Amount is formatted as Currency (₹ #,##0) and dates are stored as valid serial numbers. Avoid sorting columns in isolation; review Sort & Filter in Excel Without Mixing Data to avoid data scrambling.

3 Guided Analytics Challenges

Challenge 1: Compute Foot Traffic Conversion Rate & Average Transaction Value (ATV)

In Column I (header Conversion_Rate) and Column J (header ATV), compute operational efficiency:

' Conversion Rate Formula (format as 0.0%):
=[@[Transaction_Count]] / [@[Foot_Traffic]]
 
' Average Transaction Value Formula (format as ₹ #,##0):
=[@[Sales_Amount]] / [@[Transaction_Count]]

Challenge 2: Check Whether a Store Met Its Daily Target

Compare daily sales with the matching store-and-department target in Region_Targets:

=IF([@[Sales_Amount]] >= SUMIFS(Table_Region_Targets[Daily_Target_INR], Table_Region_Targets[Store_ID], [@Store_ID], Table_Region_Targets[Department], [@Department]), "Target Met", "Under Target")

Challenge 3: Extract Underperforming Stores Dynamically with FILTER

Using Excel 365 / 2021 dynamic arrays, output all records where the region is North and sales fell below ₹300,000:

=FILTER(Table_Retail[[Store_ID]:[Sales_Amount]], (Table_Retail[Region] = "North") * (Table_Retail[Sales_Amount] < 300000), "No Underperforming Stores")

3. HR Employee Attrition & Headcount Dataset

This synthetic HR dataset lets you practice summarizing headcount, tenure, compensation bands, and historical attrition. A simple rule in this exercise is only a review flag; it cannot establish that an employee is a flight risk.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download hr-attrition.xlsx — 240 synthetic employee rows in Employee_Roster (Table_HR), a summary in Attrition_Dashboard, plus Instructions and Answers_Checks sheets. The roster is already formatted as an Excel Table.
• The provided roster is standardized. For a separate text-cleaning exercise on your own data, try TRIM and PROPER; see our Excel Data Cleaning Guide.

3 Guided Analytics Challenges

Challenge 1: Calculate Departmental Attrition Rate

Write an analytical summary formula to compute the percentage of departed employees in the Engineering department:

=COUNTIFS(Table_HR[Department], "Engineering", Table_HR[Attrition], "Yes") / COUNTIF(Table_HR[Department], "Engineering")

Challenge 2: Assign Salary Compensation Bands with IFS

Categorize monthly salaries into practice bands for this exercise:

=IFS(
  [@[Monthly_Salary_INR]] >= 150000, "Tier 1: Senior & Leadership",
  [@[Monthly_Salary_INR]] >= 90000, "Tier 2: Mid-Level Professional",
  TRUE, "Tier 3: Associate & Entry"
)

Challenge 3: Add an Illustrative Review Flag

Highlight active employees with a performance rating of 4 or 5 and overtime marked “Yes” for further human review. This is an exercise filter, not a validated attrition prediction.

1. Select the data rows in Table_HR (exclude the header).
2. Open Conditional Formatting → New Rule → Use a formula to determine which cells to format.
3. Enter rule: =AND($G2>=4, $H2="Yes", $I2="No").
4. Set a subtle fill color and label the result “Review”, not “Flight risk”.

4. SaaS Monthly Churn & Subscription Revenue (MRR) Dataset

Subscription-based B2B software companies evaluate customer health through Monthly Recurring Revenue (MRR), cohort retention, and churn indicators.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download saas-churn.xlsx — 220 synthetic subscription rows in Subscriptions_Master (Table_SaaS), a summary in Cohort_Analysis, plus Instructions and Answers_Checks sheets. The data is already formatted as an Excel Table.
• Format MRR_USD as $ #,##0.00 and Signup_Date as YYYY-MM-DD.

3 Guided Analytics Challenges

Challenge 1: Compute Logo Churn Rate vs Revenue Churn Rate

Compare customer headcount loss against dollar revenue loss:

' Logo Churn Rate (Percentage of canceled accounts):
=COUNTIF(Table_SaaS[Churn_Flag], "Yes") / COUNTA(Table_SaaS[Subscription_ID])
 
' Revenue Churn Rate (Dollar value lost relative to total MRR):
=SUMIFS(Table_SaaS[MRR_USD], Table_SaaS[Churn_Flag], "Yes") / SUM(Table_SaaS[MRR_USD])

Challenge 2: Flag Inactive Accounts with Dynamic Date Math

Create a practice inactivity flag in Column J (header: Inactivity_Flag) based on inactivity duration:

=IF([@[Churn_Flag]]="Yes", "Cancelled", IF((TODAY() - [@[Last_Active_Date]]) > 45, "Inactive > 45 days", "Active within 45 days"))

Challenge 3: Cross-Tabulate MRR by Plan and Billing Cycle in a Pivot Table

1. Insert a Pivot Table from Table_SaaS.
2. Drag Plan_Tier to Rows.
3. Drag Billing_Cycle to Columns.
4. Drag MRR_USD to Values twice: once set to Sum, and the second set to Show Values As → % of Column Total. This reveals which package drives your recurring annual cash flow.

5. Customer Demographics & Credit Risk Dataset

Use these synthetic customer profiles to practice segmentation and conditional formulas. The example thresholds below are for spreadsheet practice only; they are not lending, credit eligibility, or marketing recommendations.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download customer-credit-risk.xlsx — 320 synthetic customer rows in Customer_Profiles (Table_Customers), five age brackets in Age_Bracket_Lookup, plus Instructions and Answers_Checks sheets. The data is already formatted as an Excel Table.
• Setup the bracket lookup table in Age_Bracket_Lookup!$A$2:$B$6:
  • 18 → 18-25: Early Career
  • 26 → 26-35: Young Professional
  • 36 → 36-50: Mid-Career / Family
  • 51 → 51-65: Pre-Retirement
  • 66 → 66+: Senior

3 Guided Analytics Challenges

Challenge 1: Segment Customers with Approximate Match VLOOKUP

In Column I (header: Age_Group), map each customer to an age band using VLOOKUP with TRUE (approximate match):

=VLOOKUP([@Age], Age_Bracket_Lookup!$A$2:$B$6, 2, TRUE)

Analyst Note: Approximate match requires the lookup array to be sorted in ascending order. If Age is 32, Excel steps down Column A until it exceeds 32 (at 36) and returns the preceding label: 26-35: Young Professional.

Challenge 2: Apply an Illustrative Two-Condition Segment

Use AND logic to label rows that meet both practice thresholds (annual income of at least ₹12,00,000 and sample score of at least 750). This label does not indicate creditworthiness or eligibility:

=IF(AND([@[Annual_Income_INR]] >= 1200000, [@[Credit_Score]] >= 750), "Meets Practice Thresholds", "Does Not Meet Practice Thresholds")

Challenge 3: Calculate Segmented Average Credit Score with AVERAGEIFS

Compute the mean credit score for female clients living in Tier 1 cities acquired via Organic Search:

=AVERAGEIFS(Table_Customers[Credit_Score], Table_Customers[Gender], "Female", Table_Customers[City_Tier], "Tier 1", Table_Customers[Acquisition_Channel], "Organic Search")

6. Digital Marketing Campaign Performance Dataset

Growth analysts, performance marketers, and media planners spend their days in spreadsheets evaluating return on ad spend (ROAS), cost-per-click (CPC), and acquisition funnels.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download marketing-campaigns.xlsx — 160 synthetic campaign rows in Campaign_Data (Table_Marketing), a summary in Channel_Scorecard, plus Instructions and Answers_Checks sheets. The data is already formatted as an Excel Table.
• Format Spend_INR and Revenue_INR as Indian Rupees (₹ #,##0).

3 Guided Analytics Challenges

Challenge 1: Compute Click-Through Rate (CTR) and Cost Per Click (CPC)

In Columns H and I, build the primary funnel efficiency metrics:

' Click-Through Rate (format as 0.00%):
=[@Clicks] / [@Impressions]
 
' Cost Per Click (format as ₹ 0.00):
=[@[Spend_INR]] / [@Clicks]

Challenge 2: Calculate ROAS and Cost Per Acquisition (CPA)

Compute return on media investment and customer acquisition unit economics:

' Return On Ad Spend (format as 0.00"x"):
=[@[Revenue_INR]] / [@[Spend_INR]]
 
' Cost Per Acquisition (format as ₹ #,##0):
=[@[Spend_INR]] / [@Conversions]

Challenge 3: Dynamically Rank Top Campaigns with SORT and FILTER

Extract and rank all campaigns delivering a ROAS of at least 3.0x, ordered from highest revenue to lowest:

=SORT(FILTER(Table_Marketing, Table_Marketing[Revenue_INR] / Table_Marketing[Spend_INR] >= 3.0), 7, -1)

7. Corporate Financial Profit & Loss (P&L) Dataset

Financial planning & analysis (FP&A) analysts build quarterly variance models to explain budget overruns to Chief Financial Officers and division leaders.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download financial-pl.xlsx — 44 synthetic ledger rows in PL_Ledger (Table_PL), a summary in Executive_Summary, plus Instructions and Answers_Checks sheets. The ledger is already formatted as an Excel Table.
• Format all numeric columns with standard accounting parenthesis formatting: ₹ #,##0;(₹ #,##0);"-".

3 Guided Analytics Challenges

Challenge 1: Calculate Dollar Variance and Percentage Variance

In Columns H and I, build the standard FP&A variance calculations:

' Rupee Variance (Actual - Budget):
=[@[Q1_Actual_INR]] - [@[Q1_Budget_INR]]
 
' Variance Percentage (format as +0.0%;-0.0%;"0.0%"):
=([@[Q1_Actual_INR]] - [@[Q1_Budget_INR]]) / [@[Q1_Budget_INR]]

Challenge 2: Build Section Subtotals via SUMIF

On your summary tab, aggregate total operating expenses dynamically without hardcoding cell ranges:

=SUMIF(Table_PL[Category], "Operating Expense", Table_PL[Q1_Actual_INR])

Challenge 3: Conditional Warning for Adverse Budget Overruns

Configure a formatting rule that highlights expense lines where actual spend exceeded budget by more than 10%:

• Formula rule: =AND($B2="Operating Expense", ($D2-$E2)/$E2 > 0.10)
• Format: Soft red fill with dark red text.

8. Warehouse Inventory Stock & Reorder Levels Dataset

Supply chain analysts protect businesses against stockouts and tied-up working capital by modeling consumption velocity against supplier delivery lead times.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download inventory-reorder.xlsx — 150 synthetic inventory rows in Inventory_Status (Table_Inventory), 20 suppliers in Supplier_Directory, plus Instructions and Answers_Checks sheets. The inventory is already formatted as an Excel Table.
• Ensure Current_Stock and Safety_Stock are formatted as Integers (#,##0).

3 Guided Analytics Challenges

Challenge 1: Calculate Stockout Runway in Days

Compute how many operating days remain before current inventory reaches zero:

=[@[Current_Stock]] / [@[Daily_Burn_Rate]]

Challenge 2: Formulate Dynamic Reorder Point (ROP) Trigger

For this exercise, calculate a reorder threshold as safety stock plus expected demand during supplier lead time: Safety Stock + (Daily Burn Rate * Lead Time).

' Calculated Reorder Threshold (Column H):
=[@[Safety_Stock]] + ([@[Daily_Burn_Rate]] * [@[Lead_Time_Days]])
 
' Automated Restock Trigger Flag (Column I):
=IF([@[Current_Stock]] <= [@[Reorder_Threshold]], "REORDER IMMEDIATELY", "Stock Healthy")

Challenge 3: Calculate Total Tied-Up Working Capital with SUMPRODUCT

Compute total rupee capital tied up in warehouse inventory across all SKUs without adding an auxiliary column:

=SUMPRODUCT(Table_Inventory[Current_Stock], Table_Inventory[Unit_Cost_INR])

9. Product Master Catalog & Pricing Tiers Dataset

Merchandising analysts maintain the master product catalog, managing supplier manufacturing costs, retail MSRPs, GST tax categories, and channel margin matrices.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download product-pricing.xlsx — 150 synthetic products in Product_Catalog (Table_Products), a 12-brand pricing matrix in Wholesale_Discount_Matrix, plus Instructions and Answers_Checks sheets. The product data is already formatted as an Excel Table.
• The Wholesale_Discount_Matrix sheet already contains brand-specific factor columns: Wholesale_Tier1_Factor, Wholesale_Tier2_Factor, and Wholesale_Tier3_Factor.

3 Guided Analytics Challenges

Challenge 1: Calculate Gross Profit Margin Percentage

Compute gross margin percentage based on net selling price:

=([@[Selling_Price_INR]] - [@[Cost_Price_INR]]) / [@[Selling_Price_INR]]

Math Note: Format as percentage 0.0%. For Row 2 (Standing Desk Dual Motor), (22999 - 14500) / 22999 = 36.96%.

Challenge 2: Two-Way Matrix Lookup via INDEX and MATCH

Calculate an illustrative Tier 2 practice price by looking up the product brand’s tier factor, then multiplying that factor by the product’s selling price:

=[@[Selling_Price_INR]] * INDEX(
  Wholesale_Discount_Matrix!$B$2:$D$13,
  MATCH([@Brand], Wholesale_Discount_Matrix!$A$2:$A$13, 0),
  MATCH("Wholesale_Tier2_Factor", Wholesale_Discount_Matrix!$B$1:$D$1, 0)
)

Challenge 3: Calculate Post-Tax Customer Settlement Price

Apply the synthetic tax factor to calculate an illustrative total:

=[@[Selling_Price_INR]] * (1 + [@[Tax_Slab_Pct]])

10. Customer Support Helpdesk Ticket Resolution Dataset

Customer operations and IT service management (ITSM) analysts evaluate SLA breaches, mean time to resolution (MTTR), and customer satisfaction (CSAT) scores.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Workbook: Download support-tickets.xlsx — 400 synthetic ticket rows in Ticket_Logs (Table_Support), a summary in Agent_Scorecard, plus Instructions and Answers_Checks sheets. The table includes First_Contact_Resolved and is already formatted as an Excel Table.
• Ensure date-time columns are formatted as YYYY-MM-DD hh:mm.

3 Guided Analytics Challenges

Challenge 1: Calculate Resolution Velocity in Hours

In Column J (header: Resolution_Hours; Column I is First_Contact_Resolved in the workbook), calculate exact turnaround time using decimal date math:

=([@[Resolved_Date]] - [@[Created_Date]]) * 24

Formula Explanation: Excel stores dates as whole days and hours as fractional days (1 hour = 1/24). Multiplying the difference by 24 converts the fractional day directly into decimal hours (e.g., 4.75 hours for 4 hours and 45 minutes).

Challenge 2: Calculate First Contact Resolution (FCR) Rate

Calculate the percentage of tickets resolved on first contact, using the workbook’s First_Contact_Resolved field:

=COUNTIF(Table_Support[First_Contact_Resolved], "Yes") / COUNTA(Table_Support[Ticket_ID])

Challenge 3: Build an Agent Performance Scorecard Pivot Table

1. Insert a Pivot Table from Table_Support.
2. Drag Agent_Name to Rows.
3. Drag Ticket_ID to Values (summarized by Count).
4. Drag Resolution_Hours to Values (summarized by Average, formatted as 0.0 hrs).
5. Drag CSAT_Score to Values (summarized by Average, formatted as 0.00).
6. Apply PivotTable conditional formatting data bars to the Average CSAT column to instantly compare support engineer quality.

4 Essential Data Hygiene Drills Before Analysis

When a workbook has inconsistent formatting, whitespace, numeric text, or blank rows, these checks can help before analysis. The synthetic workbooks linked above are prepared practice data; these are general techniques for other files you may encounter:

1. The Ctrl+T Table Shield

Never apply filters or sorts on naked cell ranges. If you sort a single column without expanding the selection, Excel silently moves that column's values while leaving adjacent columns frozen—scrambling your records permanently. Press Ctrl + T to convert every dataset into a Table. Tables treat each row as an atomic record.

2. Remove Leading and Trailing Whitespace

A lookup key like "CUST-4401 " with an invisible trailing space will never match "CUST-4401", generating confusing #N/A errors. Use TRIM and CLEAN:

=TRIM(CLEAN(A2))

3. Convert Numeric Text Strings to Real Numbers

If numbers are left-aligned or preceded by an apostrophe ('2499), Excel treats them as text. Formulas like SUM will ignore them silently. Coerce them into true numeric values using the double-unary operator:

=--A2

4. Isolate Blank Row Cutoffs

If a practice sheet contains an empty row at Row 50, Excel's AutoFilter halts at Row 49, completely omitting records from Row 51 onward. To fix this, inspect row headers or highlight the entire column range manually before clicking Filter.

Formula Cheatsheet for Excel Practice Sheets

Keep these formula patterns open as a quick reference while solving the challenges:

' 1. Modern Flexible Lookup (searches anywhere, returns anywhere)
=XLOOKUP(lookup_val, lookup_col, return_col, "Not Found")
 
' 2. Two-Dimensional Matrix Retrieval
=INDEX(matrix_range, MATCH(row_val, row_header_col, 0), MATCH(col_val, col_header_row, 0))
 
' 3. Multi-Condition Summation
=SUMIFS(sum_range, criteria_col1, "Criteria1", criteria_col2, ">100")
 
' 4. Multi-Condition Counting
=COUNTIFS(criteria_col1, "Approved", criteria_col2, "<50")
 
' 5. Dynamic Array Filter (Office 365 / Excel 2021+)
=FILTER(data_range, (col1 = "East") * (col2 >= 50000), "No Matching Records")
 
' 6. Unique Distinct Value List
=UNIQUE(Table_Orders[Category])
 
' 7. Dynamic Multi-Column Sort
=SORT(data_range, 3, -1)

For advanced multi-dimensional breakdowns, pair these formulas with Excel Pivot Tables and interactive slicers.

Ready to advance beyond manual spreadsheet calculations? Turn these formula patterns into automated reporting models with our hands-on Excel for Data Analytics Course, featuring step-by-step video walkthroughs and downloadable milestone templates.

How to Build a Hiring-Ready Portfolio Dashboard

Transforming one of these raw practice sheets into a public portfolio project is how entry-level analysts stand out to hiring managers:

1. Dedicated Architecture: Create three separate sheets in your final workbook:
   • Raw_Data: Read-only, locked Table containing the source records.
   • Calculation_Engine: Staging formulas, dynamic array extracts, and pivot caches.
   • Executive_Dashboard: 100% presentation layer with grid lines removed (Alt + W + V + G).
2. Top KPI Scorecards: Use large 24pt bold cards for top-line metrics (Total Net Revenue, Blended Margin %, Active Headcount, Customer NPS).
3. Interactive Slicers: Connect your pivot charts to visual Slicers for Region, Quarter, and Category so hiring managers can interact with your file.
4. Business Recommendations: Add a callout text box explaining what the numbers mean. For example: "Sales in the East territory dropped 18% in Q2 due to supply chain stockouts on Audio SKUs; increasing safety stock buffer to 10 days will protect ₹14,00,000 in recurring revenue."

Ready to practice more advanced concepts? Explore our complete interactive curriculum at Free Excel Course and check out our specialized Excel for Data Analytics Course. All interactive modules and exercises on Topfolio are 100% free to access, with an optional ₹99 verified certificate available upon completion.