How To: Multiply column times row with Transpose in MS Excel
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
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: Install fonts in Photoshop
In this how to video, you will learn how to install fonts on to a computer running Windows. First, go to the start menu and go to control panel. From here, double click on fonts. Next, select install new font. From here, browse your folders to the folder you have saved your downloaded fonts. Once it is selected, press okay to add the font to your current list of fonts. You can check if the font can be used by opening up Photoshop. Create a new file and then press the text icon. From here, you...
How To: Create an array from a rasterized object in Photoshop
This image editing software tutorial shows you how to create an array from a rasterized object in Photoshop CS3. An array (in design terms, not programming terms) is an object that duplicates itself around a pivot point. So learn how to work with arrays to create designs in this Photoshop video.
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: 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 Tangent Line with Excel
Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.
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: Draw eyes in MS Paint
In this tutorial, we learn how to draw eyes in MS Paint. Start out by drawing the outline for the eye using a thin marker. After this, draw on a thicker line at the top of the eye and then draw on the crease of the eye above this. Now, draw in the details of the middle of the eye and start to shade in around the crease of the eye and the middle of the eye. From here, draw in the eyelashes on the top and the bottom of the eye, making them longer if they are for a woman. When finished, save thi...
How To: Master Maya's basics by 3D modeling a hand
If you've found this video, chances are that you are looking to improve your skills using Maya, the 3D modeling software. You've come to the right place. This video will teach you how to create a polygonal model of a hand, one of the most challenging and important parts of the body to model correctly. Watch and learn!
How To: Create a favicon in Dreamweaver
This is a handy tutorial about creating the favicon. A favicon is an icon which appears on the tab, in the address bar and in the favorite menu of browsers. To make a favicon:
How To: Conditionally format at every change in value in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
How To: Edit videos in Audacity
Audacity is a great (free) audio editor for recording, slicing, and mixing audio. Learn how to use this software with this detailed step-by-step guide on how to edit videos in Audacity. Be sure to check out other Audacity tutorials on WonderHowTo to find the answers to all your questions!
How To: Create realistic smoke and dust particles in Maya
The key to being able to animate realistic smoke or dust is being able to master the particle texture rate technique in Maya. Once you have gotten this down, you can create any sort of particle effect, such as sand or bubbles in addition to smoke and dust. This three part tutorial series goes in depth into the subtleties of Maya, showing you how to get the most out of working with particles to lend an extra layer of realism to your project.
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: Install ISO game files with the use of Daemon Tools
In this video, the poster is teaching YouTube users how to use Daemon Tools mount games image files. That’s very useful to many people that cannot burn ISOS or any other image files into a blank media (CD, DVD). With the tips provided by this video, anyone can use Daemon Tools to mount the image in a virtual CD/DVD drive. Daemon Tools is a Freeware program and you can download it at many websites on the internet.
How To: Find and replace text in MS Word 2007
This video will show you how to use the ‘find’ and ‘replace’ text buttons in Microsoft Word 2007. Microsoft Word 7 is slightly different from the Microsoft you might be used to but with these instruction you’ll have no problem finding the buttons.
How To: Mount ISO, BIN, or CUE files using Daemon Tools
In this video tutorial, you will learn how to mount and unmount an .ISO, .bin and .cue image with daemon tools. This is useful because when you download a game, movie or an application, you usually get an .ISO, .bin or .cue file.
How To: Stop iMovie from automatically zooming photos
Fix the automatic zooming feature in iMovie with the techniques presented in this tutorial. When pictures and photographs are imported into iMovie for Mac, there is an automatic zoom applied to all the images. This tutorial from TheHowToMac shows how to stop this feature, as well as fine-tuning the Cropping, Ken Burns & Rotation settings.
How To: Create a bond discount or premium amortization table in 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 52nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a bond discount or premium amortization table.
How To: Create a burning match effect in Houdini 10
Learn how to use the Houdini SOP solver to create a realistic burning match effect within Houdini 10. Whether you're new to Side Effects Software's popular 3D production program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look. Create a burning match effect in Houdini 10 - Part 1 of 4.
How To: Model 3D heads using Maya
Maya is the most powerful and widely-used program in 3D graphics today. All of this power also means that it is likely the most complicated 3D modeling as well. This video features some basic tips for using Maya to create a 3D model of a human head. It doesn't have any instructions, so some basic knowledge of the software is recommended, but the techniques are basic enough that newbies should be able to pick it up as well.
How To: Model a basic sword in 3D using Metasequoia
The sword is a very oft-depicted item in video games and CGI-heavy movies, so making them in 3D is an important skill to have if you want to become a 3D artist. This video tutorial walks you through the process of modeling a basic sword using the 3D graphics suite Metasequoia. It moves pretty fast, but is also basic, so you should be able to follow along. You 3D models will be hacking and slashing in no time!
How To: Draw vector art using the path tool in GIMP
This video will introduce you to the basics of creating vector art in GIMP by teaching you to draw using the path tool.
How To: Create 3D objects from vector images in Cinema 4D
Learn how to use Maxon CINEMA 4D R10 - along with Adobe Photoshop and Illustrator for vector image editing - to create 3D objects from vector images.
How To: Clear data & cell contents in Excel using a macro
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
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: Create a PDF Portfolio or Magazine with InDesign and Share It Online
Why a PDF Portfolio? If you've been wanting to create a PDF (portable document format) portfolio for your photos, art or design work, or wanted to create a PDF magazine that can be read by anyone on the net, then this article will show you how to go about it.
How To: Use the Excel Vlookup function in Microsoft Excel 2007
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
How To: Open & edit Dolby Digital AC3 audio with Audacity
A great number of audio editors don't support importing/exporting AC3 files, luckily the awesome—and, of course, free–Audacity does. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial, which presents a complete overview of how to open and edit Dolby Digital AC3 audio when working in Audacity.
How To: Create a sudoku puzzle in Excel with array formulas
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
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: Change Excel options directly in the Registry
This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...
How To: Make Mona Lisa's Eyes Blink in Photoshop (GIF Animation)
If you loved The Da Vinci Code by Dan Brown, then listen up— there's been a new discovery found hidden within Leonardo da Vinci's most famous painting— the Mona Lisa.
How To: Create a simple letter for Mail Merge in Microsoft Word 2007
In this quick clip, you'll learn how to go about creating a basic letter for Mail Merge within MS Word 2007. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Improve your text by using Illustrator text effects
In this video, we learn how to do basic text effects in Adobe Illustrator. First, open up Adobe Illustrator and make a new document. Now, type in your desired text and change your font to one that you prefer. To make your text turn into a radiant, you will click "file" then "type" then "create outline". Now you will click on your text then click your radiant swatch. Then, go to "gradient" and adjust your colors to which you prefer. You can now put a stroke on it using the "stroke" tool and ch...
How To: Make a shrinking data validation list 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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
How To: Give someone a shave in GIMP
In this Software video you will see how to give someone a shave in GIMP. Learn spot removal, skin smoothening and a makeover or removing a 1 day beard. This is done using the Clone and the Healing tool. To use the Clone tool, select the tool from the right hand panel. Then to select the source skin color, you have to hold ctrl key down and click. Now when you apply it to the area you will get the same shade of the source color. So, you will need to select an area very close to the spot you ar...
How To: Build a 15-minute schedule in Microsoft Excel
Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.
How To: Add a shake, quake or jitter effect using Sony Vegas
This screencast shows you how to add a shake effect to your video in Sony Vegas. It is also known as Quake, Jitter, tremor etc. It can have an interesting impact on your productions.