In this software video tutorial you will learn how to create drop down menus in Excel using Data Validation. This example will show you how to display a list of parts in a drop down menu. Create the list of parts somewhere in your worksheet. Then in the cell underneath the one where you want to display the parts, go to the data validation window and enter the data. For this select the cell and then press 'Alt + D + L' to bring up the data validation box. Here you click on 'settings' and selec...
In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...
This video tutorial is in the Computers & Programming category where you will learn how to save multiple locations in Yelp. Yelp is great for finding businesses in your neighborhood. You can also search for something in other cities. You can enter the location in the 'near' box to search for something somewhere else. You can also save locations to easily search later. Click on 'account' and then on 'manage saved locations'. Here you click on 'add new location', type in the location name and t...
This video tutorial belongs to the software category which is going to show you how to add a watermark in Camtasia Studio. Open up Camtasia Studio and either import a video or open up a saved video to add a watermark. You got to edit your video and be ready to publish it because adding a watermark is the last step. Now click on 'produce video as' and the production wizard will come up. Here you can select a preset mode or create a custom one. Then you go to 'add / edit preset' and click on 'e...
This video tutorial is in the Computers & Programming category which will show you how to use the online discussion site Voice Thread. Voice thread enables you to create an online discussion with your students. In this video you will learn how to open an account, how to open a thread and how to post a comment on it. Go to the site. On the right hand top corner you will find a coffee cup. If you click on that, it will ask you for a username, password and email for opening an account. After you...
In order to insert a movie into a PowerPoint 2007 presentation, you will need to create a placeholder for the insert, in your presentation. Click on the media center. A window will pop up, which will allow you to open your movie. If you have already have your presentation, but you haven't left a placeholder, you can add your movie by going to the point where you want to add the movie, in your presentation. Then, click Insert. Go to Media Clips group. Choose an option from the drop down menu t...
In this video tutorial, viewers learn how to quickly burn ISO disc images in Windows 7. Users will not need to download any third party software. This task is very fast, easy and simple to do. Simply double-click on the ISO file to Open Windows Disc Image Burner. Then select your disc drive and click on Burn. Users may also right-click on the ISO file an select Burn disc image. This video will benefit those viewers who use a Windows 7 computer, and would like to learn how to easily burn ISO d...
In this video tutorial, viewers learn how to increase the rendering speed in Adobe Final Cut Pro. Begin by right-clicking on your current sequence and click on Settings. Click on the Video Processing tab and select "Always Render in RGB". Then click OK. This change will only be noticeable when working with really high quality high definition footage or film. Even then, you are able to re-render at a higher bit rate later, without having to affect the original image or export. This video will ...
In this video tutorial, viewers learn how to use the Sticky Keys feature in Microsoft Windows 7. To use the Sticky Keys, click on the Start menu and open Control Panel. In the Control Panel window, double-click on Ease of Access and click on Change how your keyboard works under the Ease of Access Center. Then click on Set up Stick Keys and check the option Turn on Sticky Keys. This video will benefit those viewers who have limited dexterity and find it difficult to use complex keyboard shortc...
In this video tutorial, viewers learn how to partition an external hard drive on a Mac computer. Begin by open Macintosh HD. Scroll down the list on the left and click on Applications. Double-click on Utilities and select Disk Utility. Under Volume Schemes, select 2 Partitions. Select the name of the partition and choose the format that you want for the drive. Select the second partition and do the same. Now click on Apply and click on Partition. This video will benefit those viewers who use ...
In this how-to video, you will learn how to make a rainbow in an image. First, open the program. Make a new layer and go to the gradient tool. Change the style to the one that looks like a rainbow. From here, change the sliders that you have the colors of the rainbow selected. Once this is done, slide the rest of the sliders near the last color, which should be red. Save the gradient and click okay. Now, go to the bottom left hand corner until a plus sign shows. Click and drag until you get t...
In this video tutorial, viewers learn how to make the System Restore feature use less space in Windows 7. Begin by clicking on the Start menu. Right-click on Computer and select Properties. Under Tasks, click on System protection. In the System Properties window, select the hard drive and click Configure. Under Disk Space Usage, drag the slider to the left for a lower amount. Then click on Apply and OK to confirm. This video will benefit those viewers who have a Windows 7 computer and would l...
First of all you have to go to Photobucket. In the search option you have to type in '3d gif''. Now click 'search'. You shall get a number of photos and you can select the image that has red color moving screen. It is better to get image this way without a virus. Now you have to right click on the image and save as '3d image animation wallpaper' and click save and then save it on your desktop. Now right click on your desktop and click on the properties. Now go to the desktop and then select ‘...
In this video tutorial, viewers learn how to uninstall the program on an Android phone. Begin by clicking on Settings and select Applications. Click on Manage applications. Now users will be revealed a list of all the applications that are installed on the phone. Simply scroll through the applications and select the unwanted application(s). Users will now see the information about the application, click on Uninstall. Now click OK and click OK again when the application is finished uninstallin...
This video shows you how to assign a letter to your USB flash drive (or memory stick) or how to change it in Windows.First of all, connect the flash drive in the computer's USB port. Click on the start button, then right click on My Computer and choose manage. Once the window opens, go to Disk Management. There, you should be able to see the USB drive as "USB DISK". Right click on it and choose "Change drive letter and paths...". Now click on change and select the desired letter for the drive...
In this how-to video, you will learn how to compress iMovie files into QuickTime files to make them look really good on YouTube. First, open iMovie. Click Share and click Share again. Go to Expert Settings and click on Share. Click on Options and go to Settings. Change it to h264, current frames per second, and every. Restrict should be set at 5000. Optimize it for DVD and change encoding to best quality. Change the size to NTSC 720X486. Check de-interlace video and hit okay. Change the sound...
In this video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...
Open your first image and go to the rectangular marquee tool and select all of the image. Next click command or control C to copy image. Then go to your second image and click command or control V to paste the image. Select both the layers (hold down shift when clicking the layer), then go to edit, auto align layers and choose the top option then click ok. Last add a mask to your top layer, this is done by selecting the gradient tool (make sure its set black to white, the mode is normal and o...
If you want to change your video information on YouTube, you need to go to your account page by clicking "Account" link on the homepage of the YouTube.
The video shows you how to link your hotmail account to your Mac. The person first asks you to open the mail and write down your full name, hotmail id and the password in the boxes given there. Then click on continue, and in the next option box, leave the account type as POP and then give a description as hotmail in the space provided. Then you have to type pop3. live.com in the box given for incoming mail server. Once done, click on continue and it will ask you for description of outgoing ma...
In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...
Yanik Chauvin shows viewers how to add a reflection using Photoshop. This tutorial focuses on how to do a reflection on a white background. You can do this with objects as well as people. Bring up your image with a white background to add the reflection to. First, you should press ctrl+j to add a second layer. In order to do a reflection, you need room, so you need to increase your canvas size. To do this click image, click canvas size, and click the bottom arrow so it can expand downward. Yo...
How to Make Anything demonstrates how to use Window Vista's snipping tool to make a screen capture. With previous operating systems, you'd have to install a third party application to make a screen capture. To find the snipping tool in Windows Vista, go to the start menu and type "snipping tool" into your search box. The snipping tool box will appear. Click on the options tab. In the next screen, tick display icon in the quick launch toolbar to enable the snipping tool in the toolbar. Click o...
In this video you will learn how to update your version of Windows 7 and how to check the system settings for automatic updates. In order to do this you need to go in the Start Menu and then in the Control Panel. Then you need to click System and Security. The next step is to click Windows Update. A new window will pop-up and you will see two types of updates: Important Updates and Optional Updates. To install them just click on the blue link and then check the boxes. To check for updates you...
Trevor4Ever595 shows us how to hack Hell Tour on Kongregate tours. First start the game by clicking 'New Game'. Complete the first level. Once you're on level two complete it as usual, and at level three you can start doing stuff. Open the cheat engine, click the process list, and click on your browser. Multiply your souls by 8 and put it into first scan. Go back to the game use some of your soul and then open cheat engine and multiply it by 8 again. Go down and click the frozen box on your c...
This video tutorial teaches how to find homegroup password in Windows 7. For this you should be using the computer which is part of the homegroup. The way to check this is by going to the control panel and clicking on network and internet link. In the ensuing window the network and sharing center link is clicked. This will show if the computer is connected to the home group. On confirming that the computer is connected to the homegroup, now navigate back to the network and internet link, and ...
Ever have the problem of people messing with your word documents? This guy shows you the solution by telling you how to create password protected encrypted word documents. The process starts with your open file. Clicking on save as... and in the popup window clicking the tools button in the bottom left corner and clicking general options. There it shows you text entry boxes, one for setting a password to open the file, another to set a password for rights to modify the file. Enter your passwo...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
First click the explore button, this will open a fold in which you will click homegroup and the second computer in the network. By clicking on that you will see what is in the homegroup. For example clicking on the video icon shows you all the videos available. If you right click on the video you can choose to watch it, open it, send it to different places, drag it onto your computer or copy and paste it into another directory.
This is a tutorial video on uploading HD quality video onto YouTube. The video is simply a screen shot view of the YouTube home page. As the narrator goes through the steps the cursor moves and clicks on what you should click on. He advises to click on upload; he clicks to choose a video. The video must have a certain resolution to be assigned HD video. He indicates that YouTube will accept a variety of file formats to upload. You must use the 44.1 kHz frequency rates to get the best resoluti...
Clear the cache and remove video updates and patches on your XBox 360. You can only do this offline! 1. Go to my XBox 2. Go to system settings 3. Click on memory You can do this on your memory card or to your hard drive, whichever one you want to clear. This demonstration is being done to the hard drive of the XBox 360. 4. Click "A" 5. Go to device 6.Go to hard drive and click on clear system cache 7. Click "A" 8. Click "Yes" to perform maintenance on XBox 360 storage device and continue.
Tired of being limited with your right-click options in Microsoft Windows? There's a program that could help you out, and it's called Right-Click Extender. Insert many different additional items to the right-click context menu.
In this video, the author shows how one can make one's own playlists on YouTube, and also get the code which can be embedded on one's website or blog. All one has to do' according to the author, is to first load all the videos which one wants in a playlist and pause them. Then one has to click the 'Playlists' option under the video pane. In the drop-down list which opens, one can choose one of the existing playlists or create a new one, and then, simply click the 'add' button. This action has...
In this video from Tiffany0x we learn how to change your profile background on youtube. First she goes to google, then clicks on images and type in whatever image you're looking for for your background. Then copy the image's link in your browser. Then go to youtube. Click My Account. Then you'll see Channel Settings. Click that, then click Channel design. In Advanced Customizations you'll see a place where you can put in a Background URL. Paste the URL into that box. Once you have done that, ...
Zooming in on your BlackBerry phone could be kind of tricky, especially if you're new to your BlackBerry device. Best Buy has answers. The Best Buy Mobile team explains how to zoom in and out on a Blackberry device when browsing the web.
Manage your windows in Linux. Learn about those minimize, maximize and close buttons on the windows. Check out this video tutorial on how to maximize windows horizontally or vertically on Ubuntu Linux.
Crochet has never been easier to learn. Make unique crocheted items with this free crochet instructional video series.
Sketching takes exercises and practice. Learn different sketching techniques to get started with this free drawing video series.
Clay pottery is a fun and creative art form that can be done with slabs of clay and not only on a spinning wheel. This free video clip series will show you several tips on how to construct a clay salt cellar and open a world of design ideas for you.
MySpace is an excellent resource for up and coming musicians. If you just can't do without that hot new jam, then it's time to rip your favorite song using Audacity media player. This video tutorial demonstrates the process of ripping MySpace songs in a few easy to follow steps:
