Already on ArticleSlash?

Forgot your password? Sign Up

Using Excel to Organize Your Browsing Discoveries (Create a Mini-Database Using Excel)

John V. W. Howe

Visitors: 182

Judging from the large market share that Micosoft owns on the Internet, a large majority of Internet users have Excel available on their computers.

Excel is a great, versatile tool and can be used for any number of uses. Many people consider Excel a program for number crunching and formulas. It is much more than that.

An Excel workbook (contains more than one worksheet) can be created to record interesting information or websites to which one wants to return later. Nothing is more frustrating than to discover a great site with super content and not be able to find your way back to it.

An easy way to use Excel for this is to create an icon for the workbook and put it in the “Quick Launch" area of the tool bar on the bottom of the page to the right of the Start Button. When you are browsing and find a “gem", you can quickly open the workbook and record the gem and its URL. This workbook will probably stay open a lot of the time that you are on the Net.

To use Excel as a database, make each row be the entry in the database and each column be the field in the record contained in the rows. You enter the information for an item in each row. You can then sort all the information, use the Find function to look up an entry by search term, delete a row, insert a row, etc.

A video has been created to demonstrate how to use Excel to organize your topics and website locations. (Video length 24:32).

To effectively use the video, download the example Excel workbook from Boomer eZine. To download it, right click on the link below and select “Save Target as". Save the spreadsheet on your hard drive where you keep your important files. You can use this workbook for your practice lessons in the video and you can use it for your mini-database. Now, about the format of the video, it will cover a short topic and then pause so you can practice the same steps in the workbook.

If you want to go back and review something in the lesson, you can use the slider at the bottom of the video player to skip back.

When you are satisfied that you understand the content and you are ready to proceed, click on the arrow in the video to continue.

I hope you find this Excel workbook handy to organize your Internet browsing data.

Click here to view the video about using Excel as a mini-database Good luck and good browsing.

Copyright 2007 John Howe, Inc.

John V. W. Howe is an entrepreneur, author, inventor, patent holder, husband, father, and grandfather. He has been involved in entrepreneurial activities for over 40 years. He founded to help Boomers (baby boomers) become entrepreneurs when they retire.


Article Source:

Rate this Article: 
Do You Really Need Excel VBA Training?
Rated 4 / 5
based on 5 votes

Related Articles:

Database Tips From an Excel Training Course

by: Christine Harrell (March 14, 2008) 
(Computers and Technology)

Excel 2007 Training - Isn't About Time You Upgraded Your Excel Skills?

by: Jack G. Elliott (November 18, 2008) 
(Computers and Technology/Software)

Excel Programmer – Excel Automation for businesses

by: Steve Das (December 13, 2012) 
(Business/Small Business)

Microsoft Excel How to Create Charts

by: Adrian Sallis (June 24, 2008) 
(Computers and Technology/Software)

How To Create A vCard From Excel Competently

by: Lisa Malkin (February 23, 2013) 
(Computers and Technology/Software)

How to Create a Dynamic Excel Calendar Without Using Macro

by: Jason Khoo (November 19, 2008) 
(Computers and Technology/Software)

Using Microsoft Excel Or Google Spreadsheets to Create a Monthly Budget

by: Trevor Shipp (July 27, 2008) 
(Finance/Personal Finance)

Excel 2007 forms using VBA – An exceptional tool to create complex business ..

by: Blake Quintero (August 02, 2011) 
(Computers and Technology/Software)

A Review of Excel in MLM

by: Brian Garvin (September 28, 2008) 
(Home Based Business/Network Marketing)

Do You Really Need Excel VBA Training?

by: Christine Harrell (November 22, 2008) 
(Computers and Technology/Software)