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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
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 183rd installment in their series of digital spreadsheet magic tricks, you'll learn how to sum revenue from a table of data by year and month using the SUMPRODUCT, TEXT, SUM, IF & LEFT functions 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 156th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will check two tables and find the values that do not match and then create a new list.
In this how-to video, you will learn how to do a cartwheel side flip. First, make sure you can do both a cartwheel and side flip. If you can do these tricks from a standing position, you have more control over the flips. Try to land on the balls of your feet with your legs somewhat apart. Now, come off the balls of your feet and do the side flip. Make sure that you then turn and tuck to perform this correctly. Notice that your arms add momentum as you go through the cartwheel and into the sid...
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. In this Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...
In this video tutorial, viewers learn how to do a standing full (360 back-flip). Before attempting this trick, it is highly recommended that users have mastered a back-flip. Make sure that you can see he ground in mid-air. Bring your feet together and bend the arms back. Bend your knees and push up with your arms raised up. Then leap up high and twist you body in mid-air. Users may also start twisting the body as they leave the ground. This video will benefit those viewers who are interested ...
In this video tutorial, viewers learn how to perform an Ollie, kick flip and shuv-it skateboarding tricks. For the Ollie, begin with the back foot on the tip of the tail and the front foot on the middle of the board. Bend your knees slightly and extend your back as you raise up. Pop the tail of the board and roll the front foot on the nose of the board to land it. For the kick flip, start with an Ollie position and bend the knees. Pop the tail and roll your front foot to the nose. Flick with ...
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. In this Excel tutorial from ExcelIsFun, the 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
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. In this Excel tutorial from ExcelIsFun, the 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
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. In this Excel tutorial from ExcelIsFun, the 124th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a box plot or box-&-whisker chart using a stacked bar chart and a open-high-low-close stock chart. You'll also learn how to use the QUARTILE function.
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. In this Excel tutorial from ExcelIsFun, the 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
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. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
In this video Eric Joneckis gives you a few tips on acting like a true skateboarder. If you want other people to take you seriously as a skateboarder, you need to look the part. Here are a few tips: Always wear a shoelace belt, skateboarding shoes that shouldn't be untied to take them off, long hair and a cap to keep it all in place. Next to style, attitude is the most important thing you can have. Learn how to fool the people around you into thinking you are a good skateboarder. If you can't...
Remember: a varial kickflip is basically a pop shove-it with a little more ankle action, so set up like you would for a pop shove-it. Hit the tail as you would for a pop shove-it, and as the board starts to snap up, flick your front foot just like a kickflip. That action will cause the board to flip while the shove-it action from your back foot will make the board turn 180 degrees below you. Don't flick the flip too hard or it will flip away from you like a crazy 4th of July firework. Let the...
This video displays a very interesting experiment or magic trick involving the concepts of density and buoyancy. You will need an empty plastic bottle with its label removed, some water, and a ketchup packet. Using the concepts of pressure and density, this video demonstrates an interesting experiment which can also double as an interesting party trick; by squeezing a full water bottle, you can cause the ketchup packet to rise and sink in the bottle at your whim. This video is an interesting ...
Home security is as important as having a job. You have to protect your family and your valuables. If you can't afford a high tech security system, then maybe a fake security camera will do the trick. This security camera dud is also a cheap alternative for a film prop. Watch this video tutorial to learn how to build a fake cardboard security camera.
Club Penguin is a flash-based website with an a virtual world of online games for kids to play. Learn how to hack Club Penguin with tricks and cheats. Watch this video tutorial to learn how to find hidden items in the Club Penguin catalog (09/29/09).
IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to clean up an IMVU avatar in Photoshop.
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Wizard101 chessboard bug (09/23/09).
Gamble your life away in Las Vegas Slots on Facebook. And learn how to hack it with tricks and cheats. Watch this video tutorial to learn how to earn more daily credits in Las Vegas Slots on Facebook.
Bouncing Balls is a Facebook game that allows you to destroy balls left and right! Get Bouncing Balls hacks, cheats, tricks and tips! Watch this video tutorial to learn how to hack Bouncing Balls on Facebook (08/13/09).
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Yardbirds in Wizard101.
Okay, so first things first: the con presented in this bar trick video is illegal since you're basically stealing money, so perform at your own risk!
The one card trick that every street magician or street hustler needs to know is 3 Card Monte. With the help of this video tutorial, you'll see exactly how to perform the three-card monte throw. There is no real magic here, it's all just a sleight of hand, which is needed for any magic card trick.
Epic from TRICKset breaks down how to do a Macaco... Portuguese for monkey, this was made famous in Capoeira! This is a super cool trick for flat land gymnastics. He talks about the preparation you need to undertake before trying it out. He shows the step by step from the squat to the hand position and the Macaco execution. Capoeira is a form of martial arts and dance that originated in Brasil.
This subtle trick will lengthen your school report without your having to write a single extra word. Learn how to extend the length of your papers with this simple video. You will need a paper and flexible ethics. The trick is to enlarge the font of all the periods in your paper! Fact: If you have a 16 page, 12 point paper, changing the periods to 14-point will stretch the paper to 19 pages!
This yo-yo tutorial demonstrates the Kamikaze.
This yo-yo tutorial demonstrates the chopsticks thumb mount.
This yo-yo tutorial demonstrates the Magic Drop.
This yo-yo tutorial demonstrates the Rancid Milk.
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 barhop 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 manual 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 rocket manual 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 bunny hop 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 wall tap 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 barspin 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 G-turn on a BMX bicycle.
