Excel remains one of the most accessible and powerful tools for data analytics. Its combination of user-friendly design and robust capabilities enables new learners to explore data visualization, manipulation, and statistical analysis with ease. The right datasets can provide a strong foundation for developing practical data analysis skills.
This article presents 15 beginner-friendly Excel datasets that enable new analysts to explore real-world scenarios while building proficiency in Excel features, including pivot tables, charts, formulas, and data cleaning techniques.
Understanding Excel Datasets
An Excel dataset is a structured collection of data stored in spreadsheet format, typically as .xlsx or .csv files. Excel files support complex features such as formulas, conditional formatting, and charts, whereas CSV files offer a lightweight format that ensures broad compatibility across platforms.
These datasets cover a variety of fields—from retail sales and finance to healthcare and sports—offering meaningful opportunities to practice and grow analytical thinking.
Read More: Is Axis Atlas Worth It?
Featured Excel Datasets for Beginners
Superstore Sales
A retail dataset simulating sales, customers, shipping, and profits. Ideal for practicing dashboard creation and sales performance analysis.
Key Variables: Order ID, Customer ID, Sales, Discount, Profit, Region, Product Category
Iris
This classic dataset includes measurements for iris flowers and is commonly used for classification and visualization tasks.
Key Variables: Sepal Length, Petal Length, Species
Titanic
Contains detailed records of the Titanic passengers. Commonly used for classification and data preprocessing exercises.
Key Variables: Survival Status, Passenger Class, Age, Fare, Gender
Wine Quality
Features the chemical properties of red and white wine samples, used to predict wine quality scores.
Key Variables: Alcohol Content, pH, Acidity, Sulphates, Quality
Adult Census Income
Based on U.S. Census data from 1994, this dataset predicts income levels using demographic attributes.
Key Variables: Age, Education, Occupation, Income, Gender, Race
Boston Housing
Provides housing data for Boston suburbs. Perfect for regression and correlation analysis.
Key Variables: Crime Rate, Number of Rooms, Median House Value
Breast Cancer Wisconsin
Used for medical research, this dataset helps classify tumors as malignant or benign.
Key Variables: Radius, Texture, Smoothness, Concavity, Diagnosis
Online Shoppers Purchasing Intention
Captures web session behavior and intent to purchase. Useful for marketing and e-commerce insights.
Key Variables: Bounce Rate, Exit Rate, Product Page Duration, Purchase Intent
Bank Marketing
Information on marketing campaigns of a Portuguese bank. Great for customer segmentation and campaign analysis.
Key Variables: Age, Job, Loan Status, Contact Type, Response Outcome
Avocado Prices
Tracks avocado sales across U.S. regions. Suitable for time-series analysis and price forecasting.
Key Variables: Average Price, Type, Region, Total Volume
Amazon Top 50 Bestselling Books (2009–2019)
Details of bestselling books with user ratings and reviews. Great for analyzing trends in publishing.
Key Variables: Book Title, Author, Rating, Reviews, Genre
FIFA World Cup
Historical data on FIFA World Cup tournaments is perfect for sports analytics and trend spotting.
Key Variables: Year, Host Country, Winner, Total Goals, Attendance
New York City Airbnb Open Data
Captures listings and pricing data from NYC Airbnb rentals. Useful for spatial analysis and price prediction.
Key Variables: Price, Room Type, Latitude/Longitude, Neighborhood
World Happiness Report
Analyzes global well-being metrics and contributing socioeconomic indicators.
Key Variables: Life Satisfaction, GDP per Capita, Health, Country Name
Stock Price
Tracks daily stock performance of major companies like Apple and Amazon. Excellent for beginners in time-series forecasting.
Key Variables: Date, Open/Close Price, Volume, High/Low
Sample Practice Questions
Each dataset presents a unique learning opportunity. Here are sample questions you can explore:
Superstore Sales
- What region has the highest sales?
- Which product category is most profitable?
Titanic
- What percentage of passengers survived?
- How does passenger class relate to survival rates?
Iris
- How are petal length and width correlated?
- Which species has the largest sepal length on average?
Wine Quality
- Which chemical feature most influences wine quality?
- Are red wines rated higher than white wines?
Adult Census Income
- What age group earns the most?
- How does education level affect income?
… and many more for each dataset. These questions help you strengthen your exploratory and inferential skills.
Visualization and Analysis Tools in Excel
As a beginner, you can apply various tools within Excel to analyze these datasets:
- Pivot Tables for summarization
- Line and Bar Charts for trends
- Histograms and Boxplots for Distribution Analysis
- Conditional Formatting to highlight patterns
- Statistical Functions like
CORREL,AVERAGE, andMEDIAN
These features make Excel a great starting point before moving to more advanced platforms like Power BI, Tableau, or Python.
Final Thoughts
These 15 datasets offer the ideal playground for anyone starting out in data analytics using Excel. By practicing with real-world examples, you can build foundational skills in data cleaning, visualization, and interpretation. Whether you’re analyzing book ratings, predicting wine quality, or studying housing trends, these datasets will guide your journey into data analytics.
