Integrate real-time data into an Excel worksheet for budgeting

Oiio. net sales manager has to carry out a budget every month. The previous practice was to first classify and summarize the cost and expenditure from the sales system based on the current month's expenses to excel, then, we will track and reference the budget for the next month's plan. However, this is a long manual operation, and the summary of the fees is collected each time, in fact, it is already a static report that is out of the "current" type, which makes the budget evaluation quite inaccurate.

Office 2007 adopts a powerful open XML format, so Andy adopts a special mechanism, the sales manager can upload a small XML data stream of the sales system to the workbook of Excel. When the sales manager opens the Excel file, the sales system can automatically load and update the data in the Excel Workbook, just like the data link updates between the previous Excel Workbook and the Excel Workbook. The difference is that, allows dynamic link updates between EXCEL and other systems and even platforms.

Now, the Excel Workbook responsible for budget planning can keep the latest sales data at any time. With the powerful EXCEL function, you can customize the desired plan report at any time according to financial requirements, and before the meeting, simply press the next key to obtain the final real-time data, instead of repeating the previous step, which not only saves repetitive labor, but also makes the plan more informative and accurate, this is really cool.

**************************************** ************
You can see more occasionally released Office 2007 application scenarios from the following links
Http://andyk.cnblogs.com/category/53398.html
**************************************** ************