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