Home > Data > Sample > Sample Data Excel Sample Data Food SalesIndulge your "taste" for data analysis with this free Microsoft Excel sample dataset. Explore the sales orders of a fictional food production company in this comprehensive data set. It even has cookies! 🍪
Whether you're looking to test your skills, train, or practise, these sample files offer a fantastic learning opportunity for Excel enthusiasts. Download this sample data today and take your Excel skills to the next level! |
Sample Data - Food SalesThis sample file has food sales data, from a fictional food company.
|
Manual Entry ColumnsEach row in the food sales data has the following 8 fields, for manual data entry:
The screen shot below shows the first 6 columns in the Food Sales dataset table. Calculated ColumnEach row in the food sales data also has one column with a formula calculation:
The screen shot below shows the last 3 columns in the Food Sales dataset table. In cell I2, the following formula multiplies the number in the Qty column by the number in the UnitPrice column:
Tip: I've added grey fill colour, and an orange heading cell, to column I, to show that it's different from the other columns, that are for manual entries. |
Customize the Sample DataYou can use this food sales data as is, or make changes to the data, to customize it for your training sessions. For example:
See the video in the next section, for examples of using the Excel Find and Replace feature, to quickly modify existing data. Video: Find and Replace with WildcardsIn this video, you'll see how to use the Excel Find and Replace commands, to clean up names in a contact list. For written steps, and the sample file, go to the Find and Replace page. Video Timeline
|
Example: Food Sales Data AnalysisIn addition to the food sales data file, there is a second sample file that you can download. The second file has the same food sales data, along with the following types of data analysis examples:
1) Summary FormulasIn the data analysis sample file, there is a sheet named Totals, with summary formula examples.
To get the total quantities for each region, for each category, I entered this formula in cell C5:
The formula calculates a total:
The formula from cell C5 was copied down to row 8, and across to column D. |
Video: Sum Cells - Multiple CriteriaIn Excel , you cn use the SUMIFS function to calculate a total for rows that meet two or more criteria. Watch this short video to see the steps, and there are written instructions on the Excel Sum Functions page. |
2) Pivot TablesIn the data analysis sample file, there are two sheets where I've added pivot tables and pivot charts. CatReg SheetOn the sheet named CatReg, there's a pivot table with 3 fields:
RegPct SheetOn the sheet named RegPct, there's a small pivot table with 2 fields:
Instead of showing the quantity numbers, I set that field to:
Tip: See more examples of using the Show Values Of setting options in a pivot table. Video: Create a Pivot TableWatch this video, to see the steps for creating a pivot table in Excel 2013 and later. There are written instructions. The video transcript is below the video, and for detailed steps, go to the Create a Pivot Table in Excel page. |
3) Pivot ChartsIn the data analysis sample file, there are two sheets where I've added pivot tables and pivot charts. CatReg SheetOn the CatReg sheet, there's a pivot chart based on the pivot table from that sheet. I used the 2-D Stacked Bar chart type, and it has three fields:
Tip: There is another Pivot Chart example, and detailed steps, on the Pivot Chart Compare Years page RegPct SheetOn the RegPct sheet, there's a pivot chart based on the pivot table from that sheet. I used the 2-D Pie chart type, and it has two fields:
Tip: There are formatting tips for this type of chart on the Excel Pie Chart page. |
Download Sample DataFood Sales: Click here to get the food sales data file. The zipped Excel file is in xlsx format, and does not contain any macros. Food Sales - Data Analysis: Click here to get the food sales data file, with pivot tables and pivot charts, analyzing the data. The zipped Excel file is in xlsx format, and does not contain any macros. |
Related LinksHere are a few of my Contextures tutorials on working with data in Excel, organizing it in tables, and summarizing the data in pivot tables. -- Excel Tables -- Pivot Tables |
Last updated: December 6, 2023 2:31 PM