Wiki Sumber Informasi iSIKHNAS

Learning objectives

After completing this exercise, you will be able to:

• understand the differences between a data range, a named range, and an Excel table
  • name a range
  • create an Excel table
• create an Excel pivot table from any of these (data range, named range, Excel table)
• determine whether a workbook contains hidden worksheets
  • 'unhide' a worksheet
  • 'hide' a worksheet
• add additional data to an Excel table
• update pivot tables with the additional data
• delete a worksheet.