Hot Software How-Tos
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: 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: 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: Remix popular songs in Audacity
In this Software video tutorial you will learn how to remix popular songs in Audacity. Open Audacity. Go to file > open and find your song for remixing. Then go to effect > change speed. Select a percentage change and click OK. You can change the pitch by going to effect > change pitch and select something and click OK. Play it and see what the pitch change does to the original and select the one that you like. Under ‘effect’ there are plenty of other options available like ‘amplify’,...
How To: Design and create a website with Adobe Dreamweaver CS3
Interested in creating your own website? Have access to a copy of Dreamweaver CS3? This video guide will get you started. Whether you're new to Adobe's popular WISYWIG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS3 workflow, you're sure to be well served by this video tutorial. For more information, including a step-by-step overview, watch this free video guide.
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: Use the SERIES chart function in Microsoft Excel 2010
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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart function.
How To: Create and use Xrefs when working in MAXON Cinema 4D
This tutorial looks at streamlining your C4D workflow, organizing your assets and working with groups. Xrefs can be incredibly useful and as well as helping you to stay organized can also hugely reduce hard drive space used. 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 tr...
How To: Design a soccer ball in Adobe Photoshop
Make a soccer ball in Adobe Photoshop! Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at IT Stuff TV. For more information, including step-by-step instructions on how to get started making your own custom soccer ball logos in Photoshop, watch this graphic designer'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: Force text formulas to wrap with Excel's CHAR function
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
How To: Change the pitch & formant of your voice with Audacity
Want to disguise your voice? With Audacity, it's a simple process. And this clip will show you precisely what to do. 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 video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.
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: 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: 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: Get auto tune (t-pain effect) in Audacity using gsnap
In this video tutorial, learn how to get auto tune, or the t-pain vocal effect, in Audacity using gsnap. To get the GSNAP (GSnap/Grymmjack skin), go here.
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: Value a stock with irregular dividend payments in Microsoft 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 67th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock with irregular dividend payments,
How To: Smooth proxy objects in Maya
ets face it: modeling in polygons in Maya is a rough way to make organic objects. In comes the smooth player: subdivision proxy objects. Learn how to model with the least amount of detail, but see your Maya model in all of it's quad-faced glory by using the subdivision proxy objects tool.
How To: Turn a male voice to female voice with Audacity
If you're a user of digital editing software Audacity, you already know you can do a ton of cool things. One of the cooler things you can do is changing a guy's voice to sound like a woman's. This is done with pitch control, or autotune, and will like you modify the voice by a number of octaves. I this video, rock band 30 seconds to Mars is made to sound like Avril Lavigne. Check it out! Of course, this can also be done with your own voice too!
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: 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: Make a voice sound deeper or higher in Audacity
Want to sound a little bit older? As if you've just inhaled helium? With Audacity, it's easy to manipulate or even entirely disguise a human voice. And this clip will show you just how it's done. 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 video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.
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: Compare two PDF documents in Adobe Acrobat 9 Pro
In this Adobe video tutorial the instructor shows how to compare two PDF documents. He says to go to the documents menu and choose the option to compare PDF's in Adobe Acrobat 9. This brings up a pop-up window where you can choose the files to be compared and all the various other options to choose from. This is the compare documents dialog box. Now he selects the old versions and new versions and performs other settings and shows how to perform comparisons. This video demonstrates the abilit...
How To: Delete the background of an image in Photoshop CS3
In this video tutorial, you'll learn how to delete the background of an image in Adobe Photoshop CS3.
How To: Generate a dynamic list from a table 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. In this Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
How To: Use Spotlight in Autodesk 3ds Max 2014
This 4th Chapter of Lights in Autodesk 3Ds max is fully concentrated on spot light. We will learn about the various spot light parameter of 3ds max like, Hotspot/Beam and falloff, then how to use overshoot or its limitations, how we can make the spotlight rectangular than circuler and many more. Hope you will enjoy.
How To: Make selections with Photoshop CS5's Refine Edge tool
Adobe Photoshop CS5 brings a very welcome change to Refine Edge. Edge Detection will help with much more detailed selections such as hair or fur. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
How To: Edit in storyboard mode in Corel VideoStudio
In this video tutorial, viewers learn how to edit in storyboard mode in Corel Video Studio. The storyboard mode is an alternative view for the time line. To switch to storyboard mode, click on the film strip icon above the time line. Storyboard arranges your project by element. To add a new element or transition in storyboard mode, click on the Edit tab and select the element or transition that you want by dragging it to the storyboard. This video will benefit those viewers who use Corel Vide...
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: 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: Create glass material in 3ds Max
Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...
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: Soften skin, control color & tones in Photoshop CS4
Learn about skin softening techniques and the controlling of color and tones when working in Adobe Photoshop! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started managing skin tones in Photoshop yourself, watch this designer's guide!
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: Create cartoon animation with After Effects
A lot of people use Flash for 2D cartoon animation, but Adobe After Effects is another great tool to create some very cool cartoon animation. This how to gives you a clear idea of the steps to take to use AE as a cartoon creation device. This short video tutorial will demonstrate how to properly export character animation from Flash and import it into After Effects to combine with background and foreground elements. It also gives a handy trick of how to duplicate a character animation clip to...
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: 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: 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.