Learn how to utilize Adobe Photoshop CS5's new content-aware fill feature to remove and replace existing backgrounds within your digital images. 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 started using the content-aware fill tool for quick, seamless edits, ...
See how to turn a digital photo into an infinitely scalable vector cartoon. 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.
Learn how to artificially age your digital photographs using a number of common filters in Adobe Photoshop CS4. Whether you're new to Adobe's popular graphic editing program or a seasoned design 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.
See how to apply custom picture styles in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Learn how to add digital media and effects to the After Effects CS5 timeline. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with CS5's new features, you're sure to be well served by this video tutorial. For more information, and to get started familizaring yourself with the After Effects CS5 workflow, watch this free video guide.
Learn how to use After Effects CS5 to edit your digital video. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with CS5's new features, you're sure to be well served by this video tutorial. For more information, and to get started familizaring yourself with the After Effects CS5 workflow, watch this free video guide.
Microsoft PowerPoint 2010 includes more than just a host of new features, it also offers a significant number of new presentation themes. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using PowerPoint 2010's new themes in your own digital slideshows, watch this free v...
Photoshop CS5 brings a great new way to reduce noise in your images. Noise Reduction within Camera Raw works wonders! 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.
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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to build a pivot table to calculate year over year sales showing percentage change.
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 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.
Organizing your photos in iPhoto 09 is a breeze provided you know how to take advantage of the program's various features (like, for example, keyword tagging). This free video software tutorial from the folks at MacMost will get you off and running. For specifics, and to get started organizing your own photographs, watch this iPhoto user's guide.
Color correct your digital photos in Adobe Photoshop Elements! 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 adjust an image's color balance using a levels adjustment layer in Photoshop Elements, watch this PSE guide.
With photo labs around the world closing in the wake of the digital camera revolution, knowing how to develop your own film at home is more important than ever. This video teaches you how to develop one type of film, C41, at home using a kit. Even when there are no more photo labs left, you will still be able to make beautiful still prints from film at home after watching this video.
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to generate an X-Y scatter chart in Microsoft Excel.
One of the many significant problems with Apple's ubiquitous iTunes music player and iPod MP3 players is their lack of native support for FLAC, the highest-quality type of condensed digital music file. This video features step-by-step instruction for converting your FLAC files into ALAC files, which have similar quality and can be played on on your iPod.
This tutorial demonstrates for the budding digital artist how to draw a realistic face in Paint on their computer. The figure still has a bit of an amine / manga look about its eyes, but the other facial proportions are spot-on and sure to impress, especially when attached to a body.
Want to extract an image from its background? In Adobe Photoshop, the process is simple. So simple, in fact, that this free video software tutorial can present a thorough and complete overview of the process in just over five minutes' time. For detailed, step-by-step instructions, and to get started extracting foreground from background elements in your own digital images, watch this helpful guide.
Marvel comics have been a major inspiration to a whole generation of artists, particularly graphic novel and comic-inclined artists working in pen and pencil or digital mediums. This video demonstrates some cool techniques for drawing hands in Paint on the computer, with a focus on how to properly use lines to make the hands look more realistic.
Want to selectively adjust the timing of an audio region? 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 warp markers to manipulate timing in your Pro Tools projects.
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 apply HDR toning to your digital photographs in Photoshop CS5.
Fancify your slideshows with Apple Aperture 3. Whether you're new to digital photography or merely unfamiliar with Apple's Aperture 3, you're sure to benefit from this free video software tutorial from Lynda, which presents a thorough, step-by-step overview on how to set up complex slideshows within Aperture 3.
Ferret out any pixels with clipped highlights in Aperture. Whether you're new to digital photography or merely unfamiliar with Apple's Aperture 3, you're sure to benefit from this free video software tutorial from Lynda, which presents a thorough, step-by-step overview on how to automatically highlight hod and cold areas within Aperture 3.
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 591st installment in their series of digital spreadsheet magic tricks, you'll learn how to add $600 to a lot of numbers all at once by using paste special operations add.
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 594th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate age in years using the TODAY and DATEDIF 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 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.
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 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX 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 and Mr. Excel, the 4th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create charts to compare data values.
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 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.
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 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.
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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.
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 54th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to find, download and use VBA code in your MS Excel projects.
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 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...
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 24th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn see exactly how Excel calculates/evaluates formulas including things like intersections, unions, negation, text operators and comparative operators. Knowing the o...
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 50th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to value an asset as well as perform discounted cash flow analysis with the Excel functions PV, NPV & XNPV.
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 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.
