Digital Downloads Search Results

How To: Get started using Avid Media Composer 5

Before you can work in Media Composer, you'll need to learn how to work with it. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid yourself, take a look.

How To: Create sparklines in Microsoft Excel 2010

Learn how to add sparklines to a Microsoft Excel 2010 spreadsheet. 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, and to get started using sparklines in your own MS Excel 2010 projects, watch this free video guide.

How To: Create a basic PivotTable in Microsoft Excel 2010

Learn how to create a simple PivotTable within Microsoft Excel 2010 spreadsheet. 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, and to get started using PivotTables (or Pivot Tables) in your own MS Excel 2010 projects, watch this free video guide.

How To: Freeze panes in Microsoft Excel 2010

Learn how to freeze panes when working within Microsoft 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, and to get started freezing panes in your own Excel 2010 projects, watch this free video guide.

How To: Insert SmartArt into Microsoft Excel 2010 spreadsheets

Learn how to add SmartArt to your Microsoft Excel 2010 workbooks. 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, and to get started using SmartArt in your own Excel projects, watch this free video guide.

How To: Add numbers with SUM and AutoSUM in MS Excel 2010

Learn how to add numbers using the SUM and AutoSUM functions within Microsoft 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, and to get started using the SUM and AutoSUM functions in your own Excel projects, watch this free video guide.

How To: Use the Backstage view and File tab in MS Excel 2010

Learn how to use the Backstage view option when working in Microsoft 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, and to get started using the Backstage view and File tab in your own Excel projects, watch this free video guide.

How To: Create fern leaves within Adobe Photoshop CS4 or CS5

Learn to create fern leaves by using custom brushes and adjusting brush settings along paths. 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 making your own digital fern leaves in Photoshop, take a look!

How To: Remove spaces from a Microsoft Excel 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 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.

How To: Edit pictures within Microsoft Excel 2010

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.

How To: Create dreamy illuminated scenes in Adobe Photoshop

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.

How To: Apply three-step processing in Adobe Photoshop

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.

How To: Apply automatic lens correction in Adobe Photoshop CS5

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.

How To: Organize your iTunes music on a Mac

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.

How To: Import Flash into the PDF file format

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.

How To: Make digital clear plastic tape in Photoshop

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.

How To: Remove DRM on your Kindle

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!

How To: Manipulate time with elastic audio in Pro Tools 8

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.

How To: Use the content-aware fill tool in Adobe Photoshop CS5

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.

How To: Calculate bonuses based on years worked 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 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.

How To: Allow only Monday dates in a cell in Microsoft 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 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.

How To: Count with four criteria in Microsoft 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 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.

How To: Count times exceeding 5 minutes in Microsoft 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 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.

How To: Retrieve multiple values from a horizontal Excel 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 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.

How To: Filter data in eight different ways in Microsoft Excel

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.

How To: Reference worksheets and workbooks in Excel 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 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.

How To: Multiply & sum arrays with Excel's SUMPRODUCT

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.

How To: Create projections for sales numbers in MS Excel

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.

How To: Calculate future value for an annuity 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 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.