This video takes us through a process of inserting Macros from internet into a excel workbook. Two shortcuts Alt-F11 and Alt-F8 is used. Alt F-11 is used to open the visual basic window and Alt-F8 is used to open macro lists window that opens all macros. These shortcuts work in most versions of Excel.The steps followed:1. Go to internet explorer and the site selected is Teach Excel and in the home page you have to select free macros, you will come to page of macros.2. You can simply select th...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
In this video tutorial, viewers learn how to import media from devices in Corel Video Studio. Begin by connecting your mobile device to the computer. It can be any device with a memory card or hard drive. Open the program and click on the Capture tab. Click on the option, Import from Mobile Device and select the device that you want. Select the file(s) that you wish to import and click OK. The program will then import the media to your selection window. This video will benefit those viewers w...
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...
Wartex8 demonstrates how to use remote desktop in Windows XP. Remote Desktop is a useful utility that you can use to control another computer and its applications.The necessary steps that are adopted to activate remote desktop are:1) Right click on my computer icon (either the icon on the desktop or the one on the start menu list) and select properties, and a new dialog box called system properties will pop up on the window.2) In the System Properties, select the computer name tab and write d...
This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...
Miis are tiny versions of you that live inside your video games. On the Nintendo Wii you can personalize all of your games and add a little bit of your personality and appearance to the screen. Check out this video tutorial, and learn how to create a Mini Mii on your console for gameplay.
Is your Outlook inbox starting to seem overwhelming? No problem! In just a few minutes you can corral that growing pile of e-mail by using the 'archive' feature. Have a look at this video and learn how to use this handy option and clean up the mess in your inbox.
This is a Computers & Programming video tutorial where you will learn how to remove annoying spyware on your PC in Windows XP. Some spyware can be really nasty. This video shows how to remove spyware for free. Go to Download.com, and search for ‘ad aware’, download and install it. This video recommends Ad-Aware. While installing, select safe mode of scanning, otherwise some spyware may not be detected. Then, you need to update the definitions. Keep the definitions updated regularly. After upd...
The video shows you how to connect the Nintendo Wii to an available wireless network. First, you have to turn the Wii on. When the menu screen appears, you then click on the "Wii button" in the bottom-left corner. Next, go to "Wii Settings". On the following screen, you have to use the blue arrow on the right to go to the second page of options and select "Internet". Go to "Connection Settings" and click on an "Open Connection". From here, go to "Select Wireless Connection" and then "Search f...
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
In this video the tutor demonstrates the magnifier tool of Microsoft Windows 7. If the size of text is very small on your screen and you are facing difficulty reading it you can use the magnifier tool to resize the text to read it clearly. You can change the resolution but this makes the LCD screen look blurry. So to do this go to the Start Menu and select the Magnifier tool. Now there are two buttons with minus and plus symbol on them. Click the plus button to magnify the screen around that ...
TrueCrypt is a free application that lets you encrypt designated programs on your Ubuntu system to prevent unwanted access. Provided you select a strong password, intruders will not be able to open your personal files and documents. This instructional video walks you through the process of installing TrueCrypt on your Ubuntu operated machine and demonstrates an example on how to create an encrypted volume within a select partition.
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...
In this video tutorial, viewers learn how to unlock a locked iPod. Begin by connecting the iPod to your computer. It should fix itself automatically. If it doesn't press the Start button and select Control Panel. Click on Appearance and Personalization. Under Folder Options, select Show hidden files and folders. Check the box that says "Show hidden files and folders". Click Apply and then OK. Go to My Computer and open the iPod device. Select the Controls folder and click on Device. Delete th...
Follow along as we are shown how to change the power settings for our monitor for Windows 7. -Begin by going to the Start menu and clicking on the Control Panel.
Go to the Menu and click the Start button. Now select Control Panel. In the Control Panel, you can see the Option Programs. Now you can see Uninstall Programs in small letters below the Programs option. Click on Uninstall Programs. Here you can see the list of programs installed, when they were installed, what is the size of the program, and which version of program is installed. To uninstall a program, simply click on the program you wish to uninstall. Some options get displayed above the ta...
In this video you will learn how to insert the current time and date in MS Word 2007. In order to do that, just follow these easy and quick steps and instructions. The first thing you need to do is to click the Insert tab. Now, you need to select a space where your date and time will be placed. The next step is to click the Date & Time button, and select the format that you want. Click the OK button, and you are done. If you followed the simple steps correctly, then you won't have any problem...
This video shows how to delete a user account on Windows 7. Go to the start menu, the control panel, then user accounts. Click add or remove user accounts. Select the account you want to remove. Choose the option to delete the selected account. Windows will ask if you want to delete everything on the account or keep the information on your desktop while still deleting the account. This will be your choice. The narrator chooses to delete the full account.
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
This video tutorial will teach you how to troubleshoot a HomeGroup network in Windows 7. In order to do this follow these steps: Go to the Start Menu and then go into Control Panel. Now go to Network and Internet and then in Network and Sharing Center. Now click the Troubleshoot Problems link located on the bottom of the window. Here you can select which part of networking you want to troubleshoot, in this case select HomeGroup. A process will start and you will have to answer the questions t...
Let FiveSprockets help you get rid of the green screen effect in your videos and add great backgrounds to your movies at home! By using the Final Cut Pro program, follow along as you set your green screen clip in the display. From there you select the Effects, then Video Filter and follow it down into the Key menu. Grab the eyedropper and select the green color and make it fade away with just a few simple clicks. You can crop out any areas that didn't fade away, or use the softening tool to f...
In this video the instructor shows how to format tables in Microsoft Word 2007. To know how to format tables in Word, you will first have to know how to create them. This video assumes that you already know how to create tables. When you click inside a table in Word, a new tab label, Table Tools, appears above the Design tab in the tool bar. In the Design tab there are a lot of options available that can change the look of your table with just a click. To the extreme left there are three chec...
The video shows users how to change the boot sequence in a computer with an older AMI (American Megatrends, Inc.) BIOS to boot from the CD/DVD drive. This is required, for instance, if you need to reinstall an operating system, or fix a corrupted windows installation by running Windows Setup from the installation CD. Users should first enter the BIOS setup by pressing the delete key when prompted shortly after powering the computer on. Once the Bios Setup screen has loaded, users may navigate...
Trevor4Ever595 teaches you how to hack the game Space Attack using Cheat Engine. You start the game, select a level and pause it using P. Open up Cheat Engine, open the process list, select Firefox or whatever internet browser you are using. Then you will want to use the search box to search for the amount of money you have in the game. A lot of values will come up to the left of the search box. Go back to the game, earn more money and then search for that new amount. Cheat Engine will only r...
To scratch on a pioneer CDJ turntable, first select the sound you are going to use. Observe the position of the black line on the turntable in relation to the sound you've selected. Understand how much room you have to manipulate the sound and position your fingers accordingly. The platter will move in accordance to the black line and your finger. You can also lift your hand off the platter in the play and pause mode to let the sound move itself by its own accord and at its own speed. Move yo...
Learn how to add a new background to an image using Gimp. 1 Open the original image and the new background in Gimp. 2 Open the layers dialog and then click on add an alpha channel. 3 On the original image choose 'Select by color' from the menu and then hit delete. 4 Copy the image. 5 On the new background, select 'Add a layer'. 6 Paste on the new background. 7 Save and you are ready to go.
This video teaches the secrets of burning a CD from a playlist in iTunes in simple steps. First open the iTunes, click 'File' and select 'new playlist'. Now click 'music' and go to your library to select the songs to add to your playlist. Now click and drag the songs of your wish to your playlist. Insert the empty disc, right-click on your playlist and select 'burn to disc'. Change the options if necessary, click 'burn' and then press 'OK' to start burning your disc.
Toyota USA provides this quick video guide to show you how to use the windshield wipers in the 2010 Prius. If you want to control the wipers and washers, take the following steps: To operate the wipers, move the right hand stalk up for a single wipe, or move it down to activate the intermittent setting. Move the stalk down one more position to select a slow and constant wiper mode. One more down pull selects the fast wiper mode. Pulling the entire stalk towards you will activate the windshiel...
Chef Allen Susser first tells us about many different kinds of mangos and that he uses them often in his cooking. He then demonstrates how to select a mango, and then properly cuts it. Learn tips such as signs when a mango is ripe and how to choose the right one, as well as various methods of cutting and preparing mangos for cooking. You will learn how to slice or dice a mango in just seconds with a few excellent techniques. Cutting and preparing mangos for cooking is easy after watching this...
Open Xara 3D. Hit show or hide cursor. Type the name JRR Tolkien. Open Animation Options. Set to swing 2. 4 frames per cycle. 1 frame per second. No pause. Angle 0. Select the second "R" and change the animation. Flip the "R" around so it is a mirror image. Go from frame one to frame two. Select the "J". Move the line spacing down to the middle. This yields the JRR Tolkien logo in Xara 3d. You can also flip around the logo using the view menu.
In this video tutorial the author shows how to stretch objects and text in flash. To do this open the flash tool and select the radial gradient. Pressing shift key draws a shape. Go to frame 30 and create a key frame by pressing F6. Now similarly do it at frame 15. Now at frame 15 select the free transform tool and stretch the image. Now create the shape twins in the locations shown in the video. Repeat the same process for a text starting with adding some text to the scene. Finally convert i...
Tasktutorial will teach you how to create a nice vector cartoon flower using Adobe Illustrator. Start by selecting Rounded Rectangle Tool, and draw a black rectangle. Then select multiple points and move it according to the video, using arrow keys. Then draw an ellipse with the Ellipse Tool, using the Shift key. Watch the video to see the remaining easy steps in creating a vector flower using Adobe Illustrator and also get some cool tips and recommendations for best results.
If you are looking to improve your Photoshop skills by learning how to digital paint in it, this video shows you how to do it. To do this, open a new Photoshop canvas and select your brush to paint with. In this example the author shows how to paint a pear for demonstration purposes. You start by drawing a rough sketch, just using your paint brush and reference an image of a pear that you find in this tutorial. Now do the dark textured work on the non lighting side as shown in the video. Now ...
This tutorial video, from tasktutorial demonstrates how to create animation using the motion guide function in Flash. You will learn how to create an object, in this case, a ball, and create an animation that makes it appear to bounce. The guide shows you, how to add a motion guide by selecting a key frame and drawing it in. Then you will learn how to snap the object to your guide line, and add motion to it by selecting another key frame between the first and last frames, and snapping the obj...
The video is about how an old stalled photographic image with faded backgrounds to a normal image. A nice clean digital image is taken and is mixed with a texture of a paper and produces a final composite image of all effects combined. The procedure is not that difficult but it needs to be followed in a proper order. First the paper texture is taken as a base and then the clean digital image is dragged onto this texture. The blending mode is adjusted from normal to multiplied blending mode, w...
This video tutorial by tasktutorial shows you how to create stylish text in Photoshop. Launch Photoshop and select the type tool and choose myriad-pro font light. Create a text field and type in the text as indicated. Increase the font size and location as desired. Thereafter open the layer options, choose a gradient and create a new gradient by selecting the color as required. Apply a white color outer glow change the size, range and opacity. If you want to add more text create a new layer a...
In this flash tutorial the instructor shows how to make a black and white mask animation. To do this, first start by importing your image into the flash tool and bring it on to the scene. The image should be wider than the scene. Now select and distribute the layers. Now convert those images into movie clips. Now go to frame 80 and add all frames. Get back to the first layer and create a shape that is the your mask. Now go to frame 40, select key layer and add free transform tool. Now, mask t...
Learn how to use the Web Capture and Compare Documents commands in Acrobat 9 Pro with this tutorial selected by experts at Adobe. You can use this command to compare the differences between two versions of a web page. First, you have to convert the pages to PDF files using the built-in Convert-to-PDF command in Acrobat 9. Then, select the Compare Document command from the Document menu, choosing the settings. The program will run through the two files, compare them and present the results in ...
