Hot Software Posts
How To: Enter formulas in Excel with a macro
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
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: Use the opacity feature in Final Cut Pro
Plangere Culture Lab demonstrates how to use the opacity feature in Final Cut Pro. The opacity feature is a beneficial tool to use when working with layers. Opacity is an attribute which relates to how much you can see through a clip. To layer clips, create a new video track on the timeline. Make sure that the source tab is in the right position. The track on the top of the stack is the dominant track and will be shown. Select the volume and opacity overlay button. Click on the line over the ...
How To: Draw realistic eyelashes in Photoshop
This video demonstrates how to draw eyelashes using Adobe Photoshop and a graphics tablet. You need three tools to draw eyelashes: Soft Round Brush, Smudge Tool, and Eraser. Create a new layer. On the upper eyelid, draw each eyelash with Soft Round Brush (color: black, width 17px, opacity 100%). Use Smudge Tool (width 45 and straight 25%) on the eyelashes to straighten them. Use Eraser (width 65 and opacity 100%) if necessary. Create a new layer and use the same tools for the bottom of the ey...
How To: Enlarge breasts in Photoshop
Thinking you need a little boost in the bra department for this year's Christmas card? Here is a tutorial on how to make your breasts appear larger using Photoshop.
How To: Import images with transparency into After Effects
In this software tutorial you will learn how to manipulate images in Photoshop to remove the background and then bring that transparent background image into After Effects without loosing the transparency. The Photoshop section covers the use of the Magnetic Lasso tool and Quick Mask to remove a background. With the image adjusted, you will learn how to import your new image into After Effects with preserved transparency.
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.
How To: Score a Full Version of Microsoft Office for Only $10
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
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: Make a scary voice effect on Adobe Audition
In this video we learn how to make a scary voice effect on Adobe Audition. First, record an audio that you made and open up Adobe Audition. From here, open up any other audio that you want to hear for the beat. Then, go to "generate" and then "silence. Put this to 1.5 seconds, then go to the end of your sound and do the same thing. This will make a good effect when you are editing and adding in echo. First, reverse the audio by going to "effects" and then "reverse". This will make it a lot ea...
How To: Avoid the wobbly keyframe in After Effects
Nick Campbell shows us how to avoid the wobbly keyframe in After Effects. When you are animating logos and want them to come onto the screen, stop for a few seconds, and then continue off the screen. To fix it, highlight your key frames and then right click on "keyframe interpolation". Now, where it says "temporal interpolation" click to make it say "linear" next to it. Save this change and now the wobbly effect should have gone away. This can come up in a number of different moves, no matter...
How To: Calculate salary based on work experience 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 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.
How To: Use the camera fly mode tool in Blender
See how to work with Blender's Camera Fly Mode tool. The tool is a great way to help navigate your 3D scene, and also for camera placement (or any object set to be a "camera", for example a Spotlight). 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 informatio...
How To: Find critical values with T functions 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 91st installment in his "Excel Statistics" series of free video lessons, you'll learn how to use TINV and TDIST functions to find critical values given an unknown sigma value.
How To: Create a pass-fail grade formula 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
How To: Quickly insert formulas in Excel
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
How To: Save a file in Microsoft Word .docx and .doc format
In this video tutorial, viewers learn how to save in .doc file format in Microsoft Word 2007. When saving a file, click on File and select Save As. In Format, change it to Word 97-2004 Document(.doc) and check Append file extension. To set .doc as the default format, go to Word and select Preferences. Under Output and Sharing, click on Save and change the format to .doc in Save word file as. This video will benefit those viewers who want to learn how to save files in .doc format so that it ca...
How To: Use Excel for daily interest and monthly deposits
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
How To: Use autotune on Garageband with your Mac
Use autotune on Garageband with your MacFirst, create a new track. Click on real instrumental track. Create. Record your voice. Listen to the recording. Go to view, hide track editor. Go to enhance tuning. You can bring it to max for the TPain effect or choose the enhance tuning setting that you want. If you choose limit key, the program will keep you in the same key as your vocal key. (That was determined by the software.) For vocal effects, record a new track. Choose real instrument track, ...
How To: Make an animated GIF in Windows Movie Maker
SchizoFilms brings the viewers instructions on how to make an animated GIF in Windows Movie Maker. First open up Movie Maker. You will need to import pictures. To do this, click the button on the top left of the screen that reads 'Import Media'. Find your files here and import them into Movie Maker. Now, you will want to order the pictures in the sequence you want them to show up in. To do this simply drag and arrange them. Now, you can make adjustments for how long you want each to run by dr...
How To: Put your MS Access databases on your website
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
How To: Draw realistic hair in Photoshop
Stephanie Valentin will show you how to draw realistic hair in Photoshop. Add a new layer of paint to shape the hair, and do it with a round brush. Create hairs all around the shape with a smudge tool. Then add a new layer and draw a line with a soft round brush and smudge tool. Repeat the last step several times drawing more hair if you want. Add a new layer and add some light with a smudge brush and a round brush. When done, adjust the layer of opacity. Again, add another layer and add ligh...
How To: Put text on a curve in Corel Draw X3
This Corel Draw vector graphics drawing software tutorial shows you how to type text along a curve. Specifically you will learn how to draw a curve, and get text to follow the curve as part of making scroll saw patterns. If you are a pattern maker or not, you can learn how easy it is to put text on a curve in Corel Draw X3 in this video.
How To: Use Dreamweaver to add a Flash movie to your page
Is your webpage dull and uninteresting? How about adding a Flash movie to your page? In this video Terry White will teach you how to use Dreamweaver to do just that.
How To: Create custom exports in Final Cut Pro X
Frustrated by the lack of export options in Final Cut Pro X? Watch this video and learn how to create custom export settings. Using Compressor you can set the desired quality of your video exports from Final Cut Pro X.
How To: Produce a 3D house/building model using Maya
Autodesk Maya, affectionately known as just Maya to its users, is a 3D computer graphics software that makes it easy to create impressive, realistic models of real-life - or imagined - objects. Super useful for graphic designers, film makers and web designers, the program is one that you should study if you're looking to go into one of the fields above.
News: See the Famous Burning Monk in Shocking Color
In 1963 a Vietnamese Buddhist monk named Lâm Van Tuc burned himself to death on a busy Saigon road in protest of the persecution of Buddhists by South Vietnam's Ngô Ðình Di?m administration. Malcolm Browne's photo and journalist David Halberstam's account of the event circulated the world, winning both of them a Pulitzer Prize.
How To: Use ReDrum to load a .wav sample into Reason 4
So, you've got a copy of Reason 4 now huh? Congratulations, you own one of the most powerful music-making tools on Earth. It is infinitely complicated though, and getting started can be tough. Watch this video to learn how to load a .wav sample into Reason 4 using ReDrum, something you're going to be doing a lot of as you produce your tracks.
How To: Calculate future & present value for multiple cash flows 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the future and present values for multiple cash flows in Excel.
How To: Create an alpha channel in Adobe Photoshop CS5
In this video tutorial, we learn how to create an alpha channel within Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Make an image strip using FastStone Image Viewer
In this tutorial, we learn how to make an image strip using FastStone Image Viewer. First, open up the images that you want to have inside the strip. Then, open up Fastone Image viewer and find the location of the images. From here, go to "create", then "image strip builder". This will bring up the builder window where you can add in the images you want to see on the strip. When finished, click on the "create" button. Now, the strip will come up on your computer in a new image and you will be...
How To: Create a credit block at the bottom of a movie poster in Photoshop
Credit blocks appear at the bottom of nearly every mainstream movie poster (and even some indie films). This tutorial shows you how to create your own Hollywood-style credit block, from font to formatting, and shows you several different looks you can use.
How To: Animate a bouncing ball in Adobe Flash CS3
First go to import and click open external library and open your ball as shown before before and drag it to the library window. Now drag it to the first frame and insert key frame to 60 frame.
How To: Use and apply the Puppet Warp tool in Adobe Photoshop CS5
In this clip for Photoshop novices, you'll learn how to utilize the ever-popular CS5 Puppet Warp tool. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Make abstract waves in After Effects with the Trapcode Form plug-in
Creating an abstract wave effect in After Effects will allow you to make graphics like those in the thumbnail, basically clouds of particles with that smokey / silky effect like they used in James Bond titles. This video will show you how to make this effect yourself in After Effects in two parts. Apply this technique to your titles and they should be much, much sexier.
How To: Export a camera from Cinema 4D to Adobe After Effects
This clip presents a lesson in how to export a camera from MAXON C4D to Adobe After Effects. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
How To: Use the object axis tool in MAXON Cinema 4D
This clip presents a general introduction to the object axis tool in C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
How To: Create a simple growing tree animation in Cinema 4D
This tutorial will show you how to create a simple scene of a stylised tree growing out of the ground. You'll also learn a few settings needed to add snow to your scene, using PyroCluster. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using this trick in your own Cinema 4D projects, ...
How To: Add a title in Pinnacle Studio
In this tutorial, we learn how to add a title in Pinnacle Studio. First, click drag and drop your movie into the movie screen and then click on the "edit" tab. Now go to the left hand side and click on the "text" button. Go for a standard title, or whichever you prefer and click and drag that into the video screen. It will now be in front of your video. Double click the video screen and then edit the text to say what you would like. Next, click out of this and add a transition from the right ...
How To: Use the Eyedropper tool in Adobe Photoshop CS4 or CS5
The ubiquitous eyedropper is simple in purpose and easy to use. But imagine a world without it, where you had to dial in every one of the 16.8 million+ colors manually. The eyedropper is Photoshops color ambassador. 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 d...