Active Software Posts
How To: Get Downloaded Music Playlist Files (M3U or M3U8) to Work with Your Media Player
A playlist is simply a list of songs which can be played in sequential or shuffled/random order. Many people tailor-make playlists to suit a particular style of music or atmosphere, so being able to share these between people is great.
How To: Make a song acapella using Audacity
Highly produced and vocoder-heavy songs are the musical signs of our time, but there's nothing that beats the raw power of an a capella tune. If you want to make a song you recently recorded (or a song you like) a capella, then watch this tutorial.
How To: Make an intro animation using Adobe After Effects
Check out this tutorial and learn how to make a cool, slick intro animation for your YouTube videos or website. You will be using Adobe After Effects to make this effect and this clip will walk you through all of the steps. Check it out and brand your YouTube channel like a real TV program.
How To: Automate a process using a script in Sony Vegas
HowToMakeAnything describes how to make Script work in Sony Vegas. Script is a way of automating a normally cumbersome process. Select events from Cursor, add regions to add, fade effects etc to the clip. That may also be selected from Tools Menu, then Scripting. Drag the desired two or three scripts to the folder of Script menu in Sony Vega Pro 8 available in C drive and rescan script menu folder. It is to be noted that adding hundreds of clips can also be done to the folder if one so desire...
How To: Master advanced mixing techniques in Logic Pro
Make your mix sparkle with Logic Pro! Learn how to use Logic Pro 8 software to fine-tune your music mix in this free music production tool from a professional audio engineer.
How To: Extract records that meet certain criteria 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 Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
How To: Fix common Excel spreadsheet problems & errors
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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.
How To: Draw fire and flames in Adobe Illustrator CS4
See how to create a vector flaming box in Adobe Illustrator CS4. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.
How To: Make basic animation or moving images in Photoshop
This video shows the process of making animations in the image program Photoshop. It shows users how to open up and navigate the animation dialogue box in Photoshop by adding frames with variations on the image to be animated, with attention to using as many frames as needed to ensure a "clean" looking animation (one that is not jumpy but rather has smooth transitions). In closing, the instructor shows its viewers which options to select on the animation settings (particularly noteworthy is t...
How To: Use Kuler color themes in Adobe Photoshop CS4
Adobe Photoshop CS4 is the industry-standard software for perfecting digital images and is ideal for professional photographers, serious amateur photographers, and graphic designers. In this Photoshop tutorial, you'll learn how to use Kuler themes in your Adobe Photoshop CS4 projects. Use Kuler color themes in Adobe Photoshop CS4.
How To: Smooth shade (Gouraud) objects in Maya
Smooth shading and make all the difference in the quality of your graphics - this is especially true with the increasingly popular HD video and computer formats. If you would like to know how to use Maya to smooth and shade your objects, follow along with this video. You will get a step by step walkthrough.
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: Add Fireworks to Any Night Picture in Photoshop
Going to miss the fireworks extravaganza this Fourth of July? Doesn't mean you can't fake the experience, and that's exactly what we're going to do here—in Photoshop. You're going to learn how to take any night photograph and insert fireworks into it. It's the next best thing to watching some fireworks display firsthand.
How To: Remove unwanted objects with the Spot Healing Tool in Photoshop Elements 9
Use the Spot Healing Brush Tool in Photoshop Elements 9 to remove power lines, trees, cars, even your Aunt Marge. If it's in the picture and you want it out, this simply tutorial will show you how to do it.
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: Record HD widescreen in Camtasia
First open up the Camtasia studio and click on the link make a recording. It will open up the Camtasia recorder but before you start the recording you need to click on the tools, options and make sure the "save as AVI" is selected in file menu. Then click on video tab and select the "manual" in "video configuration", 30 in frame rate and click ok. Now download and install the software called "free sizer". Now we need to set the recording area to 1280x720. To do that, right click on the maximi...
How To: Calculate a bonus 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.
How To: Create a 3D page flip effect using Flash CS4
The 3D page flip is one of the coolest and most underutilized effects that you can put on your website using Flash CS4. You may also know it from the iPod interface. This video will teach you how to create the effect yourself with Flash and Actionscript 3, giving your websites greatly increased accessibility and flair.
How To: Create sparkles in Illustrator
Want to create some cool effects in illustrator? Create a new layer. Draw the ellipse tool and add radial gradient, then go to transparency and select screen. Then create the star tool and deselect stroke. Drag and place the star shape on ellipse and group them. Then duplicate that layer to make multiple sparkles on different layers. Resize other sparkles by holding down shift key. One can change colors of other sparkles. This will help you in making a good background.
How To: Create a multiuser login system in Microsoft 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 creating a multi-user login form to password protect different areas of your database.
How To: Add text titles in Sony Vegas & Movie Studio
Learn how to quickly add text titles and lower third graphics to your video editing or motion graphics projects in Sony Vegas and Movie Studio with this tutorial from Bill Myers.
How To: Convert a Vector Logo to a 3D Logo with Cinema4D
In this tutorial, Broadcast Designer Jason Brown will show you how to knock out a vector logo from Adobe Illustrator into a 3D logo in Maxons Cinema 4D. The tutorial also touches on basic texturing, lighting and animation.
How To: Return and get a refund for a song or App in iTunes
One of the best (for Apple) and most dangerous (for you) features of the iTunes media distribution system is that it allows you to buy things with a click of the mouse that are delivered to you instantly. The potential for making rushed buying decisions that you'll regret later is massive. Fortunately, and not many people know this, you can actually return content that you've purchased from Apple to them for a refund! This video will show you the process for returning and getting refunds for ...
How To: Model arm muscles in MAXON Cinema 4D
This clip presents a walkthrough of how to model and rig a muscly arm within MAXON 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 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: Register & activate PreSonus Studio One online or offline
In this video tutorial, we learn how to register and activate Studio One either over the Internet or offline. Whether you're new to PreSonus' DAW or new to digital recording more generally, you're sure to find much to take away from this free video software tutorial. Take a look.
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: Bypass the Password Login Screen on Windows 8
It's good to password-protect your PC to make sure that your personal files, folders, and important documents are safe and can't be modified without your permission. Though, entering the password all of the time before using your computer might frustrate you.
How To: Get last price in an Excel column based on criteria
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
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: Compare two tables and list unique items 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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.
How To: Blur out a car's license plate in Final Cut Pro
In this tutorial, you'll learn how to blur out a couple of car number plates in a static shot in Final Cut Pro. Whether you're new to Apple's Final Cut Pro non-linear video editor or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial. For specifics, including detailed instructions, watch this Final Cut Pro lesson.
How To: Create Excel formulas to solve business math problems
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 207th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up and solve a business math word problem in Excel.
How To: Make a six pointed star using the tools in Adobe Illustrator 5
This tutorial shows you how to use the star took and a few other basic functions with Adobe Illustrator 5 to replicate the Star of David on the Israeli flag. Master a few basics of image manipulation with this tutorial.
How To: Turn a 2D still image into a 3D space using After Effects
This tutorial shows you how to replicate a popular Hollywood technique. It can be difficult to get the camera projection look with an actual camera, but Adobe After Effects has an easy alternative. Turn any 2-D still image into a dynamic 3-D clip.
How To: Get an iTunes account without using a credit card
Do you want an iTunes account, but either lack a credit card or the desire to give Apple your credit card information? Well, there's a way you can get around the part of the iTunes account creation process where you enter your credit card.
How To: Make clothing see through in Photoshop
In this video tutorial, learn how to make any piece of clothing on a man or woman invisible.
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: Use After Effects CS4 Mocha
Mocha is a cool new piece of software that is included in the After Effects CS4 bundle. Mocha is a planer tracking system that works as an assistant when doing things like creating and adjusting screens. See how to use Mocha in this After Effects CS4 tutorial and make tracking in After Effects a whole lot easier. Use After Effects CS4 Mocha.
How To: Create a form in Dreamweaver CS3
This video shows you how to add form fields to a form laid out in a table in Dreamweaver CS3. You use text fields and a menu to gather user information, populate a menu with values, and add a button to submit information. Create a form in Dreamweaver CS3.