New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
Whether you are sharing an internet connection, working together or just playing group video games, you will need to network your computers. Check out this tutorial and learn just how easy it is to create a home network.
In this Software video tutorial you will learn how to make a book cover in Photoshop. Go to file -> new. Give it a name, set width 900, height 1200 and resolution 300 and click OK. You can change these settings if you like. Go to your paint bucket tool and paint the background black. Then go to layer -> new ->new layer -> OK. Now select the elliptical marquee tool and holding ‘shift’ drag from the top left hand corner and make a circle. Go to your paint bucket tool and paint the circle with a...
How To Make Anything demonstrates how to upload YouTube videos in high definition. To upload your video so the HD button becomes available to YouTube viewers, go into your video editor and set your project properties to 1280 x 720 which is the high definition resolution YouTube looks for to give you the HD option. Then, when you render your project, set your rendering parameters to a format like WMV and check to make sure that you're getting the HD image size upon output. Once your video is r...
Here is another video by a woman named Angela on how to make a miniature Christmas log cake for a dollhouse. The first thing she does is roll out a sheet of brown clay with a pasta maker on a setting of 4. Then she rolls out a white sheet with smaller setting of 6. Use a razor blade and cut some straight edges. She layers the brown and white layer and rolls them together. Cutting off the ends she has now created a log cake. Use these ends for slices of the cake for dolls. She then uses a pepp...
In this video from lkobet1 we learn how to curve a soccer ball. It is very useful for free kicks and set pieces. First you need to focus on getting a good position on the ball. Set up the ball on a really good piece of grass. Put your foot where you will land to kick it. Take a few steps back. Kick the ball with the side of your foot, not your instep. Come through the ball and across your body. That's the key to curving it. Coming through the ball when you kick with your leg will make the bal...
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...
This is a Video clip presentation from all3sports guides us on how to check and assemble the unpacked shipping box. The first step to assemble the motorcycle involves inserting the seat lifter to the reasonable depth and tighten the screws. After that attach the handle bars and front brake and make sure that there is an equal amount of gap between the top and bottom of the handle bars. Then, check the brake cables are properly fit. Then, assemble the arm gauge or arm rest with the two sets of...
dewalttv teaches you how to cut nested crown molding with a DEWALT miter saw. The advantage of this position is that it doesn't require a bevel angle. The bottom of the molding should be placed against the fence. To cut the right piece, set the miter to 45 degrees to the left and make the cut. To cut the other piece, the left one, set the miter angle to 45 degrees to the right and cut. You are done. This technique is useful when you don't want to worry about setting up a level cut.
This is a fantastic video, which guides us how to adjust auto play setting in our laptops. It shows systematic moving snapshot demonstration of the auto settings procedure of Windows 7. The speaker tells us to go to the start menu and then click on the control panel. Inside the Control Panel click on the Hardware and sound menu, which will open a new window, and then click on the Auto Play option? The window that opens now gives us several options to choose when we insert different types of d...
The video is about how to find the variance of the set of data. They found the variance by using the variance formula. Variance formula was represented by square of S, whereas S is the Standard Deviation.
This video is a tutorial on how to set the screensaver in Windows 7. To start, you need to click on the start menu. Next, click on control panel. Click on the personalization link in the first column. On the next screen, go to the bottom right and click on the box labeled 'screensaver'. It will open up a new window. From that window, you can click on the drop-down menu to select a variety of screensavers. You can see the preview of the screensaver in the animation above the buttons. You can a...
Bill D., the tech lead at all3sports.com takes us through the steps involved in unpacking and assembling a brand new bicycle. The first he says is to set up or insert the seat post. He recommends using a work stand if you have one at home. He says not to unpack everything at the beginning, but to just expose the seat pack first. Use a wire-cutter to get rid of the film protection used for packing. He has mounted the frame-set on the work stand. The seat post goes into the frame-set. He asks t...
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
Follow along as we are shown how to set a password for a new user in Windows 7. -First, go to the Start menu.
Have a passion for photography but know nothing about the basics? This video might be a great place to start on the topic of shutter speed. Shutter speed is the amount of time that the film, or your digital sensor, is exposed to the light. Whether it be outdoors, at night, or low indoor light, the shutter speed allows your camera to take a photograph with the correct amount of exposure in reference to how much light is readily available in your setting.
David Rivers is back to give us some more tricks on using MS Outlook 2010. In this video he tells us how you can avoid sending email to the wrong person by setting up some email preferences in MailTips. MailTips actually has the ability to alert you when you are about to send an email under certain conditions. Don't worry about sending an email to your boss that was meant for your co-worker. Your MailTips folder contains many options that you can use to restrict some of your outgoing mail and...
This is a video tutorial showing you how to make animated letters in the program Macromedia Flash. It shows you how to open up a text box and then separate the letters and add them into an animation sequence. Then it shows you how to set up the animation by setting the letters in different places in the time-line. The outcome is that your letters become animated into a word. This video is helpful for people who want to use animated letters in flash.
This video describes how to wrap text around an image in Wordpress. The video starts with an example describing the technique, showing a video left justified with text flowing around the right side of the image and then vice-versa. He then goes into the Wordpress editor and inserts an image into a new post. After the image has been inserted into the post, the video shows how to set the image alignment to the left. Once this setting is complete the text will then wrap around your image.
Learn how to set up an Epson printer wirelessly when you bring your new printer home you will want to start by installing the software that came with the new printer. You can set up your printer to work without wires and it will print from all over the house. There are 3 ways to set up the printer including the Epson way, with cables, and WPS. To determine is you need to use WPS, which is more complex, check your router to see if it has a sticker on it that says Wi-Fi Protected Setup. If that...
This how-to video is about how to check and set the tire pressure in the car. The first and foremost thing we need to consider while setting the right pressure in the car tire is looking for the proper inflation pressure for both front and rear tires. We can find the manufacturers specification for tire inflation near the driver side door, where the tire pressure for both the front and rear tires will be mentioned, take a correct look at the tire pressures. In this video the tire pressure req...
Dougsimmsonline shows how to determine whether or not 2 triangles are similar. Not only does he go on to show that they are but he describes step by step how to do the math to find missing angles. He does this process twice to show one set of triangles being similar and show the other set of triangles as not being similar. Doug is using a large computer touch screen as his drawing board to show you how this process is done.
In this video, Tom Leese, Director of Instruction at Angel Park Golf Club, gives pointers for your pre-shot routine in golf. Important in the transition from the practice range to real games, your pre-shot routine helps you get situated and ready to play real competitive golf. Tom explains, first, how to set your lines, taking a straight and purposeful line down course where you want your ball to go, and remaining fixed on it, as you approach your tee. Then, when positioned at your ball, he t...
In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...
Don't know how to create the night vision effect using Photoshop? Well, this video is the solution for you. First of all, select the image that you want to create the effect on. Then you need to open up a new black and white adjustment layer. In the setting box that pops up, go under the preset drop down box and select red filter. Next, go down and check the tint box. After wards, the viewers can set their own photo and saturation base on their own preference.
In this Photoshop tutorial the instructor shows how to create a glossy sphere. Now to get started open the tool and select the oval tool. Using the oval tool create a sphere shape. Draw holding the shift key button and set it to green color. Now similarly draw ellipse and give it white color. Create a few more ellipses this way. Now go to filers and then glowers and then Gaussian glower. Now go to shape free and select gradient and set the gradient. Now you can apply color changes to it and g...
This video is about shooting a sunset photograph.
Managing screen real estate can be a chore on any operating system. In this video, learn how to set up a split-screen display for your machine running Windows Vista.
Bejeweled Blitz is a Facebook game. Learn how to hack Bejeweled Blitz with tricks, cheats, hacks. Watch this video tutorial to learn how to cheat on facebook's Bejeweled Blitz (07/27/09).
d-CON is here to help identify and remedy rodent problems in your bedroom. Watch this video tutorial on how to use d-CON Ultra Set Traps to kill mice in the bedroom. Signs of a mouse in the bedroom include droppings, footprints, gnawing, rubmarks, unusual pet activities, strange sounds, and burrows or nests.
See how to escape from a set of professional handcuffs. If you ever get arrested, see how you can get out of those handcuffs with just a bobby pin. It's a pretty easy trick, you just need to modify the bobby pin a bit and you're almost there. The police will never be able to hold you down, but this is actually more for a magic show, like magicians perform.
This instructional video offers a description and overview of how to set up your own FM broadcast station. Operating from 88 MHz to 108 MHz. It describes how a FM transmitter works and how to make one. It presents a simple di-pole radio antenna for FM broadcasting and how to make one. And finally it explains how with theses two components one can set up their own station from anywhere. The video was made by Seth Gadsden in collaboration with Stephen Dunifer and Free Radio Berkeley.
It's time to pick a few locks, but with what? Check out this video tutorial to see how to make a cheap lock pick set from saw blades. You can make any lock pick you want with saw blades, a little grinding, a little more grinding, and yes... grind, with a few finishing touches.
This shows how to make a ladder golf set. You need PVC pipe and a saw to cut it. You will also need connector pieces. This Instructables video is a fun outdoor game. Make golf ball bolas using golf balls and nylon rope. Drill through the balls to make the bolas. You throw the bolas underhand at the ladder.
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how you can set up the American Audio TT-Record Turntable. This is a Belt Drive turntable that can record your vinyl with a press of a button. All you need to do is plug in your memory stick and off you go. This unit does not need to be used as a direct drive sin...
Jerome Basillio shows the gogoplata set up reaper in this how-to jiu-jitsu video. Learn some new skills or just practice your jiu jitsu skills. Follow along with this video martial arts tutorial and learn how to do a jiu jitsu gogoplata choke reaper move.
Cosmo Crow and Mark Hannah take you on a tour of the Sony DSR cameras in these how-to videos. The first video segment deals more with setting up the camera tripod. Then, Mark and Cosmo continue their tour of the Sony Camera with an in depth explanation of the Lens and all its functions. Finish up with the final installment, which will teach you how to operate the switches on the main body of the Sony Camera. Watch this video tutorial and learn how to set up and use the Sony Camera.
The spy camera shown in this how-to video has a 60 foot cable, and is full color and has audio. This spy cam can be used as a security device, or to feed paranoid delusions or stalking urges. Watch this video tutorial and learn how to set up an X10 spy camera.
In this video tutorial dedicated to the Google's Gmail, you'll learn how to set up Gmail to retrieve mail from a second email account. This tutorial also looks at how to set up labels and filters, and explains the Gmail Archive function and Gmail Conversations. Become an advanced Gmail user with this video tutorial!
New to the Ubuntu Linux distribution? Ubuntu has a great built-in email client in Evolution. This video tutorial will walk you through the Evolution setup process, using the Evolution Setup Wizard. To get started setting up your own Evolution client, watch this Ubuntu tutorial!
