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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Learn how to work with digital images within MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started editing pictures in your own 2010 worksheets, watch this free video guide.
Looking to add to your digital bag of tricks? In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to to take any photo and transform it into a dreamy illuminated scene using Camera Raw, Smart Objects, and a little creative brushing. For detailed, step-by-step instructions, and to get started using this eye-popping effect yourself, watch this video lesson.
Fancify your digital images in three easy steps! In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to take any ordinary photograph and spice it up with three-step processing. For detailed, step-by-step instructions, and to get started using this technique yourself, watch this video lesson.
Want to correct for lens problems after the fact? With Adobe Photoshop CS5, it's easy. 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 video tutorial. For more information, and to get fixing lens flares and abberations in your own digital images, watch this video lesson.
If you are looking for a cool new way to hustle free drinks at the bar or cash from your friends, check out this tutorial. In this video, you will learn an incredibly interesting trick using just whiskey, water, two shot glasses and a card or driver's license. Bet a friend that you can make make water and whiskey switch shot glasses without pouring or dumping either glass.
Music a mess? iTunes comes with a number of built-in organizational features to help you sort that problem, and your tracks, out. This free video software tutorial from MacMost will ensure that you know everything required to manage your digital music library. For specifics, and to get started organizing your own iTunes library, watch this Mac user's guide.
One of the advantages of using the Adobe family of creative products is that its many programs can be combined easily to create cool digital multimedia projects. This video tutorial teaches you how to integrate .swf files from Flash into .pdf files in Adobe Acrobat Pro 9. Including Flash in pdf files makes it easier for people who don't have the appropriate Flash players on their desktop to view the great images that you've made in Flash.
Adobe Premiere Pro CS4 is one of the best software options in the world of digital video editing. This video tutorial explains how to publish and export your projects using the Adobe Media Encoder part of the larger Premiere Pro CS4 program.
Adobe Premiere Pro CS4 is one of the most powerful digital video editing tools ever created. This tutorial is meant as a tutorial for those unfamiliar with the program, covering many of the basics including how to create a new video sequence and edit the quality of the video that you are creating.
Making digital objects move the way you want them to is one of the greatest challenges in all of computer programming. This video will help you to manage one aspect of this problem, making a ball bounce in Flash CS4. Not only does this video show you how to do it, it does so in less than 2 minutes! What more could the aspiring computer animator in a hurry ask for?
Your mother has put up with your crap all these years, so why not repay her with a long-lasting Mother's Day gift? Learn how to make a twisted origami flower that can be turned into a pin or even a hair decoration by watching this video.
Want to give your images a distinctly analog feel? Give this Scotch tape effect a try. 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 TutVids. For more information, including step-by-step instructions on how to create a transparent tape effect in Photoshop, watch this graphic designer's guide.
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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND function.
Naruto is one of the most popular mangas and animes in the world, especially among children. This video tutorial demonstrates how to draw the character Anko from the series using a tablet and Adobe Photoshop. It is very detailed and sure to improve your digital art skills.
You've got a Kindle, and you've bought your first ebooks! Did you know that you don't have complete control over those books you bought? Amazon restricts your use of ebooks with DRM, or Digital Rights Management, that prevents you from transferring your purchases to other devices, or copying them. Watch this video to learn how to strip your Kindle ebooks of the DRM, and really own your content!
Want to speed up or slow down an audio region while leaving its timbral characteristics alone? Whether you're new to Digidesign's Pro Tools digital audio workstation (or DAW) or just want to learn how to take advantage of Pro Tools 8's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. Specifically, this software tutorial provides a complete overview of how to use Pro Tools' Elastic Audio feature to time warp audio regions.
Looking to add specimens to your paper menagerie? Make a butterfly with origami, the traditional Japanese art of paper folding. This free origami video lesson presents complete instructions for making your own butterflies from a sheet of folded paper. These are great for taping to greeting cards or adding to letters. This shape is a bit advanced so be sure to practice on simpler shapes first. For more information, and to get started making paper butterflies yourself, take a look!
Whether you're new to Adobe's Creative Suite or a seasoned digital video professional after a general overview of Adobe Premiere CS5's most vital new features, you're sure to be well served by this from the folks at Lynda, which presents a detailed, step-by-step overview of how to take advante of Premiere CS5's script-to-screen workflow.
Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of Adobe Photoshop CS5's most vital new features, you're sure to be well served by this from the folks at Lynda, which presents a detailed, step-by-step overview of how to use Photoshop's new content-aware fill tool to selectively and seamlessly erase material from a digital image.
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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT functions.
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.
"Soul Man" was one of the biggest hits of 1967, and still holds its ground in success. Sam & Dave's hit single, written by Isaac Hayes and David Porter, will forever live on in the music world, and through you… if you play bass. This video is a beginner's lesson to bass guitar, which teaches you how to play the baseline for "Soul Man" by Sam & Dave, with the baseline perfected by Duck Dunn. This is a good bass line for beginners who've played for a bit to get their fingers around.
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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY 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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
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 6th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to retrieve the last value in a row.
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 very first installment in their joint series of digital spreadsheet magic tricks, you'll learn how to do a two-way lookup on a table array.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.
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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
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 60th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for an annuity.
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 61st installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions PV and PMT to make a present value calculation for an annuity.
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 33rd installment in his "Excel Business Math" series of free video lessons, you'll learn how to add current stock prices to a stock analysis table in Excel using a web query.
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 44th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with series trade discounts in MS 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 38th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate gross and overtime pay in MS Excel.
