Excel 2010 Training Book pptx

... also press + . Open a Workbook To view or make changes to an Excel workbook that you have saved in the past, you can open the workbook in Excel. If you have used the workbook recently, you can ... file. 5 Click Save. Excel saves the file. Note: To learn how to save a workbook in an older Excel format, see Chapter 13. Save a Workbook After you create a workbook in Excel and ma...

Ngày tải lên: 14/12/2013, 15:15

... 17712_577639-ch10.indd 177 3/15/10 2:46 PM3/15/10 2:46 PM Chapter Chapter 10 1010 10 Analyzing Excel Data You can get more out of Excel by performing data analysis, which is the application of tools and techniques ... subtotals. 12_577639-ch10.indd 17012_577639-ch10.indd 170 3/15/10 2:46 PM3/15/10 2:46 PM 173 Analyzing Excel Data CHAPTER 10 77 88 99 00 • Excel adds another sort lev...

Ngày tải lên: 14/12/2013, 15:15

... sharing the workbook. Once you have shared a workbook, other users can open the workbook via a network connection and edit the file at the same time. When you share a workbook, Excel automatically ... save the workbook. 7 Click OK. Excel saves the workbook and activates sharing. • Excel displays [Shared] in the title bar. You and users on your network can now edit the workb...

Ngày tải lên: 14/12/2013, 15:15

... Excel 2010 1 Các hàm trong excel d. Các hàm tài chính - financian functions ACCRINT (issue, first_interest, ... (settlement, maturity, frequency, basis) : Tính số ngày kể từ đầu kz lãi tới ngày kết toán Excel 2010 4 MDURATION (settlement, maturity, coupon, yld, frequency, basis) : Tính thời hạn ... frequency, basis) : Tính lợi nhuận của chứng khoán có kz cuối cùn...

Ngày tải lên: 15/12/2013, 05:15