Excel Essential

A workbook is a spreadsheet program file that you create in Excel . A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter. A worksheet is always stored in a workbook.

Workbook: 活頁簿

Worksheet: 工作表

Pressing Ctrl + Shift + Down Arrow highlights the cells from the current cell position to the last cell in the column with data.

刪除工作表後，不可恢復。

預設情況下，包含字母字元的儲存格為左對齊，而包含數字字元的儲存格為右對齊。

In mathematics, exponentiation is an operation involving two numbers: the base and the exponent or power. Exponentiation is written as bⁿ, where b is the base and n is the power; often said as "b to the power n".

=2^2 in excel, 2 to the power 2, the result is 4

AutoSum: Alt+=

The AutoSum function always looks up and then left.

=VLOOKUP(lookup value, table array, column index number, False)

Lookup value can be A:A

Table array can be on another page: work!A:B

To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.

Shift + Drag: maintain proportion while resizing the chart in Excel

Fn F11(my Thinkpad Notebook): create chart in separate sheet

Alt + (Fn) F1 after selecting the data: shortcut that creates a chart

Ctrl + D for duplicate a chart

Select your chart and on the Chart Design tab, choose Select Data. Choose on the legend name you want to change in the Select Data Source dialog box, and select Edit.

Select B2 > View > Freeze Panes

Ctrl + Drag: copy a worksheet

Group two worksheet using Shift

As the cell inside PivotTable do not contain formula, we have to right-click the PivotTable and select Refresh in order the renew the data.