Thursday, August 2, 2007

Spreadsheet Hint

One of the reasons I wanted to Blog, was to share some ideas that may help you use content on iBanknet.com



In our Mergers and Acquisitions section we often do side by side comparisons of the financial statements of the banks involved in the merger. We make this content available in excel, rtf, and pdf formats. As you see, these documents are styled nicely.



As a note, our excel documents do not use macros. Also, I always recommend that you have up-to-date virus protection software running before downloading anything from the Internet.



Here's a hint. Most of our HTML content can be imported into Excel. Simply go to the excel toolbar, select Data, select Import External Data, select New Web Query. Cut and Paste the iBanknet URL in the appropriate spot and press Go. Then click on the desired table you want to import and click on the Import Button. And you're off to the races.



I hope you find this hint useful ...



CJS

No comments: