Name: 如何使用Excel (How To Use Excel)
Uploaded: 2020-12-15T19:06:38.000Z
Duration: 9 min 56 s

Use the clickable sections below to skip through

A window will appear with various templates.

會出現一個窗口，裡面有各種模板。

These are ready-made workbooks you can choose

這些都是現成的作業本，你可以選擇

so you won't need to create one from scratch.

所以你不需要從頭開始創建一個。

To use a template, double-click on the icon.

Total a List is a popular template for shopping lists.

Total a List是一個流行的購物清單模板。

like this one from the homepage, for other common uses,

All of the individual rectangles on the page

That information will then be stored in the cell.

這些資訊就會被儲存在細胞中。

it'll highlight all the cells in column D.

它將突出顯示D列中的所有單元格。

The numbers down the left-hand side indicate the rows.

Click on a number to highlight the cells in a row.

點擊數字以突出顯示一行中的單元格。

When using Excel, you'll want to know which cell

在使用Excel時，你會想知道哪個單元格是

your information is in when using formulas.

當使用公式時，你的資訊是在。

you'll also see names of the cell here. G9.

你也會在這裡看到小區的名字。G9.

which is useful when you need to create formulas

當你需要創建公式時，它是有用的。

We'll click on C5 and then drag down to C13.

我們點擊C5，然後向下拖動到C13。

Once selected, you can hover over the edge of the selection

選擇後，您可以將鼠標懸停在選擇的邊緣上。

Click and drag to move your cells around.

點擊並拖動來移動你的單元格。

When using formulas in Excel, you may need to refer

在Excel中使用公式時，你可能需要參照

This is done by typing the name of the cell

in the top left corner, followed by a colon,

followed by the cell in the bottom far-right corner.

Open up Excel and double-click on "Blank Workbook"

We'll start by giving our spreadsheet a title.

我們先給我們的電子表格起個標題。

We're making a buying report for our startup clothes line.

我們要為我們的創業服裝系列做一份採購報告。

Then we'll give each column we need a heading.

然後我們要給每一列我們需要的標題。

Here we'll type "Item," and then we'll list

在這裡，我們將輸入 "項目"，然後我們將列出

以下是我們所有的服裝產品庫存。

First, let's let Excel know that we're entering prices.

首先，讓Excel知道我們要輸入價格。

要做到這一點，請在單元格中輸入成本。

Let's now highlight the rest of the cells

現在讓我們來強調一下其餘的單元格。

with the rest of the information you need.

To create a formula, first select the cell

要創建一個公式，首先選擇單元格

click on the white bar next to the "fx" sign.

This is where the formulas are stored for each cell.

這是存儲每個單元格公式的地方。

Let's use a formula to add up the cost of our stock.

我們用一個公式把我們股票的成本加起來。

First, double-click where you want the total,

首先，雙擊你想要總計的地方。

and then type the equation in the "fx" bar.

Always start a formula with an equals sign

as these are the numbers we want to total.

因為這些都是我們要總計的數字。

If the formula has been entered correctly,

the total will immediately be shown in the cell.

會出現一個錯誤符號，像這樣。

Then you should go back to your "fx" bar,

字幕列表影片播放

如何使用Excel (How To Use Excel)

sort

common

mortgage

currency