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: Animate a BIPED in 3ds Max
A 3d max tutorial.
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: Pull data from one Excel worksheet to another via DGET
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
How To: Create a Helix-Shaped NURBS Curve in Maya
There are several ways you can go about creating your NURBS helix curve in Maya; I will demonstrate the two easiest ones.
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: Create a funk guitar wah wah sound in FL Studio
This video demonstrates a couple of ways to get a wah wah sound. It shows some of the power of FL Studio's Formula Controller as an automation source as well.
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: Flip a Clip in Final Cut Pro X 10.1.2
This is a great how to for all users in Final Cut Pro X 10.1.2 Video: .
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: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!
How To: Unclothe People in Photoshop
Have you ever wanted to prank your friends by showing pictures of them naked? By learning these easy graphics editing techniques in Photoshop, you can quickly make people shirtless or nude in fake photos.
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: Create a Simple Procedural Brick Texture in Maya
This is a guide to making a very simple procedural texture for Maya. As with all procedural textures, the basic texture can be refined and added to.
How To: Download Videos with One Click in Freemake Video Downloader
Looking for the fastest and easiest way to download videos from YouTube, Facebook, MTV, Vevo, and other sites? If so, read this guide. Freemake Video Downloader 2.1 offers a brand new mode to get web videos offline in a single click!
How To: Find a P-Value with Excel
So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis.
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: Compress Mp4 videos in Sony Vegas Pro
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
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: Play a song in reverse using GarageBand and iMovie
This tutorial will show you how to take a song from GarageBand and play it backwards, using iMovie. Find out what the secret messages are in your favorite songs. You can follow the instructions in this video to learn how to reverse a song using GarageBand and iMovie.
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: Make Any Song Instrumental Using the Audacity Program
This will work for nearly any song. Upload your chosen piece (simpler pieces work better), and then follow along with the procedure so you can remove the entire vocal track and end up with a song that's purely and completely instrumental.
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 buttons and backgrounds with DVD Architect in Sony Movie Studio
In this free video software tutorial, you'll learn how to create buttons and backgrounds with DVD Architect. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
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: Add a column of numbers while ignoring #N/A errors 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to add a column of numbers ignoring #N/A errors.
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!
How To: Use NURBS in Maya Modeling to Model a Chess Bishop
The bishop is widely regarded as the most powerful of chess pieces. This video by Andrew Klein will teach you how to make a 3D model of one using Maya. It is meant to help beginners learning the basics of Maya, and focuses on the use of NURBS as part of a 3D model.