tailieunhanh - how to do everything with ms office excel 2003 phần 6

nhưng bạn có thể áp dụng định dạng tế bào khác (ví dụ, bạn có thể chọn để hiển thị số thứ tự cho ngày).Excel bao gồm 16 chức năng tài chính, giải thích trong Bảng 7-2, để tính toán thông thường, và phân tích tài chính Chức năng | 202 How to Do Everything with Microsoft Office Excel 2003 8. If you want to be able to use this query in the future click the Save Query button and specify the name in the resulting Save As dialog box. Excel s default location for saving queries is your userprofile Application Data Microsoft Queries folder. You may want to save the query elsewhere for example on a network drive so that your colleagues can use it as well. Once you ve saved a query you can reuse it by choosing Choose Data Import External Data New Database Query selecting the query on the Queries tab of the Choose Data Source dialog box and clicking OK. 9. Click the Finish button. Excel displays the Import Data dialog box 10. Specify whether to import the data into the current worksheet into a new worksheet or to create a PivotTable with it. Then click the OK button. Excel imports the data in the way you specified and displays the External Data toolbar Edit Query Query Parameters Cancel Refresh Refresh Status Data Range Properties Refresh External Data Refresh All The External Data toolbar offers these buttons for working with the data that you ve imported Edit Query Relaunches the Query wizard for editing the query. Data Range Properties Displays the External Data Range Properties dialog box shown here which contains options for saving the query definition protecting it with a password controlling how and when Excel refreshes the query and specifying formatting and layout options for the external data. These options are largely self-explanatory once you know where to find them. CHAPTER 9 Organize Data with Excel Databases 203 Query Parameters Displays the Parameters dialog box in which you can check or change the parameters for the query 9 Refresh External Data Forces an immediate refresh of the active external range. Cancel Refresh Cancels an ongoing refresh for example if it s taking too long . Refresh All Forces immediate refreshes of all external ranges in the active workbook. Refresh Status .