Display Local Search Results

How To: Look up & retrieve a row of data from a table in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.

How To: Hack into a compuuter, the easiest way

In this Computers & Programming video tutorial you will learn how to hack into a compuuter, the easiest way. Go to start > run, type in ‘cmd’ > OK. To find the IP address of a website, type in ‘tracert myspace.com’. This example is to find IP address of myspace.com. Then all the IP addresses of the website will be displayed. If you want to shut down a computer, now you type in ‘shutdown’. A remote shutdown dialog box will open up where you put in the IP address. That’s all. The ...

How To: Send a bulk email using Gmail

In this Computers & Programming video tutorial you will learn how to send a bulk email using Gmail. Go to www.download3000.com , search for ‘smartserialmail, download and install it. Open it up and create a profile by giving it a name, fill in the email address you are going to send messages from, your display name and the reply email address. In the last box type in ‘smtp.gmail.com’. Then click on advanced settings, type 465 for the port number, check the first and the third boxes, typ...

How To: Create a static FBML page for your Facebook fan page

This videos is a tutorial for using custom FBML coding on facebook fan page.The video begins by logging into facebook account.Then go to the search bar at the upper right hand corner and tpe "static fbml" and hit enter.This takes to the application page and click on "add to my page" below the default fbml picture.A window opens up showing a list of user pages and after selecting the page click on "add to page".Close the window and go to your fan page and click on "edit page".This shows a list...

How To: Reformat your hard drive to install Windows XP

In this Computers & Programming video tutorial you will learn how to reformat your hard drive to install Windows XP. You will need a copy of window XP. Insert the CD in to your CD drive. Restart your computer and the command prompt will show. Press any key to boot from the windows XP set up CD. The set up screen will be displayed. Click enter and agree to all the terms. Then select the driver on which you want to put the XP and click enter. Then select the NTFS file system and not the ‘quic...

How To: Do the black and red cared trick

In this Magic & Parlor Tricks video tutorial you will see how to do the black and red cared trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. It displays a deck of cards, which the presenter says is a normal deck of playing cards containing 52 cards. He then shows the other side of the deck where the cards all mixed up. He shuffles the deck a few times and shows that the black and the red cards are all mixed. Then he shuffles one more time, puts the dec...

How To: Make a wire wrap ring

When it comes to displaying your own sense of style, there are so many different options to choose from. You can focus on the hair, hands, whole body, or even your toes. Either way, you can customize and create any stlye you can by easily choosing which jewelry to wear or how to wear your hair style. This video tutorial will help give you another great option to help achieve that personalized look. Find out how to make awire wrap ring easily. Enjoy!

How To: Make a decorative mini magnet board

In this tutorial, Bonnie shows you how to make a super fun new craft project for use in your home or dorm room. For this video, Bonnie makes a super cute little bulletin board with a twist. This board is magnetic! No need for push pins, now you can simply display messages and important papers with magnets and avoid all the holes.

How To: Set up POP3 settings for Outlook 2003/Outlook Express

POP3 stands for Post Office Protocol, a way in which you receive mail on the internet, paralleling how mail is received in your mailbox. To set up your POP3 for Outlook, go to tools, click “view or change existing e-mail accounts’ and press next. You’ll be able to see a list of your current email accounts that you can change or remove. When you select an email and press change, you’ll be able to see the account in detail: the email address, the POP3 and SMTP server information, and th...

How To: Manipulate text within animated GIFs in Photoshop CS4

This video describes how to use Adobe Photoshop CS4 software to create and manipulate text in animated .GIFs. GIF stands for Graphic Interchange Format, a type of image file which allows short animated sequences to be displayed. A preselected scene from a television show is opened as a GIF in Photoshop CS4. Animation window is opened by selecting window then animation. The text tool is selected and a textbox is drawn by clicking and dragging. Photoshop CS4 then applies the text to the frames ...

How To: Announce alerts with OS X's Text to Speech feature

In this video tutorial, viewers learn how to announce alerts on a Mac OS X computer. To do this, open the Speech preferences and click on the Text of Speech tab. There, users are able to set up the computer to announce when alerts are displayed and announce when an application required your attention. Users are able to set additional options by clicking on Set Alert Options. Users are able to select a different voice, phrase and delay time. To preview the option, click on Play. This video wil...

How To: Do about face card trick

In this Magic & Parlor Tricks video tutorial you will learn how to do about face card trick. This video doesn’t teach you how to do the trick. It merely shows you the trick. The presenter displays a deck of cards and counts the 52 cards. He then splits the deck in to two and puts one-half face up and other face down. The deck is now shuffled twice so that some cards are face up and some are face down. He then takes out any card that is face up, which is the jack of clubs and slides it back ...

How To: Display time over or under a hurdle in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.

How To: Choose the right set for your web show

This video shows the method to select the right set for your web show. The video tells us what a set is and its importance in the show. A set is a place for shooting your own show. The set should be designed carefully and properly. A typical set should be bright with various colors. It should not look depressing like a blank wall. Make a set which will look fine on camera. There should be an element of fun in the set. The set should be made to grab the attention of the viewers. The design of ...

How To: Create a .gif animation from video

In this how-to video, you will learn how to make a .gif animation from video footage. First, open Photoshop, click file and select import video frames to layers. Next, select the video you want to use and open it. Once this is done, you will see the amount of frames in the videos as layers in the video. Go to window and animation to open a new display for the animation. If you want to shrink the .gif image size, go to edit and image. Change the size to your liking. Now, just go to file and se...

How To: Put an iPhone or iPod Touch into DFU Recovery Mode

Here's how to enter recovery mode on your iPhone or iPod touch the easy way. No need to press the sleep button and the home button at the same time for x amount of seconds, just turn your device off, if the device is frozen and can't be turned off normally just hold the above buttons until it turns off, now press and hold the home button and plug the device in. Do not let go of the home button until you see a screen in which the connector cable is displayed and there is an arrow pointing from...

How To: Create multiple backups when doing a iPhone restore

This video shows the method to make multiple backups while restoring a iPhone. See ' iPhone and iPod touch : About Backups' on your iPhone. Scroll to the bottom and see the location of the backup. You can rename the backup folder so that the device thinks there is no backup and starts creating a new one. You can also go to info.plist file and change the display name. You can add the date to the name to tell the difference. Go to iTunes and right click on iPhone. Choose restore from backup. Yo...

How To: Fix a PS3 Black Screen of Death

In this Video Games video tutorial you will learn how to fix a PS3 Black Screen of Death. For this you got to put the PS3 into stand by mode. Press down the button located at the top end of the console for 7-10 seconds and listen for 3 beeps. Repeat this step again. Then this message is flashed on the TV screen – ‘connect the controller using a USB cable etc’. Once you connect the USB cable, the trouble shooter prompt comes up displaying 6 options. You can use the 6 options to troubleshoot yo...

How To: Show vendor names associated with a low bid in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.

How To: Make a Christmas table centerpiece from an antler

Danielle Proud shows you how to make a beautiful Christmas table centerpiece for your Christmas dinner! Your guests will be amazed at how incredible your table looks. This amazing display catches light and looks simply magical. All you need is an old pair of deer or elk antlers, some sticky-backed crystals, and a little time and creativity! First, take your antlers and sand them until they are smooth and the color you like. Then, take different sized crystals, even different colors if you pre...

How To: Build a LEGO computer monitor

This video describes how to make a model or representative figure of a computer monitor using LEGO blocks. The process only requires six distinct types of LEGO blocks. One of each of the six types of LEGO blocks is used in the construction of a LEGO computer monitor. The author names, describes, and visually displays each different LEGO block necessary for completing this project. The author begins to construct the LEGO computer monitor out of the aforementioned LEGO types. The author shows t...

How To: Get your suspended YouTube account back

Falsely suspended on YouTube? Get you account back within a month. When your account is suspended on YouTube, all your videos will still be intact. Search "reopen account" without quotes in YouTube. Open the first video that is displayed. The video will show you link to contact YouTube. To get things straight, visit the link as stated in the video. You will get an email from YouTube explaining your penalties which are usually copyright claims. Click on each penalty and you'll be given a set o...

How To: Use a TI89 calculator to graph linear equations

This video shows the user how to use a T189 calculator to plot linear equations. The video demonstration is done using an ‘on screen’ representation of the calculator – there are also verbal instructions. The equations are plotted on the same axis by selecting the ‘y=’ function. The corresponding values of y in terms of x are then inputted into the graphical calculator. Once this has been done for every equation you can get the calculator to display the graph. This then allows you to compare ...

How To: Access websites that might be blocked by your school

This video describes how to access websites that may be blocked by your school. To begin, on the desktop go to the Start menu and select Run. Type in "cmd" and hit okay to open the command prompt. If that doesn't work go to Start, My Computer, C drive, Documents and Settings, Default User (or the name of the user), Start Menu, Programs, Accessories, and finally click Command Prompt. From the command prompt enter "ping" and then a space followed by the website. The website entered will display...

How To: Use Peter Answers website to mess with friends

In this video tutorial, viewers learn how to use the Peter Answers - Virtual Tarot website. Peter Answers is a fake fortune telling website that is usually used as a prank. Begin by going to the website. In the Petition space, type in a period. A "P" will be displayed. Then type in the answer too the question and press the space bar until it spells "Peter, please answer the following question:". Then type in the question in the bottom space. This video will benefit those viewers who enjoy pla...

How To: Apply accounting & percentage formatting in Excel

This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...

How To: Tie an ascot for a preppy look

This video shows the viewer how to tie a scarf in an ‘Ascot’. Allegedly this is a preppy look and should appeal to young people. The knot is tied by placing the scarf around your neck, one of the lengths should be slightly longer than the other. Wrap the longer length three times around the shorter one before taking it behind the shorter length and pulling it over the ‘knot’. This end is usually the spread out to display the pattern of the scarf. It is suggested that this look is unisex and t...

How To: Get more color in the garden

Danny Lipford shows how to grow a more colorful flower garden in early spring when there is not a lot of overall growth. He displays how he plants tulips and daffodils in the fall so that they bloom in the spring. He digs a troth about 6 feet long and 6 inches deep. After sprinkling bulb food in the troth, Lipford plants the tulip and daffodil bulbs, arranging them so each uniquely appears every other bulb. Lipford's assistant advises that he re-plants the tulips every year, since while they ...

How To: Startup configure a Mac

This is a Computers & Programming video tutorial where you will learn how to startup configure a Mac. This is a very simple, easy and quick process. In order to change what programs start when you switch on your computer that is running on Mac, first go to ‘System Preferences’ from the drop down menu and then click on System Accounts. In the next box that pops up, go to ‘Login Items’. Here a list of programs will be displayed that run when you start up your computer. Here you check box next t...

How To: Back up and restore your iPhone or iPod Touch

Learn how to back up and restore your iPhone or iPod touch contacts free without being jail-broken. Download and install iDrive lite from the link ibackup. Launch the application and sign up for the service and log on. Tap the back up button and a status bar will appear showing the progress. after the backing up is done, log in to the service and see whether the back up is successful. You can also download and install Cyntact from the link smart-mobile] to di...

How To: Block and remove friends in Facebook

This is a tutorial segment on how to remove or block friends in Facebook. It's easy and simple. Follow these simple steps. Firstly, open the homepage of Facebook. Then go to the settings on the upper right side. Then click on “Privacy Settings.” Then type the names of your friends to be blocked in the “person” field or type the email in the “email” field and click “block.” A list of your friends will be displayed then. Choose the names of your friends to be blocked or removed from the list an...

How To: Get passed blocked sites using proxy servers

This video shows the method of getting past blocked sites and opening them using proxy servers. The method shown is useful when the sites are blocked using another site. In this case it is 'www.lightspeedsystems.com'. It can be done using proxy servers. In the case shown it is 'treesniff.com'. The URL is typed and we choose the option of 'Continue to this website'. Press 'No' for the security information. After this the page of the proxy server is displayed. Type the name of the website you w...

How To: Evaluate functions on a calculator TI-89

In this how-to video the person gives a detailed evaluation of the functions of the ti-89 calculator. The video is a short but informative look at the Ti-89 calculator. During the video the person shows a difficult math problem and shows how to use the Ti-89 calculator to solve that problem. The video uses some of the functions on the calculator and shows a display of where the buttons are located on the calculator. It also shows how to properly use the calculator to solve the problem while w...

How To: Design a candle centerpiece for your table at home

In this video, The Flowergod demonstrates designing a candle centerpiece for a table at home. The video includes a time-lapse (6 times speed) demonstration of Flowergod actually creating a centerpiece, and lighting the candle afterwards. In this way, you can see how quickly (The video is less than a minute long at 6x speed, so just over 5 minutes) he arranges this centerpiece, as well as how it looks when it is finished. At the end of a video, a website is displayed where you can go to see fu...

How To: Use Outlook Express in Windows XP

In this video, the instructor shows how to use Outlook Express in Windows XP. This software comes bundled with Microsoft Windows XP, which is a part of Microsoft Office package. Outlook is an e-mail client that allows you to view your e-mails on your computer without the help of any web interface to your mail host. To use Outlook Express, you need to configure it first. Open the Outlook Express program. Outlook will then take you through a wizard to help you to configure your email host. Ente...