檳榔嶼

Add, duplicate, and rename worksheets


Reorder, clear, and delete worksheets

  - ctrl+z : undo
    - Can undo a deleted sheet
  - ctrl+y : redo

Change a worksheet's tab color


Show or hide worksheet elements





Save your changes
  - ctrl+s
  - save as : change name or location or type
  - F12 : revert save, for twb

Save your wordbook as a PDF file


Create a packaged workbook


Export data to a CSV file


Export visualizations to Powerpoint


Present Tableau operators and built-in funcitons





Create a caculated field


Create a calculated field on a shelf


Add a table calculation





Use level of detail expressions
  - Compared to the AVG
  1. Wrong Way I : AVG is not wrappered by {}


  2. Wrong Way II : Not get the right first time

  - Correct one : Type correct function in order


Create calculations in dialog boxes
  - Create a fomula filter



Calculate averages, medians, minimums, and maximums


Count occurrences and distinct items


Display the Summary Card




Calculate percentages within a table

  - Column : sum of per column is 100%
  - Row : sum of per row is 100%
  - pane : sum of columns of per first column element group is 100%
    - Pane = columns belonging to the first element in column

Forecast furture values



Sort 


Create a multilevel sort


Create a selection filter



Create a wildcard

  - Exclude


Clear a condition filter
  - value meet criteria




Create a top filter : Find the top/bottom filter



Edit, Clear, and delete filters
  - Clear All Filters


Show or hide sorting controls


Filter data using parameters
  - Terrific for presentation



Edit and delete parameters