Excel Advanced Spreadsheets


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

Leave a Reply

Your email address will not be published. Required fields are marked *