publicvova.blogg.se - Microsoft excel training material download

#Microsoft excel training material download manual
#Microsoft excel training material download code
#Microsoft excel training material download download

Note: This screen shot shows the first 6 columns in the Workplace Safety dataset table. The zipped Excel file is in xlsx format, and does not contain any macros. Workplace Safety: Click here to get the workplace safety data file. Year: year number (calculation, based on Date).Month: month number (calculation, based on Date).

#Microsoft excel training material download code

WkDay: 3-letter code for day of the week (calculation, based on Date).Incident Cost: total cost of safety incident.Department: work department where incident occurred.Shift: work shift when incident occurred - Afternoon, Day, Night.Report Type: Type of safety report filed - First Aid, Lost Time, Medical Claim, Near Miss.Plant: manufacturing location were incident occurred.Days Lost: number of days employee off work.Incident Type: Type of safety incident, e.g.Injury Location: location on body where injury occurred.There are 514 rows of data in the workplace safety report table.There are 14 columns of data, including 3 columns with a calculation.This sample file has fake workplace safety report data.

#Microsoft excel training material download download

There are 244 rows of data in the food sales table.įor details on this data, and to download the zipped Excel file, go to the Food Sales Sample Data page.

There are 9 columns of data, including 1 column with a calculation.

This sample file has food sales data, from a fictional food company. The zipped file is in xlsx format, and does not contain any macros. OR, click this link to download the Excel file: Office Supply Sales sample data workbook. Copy and paste the data from the Office Supply Sales Table, further down on this page

Total: total cost of the order - Units x UnitCost.

Region: geographical area in which the sale was made.

Order Date: 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 9) Insurance Policies 1) Office Supply Sales Data In the sections below, there are brief descriptions of the sample data files.Įach section has a download link, or a link to an instruction page where you can get details about the data, and download the sample file.

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.

#Microsoft excel training material download manual

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. Related Links Why Use Sample Data in Excel?