Free Excel Practice Sheets & Datasets: 10 Real Workbooks

Practicing Excel on toy three-row tables never prepares you for enterprise data analytics. In corporate environments across Bangalore, Mumbai, London, and New York, entry-level data analysts earning ₹5–12 LPA ($65,000–$90,000) are handed messy, multi-thousand-row operational extracts with missing customer keys, mismatched dates, unformatted numeric strings, and multi-tab relational schemas.

To build genuine analytical muscle, you need authentic data for excel practice that simulates real production systems. Whether you are prepping for technical interview assessments or building an entry-level portfolio, this resource guide provides 10 comprehensive excel practice sheet models spanning e-commerce, retail, SaaS, human resources, corporate finance, and operations.

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

• Worksheet Tabs: Name Tab 1 Orders_Raw, Tab 2 Customer_Master, and Tab 3 Product_Catalog.
• Table Conversion: Select any cell within the data and press Ctrl + T (or Cmd + T on macOS). Ensure "My table has headers" is checked. Rename the table to Table_Orders under the Table Design ribbon.
• Ready-to-Use File: You can also download our companion practice workbook at excel-filter-sort-practice.xlsx to inspect sample sorting and safety drills.

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

Assuming Tab 2 (Customer_Master) contains Customer_ID in Column A and City in Column C, enrich your order row with the buyer's home city using XLOOKUP:

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

Why Modern Analysts Prefer This: Unlike legacy lookup functions, XLOOKUP defaults to exact match and does not break if someone later inserts a column between Customer ID and City. 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

• Worksheet Tabs: Name Tab 1 Daily_Sales and Tab 2 Region_Targets.
• In Region_Targets, set up baseline targets: North = 250,000; South = 200,000; East = 100,000; West = 180,000.
• 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: Flag Target Quota Met via VLOOKUP

Compare daily sales against the regional baseline maintained in Region_Targets!$A$2:$B$5:

=IF([@[Sales_Amount]] >= VLOOKUP([@[Region]], Region_Targets!$A$2:$B$5, 2, FALSE), "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(Daily_Sales!A2:E60, (Daily_Sales!C2:C60 = "North") * (Daily_Sales!E2:E60 < 300000), "No Underperforming Stores")

3. HR Employee Attrition & Headcount Dataset

Human resources analytics revolves around headcount retention, tenure bands, compensation fairness, and spotting flight risks before key personnel depart.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Worksheet Tabs: Tab 1 Employee_Roster, Tab 2 Attrition_Dashboard.
• Press Ctrl + T to convert the roster into Table_HR.
• Clean text fields using TRIM and PROPER if any leading spaces exist, following 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 standard organizational compensation tiers:

=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: Apply Conditional Formatting for Flight Risk Detection

Flag critical employees who are performing at the highest tier, working overtime, but remain at high turnover risk:

1. Select the roster rows from cell A2 through I100.
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 fill format to light amber with dark orange text.

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

• Worksheet Tabs: Tab 1 Subscriptions_Master, Tab 2 Cohort_Analysis.
• Convert the range into Table_SaaS.
• 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 an account status alert in Column J (header: Account_Health) based on inactivity duration:

=IF([@[Churn_Flag]]="Yes", "Cancelled", IF((TODAY() - [@[Last_Active_Date]]) > 45, "At-Risk Dormant", "Healthy Active"))

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

Consumer lending institutions, fintechs, and retail banks analyze demographic profiles to price personal loans, allocate credit lines, and build customer marketing cohorts.

Schema Architecture

Sample Data Rows

Download & Workbook Setup

• Worksheet Tabs: Tab 1 Customer_Profiles, Tab 2 Age_Bracket_Lookup.
• 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: Identify Prime Banking Prospects with AND / OR Logic

Create a flag for candidates eligible for pre-approved premier credit cards (Annual Income of at least ₹12,00,000 AND Credit Score of at least 750):

=IF(AND([@[Annual_Income_INR]] >= 1200000, [@[Credit_Score]] >= 750), "Pre-Approved Prime", "Standard Review")

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

• Worksheet Tabs: Tab 1 Campaign_Data, Tab 2 Channel_Scorecard.
• Convert the range into Table_Marketing.
• 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

• Worksheet Tabs: Tab 1 PL_Ledger, Tab 2 Executive_Summary.
• Convert the range into Table_PL.
• 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:

' Dollar 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

• Worksheet Tabs: Tab 1 Inventory_Status, Tab 2 Supplier_Directory.
• Convert the range into Table_Inventory.
• 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

The standard industrial supply chain formula states: Reorder Point = Safety Stock + (Daily Burn Rate * Supplier 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

• Worksheet Tabs: Tab 1 Product_Catalog, Tab 2 Wholesale_Discount_Matrix.
• On Tab 2, configure a 2-way matrix with Brands in Column A and customer tier pricing columns (Wholesale_Tier1, Wholesale_Tier2, Wholesale_Tier3).

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), (22999 - 14500) / 22999 = 36.96%.

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

Fetch the tiered wholesale price for any product by matching the item's Brand vertically and the target customer tier horizontally:

=INDEX(
  Wholesale_Discount_Matrix!$B$2:$E$15,
  MATCH([@Brand], Wholesale_Discount_Matrix!$A$2:$A$15, 0),
  MATCH("Wholesale_Tier2", Wholesale_Discount_Matrix!$B$1:$E$1, 0)
)

Challenge 3: Calculate Post-Tax Customer Settlement Price

Compute total invoice bill amount including statutory GST:

=[@[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

• Worksheet Tabs: Tab 1 Ticket_Logs, Tab 2 Agent_Scorecard.
• Convert the range into Table_Support.
• 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 I (header: Resolution_Hours), 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

Compute the percentage of non-escalated tickets that achieved a satisfied CSAT score (4 or 5):

=COUNTIFS(Table_Support[Escalated_Flag], "No", Table_Support[CSAT_Score], ">=4") / 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

Raw practice workbooks frequently arrive with subtle formatting anomalies that break lookups and pivots. Run these four checks whenever you open a new practice workbook:

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.

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.