Có 20+ tài liệu thuộc chủ đề "tài liệu excel 2010"
tailieu.vn Xem trực tuyến Tải xuống
Working with Excel. In this chapter you learn about Excel and you find out the kinds of tasks you can perform with Excel.. You also learn how to start the program, and you take a tour of the program’s major features.. This chapter also shows you how to work with Excel Ribbon and the Ribbon’s galleries, how to customize the...
tailieu.vn Xem trực tuyến Tải xuống
Excel displays a list of the gallery’s contents.. 4 Move the mouse over a gallery option to see a preview of the effect.. Excel displays a preview of the effect.. 5 Click the gallery option you want to use.. Excel applies the gallery options to the selected object.. 1 If necessary, click the object with which you want to apply...
tailieu.vn Xem trực tuyến Tải xuống
You can customize Excel and set up the program to suit the way you work by. configuring the Excel options. Excel Options. 4 Use the controls on the right side of the dialog box to configure the options you want to change.. The Excel Options dialog box appears.. 3 Click a tab on the left side of the dialog box...
tailieu.vn Xem trực tuyến Tải xuống
In the United States, for example, you can use the month/day/year format . Excel closes the cell for editing.. 1 Click the cell in which you want to enter the date.. 1 Click the Home tab.. 2 Click the dialog box launcher button in the bottom right corner of the Number group.. 3 Click the Number tab.. 5 Click the...
tailieu.vn Xem trực tuyến Tải xuống
1 Click in the first cell that you want to include in the range.. 2 Hold down and click in each of the other cells that you want to include in the range.. Each time you click in a cell, Excel adds it to the range.. 3 Release to end the range selection.. 1 Position over the first cell you...
tailieu.vn Xem trực tuyến Tải xuống
4 4 2 Click the Home tab.. 3 Click the Insert. Note: You can also press. 1 Select the cell or range where you want the inserted cell or range to appear.. Insert a Cell or Range. If you need to add data to an existing range, you can insert a single cell or a range of cells within that...
tailieu.vn Xem trực tuyến Tải xuống
1 Select the cells that you want to merge.. You can create a single large cell by merging two or more cells. You can center a title across the entire worksheet, or you can center a heading across the columns that it refers to. 5 Type your text in the merged cell.. 05_577639-ch03.indd 61. 05_577639-ch03.indd PM PM. 1 Select the...
tailieu.vn Xem trực tuyến Tải xuống
Excel selects the range.. Navigate Using the Name Box. 1 Open the workbook that contains the range you want to work with.. 2 Click the Name box. 3 Click the name of the range you want to select.. Navigate a Workbook Using Range Names One of the big advantages of defining range names is that they make it easier to...
tailieu.vn Xem trực tuyến Tải xuống
4 4 To format the text as italic, 4. click the Italic button. 5 To format the text as. underline, click the Underline button. Excel applies the effects to the selected range.. 6 Click the Font dialog box launcher. 1 Select the range you want to format.. 2 Click the Home tab.. 3 To format the text as bold, click...
tailieu.vn Xem trực tuyến Tải xuống
Excel applies the color to the range text.. 1 Select the range you want to format.. 2 Click the Home tab.. Add a Background Color to a Range. You can make a range stand out from the rest of the worksheet by applying a background color to the range. For example, many people apply a background color to the labels...
tailieu.vn Xem trực tuyến Tải xuống
3 3 2 Click the Home tab.. 1 Select the range you want to format.. You can reduce the time it takes to format your worksheets by applying Excel’s predefined styles to your ranges. Select the range that includes your data, click the Home tab, and then click Format as Table. In the gallery that appears, click the table format...
tailieu.vn Xem trực tuyến Tải xuống
Formulas and Functions. 08_577639-ch06.indd 110. 08_577639-ch06.indd PM PM. 08_577639-ch06.indd 111. To get the most out of Excel, you need to understand formulas so that you can perform calculations on your worksheet data. You need to know the components of a formula, you. need to understand arithmetic and comparison formulas, and you need to understand the importance of precedence when building...
tailieu.vn Xem trực tuyến Tải xuống
3 Use the mouse to click and drag the row or column of numbers that you want to add.. Excel adds a reference for the range to the formula.. 1 Click in the cell where you want the sum to appear.. Note: In the function banner, bold arguments are required, and arguments that appear in square brackets are optional.. Add...
tailieu.vn Xem trực tuyến Tải xuống
09_577639-ch07.indd 130. 09_577639-ch07.indd PM PM. You can use a few keyboard techniques that make it easier to navigate data after it is entered in a worksheet.. After you enter data into a cell, it is usually easiest to use your mouse to click in the next. cell you want to work with. However, if you are entering data and your...
tailieu.vn Xem trực tuyến Tải xuống
2 Click the Home tab.. 3 Click the Delete. You can also right-click the tab and then click Delete Sheet.. 1 Click the tab of the worksheet you want to delete.. If you have a worksheet that you no longer need, you can delete it from the workbook.. This reduces the size of the workbook, reduces clutter in the worksheet...
tailieu.vn Xem trực tuyến Tải xuống
To use an Office Online template, click a category in the Office.com Templates section. Click the template you want to use, and then click Download.. 1 Click the File tab.. Create a New Workbook from a Template You can save time and effort by creating a new workbook based on one of Excel’s template files. Excel creates the new workbook...
tailieu.vn Xem trực tuyến Tải xuống
These include the workbook colors for things like text and borders. 11_577639-ch09.indd 160. 11_577639-ch09.indd PM PM. Chapter 999 Modify the Workbook Colors. Set the Workbook Fonts. 11_577639-ch09.indd 161. workbook you want to format.. 2 Click the Page Layout tab.. Modify the Workbook Colors. You can give your workbook a new look by selecting a different color scheme. Each color scheme...
tailieu.vn Xem trực tuyến Tải xuống
You can get more out of Excel by performing data analysis, which is the application of tools and techniques to organize, study, and reach conclusions about a specific collection of. In this chapter you learn how to sort and filter a range, apply data validation rules to a range, convert a range to a table, create a data table, and...
tailieu.vn Xem trực tuyến Tải xuống
the input values and the formula.. 3 Click the Data tab.. 5 Click Data Table.. 1 Type the input values:. To enter the values in a column, start the column one cell down and one cell to the left of the cell containing the formula, as shown here.. To enter the values in a row, start the row one cell...
tailieu.vn Xem trực tuyến Tải xuống
1 Click the chart.. 2 Click the Layout tab.. You can make your chart easier to read and easier to understand by adding one or more titles to the chart. For example, you can add a chart title, which is a title that appears at the top of the chart and is usually a word or short phrase that describes...