Then, as if by magic, the left side of the sheet will show the hours worked by project by day:įrom the newly created pivot table, you can see that Thursday was the busiest day, and Training course took the most hours. I just drag Date, Project, and Hours into three of the four boxes, like so: Let’s start by making a table showing each project in a separate row, and each day in a separate column, with the values being the number of hours worked. On the left, you’ll see a blank template showing what your pivot table will look like, and on the right are the four field names (columns of your original data) which you can drag into four boxes, below, to make different tables. When the Create PivotTable dialog appears, just leave everything default and click Enter.Ī new sheet will be added. Click Insert item on the top bar and click Pivot Table to bring up Create Pivot table dialog. Here’s a sample, showing the hours worked by four people on some projects this past week: We suppose you have some data in a sheet of a workbook. Then do you know how to create a pivot table in Excel 2016? If not, please follow my words, I would show you the detailed steps of creating a pivot table in Excel 2016. The pivot table in Excel offers us a good chance to analyse data in a easy way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |