tailieunhanh - modeling structured finance cash flows with microsoft excel a step by step guide phần 10

Việc phát hành sắp tới của Microsoft Excel 2007 có một số cải tiến làm cho các mô hình tài chính mạnh hơn và có khả năng xử lý lượng dữ liệu lớn hơn. Những thay đổi rõ ràng nhất là đồ họa, đó là một bản cập nhật đáng chú ý đến hệ thống lệnh trên thanh công cụ, | Using This Book with Excel 2007 The upcoming release of Microsoft Excel 2007 has a number of improvements that make financial models more powerful and capable of handling larger amounts of data. The most obvious changes are graphical namely a noticeable update to the toolbar command system which allows faster access to controls for formatting and manipulating spreadsheet data. There is also a vast expansion of the maximum number of rows and columns. Figure shows the new look of Excel 2007 s default workbook window. A very important new feature is Excel s improved use of memory. Formula calculation methodologies have also been made more efficient. Both speed up total workbook calculation time. While it may take a few years before companies switch over to Excel 2007 small businesses and tech-savvy individuals will want to run Excel 2007 now and they will need to know how it affects this book. FIGURE Microsoft Excel 2007 s default workbook window. 179 180 USING THIS BOOK WITH EXCEL 2007 Overall the difference between Excel 2007 and earlier versions will have no impact on the functionality of the Project Model. However a few of the step-by-step instructions will need to be performed differently due to the new tabbed Ribbon system that Excel 2007 uses. Instead of the menu bar selections commonly found on Microsoft Office 2000 2002 and 2003 applications File Tools Format and the like Excel 2007 uses a Ribbon and various tabs that reorganize and access commonly used controls. Accessing those operations is more graphical and iconbased rather than menu driven. This affects the creation of data validation lists pasting formats inserting names adding worksheets using Goal Seek and opening the Visual Basic Editor VBE . Instead of using the menu commands to access these operations the Ribbon system is used by clicking on the appropriate button. The keyboard shortcuts still remain and can be used to quickly use many of those operations. Using operations and tools .