BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a feeble grind on a BMX bicycle.
BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a 180 on a BMX bicycle.
BMX: Catch Some Air If Ernest Michaux, inventor of the modern bicycle, could see what people are doing with his creation, he'd freak out. The art of creative biking has never been more challenging and rewarding than it is now. Check out the tricks for a guide to BMX mayhem. Watch this video tutorial to see how to perform a 360 ledge on a BMX bicycle.
Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to
Surfing: Hang Ten The ocean is a force of nature that refuses any effort to tame it. To throw one's self on the mercy of this beast is a courageous act. With the help of this trick guide, you can learn to harness that power and push your water-borne adventures to new heights. See how to
Take two rubber bands and make them dissolve through each other. This takes practice and strong fingers. It is a cool trick to do at a bar, or with friends.
This is a simple trick that can amaze, and only requires about a 1/2 hour of solid practice, more or less.
In this tutorial, we learn how to jump over a car with film effects & tricks. First, you will take a long shot of someone pretending like they are jumping over a car, make sure they add in excitement. After this, you will take a long shot of a car driving over in the same area. Now, load your clips and add in the image of the person jumping with the image of the car. After this, use the magic tool to add them both in the same scene, then you will have a great film effect that makes it look li...
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
To do the Presto Printo Card Trick, you need to begin with a deck of standard cards and a deck of plain white cards, which have been cut to the same size as standard cards. You will need to print the effects that you want to achieve on the cards in advance. You will need extra blank white cards to conceal.
This prank is great because it combines the digital and the analog to create a multimedia prank. All you have to do is load up this web page, which looks just like the Google front end. If you follow the instructions in this video, you will learn how to make the two O's in the title disappear from the page. Combined with a little storytelling and misdirection on your part, this can be turned into a trick where you make your friends think that you have magically erased the two O's from Google'...
Three pranks, one video, a million annoyed victims! Welcome pranksters, watch on and learn! This video will teach you three easy sign-related pranks for general mischief. The first, the out-of-order sign prank. The second, the Please Pull Hard sign on the push door trick. Lastly, the classic broken LCD monitor trick. All simple, all easy, all hilarious. And you probably won't break anything expensive!
One prank doesn't have a terribly long lifespan usually. You do it once to one of your friends, they tell everyone else, pretty soon your friends see that prank coming a mile away when you try to pull it again. Why not stock up? This video will show you how to pull three diverse, great pranks. First, the food-coloring-in-the-showerhead trick. Second, the living room string labyrinth. Third, the old broken PC desktop trick. Pull all three on someone in rapid succession for bonus score!
If you've ever heard of the Yes Men, then you know about some of their most famous and awesome pranks. These guys have done so much and have tricked so many people in the past decade. From tricking people to signing petitions about allowing Global Warming to occur to passing out over 80,000 fake New York Times papers, these guys are good.
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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.
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 to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.
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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....
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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.
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 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break apart the hours worked in a given day into one part for the day shift and a second part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different ca...
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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.
In this two part video, learn how to build a scaffold or a bridge between two glasses that is strong enough to support another glass on top of it.
Check out this tutorial for steps on how to perform a very cool slight of hand trick. In this video, learn how to take a solid sugar packet, toss it in the air and catch it - like a ring - around your pointer finger. Your audience will be totally amazed, but you will know the secret.
One of the most basic, but most impressive card tricks is how to make a card vanish and reappear with ease.
Humans don't really have the strength to rip a solid apple in half.. or do they? In this video, learn a cool trick for separating any apple with nothing but your bare hands. This comes in handy as a magic trick, or, more practically, as a way to enjoy a fresh apple without a knife.
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 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
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 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions 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 and Mr. Excel, the 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.
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 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.
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 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
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 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:
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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
