In this software video tutorial you will learn how to merge and unmerge cells in Excel. A cell in an Excel spread sheet is assigned a row and a column number. You will mostly need to merge cells when you are trying to create headers that span across two or more cells. For this select the cells that you want to merge by clicking and holding down the left mouse key on the first cell and then dragging it across the other cells that you want to merge. Then go to the 'home' tab, click on 'alignmen...
In this tutorial, we learn how to remove a scar in Photoshop. First, select the magnifying glass to zoom in on the area you are working on. Next, select the paperclip icon, the select the second brush. Now, come to the edge of the scar and drag across the around the entire scar. Come back around, then the scar will be highlighted. Now click down and hold the image highlighted, and you can smooth out the skin and it will disappear. Next, do this on the other side of the face to remove the rest...
In this Software video tutorial you will learn how to convert a Word DOC to a PDF eBook for free. Go to the website PrimoPDF and click on download free link. Then download and install the program. Now open up the word doc that you want to convert to PDF and select the print option. Under the name of the printer you will find PrimoPDF option. Select this option and click OK. The PrimoPDF dialog box will open up. Here you select the ebook option and the location where you want to save the ebook...
This video tutorial belongs to the software category which is going to show you how to convert an mp3 to WAV format in iTunes. Go to file menu and click 'add file to library'. Grab your mp3 file that you want to convert by double clicking on it. This will automatically add to the iTunes library. In the library click on 'music' and find the file that you just added. Now click on edit > preferences > general > import settings. Now in the 'import settings' dialog box, select 'WAV encoder' under ...
In this video tutorial, viewers learn how to add video transitions to a video in Pinnacle Studio. This task is very easy, simple and fast to do. Begin by imputing the video clips into the time-line. Then click on the Transitions tab and select a transition. Once selected, simply drag the transition in between two video clips. There are many transitions to select from. Users are able to preview each transition by clicking on it and pressing the Play button. This video will benefit those viewer...
In this video tutorial, viewers learn how to a horizontal line in Microsoft Office 2007. Begin by clicking on the Page Layout tab and select Page Borders. Then click on Horizontal Line. Scroll through the list and select a type of horizontal line. When finished, click on OK. Users are able to drag the horizontal line around by holding down the left button on the mouse and moving it. When users highlight the line, right-click on it and select Format Horizontal Line. There users will be able to...
In this Software video tutorial you will learn how to combine documents into a single PDF in Adobe Acrobat 9. Go to the 'combine' menu and select 'merge files in to a single PDF'. Click on 'add files' and 'add folders'. Now create a new folder and click OK. Then drag and drop files in to the folder. You can then arrange them in the order you want. You can also delete any document that you don't want. You can also choose pages from a document. With all the documents selected, you can go ahead ...
In this video tutorial, viewers learn how to create a new standard user and administrator account. Begin by clicking on the Start menu and select Control Panel. Then click on User Accounts and Family Safety and click on User Accounts. Now select the "Manage another account" option and click on "Create a new account". Users are able to name the account and select the account type (Standard or Administrator). Finish by clicking on Create Account. Users are then able to make changes to the accou...
You may not have realized it, but picking the right cookware for your cooktop can be a big help. Not only can it result in things being cooked faster, but it will also result in less damage for your tools.
In this software video tutorial you will learn how to create a pdf document using Microsoft Word. First you select the document you want to convert to pdf, click on file and select print. When the print window opens up, on the left had bottom, you will see the pdf button. Click on it and a dropdown menu comes up. Select 'save as pdf' from the dropdown menu, give the file a name and click 'save'. Exit the word program and you will see the pdf document on the desktop. You can now open it to see...
In this video tutorial, viewers learn how to rip a DVD with the program, Handbrake. Begin by opening the video in the program by clicking on Source and locating the DVD drive. Handbrake will start scanning the all the titles of the DVD. When finished, it will automatically select the correct title for the movie. Under Destination, click on Browse to select your saving destination. You are also able to change the name of the file. Now select the video format and aspect ratio. When finished, cl...
In this next maintenance tutorial, you'll be finding out two things on how to improve the performance of your car. One is how to check the car's tire pressure. During a time where gas is expensive, tire pressure can help you save money and time at the pump. It's easy to do and can be checked in a matter of minutes. The other bit of information is more of a question. Which is better for tires? Nitrogen or oxygen. You may be surprised by the answer. So check out the tutorial above on how to che...
Doing proper maintenance on your car is important for making sure that your car will last for years. There's a bunch of different areas of where you can work, but in this tutorial, you'll find out how to check the antifreeze coolant using a multimeter. So check it out, good luck, and remember to always be safe. Enjoy!
You have an iPhone now… but how do you add your email, so you can stay connected to everyone wherever you go? Setting up your email accounts always seem trick, but not on this device. Want to know how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up your email on the Apple iPhone.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 35th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate the service charge for a checking account and see how to create a formula for the balance in a checkbook or checking register.
This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
The first step is to select a photo of a black, glossy car. Using the Lasso- polygonal tool, select the outline of the car. Once the image outline is complete, the dots animate around the image. The next step is to deselect the areas on the car where the chrome paint is not required. To do this, follow the same procedure as above holding the ‘Alt’ key (a minus sign appears next to the cursor). Once the selections are done, go to ‘Image’ menu, select ‘Adjustments’ and click on ‘B...
In this video tutorial, viewers learn how to add a watermark to an image using Adobe Photoshop. Begin by importing the image into the program. Select the Horizontal Type Mask Tool under the Text tool. Then select the font color, type and size. Now type in the text and click out of it when finished. Then press the Control and J key to open the text into a layer. Click on the layer and select the style. Now finish by editing and customizing the text. This video will benefit those viewers who ha...
If you want to run multiple windows operating systems at the same time you first need a Windows computer, the installation disk for the operating system you want to run, and Windows Virtual PC 2007. To install this, first type in Virtual PC 2007 to Google, go to the Microsoft link and download and install the program. Now, open the Virtual PC and click next on the wizard. Name your hard disk and click next until you choose where you want this at. Now your virtual hard drive is created. Now, p...
This how to video will show you how to remove blemishes and do other touch ups in Photoshop. First, open the image you want to touch up in the program. Now, choose the polygon tool and select the background of the image. Now, go to adjustments and change the brightness and contrast. You can also add a blur in the filters. Use the smudge tool to touch up any errors from using the blur filter. To fix blemishes, use the patch tool. Select the area you want to fix and drag it to an area of simila...
In this how to video, you will learn how to set up Outlook Express for Gmail. This is useful if you want to use the program to access your email. First, log in to your Gmail account and go to settings. Next, go to Forwarding and Pop and select Enable Pop for all Mail. Save this and then go to Forwarding and Pop. From here, select Outlook Express. Click Run the Auto-configuration Tool. From here, you must save a file and open it. Once it is open, type in your account information. Press configu...
This video tutorial from easycomputercoach shows how to easily attach pictures to email addresses. In Windows XP you can send pictures resizing them in the process, in case you have large file sizes.
Robert demonstrates how to use Photoshop to give yourself a tan. First, you need to upload your picture(s) into Photoshop. Then pick one to work on. Next, you will need to copy the background to save the original image. On the right side drag the background label to the new layer icon (you can just hit control J). You will then need to select a paintbrush tool. Go up to the tool bar and click on the paintbrush settings to set the hardness at 80%. The master diameter will be adjusted as you wo...
In this video, we learn how to create a picture frame on a photo using PhotoShop. First, open up the program and open the picture that you want to change. Next, select the rectangular marquee tool from the toolbar on the side. Now, create a selection of what you want to frame. Then, click with the right key and select "inverse". Click again with the right key and choose "layer via copy". Now, click 2 times on the layer to open and the layer style menu will show up. Now put the contour to crea...
In this video tutorial, viewers learn how to open ports on a Windows XP computer. Begin by clicking on the Start menu and open Control Panel. Double-click on Network Connections and select your network connection. Right-click on it and select Properties. Click on the Advanced tab and click on Settings. Select the Advanced tab again. Click on your internet connection and click on Settings. Click Add and fill in the port information. Click OK. T forward a port, users need to go to their router'...
1. Describes how to setup a VPN connection on Windows XP. 2. Goto Start-> Control Panel-> Network connections.
My Blackberry TV demonstrates how to protect your Blackberry device with a password. Protecting your Blackberry with a password will help to stop people from accessing your personal information on your device. From the home screen, press the Blackberry menu key. Then, select the options choice. Next, scroll down to the password choice on the options menu. Select password and then select the set password button on the password screen. Enter your desired password and then press the enter key. V...
In this video tutorial, viewers learn how to import and render footage in Adobe Final Cut Pro. To import files, begin by going to File, select Import and click on Files. Then browse for the file and click Open. Now drag the clips into the time line to edit. To render the footage, begin by selecting it. Then click on Sequence, select Render Selection and click on Both. This video also shows viewers how to cut a clip and add effects. This video will benefit those viewers who are just beginning ...
In this video tutorial, viewers learn how to create a 3D sphere and reflection in Adobe Illustrator. Begin by using the ellipse tool and create a circle. Select the black and white gradient, and drag the colors that you want into the gradient panel. Now hold the Alt key and draw a smaller circle inside. Fill it with white/transparent gradient. Select the sphere and go to Object/Group. Now go to Effect/Distort and Transform/Transform. Tick the Preview and Reflect Y, insert 1 copies box and sel...
In this video, we learn how to use PhotoShop to change hair color.. First, select the mask tool inside PhotoShop. Now, zoom in on your picture and brush the hair that you want to change the color of. Zooming in and using smaller or bigger brushes will help you be more precise. After this, zoom out and press on the mask tool to create your selection. Then, select the marquee tool and right click and choose "inverse selects". Now, click on "image", "regulations", then "tonality/saturation". Now...
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
In this video tutorial, viewers learn how to create a photo-montage using Adobe Photoshop. Begin by inserting the images into the program. Then double-click on the montage image to unlock it and select the eraser tool to remove the background. Once the background is removed, select the move tool and move the montage image to the background. To modify the dimensions, go to Edit and select Free Transformation. Hold the Shift key to maintain the proportions. This video will benefit those viewers...
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
Make your video look like a Hollywood film in 3 simple steps
In this Software video tutorial you will learn how to make a copyright brush using Photoshop. Open up Photoshop and open a new document by clicking ctrl+N. Create a new text layer on the right side and type in your text. Right click on the text layer > rasterize type. On the left side select the ‘rectangular marqee tool’ and draw a rectangle around the text. Go to edit > define brush preset. In the next box, give it a name and click OK. Then go to file > open and select a picture on which...
This how to video shows you how to setup a meeting using Microsoft Outlook. First, open the program. From here, click on calendar. Next, go to the upper left corner and select new. On the subject line, type in the subject of the meeting. In the body, type in what the meeting is about. Go to scheduling and go to the left and select invite attendees. From here, select the address book and search for people by their last names. Select who is optional and who is required. Click okay. You will see...
In this video, we learn how to change the color of dark hair in PhotoShop. First you will want to open up PhotoShop and open up the picture you want to change, zooming in so you can see the hair up close. Next, open up the mask tool, then use the brush to color the hair. This will only highlight the hair to change the color in the future. Use different sized brushes when you need to. Once you've done this, click on the mask tool to create the selection. Now, select the marquee tool and click ...
River City Graphix Tutorials demonstrates how to make a reflection in Photoshop. First, fill the background layer with black. Then, select the text tool and a color of your choosing. Type the words that you would like to reflect. Next, duplicate the layer to make a copy of the layer. Hold shift and bring it down, setting it on the bottom of the other layer. Select the rectangular marquee tool, right click to get the free transform tool. Right click again and then flip the image vertically. Se...
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 302nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX & MRAND functions to randomly select names without repeats.
