Week 7 Discussion Board 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. and discuss one in reply including a use in reply to my post.

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