How To: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Make folded, flowing ribbons in Illustrator CS3

Ribbons are really kind of a hot commodity, believe it or not, because they're actually quite trick to make. But knowing how to make some ribbons could make you very valuable and you could implement them into your own designs. Watch this Illustrator video tutorial to work with vector ribbons. Learn how to create a smooth silver ribbon with multiple folds. It is entirely vector and very versatile. This one gets a little complicated, so prep yourself to be frustrated at first glance, but once y...

How To: Add in-between tab characters in QuarkXPress

A tab character is a control character in a document that represents movement to the next tab stop. In this QuarkXPress video tutorial you will learn how to add a in-between tab character. Make sure to hit "play tutorial" in the top left corner of the video to start the video. There is no sound, so you'll need to watch the pop-up directions. Add in-between tab characters in QuarkXPress.

How To: Change an object's color in Photoshop using magic wand

Use the "Magic Wand" tool to select the color you wish to change. The next step is to open the replace color box. Go to Image > Adjustments > Replace Color. After the Replace Color box is open, you may have to select the color that you want to change in the image. Sometimes, it will automatically select the color you're changing, but sometimes you will have to use the Eyedropper Tool and click a hue of the color you wish to change. After the color is selected in the "Replace Color" box, you c...

How To: Copy and move worksheets in Microsoft Excel 2007

Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.

How To: Get iSerial Reader for Mac

In this Software video tutorial you will learn how to get iSerial Reader for Mac. With this program you can get the serial numbers to use for various programs. Almost all programs are listed. There is nothing complicated about this. Download the iSerial reader from Serial Box. Once it is downloaded, open the folder and install it. After you open the program, follow the ‘installing serial box’ instructions. The file to add when you click ‘install now’ is the ‘serial box’ file that came with th...

How To: Smooth skin in Photoshop CS3

Think every model you see in a magazine has perfectly smooth skin? Sure, but don't worry, it's not natural! You can do the exact same thing in Photoshop with this tutorial. Watch and learn how to smooth skin by retouching portraits with blur tools in Photoshop CS3.

How To: Generate random numbers (integers) in Excel

1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...

How To: Create glass material in 3ds Max

Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...

How To: Make someone look fat with Photoshop

Well, usually people are looking to go from fat to thin, but sometimes it's fun to see what a person would look like if they were on a full Twinkie diet. Well, this tutorial shows how to use the liquify tool in Adobe Photoshop to add weight to someone to make them look pudgey, overyweight, fat or even downright obese. The tool is easy to use and the video shows clearly how to turn that beach babe into a Jenny Craig "before" photo! Check it out and YOU can make people look fat in photos.

How To: Make a GIF animation on Photoshop CS3

Adobe Photoshop has several cool features you probably did not know about. One such feature is that Photoshop allows you to animate a picture. Watch as this video walks you through the easy steps of making a basic GIF animation in Adobe Photoshop version CS3 in a matter of minutes. Have fun!

How To: Move the active cell in a selected range in Excel

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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.

How To: Randomly generate 1s, 0s & blanks with Excel's CHOOSE

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

How To: Download & install GTA San Andreas Multiplayer

Although Grand Theft Auto 4 was released, many people are still going to want to play GTA San Andreas. Here's how to download and install GTA San Andreas Multiplayer. First, go to Google and search GTA San Andreas Multiplayer. Then, click on the first result that comes up. Go to that website and click on one of the download links that shows up. (Either one of them is fine.) Open the file and follow the Setup Wizard. The installation process takes a very short time and is very easy. Then navig...

How To: Use Trapcode Sound Keys After Effects plugin

Sound Keys is a keyframe generator plug-in for Adobe After Effects. Learn how to visually select parts of an audio track and convert that audio into keyframes. TrapCode Sound Keys After Effects plugin is great for audio-intensive animations. See how to use it in this tutorial. Use Trapcode Sound Keys After Effects plugin.

How To: Use Spotlight in Autodesk 3ds Max 2014

This 4th Chapter of Lights in Autodesk 3Ds max is fully concentrated on spot light. We will learn about the various spot light parameter of 3ds max like, Hotspot/Beam and falloff, then how to use overshoot or its limitations, how we can make the spotlight rectangular than circuler and many more. Hope you will enjoy.

How To: Model a basic polygonal house in Maya

New to Maya (AKA Autodesk Maya)? Not to worry. This tutorial will save your day! Not only will you learn how to use all the basic tools in the graphic design software, but you will also create your first impressive 3D model - a house made from polygon shapes.

How To: Remove (detach) audio from video in iMovie

If you've imported some video footage into iMovie, but want to use the sound elsewhere, like in GarageBand, you're going to have to detach the audio from the video. This tutorial will show you how to remove the audio from an video clip in iMovie in Mac OS X. Detaching audio is very simple, so don't worry!

How To: Create a bootable CD with ImgBurn

Download the software from Imgburn. Choose mode, build, advanced, bootable disk. Go to allbootdisk to get a bootable image of your operating system. Choose from Windows 95 through Vista. Download the diskette image. Name and save to desktop. Choose volume and label. Click ok. Make the output burn to image file. Name the file and save it to the desktop. Download Sun Virtualbox. Test the image by choosing settings, storage, add device. Choose media manager. Select make primary slave. After test...

How To: Export individual tracks and separate files when using Audacity

In this clip, you'll learn how to export each indvidual track within an Audacity session to a separate WAV or MP3 audio file. Whether you're new to the Audacity DAW (digital audio workstation) or are simply looking to pick up a few new and useful tips and tricks, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Remove blemishes in Sony Vegas

First click on Video Event Fx, it will let you select the plug-ins that you have. Now select pixelan CE blurpro and click on OK. Now select remove blemishes 1 in preset menu. It will remove the first set of blemishes from the video now go for the blemishes 2 and then go for the blemishes 3. Now you can see the difference by playing that video. If you choose arty 3, it will make the pictures of the video as cartoony. Now go again for the blemishes 3, it will make the video even more better. Yo...

How To: Insert a horizontal line in Microsoft Office 2007

In this video tutorial, viewers learn how to a horizontal line in Microsoft Office 2007. Begin by clicking on the Page Layout tab and select Page Borders. Then click on Horizontal Line. Scroll through the list and select a type of horizontal line. When finished, click on OK. Users are able to drag the horizontal line around by holding down the left button on the mouse and moving it. When users highlight the line, right-click on it and select Format Horizontal Line. There users will be able to...

How To: Create a rainbow mist effect in Blender

Learn how to use nodes and glsl in blender to create a realtime mist effect that fades out objects in the distance to whichever colors you want. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a look!

Prev Page