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: See Through Clothes with Gimp 2.6

If you can't seem to find any photos of naked people on the internet, don't fret, this how to will show you how to "see through" clothing using some simple techniques with Gimp 2.6 photo editor. Gimp is like Adobe Photoshop without the heavy price tag. Tight, white clothing works best for this trick, so keep that in mind. Watch the video and get one step closer to seeing someone naked. Right on your own computer! See through clothes with Gimp 2.6.

How To: Animate scale in Adobe After Effects

Get started using Adobe After Effects with the help of The New Boston! This beginner's tutorial is bound to answer the many questions you have about the popular digital motion graphics and compositing software. The main purpose of After Effects is for film and video post-production.

How To: Repeat a list of names 7 times in Excel

The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.

How To: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)

Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.

How To: Change Skin Tone in Photoshop

With Adobe Photoshop on your computer, it's super easy to change or adjust the skin tone of somebody in a digital photo. The process uses some basic selection and color adjustment tools, and it's a fun way to make a friend's face nauseously green or lessen the effects of overly strong, sometimes even orange, makeup.

How To: Calculate monthly retirement income in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.

How To: Combine audio tracks in Audacity

If you have more than one audio track that you need to splice together, check out this tutorial. In this video, you will see just how easy it is to combine audio tracks using Audacity. Audacity is similar to Garage Band and is a way to edit and save music and other audio files. This software is widely used for podcasts as well.

How To: Generate a dynamic list from a table in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Use Excel data analysis filter & dynamic ranges

We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...

How To: Convert TRUE & FALSE values to 1 & 0 in MS 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

How To: Draw cartoon clouds in Photoshop

What better way to pass a cloudy day than with Photoshop? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which demonstrates how to generate cartoon clouds within photoshop. For more information, and to get creating clouds yourself, watch this graphic designer's guide.

How To: Isolate one color with Adobe Photoshop

This how to will teach you how to single out one color with Adobe's Photoshop CS5. This technique will work with other versions of PS as well. With this trick, you'll be able to create some fantastic effects, make colors pop, or simply highlight something you want to show off. It's not hard to do, and a useful things to know if you're planning on putting your Photoshop skills to use in a professional manner. Now you can remove all but one color in Photoshop.

How To: Create digital smoke in Photoshop & Illustrator

In this image editing software tutorial we are going to show you how to easily create digital abstract smoke using both Illustrator and Photoshop. One of the best things about this technique is that it’s very customizable and you can do it pretty quickly. Watch and learn how to create smoke effects in Illustrator and Photoshop.

How To: Make stencils in GIMP

In this tutorial, we learn how to make stencils in GIMP. Start with heads or faces if you are new to this. Then, use the rectangle tool to select the head. Then, go to image and fir canvas to selection. Now, remove the background by using the background tool. Once finished, go to colors, then threshold. The image should turn black and white. Turn the dial to the right, then turn it to the left to make it lighter and darker. Find the spot to where it shows detail but it's not distorted, then h...

How To: Blur out a person's face in Final Cut Pro 7

In this clip, you'll learn how to blur out a person's identity with matte tracking in Final Cut Pro or Express. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.

How To: Upscale video to HD in Final Cut Pro with BCC 5 UpRez

Boris Continuum Complete 5's UpRez filter is a fantastic new filter that lets you upscale SD video to HD. In this podcast, Dave DiPinto demonstrates a possible production scenario in Apple Final Cut Pro where you have D1 resolution stock footage that you want to use in a 1080 HD project. He shows you how to use the BCC plug-in filter UpRez to upscale the footage to HD for use in the Final Cut Pro project.

How To: Record bond discount & premium journal entries in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 53rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to record bond discount and premium journal entries in Excel.

How To: Speed up, slow down in reverse in iMovie 09

In this tutorial, Gary teaches us how to speed up and slow down in reverse in iMovie 09. First, open up iMovie on your computer and set your preferences so the advanced tools are turned on. Now, open up your project and play it back at normal speed. Next, go to the information for this clip by selecting the "i" button. Click on the speed and then click "convert entire clip" so you can control the speed of the clip. After this, you can move the lever on the gauge to make it faster or slower. W...

How To: Use the soft light layer mode in Photoshop

In this tutorial, we learn how to use the soft light layer mode in Photoshop with Yanik Chauvin. This will reduce gray in the picture. First, duplicate the layer and then click on the blending mode menu. Click on the soft light option, then your photo will adjust and have saturation in it. The flatness will be removed from the image and the gamma will be increased. If you find this too strong, you can go into the opacity slider and adjust this to what you think fits your picture. When finishe...

How To: Get rid of edge seams in Adobe After Effects

Interested in getting rid of edge seams within Adobe After Effects? This video guide will show you how it's done. Whether you're new to Adobe's popular compositing editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.

How To: Rig a small piston with constraints in Blender

Blender's constraint system offers a very powerful feature-set. In this video tutorial we will look at how to rig a piston using several constraints. 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 from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!

How To: Make animated gifs with Adobe Fireworks CS4/CS3

In this Software video tutorial you will learn how to make animated GIFs with Adobe Fireworks CS4/CS3. It is easier than Photoshop and Flash. You can create a picture or you can drag and drop a picture. To drag and drop a picture, find out the dimensions of the picture. In the example, it is 420 x 420. Now open fireworks, open a new document and set the height and width to 420 pixels and click OK. Now drag the picture and drop it in to the blank canvas. On the top bar go to window > states. T...

Prev Page