OrderDate: first column shows when the order was placed,.

There are formulas in one column - Total.Įach row in the Excel dummy data shows the following fields: The first set of sample data on this page is sales data for an imaginary office supply company, and each row

Tip: Check the Key Excel Skills page, for training topic ideas.

Easy to prepare class demos for sum and count formulas, lookup functions, pivot tables, summary reports, and other Excel skills training.

It's easier to help with troubleshooting when you both have the same data.

Send people to this page, so they can download the sample data, and recreate their problem or error there.

Handy data to share when helping with Excel forum questions.

Useful for testing macros and manual processes - you might discover problems that didn't occur with original test data.

No privacy concerns about using real data from your employer or your client's company.

Quick way to get interesting data for Excel training class exercises.

Here are a few of the reasons that people have shared with me, as to why they like using these datasets, with dummy data for Excel:

Why do people download my sample data workbooks, to use in Excel? Then, to get started, you can download sample Excel file with data for your training sessions. You can see a screen shot of each dataset, and a list of the columns it contains, with a brief description. The sample file contents are described in the sections below, so you can decide which dataset will be the best match for what you need. This page has Microsoft Excel sample datasets that you can use for testing, Excel training and demos, and other learning activities. Note: You many not resell this sample data, in whole or in part, or include it in paid products. There are dataset examples for property insurance data, food sales records, work orders, workplace safety, athletes, and other Excel datasets. Or download one of the many sample data files in Excel format. There is a table with office supply sales sample data, to copy and paste into your Excel workbook. This page has Microsoft Excel sample datasets that you can download, to use for testing, Excel training and demos, and other learning activities. Key Skills > Sample Data Excel Sample Data

Download data penjualan excel