Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Playing with magnets can be a fun activity for many young children out there willing to learn about science. This tutorial gives those science hungry kids a cool little trick on how they can make their own electromagnet from scratch. The supplies are easy to get and will take only a few minutes to prepare. So sit back and find out what it takes. Enjoy!
Talking on the phone with a girl you like for the first time can be nerve wracking. Luckily, The Wing Girls are here to help with their honest and earnest dating & relationship advice. Learn how to get past that first phone call and get comfortable on the phone with your crush with tips & tricks given here!
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
Car drifting is a very cool, racecar style driving trick. This two part video series will show you how to drift like a pro. Grab the wheel and be careful!
There's a lot of iron in your cereal, so much that it's possible to isolate and remove it using a little known trick. In the video below, Mr. G of Do Try This at Home will show you his secret to removing the iron content of your daily cereal, using a magnet to show exactly how much of the mineral is in a bowl of bran flakes. It's a little bit awkward, so brace yourself!
Creating text that catches the eye can be difficult. One great trick is to have your text actually composed from an image. Using Photoshop CS4, you can quickly create professional-looking text from a single or multiple images. Watch this video tutorial to find out how.
A performer from the UK street stunt team 3Run demonstrates the wall flip. It's a simple but always impressive parkour move. The performer vaults off the wall and goes spinning back over himself, landing on his feet. The performer offers a lot of advice for how to do the trick, making it (almost) look easy.
MAKE and Kipkay brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will.
Here are a couple of ways to do false cuts. They are needed when performing magic to make your audience believe the deck is being mixed up..... Pretty simple to perform... This is a basic beginner's skill to master for all up-close or general card magic.
Need rope, but don't have any. This is a great emergency trick for making rope with plastic bags. This video demonstrates a simple method for converting your used plastic bags into rope. It requires only bags and a working set of hands.
Improve your extreme card manipulation (XCM) with this video tutorial! Watch and learn how to do the Squeeze a Square Display card flourish. This is a perfect card flourish for your magic routine, or to just impress people. It's flashy and elegant. There' s no card trick involved here, just a great performance. Learn the Squeeze a Square Display!
Watch this video tutorial to learn how to perform a "one face up" false cut card flourish. A card flourish is something a magician uses, a technique for handling playing cards, mostly during magic card tricks. Is it magic though? No, just a little sleight of hand a fancy showmanship. See how to do the OFU (one face up) false cut.
Jumpstyle is all the rage from Europe and can be danced to with hiphop or electronica.
Whether you’re an Oscar nominee or a new mom with an upcoming high school reunion, these tricks will get you into that va-va-voom dress without splitting the seams.
Learn how to do a railey to wrapped with Flysurfer teamrider Mathias Wichmann. Kite surfing or kiteboarding is a hybrid sport combining kite sailing and wakeboarding in open water. It's a high endurance sport that uses your whole core to keep you flying high on the surf.
Learn how to do a kiteloop with Flysurfer teamrider Mathias Wichmann. Kite surfing or kiteboarding is a hybrid sport combining kite sailing and wakeboarding in open water. It's a high endurance sport that uses your whole core to keep you flying high on the surf.
Learn how to do a frontloop with Flysurfer teamrider Mathias Wichmann. Kite surfing or kiteboarding is a hybrid sport combining kite sailing and wakeboarding in open water. It's a high endurance sport that uses your whole core to keep you flying high on the surf.
Learn how to do a front to blind with Flysurfer teamrider Mathias Wichmann. Kite surfing or kiteboarding is a hybrid sport combining kite sailing and wakeboarding in open water. It's a high endurance sport that uses your whole core to keep you flying high on the surf.
Learn how to do a backmobe with Flysurfer teamrider Mathias Wichmann. Kite surfing or kiteboarding is a hybrid sport combining kite sailing and wakeboarding in open water. It's a high endurance sport that uses your whole core to keep you flying high on the surf.
Secretly shoot your voice across the room in stealth mode on a laser beam in this fun and easy project! Make Magazine and Kipkay present this cool spy trick. Build a simple laser communicator that transmits your voice across a room. You need an amplifier, radio, laser pointer, battery pack and a solar cell.
The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch this video to learn how to open a bottle of champagne.
From the Fallout 3 SuperGuide on MyCheats. MyCheats staff writer Mike Nelson talks about his favorite exploits and tricks in Fallout 3.
Brian Brushwood reveals the techniques used to make super-realistic fake tongues, like those used in last year's Halloween Horror Nights show. Brian Brushwood on The Road shows how to make fake tongues to use for the magic illusion 'Sword through the Tongue' trick. He's performed this in his stage show at Universal Studios in Orlando.
In this video tutorial, you'll see how you can build a homemade steadycam camera stabilizer for under fifty bucks. This is more specifically how to build the JayCam MkII Merlin-type camera stabilizer from Jay Shaffer. He demonstrates how to use inexpensive parts to make a versatile stabilizer for camcorders like the Canon HV30. This is a great steadycam addition for anyone in need of DIY cinematography tricks, because real steadycams can be costly.
Learn how the do all of the Celebrations in Fifa 09. If you want to know the controls while playing, just go to the pause menu, then to Controls, and then to Celebrations Help. When you score make sure your celebration is that of a winner a la David Beckham. Check out the tricks to doing celebrations like 'Look at Me', 'Low Aeroplane', 'Fist Bump' and 'Acrobatics'.
Learn how to do the standard skills in Fifa 09, it looks like every player in the game can do these. These are special tricks, but they are necessary if you want to play online or ever score. This includes a foot flick, slide tackle, 360 roulette and reverse stopovers.
Tutorial on one of the hardest tricks in the game. A chest flick is also hard in real life. So it's appropriate that they make it hard on the Playstation 3. FIFA 09 is the best soccer game yet. Check out this chest flick juggling move today! All the controller sequences are spelled out.
How to use a can opener with one hand or without a prosthesis. This is an adaptive equipment tutorial for handicapped, disabled or individuals that have lost limbs to amputation. This trick is important to ensure healthy living and daily tasks like opening food in the kitchen. Live without limits!
You can save calories without sacrificing flavor just by tweaking your Thanksgiving dishes. Learn how to make low calorie Thanksgiving dishes this year.
To draw snowy pines in colored pencil, depict the tree with snow weighing down the branches and with snow dunes in the background. Learn to depict snow on trees with tips from a professional illustrator in this free instructional video on drawing. All you need are a few tips and tricks to master the art of drawing snowy pines.
You bought a whole bunch of strawberries on sale, but you don't want them to go bad. CHOW contributor Daniel Duane shares his trick for keeping farmers’ market strawberries fresh and making them last longer. Just follow this cooking how to video for great tips on keep fresh fruit longer.
