Excel Data for Practice
Description
Excel Data for Practice
15 Excel Files
Enhance your Excel skills with our Excel data for practice. Designed for students and teachers, each file varies in size, offering a wide range of practice opportunities. From large datasets to shorter ones, you’ll have plenty of material to work with.
Save time and start practicing immediatly the spreadsheet tools and functions. Whether you’re a beginner or an expert, these datasets provide real-world use cases to test your skills, deepen your understanding of data manipulation and the necessary experience for any role involving the use of Excel data .
The files are based on real-world datasets but with fake figures and modified data. Eventhough, data has been carefully crafted to make sense and simulate real-life scenarios. Some of the files are:
1) Hotels Data
A 720 rows dataset with details of the rooms, prices and services of multiple hotels in a particular city.
What can you practice with this Excel data?
- Sort table
- Excel Tables
- Conditional and nested conditionals
- Pivot Tables
- Charts
- Basic math and statistics formulas
- Count, CountIF
2) Time Report
A table (95 rows) showing the hours worked by consultants each business day (23 columns, one per day) of the month for their clients. Each row corresponds to a single employee and it contains the personal data of the consultant (name, university education, role in the company, etc) and the hours billed to the client.
There is also a second worksheet (“rates”) that contains the consultancy fees broken down by category.
Column description
| employeeId | Unique ID of each consultant |
| firstName | First name of the consultant |
| lastName | Family Name of the consultant |
| category | Role of the consultant |
| degree | Education of the consultant |
| country | Country where the consultant is working |
| birth_date | Date of birth |
| 1 | Hours worked the first business day of the month |
| 2 | Hours worked the second business day of the month |
What can you practice with this Excel table?
- Cell formatting
- Data analysis
- Dates
- Vlookup
- Pivot tables
- Excel string functions
3) Invoices
Dataset with the detail of more than 25000 invoices due by a company to its suppliers. There is also a second sheet with exchange rates.
What can you practice with this Excel table?
- Practice Excel shortcuts and tools to manage large tables
- Duplicates
- Excel string functions
- Dates
- Math functions
- Calculations
- Pivot Charts
- Etc
4) Airports & Flights
Interesting large dataset (25249 rows and 16 columns) with the origin and destination of more than 25000 flights worlwide. Each row corresponds to a flight and it contains the origin and destination as well as the time.
What can you practice with this Excel table?
- Data analysis about airports
- Dates practice
- Strings
- Pivot tables
- Charts
Columns Information
| trip | ID of the route. Codes of the origin and destination airports |
| flight | Code of the flight |
| depart_time | Departure hour of the flight |
| arrive_time | Arrival hour of the flight |
| departure_year | Departure year of the flight |
| departure_month | Departure month of the flight |
| departure_day | Departure day of the flight |
| departure_airport | Origin airport of the flight |
| departure_city | Origin city of the flight |
| departure_ctry | Origin country of the flight |
| arrival_airport | Destination airport of the flight |
| arrival_city | Destination city of the flight |
| arrival_ctry | Destination country of the flight |
| arrive_year | Arrival year of the flight |
| arrive_month | Arrival month of the flight |
| arrive_day | Arrival day of the flight |
5) Accounting – Expenses
Excel file with two sheets:
- Expenses dataset with 30000 costs reported by the different divisions of a multinational company.
- The budget allocated to each department in charge of the costs.
What can you practice with these Excel datasets?
- VLOOKUP
- INDEX-MATCH
- Sort, filters, edit functions.
- Pivot Tables
- Charts
- Etc
6) Multinational Orders
Large Excel practice worksheet (9000 rows and 17 columns) with data about the orders processed by an electronics manufacturer.
In a second sheet, you will find another table with the static data of the different clients that placed the orders.
It is a dirty dataset is based on real tables. Some data cleaning is required before starting the analysis or as input to another application or software.
To see the types of Excel projects for this table click here.
What can you practice with these Excel datasets?
- Data cleaning in Excel
- LOOKUP functions.
- Excel String functions
- Nested conditionals
- Excel math formulas
- Conditional formatting
- Nulls
7) Rental Car Company Data
You will find three datasets (1 file, 3 sheets) with the normalized data model of a rental car company. The data is clean and ready to be treated and analyzed. The three tables, with referential integrity, can be combined through their unique IDs so the possibilities are amazing. Just like a real-world business case, it has been created with multiple logics so you can find insights about the company operations, clients or calculate KPIs. The tables are as follows:
- Bookings: A 2900 rows and 18 columns table with the details of each order placed by customers during the year
- Cars: A 34 lines and 9 columns table with the details of all the cars available for hire in the company.
- branch: A 125 rows and 27 columns dataframe with the static data of each branch of the company along with the conditions for rental depending on the option selected by clients in the bookings table.
What can you practice ?
- Calculate the turnover of the company.
- Find out what is the most popular car for hire.
- Check that all orders meet the branch requirements to hire the selected car.
- Compare branches to find inefficiencies.
- All types of functions.
- Etc.
8) Offline/Online Customers
An Excel file with two worksheets:
1) The list of customers of a supermarket that bought online (1026 rows)
2) The list of customers that buy on the supermarkets on a regular basis (1300 rows)
What can you practice with these Excel tables?
- VLOOKUP
- INDEX-MATCH
- COUNTIF
- Duplicates
9) Employment Survey
A table with the results of an employment survey. 1220 rows and 20 columns. Each row corresponds to the responses of each respondent. You will find personal data of the respondent along with questions about his/her career and current working status.
10) Blood Tests
This set consists of three tables from a clinic with the information of the patients and the results of their blood tests. The tables are:
- patient_data: Dataset with the personal data of patients.
- blood_test: The Results of the tests. Each line corresponds to one patient.
- units: The reference values of every component tested.
11) EUR Exchange Rates
Excel dataset (766 rows and 33 columns) with made-up exchange rates of the EUR with 32 other currencies broken down by days. It contains the exchange rates from 2018 to 2020.
Excel subjects to practice with this table:
- Charts
- Pivot Charts
- Dates
- Statistics and Math formulas
12) Real State
A real state agency table (72 rows) with data about prices and age of the properties for sale.
To see exercises you can do with this file, see here.
What can you practice with this Excel data?
- COUNTIF, AVERAGEIF
- Statistics formulas
- Conditional statements
- Math calculations
- Charts
- Pivot tables
- Excel tables
Finally, some of these datasets are used in Practity projects, so if you’re interested in the possible Excel exercises and problems to solve with these spreadsheets, visit our real Excel projects.
CONTACT
If you need further information about the datasets, do not hesitate to contact our customer service team:
You can also contact us at info@practity.com
Reviews (2)
2 reviews for Excel Data for Practice
Only logged in customers who have purchased this product may leave a review.
Aladin –
I was tired of searching data for my students. Very happy with the files, you can use them for any function of the spreadsheet.
Igor P –
Very useful datasets, exactly what’s described in the description