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.
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 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.
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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.
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 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...
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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with 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 160th installment in their series of digital spreadsheet magic tricks, you'll learn how to find all the occurrences of a word, number, format or formula and then change or replace all of them! See how to use the Find and Replace feature in Excel with this free video tutorial.
The best way to transfer contacts from a computer to an iPhone is to use Mobile Me, formerly known as Dot Mac, which automatically synchronizes Outlook or Entourage with the iPhone. Keep track of contact information, on both the computer and the iPhone, with tips from a digital technology specialist in this free video on the iPhone.
New to the ukulele or simple looking to add to your bag of tricks? This two-part video tutorial series enumerates a number of tips and techniques that will add color to your ukulele playing. Become a better ukulele player with this free video lesson series.
French tips are timelessly elegant for a reason: they're simple, very minimal and understated, and very feminine without being overdone. But sometimes doing the same white French tips over and over again gets a little dull.
In this tutorial, Nancy goes over the star tip. The star tip is the most popular tip used for cake and cookie decorating. This tip is fantastic for beginners and can look like stars, flowers and also be used to fill in colors for other designs. Follow along with Nancy for fabulous tips and design ideas.
Learn how to frost a cupcake using a 1M tip or large tip. The supplies you'll need are cupcakes and a bag with the frosting and the tip. First, squeeze the bag to remove any air bubbles. Take your cupcake in your hand and start at the outside and work your way in. Then, in one motion, go over the first layer to create a stacked second layer of icing. This method gives you a pretty ice cream cone type effect on your cupcakes. Next, you'll learn how to make your cupcakes look like roses. Using ...
In this how-to video, you will learn how to perform a palm spin gainer. This is useful if you enjoy free running and want to learn an awesome trick. First, place your right hand on the wall. Drive up your right leg up, as this will give you the rotation you need. The other leg is used for take off. Your hand will spin while you do this trick. Look over your shoulder to wear you are going to land. Make sure your legs are split while you perform this. This video gives you the proper tips and kn...
The Wizard101 Test Realm. You can play in it, but beware of scammers, beggars, and spammers! There's nothing worse than getting bombarded with these annoying requests.
Want to convert your footage from 25 to 24 frames per second? In After Effects CS5, it's easy!
Looking to add some grit to your next digital video production? Try this grungy title effect on for size!
Learn how to rig a still image with the After Effects CS5 puppet tool!
Create eye-popping backgrounds with the After Effects CS5 Fractal Noise effect! Learn how with this brief video guide.
Learn how to use After Effects CS5's built-in masking tools! Specifically, this clip addresses the creation and interaction of masks.
Learn how to create layer and text animations in After Effects CS5 by altering position, rotation, opacity and scale parameters.
Trying to keep up with the Joneses when it comes to building an awesome farm on FarmVille? Here are seven useful tips you can use to quickly accrue experience and coins within FarmVille that you can use to develop your farm, cheat free!
This video describes how to optimize a Microsoft Windows 7 PC for running Pro Tools 8. Whether you're new to Digidesign's Pro Tools 8 or simply looking to pick up a few new tips and tricks, you are certain to benefit from this free software video tutorial. For complete instructions, take a look.
This video describes how to create a new user account on an Apple Mac OS X 10.6 (Snow Leopard) computer to tell whether your Pro Tools problem is user-specific or global. Whether you're new to Digidesign's Pro Tools 8 or simply looking to pick up a few new tips and tricks, you are certain to benefit from this free software video tutorial. For complete instructions, take a look.
This video describes how to reset the PRAM, or parameter random access memory, on an Apple Mac OS X 10.6 (Snow Leopard) computer. Whether you're new to Digidesign's Pro Tools 8 or simply looking to pick up a few new tips and tricks, you are certain to benefit from this free software video tutorial. For complete instructions, take a look.
This video describes how to trash your Pro Tools user preferences, restoring them to their factory default setting, on an Apple Mac OS X 10.6 (Snow Leopard) computer. Whether you're new to Digidesign's Pro Tools 8 or simply looking to pick up a few new tips and tricks, you are certain to benefit from this free software video tutorial. For complete instructions, take a look.
In this free video software tutorial, you'll learn how to create a sunburst effect when compositing footage in After Effects. Whether you're new to Adobe's popular compositing application or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to use the Saturation Curve editor when color correcting or grading footage in Color. Whether you're new to Apple's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to create buttons and backgrounds with DVD Architect. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to use the video stabilizer in Sony Movie Studio HD Platinum 10. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to create animations from still clips in Sony Vegas Movie Studio. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to add digital explosions to your projects in Sony Vegas Movie Studio. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this free video software tutorial, you'll learn how to fix washed-out colors in Sony Vegas Movie Studio. Whether you're new to Sony's popular non-linear editor or a seasoned digital video professional merely looking to pick up a few new tips and tricks, you're certain to be well served by this video guide. Take a look.
In this video tutorial, we learn how to use the Referring Sites pane in the Google Analytics web tracking service. Whether you're new to Google's popular web analytics platform or a seasoned pro merely looking to pick up a few new tips and tricks, you're sure to be well served by this free video tutorial from Lynda.
In this video tutorial, we learn how to use the Map Overlay feature when using the Google Analytics web tracking service. Whether you're new to Google's popular web analytics platform or a seasoned pro merely looking to pick up a few new tips and tricks, you're sure to be well served by this free video tutorial from Lynda.
In this video tutorial, we learn how to do basic greenscreening within Adobe Premiere Pro CS5. Whether you're new to Adobes's popular NLE (non-linear editor) or simply looking to pick up a few new tips and tricks, you're likely to be well served by this free video lesson. Take a look.
In this clip, you'll learn how to add a Volume Slider to an iOS app with Xcode. Whether you're new to the Objective-C operating language and Xcode IDE or are a seasoned developer merely looking to pick up a few new tips and tricks, you're certain to be well served by this tutorial. For more information, including a complete overview and detailed, step-by-step instructions, watch this free video Objective-C programming lesson for iPhone & iPod Touch developers.
In this clip, you'll learn how to create a Cydia repo of an iOS app with Xcode. Whether you're new to the Objective-C operating language and Xcode IDE or are a seasoned developer merely looking to pick up a few new tips and tricks, you're certain to be well served by this tutorial. For more information, including a complete overview and detailed, step-by-step instructions, watch this free video Objective-C programming lesson for iPhone & iPod Touch developers.
In this clip, you'll learn how to generate static libraries within Xcode. Whether you're new to the Objective-C operating language and Xcode IDE or are a seasoned developer merely looking to pick up a few new tips and tricks, you're certain to be well served by this tutorial. For more information, including a complete overview and detailed, step-by-step instructions, watch this free video Objective-C programming lesson for iPhone & iPod Touch developers.
In this clip, you'll learn how to add an in-application purchase feature within your app. Whether you're new to the Objective-C operating language and Xcode IDE or are a seasoned developer merely looking to pick up a few new tips and tricks, you're certain to be well served by this tutorial. For more information, including a complete overview and detailed, step-by-step instructions, watch this free video Objective-C programming lesson for iPhone & iPod Touch developers.
