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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
Working out your core is important in sports.
Create three-dimensional objects in 3d-making software, Blender with help from this video tutorial. Learn the basics of how to get started making these animations with step-by-step instructions from this Blender expert.
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
Have you ever had the urge to create your own Podcast to share with your friends and family? In this video, learn how to not only create a Podcast, but how to upload it onto iTunes for download. This process is actually quite easy... and even easier with the help of this video!
Love4Nails starts off with pink, silver, and black nail polish. First choose one of your colors to create a French tip manicure. She next takes the silver polish, starts at the bottom and creates a swirl around the nail. Swerve the silver in a way that it covers the French tip part of the nail. Then get the pink glitter and apply only on pink polished area. Place black rhinestones on the swirled area of the nail. Because you're using the pink glitter polish, if you choose not to add rhineston...
In this how-to video, you will learn how to quickly make a Windows 7 boot disk. This is essential for making backups or booting from something other than the operating system on your hard drive. First, go to the control panel and click the back up your computer option under system and security. Next, go to the left and click create a system repair disk. Put a blank DVD in to the optical drive. Select your drive and press create disk. This video shows just how quick and easy it is to make a bo...
The instructor talks about a technique called white knuckles. White knuckles means creating tension with your hands. You'll squeeze the bar as hard as you can to create tension, and you'll see white knuckles. To learn how to do this take a jump stretch band and wrap it around your wrists. Now you'll have to spread your hands out and hold the bar as hard as you can so that your hands don't slip on the bar. This will also teach you to pull your hands apart to engage the last. Lie on the bench w...
Facebook is a wonderful website where you can connect and keep up to date with your friends. Facebook has some useful features like chat. Facebook chat can be used to chat in live with your online friends. The chat also supports smileys. Using different character combination you can create different smileys. To create the happy smiley type :). To create sad smiley use :(. Use :P to show a funny smiley. These are the basic smileys. There are many more smileys present like the one showing teeth...
To throw a clay pottery fruit bowl, place a lump of clay on the potter's wheel and wet it with water. Use the foot pedals to spin the wheel while shaping the clay with your hands. Draw the clay up and then use your thumbs to create an indentation in the center of the clay. Apply slight pressure and the clay should assume a bowl form. Use water as necessary to create the right clay consistency. Draw the clay up to make the bowl walls thin. While shaping the bowl walls with one hand, create a r...
Love4Nails teaches how to paint your nails using green polish. Start by using a lighter color. In this case, she uses white. She then side swipes the nail using dark green. Start from a corner at the bottom of your nail and using a swirling motion paint to the top. Next, she uses nail art polish in black to outline the side of her nail that's been painted in green. Creating a "V" she outlines the other side of the nail. She then uses a gold striper polish inside the "V." Use dotting paper and...
Jennifer a licensed cosmetologist demonstrates how to create a loose beach style bohemian hairdo. Jennifer starts by explaining how to part the hair in the front of the head. She does this to then show viewers how to create a French braid as many celebrities like Anne Hathaway, Jennifer Aniston and Molly Sims have been spotted wearing. She demonstrates how to zig zag the part by using a rat tail comb to place in the middle of the part and make a zig zag motion to create the look. Jennifer als...
Fimo expert Corinne Bradd and Emma Ward with The Crafts Channel and magazine Craft Beautiful demonstrate how to create a striped cane in 5 minutes. To create the stripes, cut out rectangles of black and white clay and stack them in alternating colors. Then, roll out a cane in a nice, bright color so that it matches the length of the stacked clay rectangle. Then, cut the rectangle into slices. Then, press the rectangle stripes onto the bright cane so that it completely wraps the cane. Squeeze ...
In this Computers & Programming video tutorial you will learn how to track Google's trends features. This will help you find some powerful micro niches and great keywords to create content and get top rankings in search engines. Any trend on the internet first starts with an event. For example ‘mega millions’ gets lot of traffic when someone wins a jackpot or a big lottery draw is coming up. Similarly, ‘July 4th’ traffic spikes around that event and dies down. If you want traffic from this ev...
The bob is a historical beautiful hairstyle that has never gone out of style and it seems like it will not go out of style anytime soon. This video is about how to create the classic bob. To begin creating this style the hair is given volume first by parting it on the side and a piece is sprayed followed by backcombing it slightly. This process is repeated approximately four times on the side, four times in the back and four times on the opposite side. After teasing the hair, a boar bristle b...
This video demonstrates how to create an origami ninja star. Prepare a square shaped piece of paper. Lay it down on a table or on a flat surface. Fold the paper right across the middle in a vertical orientation. Fold it once more in the same manner as the first fold, now creating a more slender vertically standing rectangle. Fold the upper portion of the origami diagonally forming a small triangle on top of the rectangle. Do the same on the bottom portion of the origami. Fold the upper portio...
This video shows you, purely through demonstration, how to make a rubber band ball out of only rubber bands. It begins by showing how to create a small knot out of a few rubber bands, then wrap more rubber bands around it as one would with the small ball that is usually used as the core of a rubber band ball. The first few seconds are the most important, as forming the core of the ball out of rubber bands is the main trick to successfully creating the one hundred percent rubber band ball. Unf...
Not a very good artist? Well Joe makes it simple for anyone to create a great looking wiener dog! First he starts with the eyes. He draws two large circles then adds the dots for eyes. Joe gives them a little personality by making the eyes a little cross eyed. He next moves down to the nose where he draws a small round circle and fills it in. Next he follows his way down and creates the long body for the dog. He even includes realistic aspects such as eyebrows and a smiling mouth. Learn from ...
This video explains how to make a polymer clay "rainbow cane," which, amongst other things, can be used to make jewelry or pendants. First, you must run a conditioned piece of each color of clay through a pasta machine. Then, cut each color into a square, and from there cut each square diagonally, creating triangles. Arrange the triangles side by side and attach them together, so that you create a large rectangle of the colors. Run this rectangle through the pasta machine several times, until...
Use paper to be creative and engage in some easy crafts to create something out of a simple piece of paper. 1. In this paper craft start by creating a paper football and a paper boat. They are quite easy to make, and if you do not know how to do them you can easily find videos which describe how to do each one of them on the internet. 2. Once you have both the paper football and the paper boat you will be able to create a paper launcher by following this video. 3. Start by turning the paper b...
Do you have Adobe Flash CS3 downloaded on your PC and have no idea how to use it or what to use it for? Well in this video tutorial, witness as you will learn how to create a simple image gallery with transitions in Flash CS3. Enjoy!
This video teaches you how to make a steampunk bunny. You want to start off by making a blob with a fairly light color. Then you want to use a sharp stainless steel tool to create a round head. Make sure to make the head of the bunny is forwarded a little bit so that it looks like a bunny. Next, using your hands create a tail in the back of the bunny. Insert one of the bigger eyes using the little wire. Go ahead take your tool and carve out the nose, the cheeks and the mouth. Next you want to...
In this tutorial, Yanik Chauvin teaches us how to create an old-style looking photo starting from a grayish, underexposed one, using the software "Lightroom". He starts by creating a virtual copy of it, and then he adds a Camera Calibration preset named Camera Landscape and increases the exposure. After that, he crops the image removing the blank parts of the photo, and adjusts Contrast, Blacks and Clarity to strength the image borders.
In this video, Joe Wilson, executive director of TOONSEUM explains how to draw a sasquatch. He starts with the eyes, by drawing a B letter on it’s side. Next he draws a pair of pupils and eyebrows. Next, he creates a nose, and a mouth. In order to make the sasquatch look angry he places a triangle shaped tooth sticking out from the mouth. After this, he starts creating the head and body outline. With this finished, he adds hands and feet to the sasquatch. After tweaking the expression a bit, ...
This video describes how to make a snoopy head from a type of polymer clay. You will need both black and white polymer clay, a blending tool and a ruler. It begins with the main part of the head and moves onto creating the correct structure using a blending tool. It advises using your thumbs to smooth away the creases and cracks from the surface of the snoopy head. After the main part of the face is made, it describes how to create the eyes and ears using the black clay. The eyes and ears are...
This video in the Software category will show you how to create simple panoramic images in Photoshop. This video uses only five images for this effect. Select the five images and put them in a folder. Go to File -> Automate -> Photomerge. On the Photomerge page select ‘Folder’ and browse. Find and ‘choose’ the folder you created. Under the layout panel on left hand side of the page, select ‘cylindrical ‘option and click OK. Now the panoramic image will appear that will have some blank areas. ...
This video shows you how to use Skype on a Nokia N900 cell phone. Skype can be activated from the Settings menu of the phone. You must scroll down to "VoIP and IM Accounts" and then select "Skype". After that, you must either log in to your Skype account or create a new one. If you don't have an account, then you must create one and you'll be able to sign in right away. Once you have logged in, you can create and edit contacts. Once that is done, you can use Skype to contact people. Skype set...
The difference between a professional put and an amateur put is in the finish of the put. The professional moves his shoulders directly parallel to the target line while moving his eyes instead of his head to follow the ball. The amateur swivels their entire body to follow the ball which creates an inaccurate shot. This movement lifts the body which completely messes up a shot. For practice you can practice swinging your putter exactly the same path of a straight line. This will help create a...
Want to take your bob from straight and boring to curly and sexy? This video shows you how! First, spray a heat protectant on your dry hair, then put up most of your hair so you are working with the bottom section of hair first. Take your curling iron (whatever size curls you are looking for, smaller with create tighter curls, bigger will create looser curls) and start curling about one inch strands of hair. Alternate directions for a more natural look. Repeat the process with small sections ...
Pulling a computer virus prank on your friends calls for good laughs. In this video you will learn exactly how to create a non-threatening "shutdown" command and disguise it as a real computer virus.
This wordless video shows how to draw a staircase in 3d. Start by drawing the steps in one dimension. Extend two lines at the top of the stairs the width you want the steps to be. Draw another line between them to make a square. This creates a landing. Draw two lines downward and parallel to the steps from the line at the top of the stairs. This will create a rail and a second base. Then extend lines from each jut of the one dimensional steps, stretching the lines alternately to the base and ...
In this video tutorial, viewers learn how to make a reflective text in Adobe Fireworks CS3/CS4. Adobe Fireworks a bitmap and vector graphics editor. Begin by opening Fireworks and create a new project. Create your text and then duplicate it. Align the duplicated text under the original and flip it vertically. Click on the color and select Fill Options. Select Gradient and keep the second option at Linear. Drag the opacity on the left to zero and the right to 100. This video will benefit those...
In this video tutorial, viewers learn how to make a metallic wallpaper with a stripped paint effect. GIMP (GNU Image Manipulation Program) is a free software raster graphics editor. This video is very descriptive and clearly explains all the procedures. It provides step-by-step instructions and a visual demonstration for viewers to easily understand and follow along. This video teaches viewers how to use the weave filter and RGB noise, layer modes like abstract, burn and saturation. This vide...
In this Software video you will see how to extract and apply color correction in Photoshop CS4. First select the object and extract it. The tool that you use to extract will depend on the type of image. For example, for oranges, select the Magnetic Lasso Tool from the left hand panel. Take the cursor, click on the outer line of an orange and drag the cursor along the outline of the orange. The tool automatically creates anchor points. You don’t have to click. But, if you want to create an anc...
In this video tutorial, viewers learn how to create a Pandora battery for the fat PSP. A Pandora battery allows the user the process of using exploits and hacks to execute unsigned code on the PSP. Before beginning, users are advised to completely drain the battery. Begin by taking out the battery and cut it open. Use a knife and gently pry it open. Do not damage the circuit board. You will need to break the pin under the number 4. Then put it back together and place it back into the PSP. Thi...
This video shows a user how to create a panoramic picture using Photoshop. In this video the details like how to merge a photo and other options which are very useful to a learner are shown clearly. This video is very practical for keen user as different things like the layouts and merging a photo are explained in detail. In this video a user can find different filters that are used in creating this panoramic picture. One will find it very easy and one with artistic heart will definitely appr...
In this video you will learn how to design how to create a license plate in Adobe Photoshop. To do that that just follow these instructions: Create a new file with 1000x1000 px. Then create a new layer, pick a white color and make a rectangle with the rounded rectangle tool. Use the Rectangular Tool to create a new rectangle on a new layer like in the video. Now color the rectangle and merge the layers. Add the effects for the layers and make a new layer to create the stars for the license pl...
This video is an instructional video to teach people how to create a wax seal in Photoshop. It helps users understand how to use different tools as well as layers to create the seal. It shows exactly what color to use and how to pick that color. It also shows the steps to creating the wax texture at a good pace so it's easy to follow. It teaches how to use textures to create pieces, and it works a lot with the pen tip and selection tools. It also shows how to insert pictures into a design suc...
David Wygant discusses how to get a woman to feel chemistry with you. First, realize that no one can create chemistry and to have something really special with someone, you need to have chemistry. Everyone is attracted to different kinds of people. Chemistry and attraction is a numbers game. You can create your odds by creating energy with people. Observe women, listen to what they have to say and converse with them accordingly. These techniques may unlock a woman's attraction for you. Howeve...
