In this how-to video, you will learn how to perform a hard flip on a skateboard with PJ. This will be useful if you want to learn advanced tricks on a skateboard. When you perform the trick, do not look forward. The shoulders should be facing the side. Pop the board on the tail and flick your front foot away from you. From there, the board will flip. Catch the board as it lands with your feet on the bolts. Keep your feet flat. Do not use a kick flip stance. This video offers great tips and te...
In this video tutorial, viewers learn how to do a pop tornado free-run trick. The pop tornado is the same as a tornado kick except he pop tornado does not have that extra step. Because there is no step, this move is more difficult to perform. Users should learn how to do the tornado kick before attempting this move. Start with a wide leg stance and turn the body. Then do a hook kick and set the feet down. Now quickly jump as you pull your arms in and spin the body. Lift the knee up. This vide...
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...
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 386th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting for letters less than the letter M. Yes! Comparative operators like less than (<) work on letters!
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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.
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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
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 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, SMALL and VLOOKUP functions to create a gradebook (or grade book) based on a total score minus the two lowest scores.
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 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.
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 190th installment in their series of digital spreadsheet magic tricks, you'll learn how to rearrange three parts in a text string (e.g., last, first, middle name) using the RIGHT, FIND, LEN, & LEFT functions in one 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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
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 253rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data table for what-if analysis. You'll also learn about the PMT and see the formula equivalent to a data table.
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.