Skip to Main Content

Archive for June, 2011

Create a website with rollovers using Illustrator and Dreamweaver

Knowing the basics of Illustrator and very little Dreamweaver, it has become very easy to create an interesting and fun website, complete with rollovers without knowing any code. Here’s an example of what can be accomplished. I used CS5 on my iMac, but you can use a PC and Adobe versions as old as CS2 just as well.

To Start with, create a new Folder on the Desktop (or wherever you plan to save your website) and title is “website.” This will provide a location where all your files for this particular website will be saved. It is important to keep all web files for one website in one location.

Read the rest of “Create a website with rollovers using Illustrator and Dreamweaver” »

Episode 14 – Access Series

The latest episode of the it2go podcast is up! We spend some time talking about the Access series and some of the ways you can use this powerful program. Listen in and use this post to comment! Enjoy!

it2go – The IT Training Podcast

Excel: Importing Data From the Web

The Web can be a wonderful source of information. But you can easily drag information from a web site table into Excel and squeeze even more meaning from it. I recently stumbled on a table of highest grossing movies of all time, and I was curious to know which of them had been released in 2010. Instead of scrolling through the list to search for them (quite a task since there were almost 500 titles in the list), I swooped the list into Excel so I could analyze from there. Here’s how.

First I copied the URL of the web site holding the data. Then I switched to Excel. On the Data tab of the Ribbon, I clicked the From Web icon in the Get External Data group. The New Web Query window opened providing an address field where I pasted the URL of my movie information source.

Importing Data From the Web

Importing Data From the Web

After I pressed Enter the web page displayed, but Excel still didn’t know which content on the page I wanted to import. The dialog box showed black and yellow arrow boxes as indicators for various elements on the page. I clicked the indicator next to my table and clicked Import at the bottom of the box. In the next dialog box I had to confirm cell A1 as my intended destination for the first cell of the table.

There was a slight pause for data retrieval, but in a few seconds the list of movies was sitting in my Excel spreadsheet ready for me to analyze. A favorite at our house from 2010, Toy Story 3, sits at No. 9 in the list!

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.