eHow launches Android app: Get the best of eHow on the go.
Accessing, organizing and maintaining data on a computer is easier if a user knows how to employ Microsoft Excel, SQL and other various Internet functions. Discover how to use the Internet and computer software more effectively with tips from a software developer in this free video series on computer tips.
There are 33 videos in this series:
In order to create a Web site, use Microsoft Word to input information and save it as an HTML file. Create a simple Web site as a starting point with tips from a software developer in this free video on using the Internet.
The best place to follow the NFL on the Internet is on the National Football League's Web site, which provides scores, schedules and related stories. Follow the NFL online, and find information about specific teams, with tips from a software developer in this free video on using the Internet.
A smiley face is often used in e-mails to accent the way that the writer is feeling when they are typing. Make a basic smiley face for an email by typing a colon and then a closed parenthesis with tips from a software developer in this free video on using the Internet.
When using Internet Explorer, sounds, pictures and Web pages can be turned off by going to "Tools" and un-checking the aforementioned options under the "Multimedia" section. Turn off sounds and other multimedia before refreshing a Web page with tips from a software developer in this free video on using the Internet.
In order to password-protect a Web page, use javascript and start by opening up passpage.htm. Protect a Web site with passwords by running code with tips from a software developer in this free video on using the Internet.
After pulling up files on an FTP server, copy the files and paste them onto another FTP server in order to upload the files. Access FTP files in an FTP server with tips from a software developer in this free video on using FTP.
In Microsoft Excel, the paste special command allows the user to choose what features of a cell they want to paste. Copy and paste a value without pasting the formatting with tips from a software developer in this free video on using Microsoft Excel.
Use the pivot table wizard in Excel and select what ranges should be included in a pivot table. Discover how to use the Microsoft Excel pivot table wizard with tips from a software developer in this free video on using Microsoft Excel.
In order to create a "Find Duplicates" query in Microsoft Access, select a query as a new object and find the correct option. Do a "Find Duplicates" query and include the ID field with tips from a software developer in this free video on using Microsoft Access.
Redirecting users from one URL to another can be done in HTML code by using a value that says the URL is equal to a second page. Redirect users to another URL and customize the delay with tips from a software developer in this free video on using the Internet.
In order to merge workbooks in Microsoft Excel, the first workbook should be shared under the "Tools" menu by checking the box that allows for workbook merging. Merge two workbooks by clicking on "Compare and Merge Workbook" and following other tips from a software developer in this free video on using Microsoft Excel.
Comcast e-mail can be checked by going to comcast.net, signing in and clicking on the e-mail Inbox. Check Comcast e-mail, a client that is similar to many others, with tips from a software developer in this free video on using the Internet.
Craigslist can be searched by going to www.craigslist.org, selecting a specific area of interest or region, and entering text into the search bar. Search Craigslist for cars, jobs and more with tips from a software developer in this free video on using the Internet.
Microsoft Word can be used to design a Web site by inserting pictures, inserting hyperlinks and manipulating text. Design a Web site that is personally customized with tips from a software developer in this free video on using the Internet.
One way to increase Internet download speed is to disable add ons under "Tools," or by defragmenting the computer. Get rid of unnecessary items that inhibit download speed with tips from a software developer in this free video on using the Internet.
Microsoft Word can be used to start a Web site by inserting pictures, inserting hyperlinks and manipulating text. Start a Web site by using Microsoft Word with tips from a software developer in this free video on using the Internet.
When using Excel's VBA, or visual basic editor, create a code that runs when a worksheet is activated and use a do-while loop that has an end condition. Use a do-while loop in Excel VBA with tips from a software developer in this free video on using Microsoft Excel.
Use code to create an if-then statement in Excel VBA by using corresponding worksheet cells. Use an if-then statement in Excel VBA with tips from a software developer in this free video on using Microsoft Excel.
Excel's TTEST function is used for statistical analysis of data cells and comparing figures in spreadsheets. Use Excel's TTEST function to see how much a diet affected someone's weight with tips from a software developer in this free video on using Microsoft Excel.
Excel's TRIM function will clear off any spaces that are within a cell and surrounding the data on both sides. Use Excel's TRIM function to get rid of leading spaces of text with tips from a software developer in this free video on using Microsoft Excel.
Excel can be used to build a quoting system based upon the data that is entered into the program. Build a quoting system to do calculations in Microsoft Excel with tips from a software developer in this free video on using Microsoft Excel.
In order to display a PDF file in an HTML Web page, insert an iframe into the body of HTML code that is a PDF file. Create a link to a PDF file on a Web site with tips from a software developer in this free video on using the Internet.
E-mail can be sent from an HTML page by creating a hypertext reference link that is followed by the e-mail address. Use a regular text editor to send e-mail from an HTML page with tips from a software developer in this free video on using the Internet.
FTP can be used as a built-in program in Windows that has login information, and both downloadable and uploadable files. Upload files onto an FTP server with tips from a software developer in this free video on using FTP.
A database is used for storing large amounts of data, such as the addresses of every member of an organization. View data from a database in Microsoft Access with tips from a software developer in this free video on using Microsoft Access.
Computers are complex machines built upon very simple principles. They perform arithmetical operations millions of times over to transform digital information moving at lightning speed into usable human data. A personal computer's job is to help a user create, manipulate, deliver, receive or delete media content. This is a simple, sterile definition that sounds uninteresting on the surface. Nevertheless, these fundamental functions mimic human ability in some surprising ways. Therefore, the computer is increasingly becoming an engine of the imagination, a platform for the digital life. In this free video series, a software developer provides tips for using Microsoft Excel, SQL, and various functions of the Internet as well. Learn how to create a Web site, how to follow the NFL online and how to use smiley faces in an e-mail. Discover how to merge workbooks in Microsoft Excel, how to create a database in MySQL and how to use Microsoft SQL credentials. With these computer tips, accessing and managing data has never been easier.
Dave Andrews Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8 years, Andrews has an intimate understanding of computer technologies. He holds a degree in computer science from Middle Tennessee State University with a minor in mathematics. Andrews began working with computers when he was nine years old, programming BASIC on a Precomputer 2000. He now programs in C/C , Java, Microsoft .Net, ASP, Python and PHP and has written large, integrated program used by clients as large as state governments. Andrews is currently employed by a government IT department and enjoys the public service and constant challenge that such a position provides.dkdk
Read More
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
