Hot Software Posts
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: 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: Do matrix multiplication and inverse in MS Excel
This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...
How To: Create a sudoku puzzle in Excel with array formulas
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
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: Create dynamic sub tables 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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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: Double your kick drum in FL Studio
NFX shows you how to create secondary kicks, also known as doubling your kick drum using FL Studio (Fruity Loops).
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: Download Videos with One Click in Freemake Video Downloader
Looking for the fastest and easiest way to download videos from YouTube, Facebook, MTV, Vevo, and other sites? If so, read this guide. Freemake Video Downloader 2.1 offers a brand new mode to get web videos offline in a single click!
How To: Draw eyes in MS Paint
In this tutorial, we learn how to draw eyes in MS Paint. Start out by drawing the outline for the eye using a thin marker. After this, draw on a thicker line at the top of the eye and then draw on the crease of the eye above this. Now, draw in the details of the middle of the eye and start to shade in around the crease of the eye and the middle of the eye. From here, draw in the eyelashes on the top and the bottom of the eye, making them longer if they are for a woman. When finished, save thi...
How To: Use conditional formatting for a student grading report in Microsoft Excel
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
How To: Compress Mp4 videos in Sony Vegas Pro
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
How To: Build a conditional average calculation table in Exel
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).
How To: Find the average time between orders in an Excel sheet
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
How To: Use autotune on Garageband
Yes, you can use GarageBand's Auto Tune to sound like T Pain and Kanya West. To start with, in GarageBand, click the plus sign in the bottom left hand corner to create a new track. A window will pop up, Real Instrument Track should be selected by default. Click the Create button. In the Track Info window check to make sure your Monitor is set to On. In the bottom left hand corner, click on the button with the scissors in the middle of the sound wave. This is the Edit Track button. Click on Ad...
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: Create glowing skin in Photoshop
In this video tutorial, viewers learn how to retouch images to have a glamour skin glow, using Adobe Photoshop. The video covers all the effects and techniques needed to achieve the glamour skin glow look. Viewers learn how to retouch skin tones and hair for a glamour portrait, including airbrush techniques. Viewers will learn how to create that super color saturated, soft, diffuse skin glow. This video will benefit those viewers who use photoshop and like to enhance images to the best of the...
How To: Create a night vision effect in Photoshop
Don't know how to create the night vision effect using Photoshop? Well, this video is the solution for you. First of all, select the image that you want to create the effect on. Then you need to open up a new black and white adjustment layer. In the setting box that pops up, go under the preset drop down box and select red filter. Next, go down and check the tint box. After wards, the viewers can set their own photo and saturation base on their own preference.
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: Create JDF job definitions with Acrobat and InDesign
This video shows you how to create and edit a JDF (job definition format) in Acrobat to automate the print production process. You'll learn how to effectively submit a newsletter to a print provider. Check out this video created by Adam Pratt now! Create JDF job definitions with Acrobat and InDesign.
How To: Add fonts to Photoscape
Photoscape is a pretty sweet, free photo editing software. However, it comes with a limited number of fonts installed and you'll likely want to add more yourself. This how to video shows you step by step what to do to get additional fonts and then how to install them in Photoscape. This is an excellent video designed to expand a great piece of software by letting you add more fonts. You'll need an unzip prog like winzip or winrar to help you get it done.
How To: Create realistic smoke and dust particles in Maya
The key to being able to animate realistic smoke or dust is being able to master the particle texture rate technique in Maya. Once you have gotten this down, you can create any sort of particle effect, such as sand or bubbles in addition to smoke and dust. This three part tutorial series goes in depth into the subtleties of Maya, showing you how to get the most out of working with particles to lend an extra layer of realism to your project.
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: Create amazing 3D text in GIMP
In this tutorial, we learn how to create amazing 3D text in GIMP. First, start a new image with the width and height that you want. From here, select the text editor and then type in your text. After this, change the font to what you want and then change the size and color as well. From here, you will duplicate the layer and then go to layer, and then filter. Select the map button and then map the object. Select the text and then show the preview to make sure it's what you want. Change the or...
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: Calculate leverage and solvency ratios 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 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the debt ratio, debt to equity ratio, equity multiplier ratio and times interest earned ratio.
How To: Calculate cash flow from assets 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate cash flow from assets, cash flow to creditors and cash flow to shareholders using accounting financial statements.
How To: Use secondary animation when working in Autodesk 3ds Max
If you're designing a game character, you'll never want to have them stand perfectly still. They should breathe or fidget, just like regular people do. This tutorial shows you how to use secondary animation for your characters - make them move about a little bit, even when standing still.
How To: Navigate & use the Query by Example (QBE) interface in Microsoft Access 2007
In this clip, you'll learn how to take advantage of the Microsoft Access QBE interface. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, 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: Use the Ken Burns Effect in iMovie 09
First open up the image by clicking on photo button or just drag the image from finder to the project area. Now click on the crop button or just press the c button, you will see a green and a red area in your picture. Now set the red area to where you want to zoom in and green area to where you want to start your zooming. Now set the green and red area in the picture as showing in the video and play it, you will see that the picture is zooming to where the red area was set. Now change the ima...
How To: Enhance the color of your lips & eyes with GIMP
In this tutorial, we learn how to enhance the color of your lips and eyes with GIMP. To change the eyes, use the ellipse tool to highlight each individual eye, then change the contrast of the eye as well as the color and highlights. Do this for both eyes, then save. To change the lips, use the lasso tool to highlight the outside and inside of the lips, then go to "select", "from path", and then change the color balance as you did on the eyes. Change it until it's the desired color you want, t...
How To: Free space on your HD by deleting Vegas' temp folders
This clip presents an overview of how to delete files in the Sony Vegas temporary folders, freeing up space on your hard drive. 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: Create an spaceship with afterburner effect in 3DS MAX
Making a spaceship use its afterburner and escape from the Earth's gravitational pull is tough. Modeling and animating a 3D simulation of the same thing is also hard, although quite as much so. This video series will teach you how to create a 3D model of a flying rocket with an afterburner effect using 3D Studio MAX. At the end you will have a cool little video clip and vastly improved modeling skills.
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: Use edge loop character modeling in 3D Studio MAX
Edge loop character modeling in 3D Studio MAX allows you to create smooth, natural-looking characters. This video will introduce you to using edge loop modeling to model a character from a blueprint (get it here). This is one of the most fundamental techniques in 3D modeling, so get used to doing it!
How To: Create a split screen effect in Adobe Premiere Pro
Want to show two separate scenes at once? Learn how to create a split screen effect in Adobe Premiere Pro. Whether you're new to Adobe's popular non-linear editor 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: Create realistic boat-water interactions in 3ds Max
See how to simulate the interaction between a boat (a mesh) and water (a plane), creating the waves, ripples and particle splashes. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the application, you're sure to be well served by this video tutorial. For more information, and to get started using this effect in your own Max projects, take a look! Create realistic boat-water interactions in 3ds Max.
How To: Create an advanced Cherry 7-Up animation in Cinema 4D
In this advanced three-part tutorial, learn how to create a beautiful, sweeping animation for Cherry 7-Up. This animation is made using Cinema 4D and will take a bunch of cherries, have them swim together and form the logo for 7-Up. This animation is gorgeous and looks so professional that you'd think it was an official ad for the brand.