In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...
In this tutorial, we learn how to create links between tasks in MS Project 2007. First, select the task you want to link, then click on the link task button on the toolbar. You will now see a finished task link between these tasks. In the entry table, you will see the predecessor, which is task two. You can also type the numbers in the predecessor column and enter the information in. You may want to create a link that is different, so you don't confuse two things that will start at the same t...
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
In this tutorial, we learn how to lock and unlock cells in Excel. First, right click one cell and click on format cells. Go to the protection cell, and then un-check the locked category. Click ok, then go to protect sheet, inside of tools. Now, do now allow locked cells to be checked. Now, you will not be able to select cells in the worksheet except cells that are unlocked. This is a great way to protect your information, so it won't accidentally get deleted or ruined. You can do this for ent...
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
In this C4D user's guide, learn how to ctrl-drag axes to bypass the object axis tool; how to change a group axis with several selected items; how to set a light to negative values to make darker areas; and how to undo camera (view) moves by choosing "shift-command-Z." Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more i...
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 this video tutorial, viewers learn how to print the gridlines with a Microsoft Excel spreadsheet. This task is very fast, easy and simple to do. By default, Microsoft Excel will not print a spreadsheet with the gridlines. Begin by clicking on the Page Layout tab. In the Sheet Options box, under gridlines, check Print. To remove the gridlines, do the reverse of this operation. To view the page with gridlines, click on the Office button, go to Print and select Print Preview. This video will ...
In this video tutorial, viewers learn how to play DVD movies on the computer for free. Usually, users will need to purchase expensive codes or plug-ins for a media player in order to play a DVD movie. This video introduces the VLC Media Player. This media player is able to play any DVD movie and is a free program. To download it, open your the Google website. Then search for the media player and select the first result. Then click on Download and install the program. This video will benefit h...
In this tutorial, we learn how to backup your computer to an external hard drive. All you need to do this is an external hard drive. After you connect your external hard drive to your computer, go to "my computer", then double click "external hard drive", then "setup file". Once you click on this, a setup wizard to install the program will show up, go through the steps to finish the installation. Once finished, a new window will show up, go through the different tabs to see what each has in i...
This video tutorial is in the Software category which will show you how to insert or delete a comment in MS Word 2007. This video shows how to insert both text and audio comments in to your word document. Click on the 'review' tab on top, highlight a part of the text that you want add comment to and click on 'new comment' tab. Then you can insert the comment in the comment box. You can continue adding comments throughout the document in the same way. You can view the comments by selecting 'ne...
In this video tutorial, viewers learn how to insert or delete footnotes or end-notes in Microsoft Word 2007. A footnote is a little reference which will place a small number in subscript and link it to a comment. A end-note is similar except it links the comment to the end of the document, rather than the end of the page. Begin by highlighting the text. Then click on the Reference tab and select Insert Footnote/End-note. Then just add a comment to the subscript. This video will benefit those ...
Forget dogs - tripods are a man's best friend (well, if he's a photographer). Eliminating many of the factors that create crappy photos, including the instability of holding the camera up by hand, photo blurs, and general strain of weilding those hulking digital SLRs, tripods are always there to lend a helping leg. Or three.
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 create a tilt shift effect with Adobe Final Cut Studio. Begin by changing the video's speed to 300% and disable the Frame Blending. Now click on Effects, go to Video Filters, press on Time and select Strobe. Change the Strobe rate to 7-15 fps. Now switch to Motion and Duplicate the group. Then create a simple mask in the upper group and apply defocus to the lower group. Under Mask, increase the Feather rate up to 100%. Now add another mask around t...
Check out this tutorial for a cool magic trick that you can easily perform for your friends. All this trick requires is a little preparation and you will be wowing crowds in the bar in no time.
The drawing tools in flash aren't always the most intuitive to newcomers. In this tutorial, Ralf will show you how to use the basic drawing tools in flash. You learn the difference between Merge Shapes and Drawn Objects, which are all shapes of the same look and feel with the exception that one can be more easily manipulated and the other. You'll learn how to use this selection and sub selection tools to select various objects on the flash stage. You also see how to use the oval and rectangle...
In this how to video, you will learn how to dual boot Windows 7. To do this, first back up your hard drive. Download the Microsoft Windows 7 adviser to see if your system is able to handle the operating system. Next, download and burn the Windows 7 64 bit ISO. Shrink your existing partition to at least 16 GB. Next, insert the Windows 7 CD and reboot. You should make sure that you can boot from the optical drive. Once that is done, you can begin installation of the operating system. When it is...
In this video tutorial, viewers learn how to transfer songs from an iPod device to a Windows or Mac computer. Begin by going to this link. Download Pod to Mac or Pod to PC, depending on your computer. Then install the program and open it. Plug your iPod device into your computer and select the song(s) that you would like to transfer. Users have the choice to transfer to the Desktop or directly into iTunes.
In this video tutorial, viewers learn how to break up large files to easily send through email. Go to the website: and search "winrar". Download the program. Then double-click the file and follow the instructions to install it. Now right-click the file and select Add to Archive. Users will have an option to split the files into volume bytes. Then press OK wait for the program to compress the file into several parts. This video will benefit those viewers who...
In this Electronics video tutorial you will learn how to Email photos from your iPhone. This is really very easy and simple to do and takes practically no time. On your iPhone go to the camera icon and tap on it. Then find a picture that you want to email. Then tap on the little icon on the lower left of the screen as shown in the video and then select email photo. Then you put in you want to send the photo to, type in a subject and add some text if you want. And the final step is to tap ‘s...
Learn how to adjust the mouse cursor size on a Macintosh computer, so that it is easier to see and locate. The cursor can be adjusted to your liking by accessing the "Universal Access" preferences window and then by selecting the "Mouse & Trackpad" option. Near the bottom of the control panel, you will be able to find a slidable bar that can adjust the cursor size to be smaller or larger, as needed. This option can help make the mouse cursor easier to see against a difficult desktop backgroun...
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 use the Filter Key features on a Windows 7 computer. Begin by opening Control Panel and select Ease of Access. Under the Ease of Access Center, click on Change how your keyboard works and click on Set up Filter Keys, at the bottom of the window. Now check the box beside Turn on Filter Keys. Users are provided with several options for he Filter Keys such as: turn off the Filter key wen Shift is held or 8 seconds, display a warning message when turni...
This video tells us the method to remove Trojan Virus from the computer. This can be done in a couple of steps. The first step involves the downloading of a specific application from the web. We have to search this application in Google. Type 'malwarebytes' in the search engine and press enter. Go to the third result starting with 'Malwarebytes Anti-Malware'. Click on 'Download Now' on the resulting page. Open the application and select 'Perform quick scan'. This will scan the computer for Tr...
In this video tutorial, viewers learn how to do a lanyard twisted triangle stitch. Users will need 3 pieces of gimp with the same length. Take all 3 strings and tie a knot at the end. Now separate all 3 strands from each other and select one of the strands to be the top strand. Put the top strand over the second strand and bring the second strand over the third strand. Now run the third strand through the loop of the first strand. Pull on all 3 strands to make the stitch and repeat for the re...
In your computer you can setup up two monitors on the same screen. This is the dual monitor setup which will give you more space to work with. So if your desktop is cluttered with icons and other program shortcuts, then you can use dual monitors. To setup a dual monitor system, the first thing you will need is two monitors. Now right click no your desktop and select properties from the menu. In the properties window go to the settings tab. If you see two monitor screen pictures over there the...
In this Computers & Programming video tutorial you will learn how to create a virtual machine for free using the virtual box in Mac. Open the virtual box and click on new. Click next, put in a name for the virtual machine and click next. In the next window, it gives a recommended memory, increase it slightly with the slider and click next. Click next in the subsequent 4 windows that come up and finally click ‘finish’ and click ‘finish’ again on the next window. In the next window click CD/DVD...
In this tutorial, Malou and Bob show tips and tricks to use an HP TouchSmart computer. First, you can touch the house button that will lead you to the home page. The computer is so sensitive, it will detect your touch without even having to touch the screen. When you select an object, press and hold it if you want to move it somewhere else, if you move it to the bottom on your homepage it will go into the designated area. If you press and hold your finger on the screen, it's just like right c...
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
In this Computers & Programming video tutorial you will learn how to hide and lock folders in Windows. When you want a private folder that you don’t want any one else to open and see. You will need this feature. For this open a new folder. Open the folder, right click on it and go to ‘customize’. Then select ‘change icon, click on a blank icon, click OK and ‘apply. Now you will see that your folder icon on the desk top will disappear; only the name will be visible. Now rename it with a small ...
This video provides tips to make great photo slideshows. Many people have found photo slideshows are a great way of celebrating memorable occasions, commemorate milestones or reminisce. First, choose your photo images carefully. Filter out irrelevant or blurry photos. Try using a photo editing program to improve your photos. Next, choose a theme for your slideshow. Then select transitions, being cautious to limit your use of transitions. Consider your use of intervals in the slideshow. Also, ...
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Changing the color of your eyes is very quick using Photoshop and this handy video. After using the selection tool of your choice to outline the eye (this video uses the pen tool) with a little bit of feathering, just change the hue of the eye. The video shows how to do this by pressing control + h, however it can also be selected by choosing the image menu, then adjustments, then hue/saturation. This great effect can be used as shown on close up eyes or on smaller eyes further away. Both way...
Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...
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...
How to pick the right RAM for your computer
In this video tutorial, viewers learn how to control which games can be played with Net Nanny. Begin by opening the program and select Manage Games under Games. Users will have 3 options on how to block or allowing the games. Users can block by the ratings, games or descriptions. For the ratings, simply drag the slider to which ESRB you want to be allowed. For the games, simply go through the list and click on the game that you want to block. For the description, by checking the content that ...
In this video tutorial, viewers learn how to change the lock pattern on an Android phone. The lock pattern allows minimum security on the phone to prevent other people from tampering with your mobile files. Begin by going into the Settings and click on Location & security. Under Screen unlock pattern, select Change unlock pattern. In order to change the unlock pattern, users will have to type in the current unlock pattern. Now type in the new unlock pattern and press Continue. Then retype the...
This video tutorial from butterscotch presents how to change file associations on your computer.File association is a link between a certain type of file (.doc, .gif, .txt) with a particular program.For example text files are by default associated with Notepad application.So if you double-click text file it will be automatically opened in this program.In case you want to open this file in a different type of program, you need to change the file association.To do that, right click the file, th...
