Excel: What Happened? Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Data Analysis This lesson uses a sample file. Please download a copy of the Bug Report spreadsheet.   This is what the data from 72 Bug Reports looks like when you review them in Excel. Scroll down the list: there are many reports for each department. How many?   There are reports concerning different software problems. Which software?   How would you count and graph these reports? PivotTables.   Three Parts to a Spreadsheet: Remember there are three parts to a spreadsheet: Labels, Data, and Formulas. The list in the sample, right, has a dozen labels in the first row.   These labels will become an important part of your PivotTable. Take some time to think through what data you are capturing and measuring. If it isn’t on the list, how can you sort or calculate?