Translations:Basic Excel/205/en
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.