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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
In this how-to video, you will learn how to remove tattoos using Photoshop. First, open the image in Photoshop. The patch tool is the easiest for removing these type of tattoos. If the tattoo is very ornate and complicated, it will take longer to remove. First, select the patch tool, which looks like a band-aid. Hold it down and select patch tool. Zoom in on the tattoo and draw a selection around it. Once it is selected, click the left mouse and hold it down. Drag the selection to an area sim...
In this video tutorial, viewers learn how to change an icon in My Computer. Users will need to already have a picture of the icon that they want to change to. Begin by opening the drive. Right-click anywhere, select New and click on Text Document. Name the document "autorun.inf". Right-click the text document and open it with Notepad. In the document, type in:
Tut Teacher shows that if you're going to edit alot of pictures, learning to change your eye color in Photoshop is helpful.Go to Photoshop and open "human eye", zoom in and it gives more room to work with. First, go to your lasso tool, hold down and click. You can click and drag or click along the outside edge. Set to 6 pixels, more or less depending on the image. Make sure you don't click on scanner..it'll make the image go crazy. Keep clicking along the edge there'll be a symbol on the circ...
This video illustrate us how to draw a female assassin. Here are the following steps: Step 1: First of all take a sheet of paper and pencil.
How annoying is a skipping DVD? Picture it: you're in the middle of your favorite flick, and suddenly the characters freeze and seemingly melt away right before your eyes. Sure, you can skip ahead and start watching again at another point in the film, but that's no fun. And it always seems like the disc skips at the best part, doesn't it? Well, this tutorial will show you how to do a quick fix with a tube of toothpaste. It's not just for your pearly whites anymore!
This video demonstrates how to connect your phone to your Mac computer via Bluetooth. First, make sure that you have Bluetooth enabled. On your Mac computer, begin by searching 'Bluetooth'. When the search results appear, click on Bluetooth File Exchange. A new window will appear where you can get to select a certain picture that you want to send to your phone.On your mobile phone, go to the settings where you can choose to enable the Bluetooth. In the Bluetooth settings of your phone, select...
This video tutorial from pctechbytes presents how to quickly set up Homegroups in Microsoft Windows 7.This feature allows to easily share files between computers with Windows 7 operating system.Press Start button, select My Computer option. In the newly opened window select Homegroup from the list to the left. Select View Homegroup Settings link.In this window you can choose what types of documents you want to share with other Windows 7 operating system users.You can share pictures, documents...
Why use a regular wall clock when you can have an awesome clock make out of spoons that you make yourself? Let your character show through or make a cheeky gift with this clock. You will have to buy a basic boring wall clock. Use the battery of the clock and attach it to a great metal strainer as the mount. Then use cut out a picture for the front ant but the hands back on. Glue some spoons on the back to complete the look, add a mount and your ready to enjoy telling time in a whole new way. ...
Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of la...
TooSmartGuys teach viewers how to hack their iPhone using Black Ra1n and Sn0w. First, if you have a jail broken iPhone you should back up your apps by downloading a program called App Back Up. Now, plug your iPhone in and let iTunes load. Allow it to update and you should see the iTunes icon on your phone and the cord picture. Open up Blackra1n and click the button that says make it rain. Your phone reboots and there will be a new app on there called blackra1n. Launch this app and you can put...
This video illustrate us how to draw a furry cartoon fox. Here are the following steps.Step 1: First of all take a sheet of paper and pencil and start by drawing a oval shape representing the face of the fox.Step 2: Now draw a nose and two oval shape eyes in the face.Now from the bottom of the face draw an oval structure representing the belly of the fox.Step 3: Now from the lower belly draw two small legs with feet.Step 4: Now draw a tail from the back of the mid lower portion representing t...
This video demonstrates how to turn your favorite songs into ringtones for your Blackberry Curve. You will need a USB cable to connect your Blackberry to your computer. After connecting your Blackberry, a message will ask you if you would like to turn on "Mass Storage Mode". Select yes. On your computer, open the Blackberry in a window, and then open "music". Then click-and-drag songs from your computer onto your Blackberry. You can transfer files to either music or ringtones (as long as its ...
David Shrein provides a video recording with step-by-step instructions on how to utilize the DVD ripping software 'Handbrake' on a computer running Mac OS X. He shows how to deal with an initial error message, and then moves onto selecting the DVD. You have to be careful as to what you choose, as different DVDs will have different numbers of chapters and features, which use different settings in Handbrake. He shows how to select the right settings for a movie, and preview a chapter using pict...
In this video tutorial, viewers learn how to make an animated GIF file using Adobe Photoshop. Begin by opening the program. Then click on File and select New. Choose the size of your image and click OK. Now create your picture or text image. Once finished creating your image, click on Window and select Animation. Now click on the button on the right side of lower window and select Make Frames from Layers. change the time of each frame to 0.5 sec. Now edit it and save it. This video will benef...
This video illustrate us how to draw the incredible hulk. Here are the following steps:Step 1: First of all take a sheet of paper, pencil and pencil color.Step 2: Now draw a square with round edges representing the face of the hulk. Within the face draw eyes and a big mouth and hairy eyebrows.Step 3: Now from the bottom of the circle draw an oval with wavy structure on it showing the six-pack abs of the hulk.Step 4: Now from the down side of the abdomen extend two legs with muscular legs and ...
In this tutorial video, YouTube user "inteltuts" discusses ways to use Photoshop CS4 to help make better looking product pictures, as a way to attract costumers to your online products. Using a black telephone as an example, he first shows how the opacity, linear dodge, and brush tools can help make a product image look shiner, sleeker and brighter. He goes onto create what he calls "glints", which are subtle reflections and areas of sparkling light that he places across the image. Lastly, he...
Maria from [www.stamininspirations.blogspot.com stampininspirations.blogspot.com] shows us how to make a 4x4 mini double accordion picture album. You will need a 4 x 9 in. piece of designer paper, a 4 x 9 in. piece of card stock, a 3.5 x 8.5 piece of designer paper, two 3.5 x 12 in pieces of card stock and two 4 x 4 in pieces of chipboard as well as some smaller pieces of designer paper and card stock and some ribbon. Rubber cement, a scorer and some double sided tape are also needed. Maria s...
You will be using a picture of a Nintendo character and perler beads to make the necklace. Start by making an outline of the character using black perler beads. Then begin using colored beads to fill in the character. The color beads allow you to fill in the character and they also allow you to create all the detail on the character. You can shade and use multiple colors in making the characters. After you have put all the beads on the card put a sheet of waxy paper over the character and iro...
Learn how to create an automator workload that will upload pictures to your Flickr account in this video tutorial. Simply Google "automator Flickr." Upload it to Flickr to allow access to your Flickr account. This means you will have to sign into Flickr and allow for the application to have access to your account. Every time you use the application, you will have to give the photo a title as well as tags. You will then save the photo as an application with whatever title you want. Anytime you...
Robert Dejesus demonstrates how to easily draw the picture of Goku in (Dragonball Z) by simply using a pencil This demonstration is created with beginners in mind and also to inspire children to take up drawing. First of all, a thinner, rough profile of the figure is drawn and then followed by thicker shade. The head is drawn from a circle and mended to its real profile as the face begin to appear and the hair is drawn and followed by the neck and torso and the shading is given to highlight t...
Mike Wallace is going to show you how to set up a softbox in order for a photo shoot. First, you are going to need an 1200 watt generation and with the Profoto one it comes with a pocket wizard built into it so it allows the photographer to meter and trigger with a pocket wizard TT1 on the mini camera. Also, you want to use a Manfrotto Megaboom softbox, and this is much easier then using a ladder because on the ladder you'd need to climb it whenever you wanted to reposition it. With the Megab...
Brittany Black Rainbow demonstrates how to draw an emo boy. Begin with the back ground of hair, draw it like an inverted cone, assuming like one eye is covered by the hair. Draw the second eye and brows, and now draw the nose and mouth. Complete the face. Just draw the neck and the body with a round neck T – shirt with half sleeves and the hands. Now complete the hair. It’s like thorny bush, just draw all these lightly. Give black shade to the hair with pencil itself. Now darken every thing, ...
Six Minute Style host Susan Doherty is on location in Montana at the Nine Mile School house with Kurt Seer who shows how to create a 3 dimensional wreath mobile. He uses birch as his base. You can use any wood you choose. Make a square out of four branches. Knot, tie and twist floral wire at cross sections of the wood frame. Leave a little tail for the decorations. Tie dried rosemary in the wire tail. Tie leaves and greenery around the frame using wire. Not only for Christmas, you can create ...
Would you like your own custom movie poster for that amazing film you're working on? Well this YouTube user made a video to show you exactly how to create your own movie poster right in Adobe Photoshop.
In this video tutorial, viewers learn how to make an LCD viewing hood from a slide viewer. This hood will prevent any shining or glaring of light when looking at the LCD screen. Most LCD covers are expensive or just get in the way. This viewing hood is inexpensive and only cost $6. 95. Users will simply need a slide viewer. Pull off the diffusion screen and cut off the ledge so that it is flat. Sand it to make it smooth and add some felt to cushion it on the screen. This video will benefit th...
This video shows how to make a screen capture program in Visual basic. The first step to create a screen capture is to open a new project and open a new form window. The second step is to create to temples for either saving or capturing the picture you choose to select. The third step involves following the code structure given by the instructor to enable the correct function for the save or capture button options. The final step is to open the project as a finished work with the correct codi...
First thing to do is to create a new pic image called matrix. The next thing you want to do is to change the width and the height of your picture, as well as the resolution. Pick any background color you want, take the paint bucket tool and fill the background. To get the matrix code, go to Filter, Texture, and then finally Grain. You want to set the intensity to 90, contrast to 50, and grain type should be vertical. To get the grain to be green, you press Ctrl+U, press colorize and drag the ...
In this Software video tutorial you will learn how to have fun with the’ liquefy’ tool in Photoshop. The video is by Yanik Chauvin. Open Photoshop, select a picture that you want to have fun with, go to ‘filter’ and click open the ‘liquefy’ tool. This video is looking at 3 tools under liquefy. They are Forward Wrap Tool, Pucker Tool and Bloat Tool. These tools can be modified by the brush options on the right hand side. The Pucker Tool reduces the size of a feature on the image. The Bloat Too...
In this video tutorial, viewers learn how to add hemp twine to accent a scrapbook photo. Users will only need a line of twine and tape. Put the twine on one side of the picture and tape the back to hold it. Now wrap the twine in a diagonal pattern (right and left). Then wrap it down the middle and tape the back again to hold it. Trim off the extra twine and tape all the strings of twine at the back, so that it won't move. This video will benefit those viewers who want to add an embellishment ...
This video lesson will show you how to easily make frames and borders in Photoshop. Yanik from Yanik’s photo school presents this video. It’s really easy and fun. Go to select -> all or ctrl+A. Then Go to select -> modify ->contract. Put in the amount of pixels you want your border to be and click OK. 75 may be suitable for most pictures. Then Go to select -> inverse. Now you go into quick mask, ctrl+Q or click the appropriate icon. Click filters -> filter gallery and select the type of effec...
This video shows the method to sync sound using Sony Vegas. This is important in case of double system sound when audio is recorded separate from the picture. The first step involves opening up the poorer source of audio like the audio from the built in microphone in the laptop. Now open the good quality audio like the one from a camcorder just below the first one. Align the two audio using a reference mark. In the given video, it is the clapping of hands recorded on both audio. So, the spike...
This is a simple video of a person drawing a flower with a mechanical pencil on a piece of plain white paper. If you follow along with the video and copy each shape as the artist makes them you will get a similar result and hopefully a picture of a flower that looks the same as the artists. The final product looks like a rose. A beginners video to art, all the viewer needs to is watch, copy and listen to the soothing music that is playing in the background.
This video is all about how to draw a rainbow. The picture is drawn using a computer paint tool. In a blank white page they started drawing the outline for the trees, shrubs, house.
This movie is a silent animated account of how you draw the final picture (which is shown at the beginning of the clip) of two kids flying a kite. The lines are sketched roughly using pencil, and then over-inked. The original lines are erased and leaving outlines. Then you begin coloring in all the spaces just as you wish. There is no commentary and no music, but all the basic detail is there and you can follow easily the way the characters are drawn and colored from start to finish, making i...
Do you want to achieve a nice, clean look? Flawless skin is the first step in achieve just that. This video will show you exactly how to achieve that flawless look you've always wanted.
Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...
Learn how to draw a flower in MS Paint in this video tutorial from Shannon. In the first step, you will need to draw a circle with the shape tool. To create the petals, you will need to draw additional circles surrounding the first circle. Use the paint brush tool in green to create the stem and leaves, which you will draw free-hand. Using the bucket tool, fill in the leaves and the petals of the flower. Shannon also shows in this video how to draw a bird next to the flower with the paint bru...
This video shows the method to recover deleted files in Ubuntu using Testdisk. The demonstration is done by deleting a set of pictures and recovering them later. The test disk is installed at first. Then we click on the terminal icon and go to the list options available. These include selecting the list of drives available, partition table type and the type of file system in the original photos. Then the system asks you to select the part to be analyze and destination folder. The tool then re...
In this video tutorial, viewers learn how to draw a rose. Begin by selecting your favorite rose picture. Sketch the outward point lines from the center (this will outline the petals and stigma of the rose). Sketch the rose pedals with the lines. Erase the guidelines and re-sketch the pedals. Create tones using a 4B pencil. Then smudge the tones using your fingers. Then use a 6B pencil to shade and smudge. Users may choose to add water droplets on the drawing. Finally, use the 6B pencil for a ...
