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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an 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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.
In this clip, you'll learn how to take full advantage of Magic Bullet Mojo when color grading digital footage within Final Cut Pro or Express. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
Need a primer on how to get started editing video within Final Cut Pro or Express? This clip will show you how it's done. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this 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 660th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a data set using Advanced Filter.
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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
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 654th installment in their series of digital spreadsheet magic tricks, you'll learn see when to use line charts and when to use an X-Y scatter diagrams.
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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter function.
Interested in tweaking skin tones when retouching digital portraits in Adobe Photoshop CS5? This clip will teach you what you need to know. Whether you're new to Adobe's popular raster graphics editing software or a seasoned 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.
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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
Meet the Avid Media Composer 5 Auto-Titler tool! 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 5 yourself, take a look.
Need a primer on how to set up automatic color correction within Avid Media Composer 5? Watch this helpful video guide. 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 5 yourself, take a look.
Need to know how to keyframe (or key frame) audio within Avid Media Composer 5? Never fear: this guide will show you precisely how it's done. 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 5 yourself, take a look.
This clip discusses how to perform trims with the Slip Mode in Avid Media Composer 5. 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 5 yourself, take a look.
In this video lesson, you'll see how to sort and navigate clips within Media Composer 5. 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 5 yourself, take a look.
This clip presents instructions on how to do A-side single-roller trims within Avid Media Composer 5. 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 5 yourself, take a look.
In this software tutorial, you'll see how to add a shot to a sequence with the Splice tool in Avid Media Composer 5. 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 5 yourself, take a look.
This clip presents a detailed overview on how to set up and organize projects within Media Composter 5. 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 5 yourself, take a look.
See how Lightroom 3 allows you to apply auto lens profile corrections directly to raw and non-raw images. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
In this tutorial, you'll learn how to digitally enhance makeup within Adobe Lightroom 3. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
This tutorial offers a general overview of the Lightroom 3 printing workflow. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
In this clip, you'll learn how to work with the Lens Correction features built into Adobe Lightroom 3. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
This clip offers a general introduction to the process of split toning within Adobe Lightroom. Whether you're new to Adobe's popular photo application or a digital photography professional just looking to better acquaint yourself with Photoshop Lightroom 3, you're sure to be well served by this free video software tutorial. For more information, as well as to get started using Lightroom 3 yourself, take a look!
This clip presents an overview of color grading footage shot with the new Canon EOS 5D Mark II Digital SLR (DSLR) in Apple Color. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the Final Cut Pro workflow, you're sure to benefit from this free video tutorial. For specifics, watch this Final Cut Pro lesson.
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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
In this clip, you'll learn how to go about creating behaviors for use within Apple Motion 4. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, and to get started using this trick yourself, take a look.
See how to use VBA to write a value to a cell within a Microsoft Excel workbook. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.
This clip presents a general overview of how to execute a VBA routine within an MS EXcel spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.
This video is not so much about the technical aspects of outdoor photography (desert photography, specifically) but rather about what to look for when taking pictures out in the wild.
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 638th installment in their series of digital spreadsheet magic tricks, you'll learn how to add two horizontal axes to a chart.
Learn how to create a full 3D model of a tornado within Blender 2.5. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
The value of having a good logo for your enterprise, no matter what it is, is not new and very great. Flash and other modern digital art tools have taken the art of logo creation to heights never before imagined. This video will teach you how to create a cool 3D logo using Flash CS3 and Swift 3D version 5. Brand yourself.
Thanks to the influx of purse-sized digital cameras and wads of blurry, hastily taken drunken photos posted on Facebook by partying college students, the quality of photography by the masses has gone down the deep end.
This clip presents detailed, step-by-step instructions on how to create level templates within Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started making your wn custom level templates, take a look!
Learn how to create animation rigs for creating 3D animations in Blender 2.5. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a look!
This clip presents a beginner
This clip presents a simple trick on how to do masks in the compositing editor, good for color grading and vignetting, not so much for the rest. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a look!
