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: 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: Change the tempo in GarageBand (speed up or slow down songs)
Anyone with a Mac knows the power of GarageBand, but not all iLife users know the ways to slow or speed up their songs in GarageBand. This video will show you exactly how to change the tempo of your song creations, which is actually a really simple thing to do.
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: Convert a Photo into a Line Art Drawing in Photoshop
If you're not much of a drawer, you can still get the look of a detailed drawing simply by taking a picture and using Photoshop's tools and filters to transform it into something that looks drawn by hand.
How To: Use conditional formatting for a student grading report in Microsoft Excel
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
How To: Change the color of an object in After Effects
This video shows you how to change the color of an object in After Effects.
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: Create a twinkling star effect in Adobe After Effects
This is a great background for Christmas plays, holiday pageants or any other video you want to add a little twinkle! You can add a twinkling star quite easily in Adobe After Effects, and this tutorial shows you exactly how!
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: Increase the volume on "too quiet" exported songs in GarageBand
If you've just exported your masterpiece from GarageBand and found that your volume on the song is too low, then you're going to have to fix it. And increasing the levels on your "too quiet" song, you just need to get back into GarageBand and make some adjustments.
How To: Sort & find duplicates in Excel
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
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: Format numbers to display exponents in Microsoft 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 346th installment in their series of digital spreadsheet magic tricks, you'll learn how to format your numbers to show exponents and see how to create a formula that uses exponents.
How To: Model a Leaf in Maya
Start with a Polygon Plane Start by creating a Polygon Plane with 4 width and 5 height sections.
How To: Record streaming audio directly from the web using GarageBand and SoundFlower
***WARNING*** Do not record ANYTHING without strict permission from the person or persons or artist that you're recording.
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: Use the gradient wipe transition in Final Cut Pro
In this Final Cut Pro tutorial, Richard Harrington takes a look at the gradient wipe transition. The gradient wipe transition is a highly customizable transition using greyscale patterns to create your own custom wipes.
How To: Apply & remove Adobe Acrobat 9 PDF security options
In this tutorial, learn about applying and removing security options in Acrobat 9. For more Adobe software tutorials from Layers Magazine, search Layers Magazine on WonderHowTo. WonderHowTo indexes all Layers Magazine tutorials for Illustrator, InDesign, Photoshop, Acrobat, After Effects, Premiere Pro, Dreamweaver and Flash.
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.
News: What Did Playboy Do Before the Days of Photoshop? (Slightly NSFW)
An auction at Christies showcases decades of heavily marked up Playboys, both pre and post the advent of the magical, human "perfecting" tool known as Photoshop. The edits are so heavy, it shows how such an idealized human being simply doesn't exist. See the whole NSFW collection over at Jezebel.
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...
How To: Roll a surface with Wireblend in Houdini 9
This Houdini 9 tutorial shows you how to roll and unroll a surface without using expressions. Learn how to roll a surface with the Wireblend tool in Houdini 9. Once you create the rolled surface, you can also animate it.
How To: Make shimmering glitter in Particular in After Effects
In this After Effects tutorial, Creative Cow leader, Michael Park, demonstrates how to simulate shimmering glitter particles using fractal noise, colorama effect and Trapcodes Particular plugin. Make shimmering glitter in Particular in After Effects.
Next Page
Prev Page