Microsoft Excel Basics Tutorial - Learning how to use Excel微軟的excel基礎教程-學習如何使用e xcel

Posted on March 24, 2007 at 12:58 am張貼於2007年3月24日在上午12時58分

Table of Contents for Excel Tutorials 目錄的excel教程

  1. Microsoft Excel Basics Tutorial - Learning how to use Excel微軟的excel基礎教程-學習如何使用e xcel
  2. Excel Tips & Tricks - How to unprotect only a portion of an Excel spreadsheet excel的提示與秘訣-如何u nprotect只有部分的e xcel電子表格
  3. Excel Basics - How to use the Conditional Sum wizard excel的基本問題-如何利用有條件森嚮導
  4. How to use Data Validation in Microsoft Excel to create dropdown lists如何使用數據驗證，在微軟的excel創造的下拉式列表
  5. Excel Tutorial - How to make a simple graph or chart in Excel excel的教程-如何使一個簡單的圖形或圖表，在e xcel
  6. Excel Tutorial - Example of how to use the VLOOKUP function excel的教程-例如怎樣使用v lookup函數

Learning the Basics of Microsoft Excel 學習的基本知識，微軟的excel

If you have Microsoft Office installed, but have never touched Excel before because you either didn’t know how to use it or didn’t know what it could do for you, then you MUST read this post on learning how to use Excel !如果你有微軟辦公室安裝了，但是從未觸及的excel之前，因為你根本不知道如何使用它或不知道有什麼可以為你做了，那麼你就必須閱讀這個職位就學習如何使用excel ！

Microsoft Excel is a powerful spreadsheet application that can be used for anything from a simple database all the way up to a full fledged Windows application full with windows forms, macros, and add-ons.微軟的excel是一個強大的電子製表應用軟件可用於任何從一個簡單的數據庫，所有道路邁上了一個正式的windows應用程序的全部窗戶形式，巨集指令，並附加軟件。 You can use Excel to calculate a car loan payment, graph data, manage customer records, keep an address book, etc.你可以用excel來計算汽車貸款支付，圖形數據，管理客戶記錄，保存地址簿等。

Excel is currently used by most large financial institutions for daily financial data analysis. excel的，是目前所採用的大多數大型金融機構日常財務數據的分析。 It has a huge range of financial functions, formulas, and add-ons that allows you to use Excel to store and analyze data in a simple, quick way.它有一個龐大的一系列財政職能，配方，並附加軟件，可讓您使用excel來儲存和分析數據，在一個簡單，快速的方法。

In this tutorial, we’re going to go through the basics of Excel: creating workbooks, using worksheets, entering data, using formulas, etc so that you can become comfortable with the software and begin to learn on your own by playing around with it.在本教程中，我們將要經過基本的excel ：創建作業，使用工作表，輸入數據，用公式等，讓你就可以成為舒適與軟件，並開始學習自己所玩弄它。

First Steps Into Excel 第一個步驟到excel

First, let’s open Excel and take a look at the interface of the program.首先，讓我們打開excel和來看看界面的程式。 Open Excel and a new workbook will automatically be created.打開excel和一個新的作業將被自動創建。 A Workbook is the top level object in Excel.一冊是高層對象出類拔萃。 It contains Worksheets, which hold all the actual data that you will be working with.它包含工作表，其中容納所有的實際數據，你將與。 A workbook starts off with three worksheets, but you can add or delete worksheets at any time as long as there is at least one worksheet in a given workbook.一冊開始起飛三個工作表，但你可以添加或刪除的工作在任何時候，只要有至少一個工作表，在某一特定作業。

Across the top, you have the Excel toolbars, usually the Standard and Formatting toolbars that allow you to open workbooks, create new ones, change the font style, etc. These are mostly the same as Word, but with a few different buttons that we’ll talk about later.全國最高，你有沒有excel的工具，通常的標準和格式化工具，讓您開放作業，創造新的，改變字體風格等，這都是一樣的詞，但有一些不同的按鈕，我們'當地僱員談談以後。

If you do not see the Standard and Formatting toolbars as shown above, you can have them brought back by going to View and then choosing Toolbars and check to make sure that the two toolbars have check marks next to them.如果您看不到標準和格式化工具欄如上所示，你可以把他們帶回到那去查看，然後選擇工具欄和檢查，以確保這兩個工具欄有檢查，標誌著明年給他們。

At the bottom of the screen, you’ll see three sheets, named Sheet1, Sheet2, and Sheet3.在螢幕的下方，你會看到3個產品被命名為sheet1 ， sheet2和sheet3 。 This is the default number that every Excel workbook starts off with.這是默認的人數每excel工作開始起飛。

On the right hand side of the screen is the Excel task pane, where you can perform many common tasks such as opening a workbook or creating a new one.對右手邊的畫面是excel的工作窗格，在這裡你可以履行許多共同的任務，如打開一個工作簿或創建一個新問題。 You can also perform searches for help if needed here.您也可以執行搜索幫助，如果需要在這裡。

Getting Started with Excel 起步與excel

The best way to learn anything is to actually do something useful and Excel is the best example of this!最好的方法學到什麼，是要真正做一些有益的和excel就是最好的例子，這！ Let’s say you are a teacher of high school or college students and you want to keep track of your student’s grades, calculate the average, and tell the students what grade they would have to get on their finals in order to get an A in the class.讓我們說你是一個老師的高中或大學生，你要跟踪你的學生的年級，計算平均，並告訴學生什麼品位，他們將獲得對自己的決賽中，以得到一個a在上課。

Sounds like a simple problem and it is!聽起來很簡單的問題，這是！ Excel can do this for you very quickly, so let’s see how.善於做到這一點，你得很快，所以讓我們看看如何。

First off, let’s enter some data into the cells in Excel.首先，讓我們進入了一些數據，進入細胞的出類拔萃。 In Excel, the columns are labeled starting from A and continuing to Z and beyond.在excel中，該欄目是標記出發，從不斷z和超越。 A cell is simply a particular row number and column, i.e. A1 is the very first cell in an Excel worksheet.一間囚室根本是一個特別的行號和柱，即的a1是非常細胞首次在一個excel工作。

Let’s type Students into well A1 and then type A through E as the student names continuing down column A as shown below:讓的類型學生進入良好的a1然後鍵入直通e視學生的姓名持續下跌a欄如下所示：

Now let’s enter Test 1, Test 2, and Test 3 into cells B1, C1, and D1 respectively.現在讓我們進入試驗1 ，試驗2和試驗3進入細胞b1上的c1 ，和d1分別。 Now we have a 5×4 grid, so let’s fill out some fake test grades also as shown below:現在，我們有一個5 × 4網格，所以讓我們填寫了一些假測試等級，也如下所示：

Now let’s learn some of the basics of formatting cells in Excel.現在讓我們學習的一些基本知識的格式化細胞中出類拔萃。 Right now our table doesn’t look very nice since the text and numbers are aligned differently and the headers are not visually separate from the data.我們現在表不看很好，因為文字與數字排列不同的報頭不是在視覺上分離了數據。

First, let’s center all the data so that things look nicer.首先，讓中心的所有數據，讓看的東西，要好。 Click on cell A1 and drag your mouse down to cell D6 to highlight all entire grid:點擊細胞a1和扯拽您的老鼠到細胞在d6強調所有整個網格：

Then on the Formatting toolbar, click the Center Justify button.然後就格式化工具欄上，單擊中心自圓其說按鈕。 The grid is now nicely centered with all the data directly underneath the headings.網格是目前精巧為本，與所有數據直接指向下方的標題。

Now let’s look more at how we can format Excel cells.現在讓我們看看更多的我們如何能格式的excel細胞。 Let’s change the color of the first row to something else so that we can clearly separate the header from the data.讓我們改變顏色的，第一行到別的，使我們可以很清楚地分開頭信息數據。 Click on cell A1 and drag the mouse while holding the button down to cell D1.點擊細胞a1和拖鼠標，而持此鈕，以細胞d1的。 Right click and select Format Cells .點擊右鍵並選擇格式細胞。

In the Format Cells dialog, click on the Patterns tab and select a color from the palette.在格式細胞對話框中，點擊這個模式統計表，並選擇一個顏色，從調色板。 I chose yellow to give it a bright distinction.我選擇了黃河給它一個美好的區別。

Click OK and you’ll now see that the color has been changed for the selected cells.單擊確定，你就會現在看到的顏色已經改變，為選定的細胞。

Let’s also add some borders between the cells so that if we decide to print out the Excel sheet, there will be black lines between everything.讓我們也添加了一些邊界之間的細胞，因此，如果我們決定要打印出excel的資產負債表，將有黑線之間的一切。 If you don’t add borders, the lines you see in Excel by default do not print out on paper.如果你不添加邊框，線條你看在excel默認不打印出的紙張。 Select the entire grid and click on Format Cells again.專責整個網格，然後點擊格式細胞再次。 This time go to the Border tab.這個時候去邊境統計表。 Click on the Outside and Inside buttons and you should see the small display box directly below the buttons change accordingly with the borders.點擊對外部和內部的按鈕，你應該看到小展示盒，直接在下面的按鈕改變相應的邊界。

Click OK and you should now have black lines between all of the cells.單擊確定，你現在應該有黑線之間所有的細胞。 So now we’ve formatted our grid to look much nicer!所以現在我們已經格式化，我們的網格看得多美好的！ You can do this type of formatting for your data also in the way you feel appropriate.你可以做這種類型的格式化為你的數據又在你覺得合適的。

How to use Formulas and Functions in Excel 如何使用公式和函數在excel

Now let’s get to the fun part: using Excel functions and formulas to actually do something!現在讓我們去樂趣的一部分：利用excel函數和公式，以實際做點事！ So we want to first calculate the average grade for our 5 students after their 1st three exams.因此，我們希望首先計算出平均品位為我們五學生後，第1次考試。 Excel has an average function that we can use to calculate this value automatically, but we’re going to do it slightly differently in order to demonstrate formulas and functions.卓越有一個平均函數，我們可以利用計算此值自動的，但我們也會去做略有不同，以顯示公式和功能。

Add a header called Sum in column F and Avg in column G and format them the same way we did the other header cells.放入一個頭所謂總結欄f和美國志願大隊欄g和格式，他們以同樣的方式，我們沒有其他的頭細胞。

Now first we’ll use Excel’s sum function to calculate the sum of the three grades for each student.現在首先，我們將使用excel的函數，計算總和的3個等級，為每一位學生。 Click in cell F2 and type in “=sum(” without the quotes. The = sign tells Excel that we plan on putting some type of formula into this cell. When you type in the first parenthesis, Excel will display a little label showing you what types of variables this function takes.點擊在細胞f2和鍵入" =森（ "沒有加引號。該=跡象告訴excel的，我們計劃把某種類型的公式到這間囚室。當你輸入第一個括號中，善於將顯示一個小標籤上顯示你什麼類型的變數，此功能需。

The word SUM is a built-in function in Excel which calculates the sum of a specified range of cells.字總結，是一個內置的功能在excel ，計算總和指明範圍內的細胞。 At this point after the first parenthesis, you can select the range of cells you want to sum up!在這一點上後，首先括弧，你可以選擇各種細胞，你想總結！ No need to type the cells one by one!無需類型細胞的一個又一個！ Go ahead and select cells B2 to D2 and you will see that the formula is automatically updated and is in blue.繼續進行，並選擇細胞b2的2級，你就會看到這個公式是自動更新，並為藍色。

After you select the range, type in the closing parenthesis (Shift + 0) and press Enter.之後，你選擇的範圍，種類，在閉幕括號（班+ 0 ） ，並按下進入。 And now you have the sum of the numbers!現在，你有沒有這筆數目！ Not too hard right!?不要太硬，正確的！ ？ However, you might say that it would be a royal pain to do this for a set of 100 or 500 students!但是，你可能會說，這將是一個皇家疼痛這樣做了一套100或500學生！ Well, there’s an easy way to copy your formula automatically for the other students.那麼，有一個簡單的方法來複製公式自動為其他同學。

Click on cell F2 and then move your mouse slowly to the lower right edge of the cell.點擊細胞f2和，然後提出你的鼠標，慢慢向右下邊緣的細胞。 You’ll notice that the cursor changes from a fat white cross to a skinny black cross and the bottom right of the cell is a small black box.你會看到光標變化，從一個胖白叉瘦黑交叉和自下而上的權利細胞是一個黑色小盒子。

Click on that small black box and hold your mouse down and drag it to the row of the last student.點擊小黑匣子按住鼠標下來，久拖向一排的最後一個學生。 And with that, Excel uses the same formula, but updates the current row cells so that the sum is calculated for each row using that row’s data.並指出，善於利用同樣的公式，但更新當前行的細胞，因此認為這個數目計算，為每連續使用該行的數據。

Next, click in cell G2 and type the = signs to denote we are starting a formula.然後，單擊細胞g2和鍵入=標誌，以標示我們正在開始一個公式。 Since we want to divide the sum by 3 to get the average, type the = sign and then choose the sum cell F2.既然我們想分化總結3年至得到平均，鍵入=標誌，然後選擇總結細胞f2的。 Continue on with the formula by typing in “/3″, which means divide by 3.繼續對與公式，由用戶鍵入" / 3 " ，即除以3 。

Press Enter and you now have entered your own average forumla!記者進入，你現在已經進入自己的平均forumla ！ You can use parenthesis and perform all the math functions in this same way.你可以使用圓括號，並履行所有的數學函數在這同樣的方式。 Now do the same thing as with the average and click the small black box at the lower right corner in cell G2 and drag it down to the bottom.現在做同樣的事情，因為與平均點擊黑色小方格的右下角，在細胞g2和阻力減至最低。 Excel will calculate the average for the rest of the cells using your formula.善於將計算平均為其餘的細胞用你的公式。

And lastly, let’s put in one more formula to calculate what each student would have to get on the final in order to get an A in the class!最後，讓我們把在多一個公式來計算，每個學生將不得不盡快進行最後為了得到一個a在階級！ I’m assuming that the three tests were worth 70% of the grade, the final is worth 30%, and an A is 90 or above.我假設的三次試驗中的價值70 ％的等級，最後值得一提的百分之三十，和一個a是90或以上。

So in order to calculate the minium grade to get an A in the class, we have to take 90 and subtract 70% of the average test scores and divide the whole thing by 30%.因此，為了計算最小等級，以獲得a在階級，我們要採取90核減70 ％的平均測驗分數和分化整個事情百分之三十。

Min Grade To Get A: (90 - (.7 * AVG)) / .3 閔品位得到： （ 90 -（ . 7*平均額） ） / . 3

So let’s create a new header in column I and in cell I2, beging typing “=(90 - (.7 *” and then select cell G2 and then continue on with “))/.3″ and then press Enter.所以讓我們創造一個新的標題欄，我和細胞素， beging鍵入" = （ 90 -（ . 7* " ，然後選擇細胞g 2的，然後繼續就與" ))/.3 " ，然後回車。 You should now see the grade required and also the formula in the formula bar above the column names.你現在應該看到，品位要求，也是公式，在公式桿以上的列名。

Again, grab the bottom black box of the cell and drag it down to the bottom of the data set.再次，抓斗底部黑匣子的細胞並拖動它放下至底部的數據集。 And viola!和中提琴！ You’ve now used Excel functions, created your own formulas in Excel and formatted cells to make them visually appealing.你現在用excel的職能，創造了自己的公式在excel和格式化細胞，使它們在視覺上的吸引力。

Looks like Student C has to get a 118 in order to get an A in the class!看起來像學生c有獲得118為了得到一個a在階級！ Whoops!受到出席！

Hope this helped!希望這有助於！ I’ll try and write more like this for more advanced features of Excel and other Office products.我會盡量多寫這樣的具有更先進功能的excel等辦公產品。 Please leave your comments on this Excel tutorital!請留下你的評論，對這個excel tutorital ！

Next in series明年串聯

Bookmark, Share or Email this article. 書籤，分享或電郵這篇文章。

If you enjoyed this post, make sure you 如果你享受這個職位時，要確保你 subscribe to my RSS feed 訂閱我的rss飼料 ! ！

» Filed Under »存檔下 MS Office Tips女士辦公室貼士

Related Posts相關職位

Please post your comments/suggestions!請後，你的意見/建議！