Use the clickable sections below to skip through

使用以下可點擊的部分來跳過

different parts of this tutorial.

本教程的不同部分。

First, launch the program.

首先，啟動程序。

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是一個流行的購物清單模板。

You can choose other useful templates,

你可以選擇其他有用的模板。

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

像主頁上的這個，其他常用。

such as the mortgage loan calculator

如按揭貸款計算器

and the time-sheet template.

和考勤表模板。

All of the individual rectangles on the page

頁面上所有的單個矩形。

are called cells.

被稱為細胞。

You can double-click on a cell,

你可以雙擊一個單元格。

type some information,

輸入一些資訊。

and press enter.

然後按回車鍵。

That information will then be stored in the cell.

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

At the top of the sheet,

在紙張的頂部。

you'll see letters from A to Z.

你會看到從A到Z的字母。

These are the columns.

這些都是欄目。

If you click on letter D,

如果你點擊字母D。

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.

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

Each cell is named by the column letter

每個單元格用列號命名

followed by the row number.

後面是行號。

Let's click on this cell.

讓我們點擊這個細胞。

The column G is highlighted at the top;

G列在頂部突出顯示。

the row nine is highlighted on the left.

左邊的第九行高亮顯示。

On the top left of your screen,

在你螢幕的左上方。

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

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

You can select multiple cells,

您可以選擇多個單元格。

which is useful when you need to create formulas

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

or want to move cells around.

或想要移動細胞。

Click on a cell and drag your cursor

點擊一個單元格並拖動遊標

across other cells to select a group.

跨越其他單元格來選擇一組。

Let's select all of our cost prices.

讓我們選擇所有的成本價格。

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

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

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

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

until you see the grab icon.

直到你看到抓取圖標。

Click and drag to move your cells around.

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

When using formulas in Excel, you may need to refer

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

to a group of cells you're selecting.

到您正在選擇的一組單元格。

This is called the range.

這就是所謂的範圍。

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.

後面是最右下角的單元格。

This range would be called C5 to H13.

這個範圍將被稱為C5至H13。

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

打開Excel，雙擊 "空白工作簿"

to start creating your spreadsheet.

開始創建您的電子表格。

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

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

all our clothing items in stock below.

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

The next column we want to add

下一列我們要添加的是

is the cost of the products.

是產品的成本。

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

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

To do this, type the cost into the cell,

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

double-click the cell,

雙擊該單元格。

and then click on the drop-down here

然後點擊這裡的下拉菜單

and select "Currency."

並選擇 "貨幣"。

Let's now highlight the rest of the cells

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

we want to be in this currency

我們想在這個貨幣

and do the same thing.

並做同樣的事情。

Continue to populate your spreadsheet

繼續填充您的電子表格

with the rest of the information you need.

和其他你需要的資訊。

Formulas calculate the value of cells.

公式計算單元格的值。

To create a formula, first select the cell

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

where you want to see your answer.

你想在哪裡看到你的答案。

At the top of your screen,

在你的螢幕頂部。

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

點擊 "fx "標誌旁邊的白色條。

This is where the formulas are stored for each cell.

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

You'll be able to write formulas here,

在這裡你就可以寫公式了。

as well as edit them.

以及編輯它們。

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.

然後在 "fx "欄中輸入公式。

Always start a formula with an equals sign

始終以等號開始一個公式

followed by the formula instruction.

後面是公式指令。

Type "="

輸入"="

followed by "SUM" in capital letters

後面的大寫字母 "SUM"。

followed by "("

後面是"("

followed by the range.

其次是範圍。

Our range is from D5 to D13,

我們的範圍是從D5到D13。

as these are the numbers we want to total.

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

So we'll type "D5:D13"

所以我們就打 "D5:D13"

followed by a closed-bracket sign

後面是一個封閉的括號

to complete the equation.

來完成方程。

Press enter.

按回車鍵。

If the formula has been entered correctly,

如果公式輸入正確。

the total will immediately be shown in the cell.

總計將立即顯示在單元格中。

If you've made a mistake,

如果你犯了錯誤。

perhaps you've misspelled something,

也許你已經拼錯了什麼。

an error symbol will appear, like this.

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

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

那麼你應該回到你的 "fx "吧。

and you can edit it until it's correct.

你可以編輯它，直到它的正確性。

Another common action used in formulas is multiply.

公式中另一個常用的動作是乘法。

To do this, select where you'd like to see your answer,

要做到這一點，請選擇您希望看到您的答案的位置。

and in the "fx" bar, type "="

並在 "fx "欄中輸入"="

followed by the cell number you want to multiply

後面是你要乘的單元格號。

followed by the star symbol

後面是星號

and then the other cell you want to multiply.

然後是你要乘的另一個單元格。

Press enter.

按回車鍵。

Your cell should now have the formula installed.

你的單元格現在應該已經安裝了公式。

As the formula is now installed,

由於現在已經安裝了公式。

you can change the data in cell C5,

您可以更改C5單元格中的數據。

and the answer will be corrected in E5 automatically.

並在E5中自動修正答案。

If you want to apply this formula

如果你想應用這個公式

to the rest of the cells in the "Total Cost" column,

到 "總成本 "欄的其他單元格。

click on the cell where the formula is entered.

點擊輸入公式的單元格。

Hover your cursor over the bottom right corner of the cell

將遊標停留在單元格的右下角。

until you see a small black cross.

直到你看到一個黑色的小十字架。

Click and drag across the rest of the cells

單擊並拖動其餘單元格

where you want the formula applied.

在您想應用公式的地方。

The formula will now be copied to the remaining cells.

現在公式將被複制到其餘單元格中。

Click on a cell and look in the "fx" bar

點擊一個單元格，在 "fx "欄中查找。

to check the formula used to create the cell value.

檢查用於創建單元格值的公式。

You'll see that E10 has been calculated

你會看到，E10已經被計算出來了。

by multiplying C10 and D10,

由C10和D10相乘。

just like in the first cell.

就像在第一個單元格里一樣。

Remember, you can edit formulas in the "fx" bar

記住，你可以在 "fx "欄中編輯公式。

if you want to change any of them at any time.

如果你想在任何時候改變它們中的任何一個。

You can learn how to create other formulas

你可以學習如何創建其他公式。

by learning the Excel language.

通過學習Excel語言。

For example, multiply is indicated by the asterisk symbol.

例如，乘法用星號表示。

Divide is indicated by the forward slash symbol.

除數用正斜線符號表示。

You can customize your worksheet by formatting cells.

您可以通過格式化單元格來定製您的工作表。

Let's start by changing the look of the title.

我們先來改變一下標題的外觀。

You probably want to make it bigger

你可能想把它做大一點

or change the font and color to make it stand out.

或改變字體和顏色，使其與眾不同。

Select the title cell,

選擇標題單元格。

go to the home menu at the top of the screen,

進入螢幕上方的主菜單。

and select the font size from the drop-down menu.

並從下拉菜單中選擇字體大小。

24 looks just about right.

24歲看起來剛剛好。

Now you can also select your font and color.

現在你還可以選擇你的字體和顏色。

To change the color of your cells, highlight the cells

要改變單元格的顏色，請高亮顯示單元格。

and click on the paint icon from the home menu.

並從主菜單中點擊油漆圖標。

A drop-down menu will appear.

會出現一個下拉菜單。

Now you can select your color of choice.

現在，你可以選擇你的顏色的選擇。

You can also add borders to your table.

你也可以給你的表格添加邊框。

Highlight your cells and go to the home menu

高亮顯示你的單元格，並進入主菜單

and click on the border tool.

並點擊邊框工具。

A drop-down menu will appear.

會出現一個下拉菜單。

Select an option you want.

選擇一個你想要的選項。

We'll choose "All Borders."

我們選擇 "所有邊界"。

Highlight your cells

突出顯示你的細胞

and explore the icons on the home page

並探索主頁上的圖標

to try different formatting options

嘗試不同的格式化選項

to customize your workbook.

來定製你的工作簿。

A table is a specific set of rows and columns

表是一組特定的行和列的集合

that you can apply functions to,

你可以應用函數。

such as adding filters,

如添加過濾器等。

formatting, or creating graphs.

格式化，或創建圖形。

Let's turn our buying report for our fashion startup

讓我們來看看我們的時尚創業公司的採購報告。

into a table.

成表。

First, highlight the cells you want to add to your table.

首先，高亮顯示你要添加到表中的單元格。

Click on "Insert," then click on "Table."

點擊 "插入"，再點擊 "表格"。

If your cells include headings,

如果你的單元格包括標題。

check the "My Table has headers" box,

勾選 "我的表有標題 "框。

then click "OK."

然後點擊 "確定"。

Your cells will now be turned into a table.

你的單元格現在將變成一個表格。

On the top right corner of the screen

在螢幕的右上角

under the table section,

表部分下。

you'll see a series of colored designs.

你會看到一系列的彩色設計。

Choose the one you like,

選擇一個你喜歡的。

and you'll see your table change.

然後你就會看到你的桌子變了。

You can expand the size of your table

你可以擴大你的表格的大小

by amending the number of columns or rows in it.

通過修改其中的列數或行數。

To do this, hover your cursor

要做到這一點，請將遊標懸停在

over the bottom right corner of the table

桌子右下角

and click and drag the black arrowed square

並點擊並拖動黑色箭頭方塊

across the columns or rows

橫七豎八

you want to be added to your table.

你想被添加到你的表中。

The sort and filter features on tables

表格的排序和過濾功能

help to organize your data.

幫助您組織數據。

Click on the drop-down arrow next to one of the headings.

點擊其中一個標題旁邊的下拉箭頭。

A pop-up will appear.

會出現一個彈窗。

Next to "Sort," click on "Ascending."

在 "排序 "旁邊，點擊 "升序"。

The table will now be arranged

桌子現在將被安排

in ascending order of retail prices.

按零售價由高到低排序。

Now use the filter function by unchecking

現在使用過濾功能，取消勾選

one of these boxes.

其中的一個盒子。

This will hide all the items on the table

這將隱藏桌上的所有項目

that are $182.50.

即182.5元。

A bar graph is a visual way to present your data.

條形圖是一種可視化的數據展示方式。

Let's say you want to see

比如說你想看

how profitable your denim stock is in a bar chart.

你的牛仔布股票在柱狀圖中的利潤如何。

We want to show the profit-margin values

我們要顯示的利潤率值是

against the different denim clothing items.

針對不同的牛仔服裝項目。

Select all the denim clothing items in the column,

選擇欄目中所有的牛仔服裝項目。

then press and hold down the command or CTRL button

然後按住命令或CTRL鍵。

on your keyboard and select the sales-profit values.

在鍵盤上選擇銷售-利潤值。

Once you have selected all the data,

一旦你選擇了所有的數據。

click on the insert tool on the top menu,

點擊頂部菜單中的插入工具。

then select the bar graph.

然後選擇條形圖。

A pop-up window will appear

會出現一個彈出窗口

with bar-graph design options.

具有條形圖設計選項。

Select the one you want by clicking on it,

通過點擊選擇你想要的。

and your graph will appear.

你的圖形就會出現。

You can double-click on the chart title

您可以雙擊圖表標題

and type in the heading you want to give your chart.

並鍵入你想給你的圖表的標題。

Under the "Chart Design" section,

在 "圖表設計 "部分。

you can customize your bar graph.

您可以自定義您的條形圖。

Click on the drop-down arrow

點擊下拉箭頭

by the quick-layout icon

由快速佈局圖標

and select a design to add X-axis and Y-axis titles.

並選擇一個設計來添加X軸和Y軸的標題。

To change your graph to a different kind of chart,

要把你的圖表換成另一種圖表。

you can click on the drop-down arrow

您可以點擊下拉箭頭

beside the "Change Chart Type" icon

旁邊的 "更改圖表類型 "圖標

and select a different type of graph.

並選擇不同類型的圖形。