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 Make Anything demonstrates how to make a freeze frame in Sony Vegas. You can go to the preview window and click on save snapshot to file. The program will then create a jpeg which you can lay into your video to create a freeze frame. You can also use Vegas' velocity envelopes to create a freeze frame. First, zoom into your video in the timeline so that you see each individual frame. Make sure that quantize to frames is toggled in the options menu. Then, hit S to split the video. Right ...
One of the most suggested topics on youtube for Photoshop is enhancing breast size. Sending an image to someone & need to alter it? Want your boobs to look bigger? Or do you just want to have some fun giving girls bigger boobs on Photoshop? This tutorial demonstrates how to increase breast size using Photoshop.
In this little video tutorial, kaje01 demonstrates both the basic edit and advanced techniques for applying the "x-ray" effect using GIMP. Now, what is there to x-ray? Hmm...
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.
Start with a photograph of a woman in a bikini. Open the picture in Adobe Photoshop. Now, learn how to use the Bubbles effect to make it look as though your model is not wearning anything! All you need is a little familiarity with Photoshop, since you will be working with layers and a few more advanced tools in the program. And make sure not to use your photograph to any nefarious purposes - this tutorial is just for fun, only!
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...
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.
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?!
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 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.
NFX shows how to split tracks into WAV files using FL Studio. You would do this to send your song to a professional mixing engineer or maybe to collaborate with a non-FL user. Split tracks can be used in Protools, Audition, etc., but are demonstrated here in Fruity Loops.
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.
Photoshopuniverse shows how to remove JPEG Artifacts in photoshop. It's simple. Sometimes it happens that, you get the best picture which is related with your work, but unfortunately its low quality or small. If you zoom in a small picture it will pixilated. You will see some blocks. Luckily there is a way to remove it from photoshop. Go to- filter, then noise, then reduce noise. There will be an options of removing JPEG artifact. Check that. After watching the video you can remove JPEG artif...
If you're thinking about getting a piercing, but aren't sure how it will make you look, you can use a program like Photoshop or GIMP to edit in a fake piercing. Start with a photo of yourself, with the area you are considering piercing shown prominently. Then find a picture of someone with the same kind of piercing that you want, and then use some of the editing tools and tricks in photoshops to see how it will look on you!
Don Schechter explains how to capture your footage from your camera to your computer and log it for easy access later on. You can use Adobe Premiere to capture your movie, but you can not forget to put your tape in your camera.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.
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...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
GarageBand is a powerful tool for Mac OS X that lets you edit and tweak audio tracks. One of the many audio editing capabiltiies of the program is the ability to reduce the vocals in a song. Take a look at this guide on how to edit the song's vocals so they aren't so loud using the AUGraphicEQ tool.
Bill Myers shows you a quick solution to the media offline problem in Sony Vegas and Sony Movie Studio.
Learn how to add effects to instruments and vocals in this FL Studio audio production tutorial. Make sounds have more depth or tweak them for whatever musical needs and get a basic overview of mixing and mastering in FL Studio.
Learn how to round dates and times to a given interval in MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
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 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
Learn how to use the blur, smear and sharpen tools in Autodesk SketchBook Pro 2010. Whether you're new to Autodesk's popular raster graphics editor or a seasoned graphic artist merely looking to better acquaint yourself with SketchBook Pro 2010, you're sure to be well served by this free video software lesson from the folks at Lynda. For more information, take a look.
In this video from solvingtime we learn how to remove objects from photos using Paint. To get this program go to to install it. He uses the clone stamp tool to remove things. First he zooms in on the object he wants to remove using the magnifying glass. Then click the stamp which will switch to the clone stamp tool. Use the bracket keys near the letter P on the keyboard to adjust brush size. Then while holding the control key click once on an area near the object you wa...
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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).
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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.
This simple After Effects tutorial from Laurence Grayson will show you how to use CC Ball Action effect in AE to create a realistic scrolling LED signboard effect, like the ones you see at conference centers and football stadiums. Then end result can be altered to suit your project, and corner-pinned into a scene. There are no plug-ins required, and this method uses the standard toolset in CS3, CS4, and CS5.
There are several ways you can go about creating your NURBS helix curve in Maya; I will demonstrate the two easiest ones.
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 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an interest-only loan schedule in Excel.
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.
In this tutorial Bill Myers shows you how to use Pan & Crop to zoom into or add motion to photos in Sony Vegas Pro or Movie Studio.
Learn how to make a fancy border in GIMP with this GIMP tricks video tutorial. This border can be used to frame images for YouTube videos or other things. Take your image, and go to Image and Canvas Size. The size should be made larger to allow room for your border and then click Center. On Layers, select All Layers. Then, click Resize. This allows you to make room for your Layer. On the far left side, right click on your layer and select Alpha to Selection. Go to Select, To Path, Select, and...
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...
One is the loneliest number there is. Well, unless you clone yourself! This sweet video will show you how to do just that with Apple's iMovie. You'll need iMovie 11, or iMovie 09. This technique is also possible by using other video editing software tools as long as they are capable of doing blue screening or green screening. In addition, you'll need a sturdy tripod that you DO NOT move. This is essential to creating the effect. If you move the tripod, this effect will NOT work, or come off a...
To get autotune on Audacity, you will need to have the 1.3.10 beta version from Audacity's website. Verify that you have autotune or G-snap in the plug-ins. You may need to download G-snap from the internet. First, open up Audacity. Then, go to edit and select preferences. Go to effects and click rescan BST effects next time Audacity is started. Then, click the okay button. Close out of Audacity and then reopen it. The program will then import your new files. Your new files will then show up ...
This FL Studio tutorial details how to compose a basic drum beat or loop.
Sometimes, you want to focus the attention of your viewer on a particular aspect of your image, or get rid of extraneous or distracting details. This retouching tutorial shows you how to use Adobe Photoshop to reduce detail and simplify your selection without losing much meaningful content overall.
If you're using Adobe Illustrator CS4, you know that cropping an image can be less than a simple task. This how-to walks you through the steps, not only showing how to place and move the image, but also how to crop it to the desired sized. Unlike Photoshop which allows you to work directly with pixels, Illustrator treats all images as whole objects. SO, watch this video and end the frustration that Adobe Illustrator can bring when you're cropping an image.