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. 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