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, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...
If you want to draw full body manga characters you need to make sure you know how to draw legs. First you should draw hid lines in a box and then connect legs. Make sure you have a gap for the legs and that the legs as even. Draw two circles for the buttocks and then draw legs coming down with a space in between them. Make sure you draw circles to distinguish the ankle and the knee joint. Measure out the leg to make sure the knee to hip and knee to ankle are approximately even. If you want to...
This how to video will teach you how to perform the push pull technique on drums. If you want to throw a double, you can start with a single and get an accent on the double for an inverted double. Just push and grab really quick. For a double, use a controlled rebound. For the inverted double, start with a single and dig out the second stroke of the double. A french grip is useful for performing this technique. This is good for ghostings and shuffles. For shuffles, you can use a controlled re...
Mac OSX offers an easy solution to increasing the contrast of your display, and switching the screen from black on white to white on black. In the Universal Access section of System Preferences, under the large "Display" label, you will find a set of controls. Switching from black on white to white on black will invert the colors on the screen, making it easier to read for some people. There is a toggle to the right of that control which switches your display from color to grayscale. Below th...
In this video, we learn how to control flies around your home with Rick Steinel. The common house fly can be found everywhere in the house and are full of disgusting germs. We can now make a type of liquid that attracts flies and kills them. These are safe for humans so it won't hurt your home or you. This liquid can also be placed inside of a container which will collect the flies outside, before they have a chance to enter your home. They are also very easy to install and it's very easy ins...
To open the Windows Task Manager the long way
This video illustrate us how to control dog fleas with home remedies. Here are the following steps.Step 1: First of all take some water and wash the dog with it.Step 2: Now take markotic powder and spread it on the dogs fur. If the fur hair is long then comb in the opposite direction for the powder to settle down. Leave it for some time.Step 3: You will find all the fleas on the surface of the fur.Step 4: Now dip a towel in water containing alum and sponge the dog with this towel .All the fle...
Remote desktop is a windows feature which can be used to access a windows computer from an other windows computer over the internet. Note that to access a windows computer using remote desktop the computer must run on Windows Professional or Ultimate version. Remote desktop does not work if the remote computer runs on Windows basic home version. However you can remote from a computer that runs on home version of windows. Another requirement is that the two computers must be connected over an ...
Televisions are an amazing innovation that allow for endless hours of entertainment and information dissemination, but sometimes you just want them off! Make a TV remote jammer as a joke, to get a few hours of quite or just for fun.
This is a Computers & Programming video tutorial where you will learn how to enable or disable the UAC option on your computer. UAC stands for User Account Control and this tutorial is for Windows Vista. With UAC enabled you are more secure. First, click ‘Start’, type in ‘msconfig’ and click on ‘Tools’. Here you scroll down and select ‘Enable UAC’ or ‘Disable UAC’ and click ‘Launch’. You will need to reboot your PC for the change to take effect. An alternate method is to go to Control Panel, ...
This involves a golf tip in how to draw a ball. He is on a golf course and is explaining that a draw is different then a hook. He explains that when you draw the ball you don't change the swing you change the way you align your feet. To make the proper draw is to simply drop the right foot back which causes the person to get behind the ball so the ball can be released down the line. A draw can be controlled, he reminds us, because it only falls to the left. A hook cannot be controlled because...
To quickly disable the UAC option on Windows Vista operating system on a computer first go to the control panel on your computer. Then go to user accounts, next click on turn user account on or off and you will be prompted to type in your password. Type in your password and press enter. Then uncheck the box that says use UAC to help protect your computer. Then click the okay button to finish. You can now exit out of the control panel and go back to your desktop. The UAC on your computer shoul...
This is a tutorial to get XBox live without paying $100 for the router. You need an Ethernet cable and a laptop or computer with a wireless internet connection. To begin, go to the start menu and click on control panel. Change the control panel view to classic view. Then click on network connections and go to your wireless connection under the heading 'LAN or High Speed Internet'. Right click on the wireless connection icon and select properties. In the properties window, go on to the advance...
In this video tutorial, viewers learn how learn about the Nikon SB-400. The Nikon SB-400 is consumer grade speedlight that is designed for a consumer DSLR (D40/D60). It also has a lot of limitations that prevent you from having the full control of the speedlight such as, no ability to rotate the flash head for better bouncing performance and no rear controls with a big LCD. It only has a rear on/off switch, flash ready lamp and lock switch. This video will benefit those viewers who are intere...
This video shows the viewer how to disable User Account Control within either Windows 7 or Windows Vista. This is done by clicking on the start menu and then type ‘Microsoft config’ into the search box. This opens the ‘system configuration’ menu. Select the ‘tools’ section. For Windows Vista there is simply an option to disable User Account Control. For Windows 7 click on the ‘change UAC settings’ option before clicking launch. In Windows 7 the slider should be dragged to the bottom. Both met...
In this Software video tutorial you will learn how to embed a YouTube video in PowerPoint with or without Internet. You will see two ways of doing this with and without internet access. When you have an internet connection, open up PowerPoint and click on the office circle button on the left hand corner. From there select ‘PowerPoint options’ and check the box that says ‘show developer tabs in the ribbon’ and click OK. Once the developer tab is in your ribbon, select that and go to the area t...
This video contains instructions about how to disable or enable the user accounts on Windows Vista. It is very simple; just go to control panel -> user accounts and safety -> user accounts. You can click the check box on or off to disable or enable the user accounts. This can also be done by using command line. Open run and type the following command:
In this video you will learn how to mod your Xbox 360 so that it will have rapid fire. He notes that the control he uses is a TP3 controller, you can tell if you have a TP3 controller by opening up you battery pack and on the bottom left on the micro chip it says TP3. He doesn't know if this tutorial will work for any other controllers. The materials you will need are a mini flat head screwdriver and a wire with two ends (as well as the controller of course). Then you take apart your control ...
Fatloss LifeStyle shows you the best way to "blast those hammys!" Using a bench and a weight is all you need to shape and sculpt your legs to perfection. First, lay down on your stomach on a bench and position your ankles around a free weight. Make sure that you do not use a weight that is too heavy. Start light and build from there. Now using your hamstrings lift up the weight that is between your ankles slowly and controlled so that your body is level. Then slowly and controlled bring the w...
This video was made to help users with disabilities use Windows XP more efficiently in their lives. Starting with entering the control panel the and clicking on the accessibility options the user will have an array of options to help customize their settings to their needs. The demonstrator showed that sticky keys are for those who have a difficult time holding down buttons at once for functions. The filter key eliminates double strokes for certain keys so you would need to hold down a key to...
This is another video in the helpvids series of technology videos. The video describes how to set power options in Microsoft Windows XP. These options control when the monitor is turned off, when the computer goes to sleep, and when the computer will go into a hibernation state. Laptops will have more options than desktop computers since there are battery options on a laptop. Click on the Start Menu and then Control Panel, then Power Options. The first screen offers the option to turn off you...
In this video Dr. Schultz will show you how to control extreme underarm sweating. If you suffer from extreme underarm sweating, despite regular use of antiperspirants, follow these steps: Make an appointment with your doctor so that they can give you a prescription for a topical antiperspirant called Drysol. This liquid is applied once a week, at bedtime, and is covered with cling wrap. After a few weeks you will see a significant reduction in the amount of underarm perspiration you experienc...
Learn how to find out whether your girlfriend is using you or she really loves you in simple steps. First remember that you can control only yourself and you cannot control the actions of other people. In this case your girlfriend must not still be ready for a longer steady relationship. If she is not allowing you to stay with every now and then, you can stop staying with her totally. Suppose she is suffering from any depression be there for her but don't stay with her whenever she asks to. S...
Watch as iblogtutorials teaches you how to speed up your Windows XP and Vista shutdown times. To speed up your Windows shutdown time, do the following: Go to Start and select Run. Type in "regedit". Click the triangle next to "HKEY_LOCAL_MACHINE" and then click "SYSTEM" current control set. Click the Control folder. Wait to kill service timeout. Change the Value data to 0.2 seconds. Restart your computer and from now on your shutdown time will be much faster.
This quick video produced by Toyota USA is a guide to using the Multi Terrain Selector in the 2010 4Runner. The multi terrain select control is designed for off road use. It features for driver selected modes to regulate wheel spin for off road situations. To use the multi-terrain select control, first the vehicle must be stopped with the transmission in neutral. Next, press the On/Off button to turn the selector On, then rotate the mode switch to one of the four available modes. Using this s...
In this video from solvingtime we learn how to remove objects from photos using Paint. To get this program go to to install it. He uses the clone stamp tool to remove things. First he zooms in on the object he wants to remove using the magnifying glass. Then click the stamp which will switch to the clone stamp tool. Use the bracket keys near the letter P on the keyboard to adjust brush size. Then while holding the control key click once on an area near the object you wa...
Learn how to control music playback in Firefox by using FoxyTunes on Firefox, an add-on for the Firefox browser. It works with almost any media player, even online media players like Pandora. It runs in your status bar, allowing you to skip tracks, see info, etc. You can set it to update your Facebook or Twitter accounts with your currently playing track. It can even use your song as part of your email signature. This video is very helpful to someone wanting to not have to switch programs whe...
This video tutorial shows the proper way to operate the controls for the moon roof in a 2010 Toyota 4Runner. They demonstrated how to open and close the moon roof by using the slide button. When you want to open the moon roof push the slide button backward and to close it you need to push it forward. Also if you just want to tilt the moon roof, first make sure the cover is open, then use the up and down buttons to operate the tilt.
This video tutorial shows you some of the benefits of the SmartKey on the 2010 Toyota 4Runner. This key can be used as just like the standard version, using the remote controls to lock and unlock the car. This key also provides keyless entry; if you have the key in your possession and approach the car it will unlock the doors for you. You can also use this key to open and shut the rear window. The SmartKey brings a bit of innovation to the once standard remote control key.
This is a great instructional video on how to sing better by controlling your amp. Some secret tips for your singing voice are given in this video. You can try them on a "trouble section" of your favorite song and check how fast you improve! Jill Jaxx, teacher and performer, teaches you the voice culture so easily that you can improve your singing at once. She tells you how to make quick fixes for your voice and learn to sing better fast.
British record producer David Spoon explains how he uses the computer program Propellerhead Reason 4 to create rhythm and bass tracks in his home music studio. He explains that by just messing around with the controls within the program, you can create a lot of interesting sounds and effects. Sometimes the best sounds are discovered by accident. He uses Filter 2 to create interesting effects that he describes as "acid-y" or "nasty", having to do with the resonance of the bass sound. He also a...
This video will show you how to change your time from military time to the 12 hour time scale on a Window's computer. After being infected by a virus or if you accidentally changed the time on your computer, you can easily change the time display on your computer screen back by following the easy steps in this video. You will first have to go to the Start bar and find the Control Panel. From the Control Panel, find Regional and Language Settings and choose to customize your regional settings....
Brazilian Jiu Jitsu black belt Octavio Couto Jr. is a real pro when it comes to fighting. He is going to be teaching you how to properly keep an opponent pinned down to the ground for a substantial amount of time. In this seminar, Octavio demonstrates a unique side control position known as the 100 kilo and a few other great moves to use in order to help you gain complete control over the person you are fighting. If you don't know what the 100 kilo is or how to do it, just follow this video a...
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
ClearTechInfo live up to their by offering clear and concise information on how to manage user account settings in the new OS from Microsoft, Windows 7. Begin by pressing the start button and going into the control panel. In here look for 'user accounts and family safety', open it. Now go into user accounts and then manage another account. If you are the administrator then you can change whichever setting you want for whichever account but if you're just a standard user you can only alter you...
Bed Bug control for luggage is the best way to protect your luggage from infestation. What you will do is, open your luggage and any zippers you may have on your luggage and spray it down the best you can. You will want to spray the seams and any closed area inside and outside you luggage. You should also spray down your handle and wheels (if available). Bed bug control will keep the germs from different hotels or any where you travel, so that it doesn’t follow you back home.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to build a web-enable remote controlled tank.
The human body contains nine units of blood—but in matters of a traumatic cut or injury, it's always better to be safe than sorry. If you're unsure whether you're in an emergency situation, get to an emergency room and let them decide.
Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer. By creating a new website, this video tutorial will demonstrate the new ListView control in Visual Studio 2008. Because the ListView is data driven, you will need a data sou...
