Active Software Posts
How To: Make a Resident Evil-Style Virus Graphic in Photoshop
Learn how to make a "Resident Evil"-style Biohazard Virus with nothing except the brush tool and layer effects in Photoshop. Use adjustment layers to create extra grain and contrast to your made from scratch hi-res microscopic bacteria and learn more about those brush tool options you didn't know about.
How To: Use the Quick Properties tool in AutoCAD 2011
Learn how to use the ever-useful Quick Properties tool in AutoCad 2011. This clip will teach you everything you'll need to know. Whether you're new to Autodesk's popular 3D drafting application or a seasoned professional just looking to better acquaint yourself with the newest iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
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: 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: Summarize data from multiple sheets in Microsoft 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 Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
How To: Track a stolen laptop with Adeona
This software tutorial will show you how to track a laptop if it gets stolen using free tracking software Adeona. Of course, it's a good idea to figure out how to keep your laptop from getting stolen, but if you lose it, you can use Adeona to find the location of your laptop.
How To: Remove Vocals from Songs Using Audacity
Need to remove the vocals from a song? Audacity just might be the answer. It's one of the few free audio editing programs out there with many, many features, making it simple to create a track for karaoke or simply to listen to an instrumental version.
How To: Resize an image in MS Paint without losing resolution
In this video, we learn how to resize an image in MS Paint without losing resolution. First, you will go to the file menu and then open. From here, open up the photo you want to resize. After this, go the 'image' section on the toolbar and then click 'stretch and skew'. From here, change the vertical and horizontal stretches until you have the size of picture that you want! Continue to play with it until it's right and then save this over again. This should only take a few minutes and will ke...
How To: Unclothe People in Photoshop
Have you ever wanted to prank your friends by showing pictures of them naked? By learning these easy graphics editing techniques in Photoshop, you can quickly make people shirtless or nude in fake photos.
How To: Make Someone Look Skinny with the Liquify Tool in Adobe Photoshop
Want to know how to remove a digital tag from a garment for (in this case) a pair of shoes? This clip will teach you what you need to know. 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.
How To: Bruise Someone in Photoshop
Whether you need to create realistic-looking bruises for a Halloween photo or need to look beaten up for a film project you're completing, sometimes you just need to add a few brown and purple spots to your face.
How To: Lose Weight by Using Photoshop
This video shows the method to do weight loss using Photoshop. Open the image and go to 'Filters' and 'Liquify'. Click on the 'Forward Warp Tool' on the left. Zoom into the back area and drag the mouse in towards the body to make it thin. Keep the 'Brush Pressure' high to get a sharp result. 'Brush Size' determines how large the brush is and the area affected by it. Use the 'Pucker Tool' and click on the ass to reduce it. Reduce the sides of the ass with the 'Forward Warp Tool' and reduce the...
How To: Create an Noumi anime forum signature in Photoshop
This simple Adobe Photoshop video based signature tutorial, teaches you how to create a simple effects in a forum signature.
How To: Export video from Adobe Premiere Pro CS3
Once you've created and edited a project in Premiere Pro to your heart's content, it's time to export that video so you can watch it outside of your editing console. This video will teach you how to do just that in Premiere Pro CS3 quickly and easily. Make sure your video looks as good as humanly possible using these tips.
How To: Use comparative operators in logical formulas 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
How To: Insert or delete footnotes & endnotes in MS Word 2007
In this video tutorial, viewers learn how to insert or delete footnotes or end-notes in Microsoft Word 2007. A footnote is a little reference which will place a small number in subscript and link it to a comment. A end-note is similar except it links the comment to the end of the document, rather than the end of the page. Begin by highlighting the text. Then click on the Reference tab and select Insert Footnote/End-note. Then just add a comment to the subscript. This video will benefit those ...
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: Create a Twisted Wire in Illustrator
This Illustrator tutorial shows you a way to make a double helix or twisted wire. Using Illustrator and the powerful pattern brush, Bert takes us through the steps from a wavy line to a realistic wire effect or double helix.
How To: Create handwriting in After Effects
In this Adobe After Effects tutorial, the instructor shows how to generate a hand writing effect. First, open Adobe After Effects. To do this effect, you need to use the Pen tool, which is a very good feature. Go to File menu, select new then create a new project. Go to composition and select a new composition. Right click and fit it to 100%. Go to the text tool and select a box on the composition and write something that you want. Apply a desired color and font to it. Select the text box, go...
How To: Create slow-motion or fast-motion videos in Sony Vegas
Interested in creating a slow- or fast-motion effect in Sony Vegas? This clip will show you how it's done. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.
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: 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: Extract part of a table from a larger table in 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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
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: Get the CD Product Key or Serial Off of Any CD
This will allow you to find the CD product key or serial if you have lost it so you dont have to buy another CD.
How To: Apply the Chroma Key Effect in Movie Maker
Open windows movie maker and take any video which has the background of same color. Drag and drop the video on to the time line. Then go to tools > video transitions and take the chroma key and drop it between the two videos. The chroma color should correspond to the background color of the video. After this, save the movie file. To pick the right color for the background, download Debug mode wax. This will help in creating some home videos with special effects.
How To: Convert Videos to Different Formats for Free with Format Factory
In my last article, I discussed how you could download almost any video from almost any video sharing site using the free NetVideoHunter add-on in Mozilla Firefox. Now in this article, I will discuss how to convert those videos you’ve downloaded to any format—also for free. Most of the time, the videos you download with NetVideoHunter are in FLV (Flash video) format, which is something that not all video players can play. That’s why I made this article.
How To: Create a time lapse in Sony Vegas Movie Studio or Pro
In this clip, you'll learn how to use Sony Vegas to compress hours of footage into the space of a few seconds. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.
How To: Remove (detach) audio from video in iMovie
If you've imported some video footage into iMovie, but want to use the sound elsewhere, like in GarageBand, you're going to have to detach the audio from the video. This tutorial will show you how to remove the audio from an video clip in iMovie in Mac OS X. Detaching audio is very simple, so don't worry!
How To: Automatically Hide the Ribbon Menu System in Excel
Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the le...
How To: Make your own music mixes on your computer for free
There are many music programs beyond Audacity which you can download for free, and which will allow you to mix and edit your own music. This tutorial shows you where to get these programs, like ROC, Myna, FreeSound and FlashKit, and how to use them for your own projects.
How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
How To: Conditionally format cell data bars in MS Excel 2010
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel 2010 video tutorials, you'll learn how to apply conditional formatting to cell data bars.
How To: Save Your Word Document as PDF with One Click (Using a Macro)
In this article, we're going to create an additional button in our Word toolbar which creates a PDF file of our loaded file with one simple click. We are going to use the function to create Macros, which are little 'programs' in
How To: Remove Vocals from MP3s Using Audacity
Want to create an instrumental or a cappella from a song? Learn how to remove vocals or instruments from MP3s using a freeware program called Audacity for Windows, Mac, and Linux.
How To: Overlay photos on video and overlay video on video using iMovie
Watch this video tutorial to learn some very useful tricks in iMovie. In this video, you'll learn how to overlay both photos on video and also overlay video on video using iMovie. In addition, you'll learn how to turn on the greenscreen tool.
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: 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: 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: Code a real-time chat application using Adobe Flash CS3
Add a chat program to your website and allow the logged in users to talk to each other! You can write this program using Adobe Flash CS3, PHP and MySQL. This tutorial shows you how to write your own Flash chat program incorporating all three systems.