Showing posts with label Best States in America (US) for Business–CNBC–Excel 2013 Web App Interactive. Show all posts
Showing posts with label Best States in America (US) for Business–CNBC–Excel 2013 Web App Interactive. Show all posts

Sunday, August 12, 2012

Best States in America (US) for Business–CNBC–Excel 2013 Web App Interactive

Every year CNBC publishes the top states in the US for business, quality of live, cost of living, education etc. While the data is already available at CNBC here, I thought of importing this data into an interactive Excel format.

Here is a brief description of how I did it.

Importing a HTML table into Excel:

The crudest way of this is to just copy-paste from a web-page into Excel. However my preference is to use the import data from Web Page option. This works like a charm. I did that for 2012, 2011 and 2010 data.

image

 image

image

Next I formatted the table in Excel and saved the file as HTML so that I can add the Excel Interactive Button.

Go to www.excelmashup.com to generate the code and steps to add the script to the HTML file.

image

Here is the HTML table with the Excel Interactive Button:

image

Click on the button and you see Excel Interactive format:

image

Click on “Open in Excel Web App”

image

image

Since I live in Boise, Idaho state, I zoomed in on Idaho’s results which is very impressive for business seekers. Its ranked 7th overall for Cost of Business and 9th for Cost of Living. However it is at the bottom of the list for Education.

image

In summary, I really like the Excel’s Web Interactive Interface and also the Web App. Here, feel free to test drive it yourself.