Ever wonder how magicians can seemingly identify any card? Well, wonder no more! In this tutorial, learn how to identify a spectator's card when they randomly place it mid-pile. This sounds impossible and looks astonishing but, really, it is quite easy. So, follow along with this clip and you will learn all of the inside secrets to perform this trick on your very own.
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...
In this tutorial brought to you by the guys at Achievement Hunter, you'll be finding out a secret in the Skate 3 demo. This video shows you how to get out of the map, or in this case demo barrier, into another skating area. This is the main place where you can find the infamous shark that is so difficult to jump. Enjoy!
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 ...
Looking for a primer on how to create and work with array formulas 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 13th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for math word problems in Excel.
Looking for a primer on how to create and work with arrays 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 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.
Looking for a primer on how to create and work with arrays 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 3rd installment in his series of Excel array formula series, you'll learn how to create an array formula that will calculate the expected return for a given stock.
Looking for a primer on how to create and work with array formulas 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 array formula series, you'll learn how to create an array formula for Bayes' Theorem.
Looking for a primer on how to create and work with array formulas 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 array formula series, you'll learn how to use the array FREQUNCY function correctly.
Looking for a primer on how to create and work with array formulas 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 array formula series, you'll learn how to create array formulas with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.
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 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.
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 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.
In this great 10 minute video you'll learn everything you need to grow the best broccoli sprouts possible. The "sprout people" take you step by step on growing your very own broccoli grain sprouts. After this video you'll be sprouting all over the place.
This wonderful video takes you step by step on growing your very own grain sprouts. You can also use this tutorial to grow all types of grains like, barley, kamut, oats, rye, spelt, triticale or our grain mix. Grain sprouts are so fast and easy that they've included directions for sprouting in both a , mason jar and an easy sprout sprouter in this one video. After this video you'll be sprouting all over the place.
This video will show you how to do a master reset, and a factory reset on your Blackberry. If you ever need to do this, this video tutorial is a great place to start. Just follow along with this tutorial. This is a good idea if you're looking to resell your Blackberry or pass it on to a relative or friend for whatever reason. This tutorial works for any Blackberry device.
In this Photoshop video tutorial, hosted by photoshopuniverse, from Free Photoshop Video Tutorials, you will learn how to create an effect that makes it appear as though text you input into your image has been embossed on a glass surface. As you follow along with the host in this video, you will learn how to insert text, and align it to a plane, so that it will appear to be aligned to the surface you want to place the text on, as well as how to achieve the embossed look when you're finished.
Follow these simple instructions and learn how to ollie with your skateboard. What you need:
Mmm...barbecue pork shoulder. This oven "smoked" barbecue pulled pork will melt in your mouth. Watch this video to learn how to make a succulent, tender dish, that's great for dinners and parties. All you need to do is put the ingredients in a Dutch oven, and place in the oven for a few hours. You'll be rewarded with the delicious smell and taste of flavorful, tender pulled pork.
Want to learn how to frontflip? Well, you've come to the right place. This video tutorial will show you how to accurately perform a frontflip for any of your needs: gymnastics, parkour, freerunning, or just plain old fashioned fun. It's easy to front flip, it just takes practice... and guts.
Frank Shamrock shows Yardbarker Dewey Hammond how to throw an effective punch. MMA fighter Frank Shamrock teaches the fundamentals of Mixed Martial Arts. If you want to learn how to dominate your opponent in the cage, this video tutorial on throwing punches is a good place to start.
Leg or heel catches are a great place for those new to the exciting world of freestyle soccer to start, as it isn't TOO challenging. All you have to do is flick the ball up and behind you and catch it against your heel in the crook of your bent leg. The video will show you everything you need to know and offers great tips on proper execution.
Add an old-fashioned touch to this year’s Christmas tree by decorating it with popcorn-and-cranberry garlands.
In this video I explain how to open combination locks. All combination locks can be bypassed in one way or another. This lockpicking tutorial goes over different methods.
Interested in learning how to play the didgeridoo? If so, this video lesson may prove a good place to begin. This tutorial will walk you through the rudiments of didgeridoo playing, including tonal techniques for varying the pitch, volume and timbre of your didge. For more information, and to get started playing didgeridoo yourself, watch this helpful video tutorial.
This medical how-to video demonstrates how to insert a central venous catheter line. The method used to insert the venous line is the landmark base technique. Always prepare the skin by wiping it with antiseptic. The patients head should be tilted slightly to the left. Follow along and learn how it's done.
Battlestations: Midway for the XBox 360 takes place at the very start of America's involvement in World War II, beginning with Pearl Harbor. Take a look at this instructional video and learn how to win the Battle of Tulagi and secure the strategic islands with these tips from G4TV.
In this tutorial you will learn how to UV map a motherboard box in Maya. This Maya software tutorial covers basic UV mapping procedures and using UV's to place textures on an object like a motherboard box.
Having a date over to your place for the first time is nerve-racking enough without having to worry about your embarrassing roommate. With these easy steps, an uncomfortable situation can be smoothed over. Watch this dating advice video and learn how to bring home a date when you have a roommate.
In this how-to you will learn to make a wrestling ring for those who need to find a nice place to practice wrestling. This can come in handy for schools, or even your backyard.
This is a video demonstration on how to tether your iPhone 3G to a Mac laptop to use the 3G network for surfing the web on the laptop. This is against AT&T's policy so try at your own risk. This is in place of the NetShare app that keeps getting removed by Apple or ATT. This let's you connect your computer to the 3G wireless network by using a proxy on your jailbroken iPhone.