FAA49940013: (49940013) Excel Pivot Tables
| FAA49940013 | Active | ||
| (49940013) Excel Pivot Tables | |||
| COURSE | 2010-09-27 | ||
| The course uses a combination of lecture, hands-on practice, and independent exercises to familiarize students with list design, PivotTables and PivotCharts in Excel 2003. Students will first learn how to create a list suitable for use in PivotTables. Then, students will learn to take the information from a list (or spreadsheet) and create PivotTables and PivotCharts. These tools provide the Excel user with methods to quickly analyze information for decision making. The PivotTable rearranges and summarizes the data from a database or spreadsheet automatically into categories chosen by the user. For example, a list of customers and the products they buy can be analyzed to display product totals by customer or by region. With a few minor changes to the PivotTable, customer purchases can be analyzed by product. PivotCharts display these analyses in a chart format. | |||
| AJV-W | AJV-W | ||
| BLENDED | 4.0 | ||
| Prerequisites | |||
