Hot Software Posts
How To: Create a savings plan with Excel's FV & PMT functions
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...
How To: Make calculations for markup & markdown in Excel
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 7th installment in his "Business Math" series of free video lessons, you'll learn how to make calculations for markup (mark up) & markdown (mark down).
How To: Construct confidence intervals with TINV in MS Excel
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 83rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) in NOT known using the TINV function.
How To: Edit and split clips in Sony Vegas
Sony Vegas is a cool new video editing program. In this tutorial, you will learn some simple editing techniques in Sony Vegas. You will learn to detach the sound from your movie clip, as well as how to split your movie to remove any unwanted footage. You will learn how to merge both clips and use the fade in and fade out tool to create a smooth transition.
How To: Return the address of the 1st non-blank cell 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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.
How To: Make an Excel gradebook that drops the 2 lowest scores
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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.
How To: Rearrange parts of a text string 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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one formula.
How To: Group duplicates & extract unique records 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
How To: Remove the last two words from a column 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. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
How To: Use the Office clipboard in MS Word 2007
This video shows you how easy and convenient it is to use the Office clipboard in MS Word 2007. Go to the "Home" tab. Then click on the little
How To: Create databases from templates with FileMaker Pro 10
In this Lynda video tutorial, learn how to use FileMaker Pro 10 software to create databases with pre-made templates. FileMaker offers these templates in a package called Starter Solutions. To access these options, click open FileMaker. Then, go to New Database under the File menu. Click the option "Create a database using a Starter Solution." The templates are grouped according to the nature of their use. Some are for the home, while some are for business. All you do is open the template you...
How To: Remove JPEG artifacts in Photoshop
Photoshopuniverse shows how to remove JPEG Artifacts in photoshop. It's simple. Sometimes it happens that, you get the best picture which is related with your work, but unfortunately its low quality or small. If you zoom in a small picture it will pixilated. You will see some blocks. Luckily there is a way to remove it from photoshop. Go to- filter, then noise, then reduce noise. There will be an options of removing JPEG artifact. Check that. After watching the video you can remove JPEG artif...
How To: Make fire in After Effects
What is a cooler effect than fire? Not much! Check out this tutorial and learn how to make very cool flames and explosions in Adobe After Effects..from scratch! This tutorial will take you step by step through the process of making very cool fire effects. Learn this technique and have all the fun of being a pyromaniac without singeing your eyebrows or burning the house down!
How To: Isolate colors in Photoshop
The step by step methods to isolate colors in Photoshop have been shown in the video. In a layer we have to place an image and first select the particular part to be isolated with the pen tool which has free form pen tool, add subtract, intersect and exclude overlapping path options. After that make a right click and select make selection option. Keep the feather be in 3 and click ok. Paste this in a new layer by pressing control+d keys. Create a copy layer of 2 and open Hue and saturation pa...
How To: Convert VHS tapes to DVD with Roxio Easy VHS to DVD
This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.
How To: Create the Droste Effect with Adobe After Effects
In this tutorial, Creative Cow contributing editor Carl Larsen shows you how to use the Pixel Bender Toolkit to create a recursive image set in Adobe After Effects CS4.
How To: Create the Juno opening credits look w/ After Effects
The independent film Juno featured one of the most distinctive opening credit sequences in recent memory. It has a wonderful handmade look - which it turned out was created by hand! Whether you have seen Juno or not, Cow leader Simon Bonner shows a much easier way to create unique, handcrafted looks, without the pain.
How To: Go to New Record in a form using macros in MS Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using a macro to force a form to open on new record. For more information on going to `New Record' in a form by using macros, watch this Access how-to.
How To: Email GarageBand Files
This software tutorial will show you how to email GarageBand files. Learn how to zip the GarageBand file and create an archive so you can email your GarageBand music files.
How To: Create and use face based families in Revit
This CAD software tutorial covers how to make face based families, change a family category, and make voids in Revit Architecture. Face based families are pretty handy for a few reasons. a big one though is that they do delete when you erase the host object (this is not the case with wall based and floor based) families. Also face based families are easy to move around, re-host and rotate. See how to create and work with face based families in this Revit Architecture tutorial. Create and use ...
How To: Creating a photo slideshow in Sony Vegas Movie Studio
Bill Myers shows you how to quickly create a video from photos or photo slideshow in Sony Vegas Pro Movie Studio.
How To: Set up drawing limits & drawing units in AutoCAD 2008
This AutoCAD 2008 tutorial covers setting drawing limits and drawing units.
How To: Model a human body in Maya
This tutorial series shows you how to model anatomy of the human body in Maya and gives specific tips on how to eventually be able to do it from memory. Part one starts with the head, part two the torso, part 3 the legs, part four the foot, part 5 the arm, part 6 attaching the parts and part 7 modeling hands.
How To: Convert part of an image to grayscale in Photoshop
In this lesson, learn how to selectively maintain the original color aspects in a portion of an image while making the remainder of the image grayscale for an added aesthetic effect.
How To: Use the background eraser tool in Photoshop
If you find yourself needing to quickly remove the background from an image in Photoshop, take a moment to play with the background eraser tool.
How To: Replace faces in photos using GIMP
This video shows how to use some basic image editing techniques to replace the face in an image with another face.
How To: Use the Vector Shape tools in Photoshop CS2
In this Photoshop CS2 video tutorial you will learn how to use the Vector Shape tools. The Vector Shape tools include the Rectangle tool, the Rounded Rectangle tool, the Ellipse tool, the Polygon tool, the Line tool, and the Custom Shape tool. Learn how to draw and recolor vector shapes, and rasterise them. 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. Use the Vector Shape tools in Pho...
How To: Create rollover effects in InDesign that work in PDF
Adobe InDesign can create PDFs natively. In this video we'll see a rarely used feature that allows us to create rollover effects that work beautifully in PDF files. InDesign allows us to create buttons and using the States palette we can create rollover effects.
How To: Make a wavy flag with a displacement map in Photoshop
Are you celebrating the independence day of your country? How about displaying a flag on your website? In this video tutorial you will learn how to make a flat flag wavy using a displacement map in Photoshop.
How To: Convert video to cartoon in After Effects
In this three part tutorial Creative Cow leader Aharon Rabinowitz explains the process of converting video to cartoon by using only After Effects and Adobe Illustrator CS2. Even if you don't want to create this exact effect, this tutorial covers a TON of basics and is a worthwile learning experience. Topics discussed: Dealing with interlaced footage, Basic Color and Image Correction, Creative Outlines, rendering an image sequence, using layer blending/transfer modes, Motion Tracking, Hold Key...
How To: Use the Clone Tool in Fireworks 8
Want to replicate objects fast? In this Fireworks 8 video tutorial you will learn how to use the Clone Tool (also known as the rubber stamp tool). 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. Use the Clone Tool in Fireworks 8.
How To: Control, stop and play movie clips in Macromedia Flash
In this video tutorial you will learn to control, stop and play movie clips in Macromedia Flash. Learn to use Actionscript to "talk" to your Flash object. Please note that Actionscript is case-sensitive. Control, stop and play movie clips in Macromedia Flash.
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: 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: Remove Vocals from a Song in Pro Tools
If you need to remove vocals from a song in Pro Tools first you need to open Pro Tools and load the song. First, you need to split this track so go to Track and click split to mono. Now, mute this first track. Next, you want to remove the stereo by panning each the bottom to 0. Now, flip the phase by going to the bottom clicking EQ plugin. Now the vocal is pretty much gone.
How To: Calculate stock value based on the value of future dividend cash flow 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 61st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock based on the present value of a future dividend cash flow.
How To: Remove body fat or stretch marks in GIMP
In this video, we learn how to remove body fat or stretch marks in GIMP. First, go to filters, then distort, then warp. When you are in this window, you will be able to see all the different distortions that you can do. To help you remove the fat, use the "move" tool and a proper sized brush. Now, press on the stomach and slowly press down on it until you see the part of the body start to become smaller. Don't do it too quickly, or the picture will look fake. When finished, save your new pict...
How To: Corner pin a video with the Mocha 3D tracking tool in Adobe After Effects CS5
Learn how to corner pin a video onto an iPod, mobile phone, TV or monitor with the Mocha 3D tracking tool in Adobe After Effects CS4 or CS5. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
How To: Reset and purge in Adobe Photoshop CS4 or CS5
Deke gets things started with a pair of options that can clean out Photoshops plumbing when things get clogged up: Reset and purge. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.