CHOOSE ONE
Summarizing Data with PivotTables
Using the Internet, conduct a thorough search for more information on developing Excel applications such as defined names, validating data entry, protecting a worksheet, inserting comments, etc. Choose one bullet listed below and explain and also include a reason to use in your worksheet for your bullet from the following:
Choose from the following:
Session 7.1
- Do approximate match lookups
- Work with logical functions
- Calculate statistics with summary IF functions
Session 7.2
- Create a PivotTable
- Change a PivotTable layout
- Format a PivotTable