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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
In this video tutorial, viewers learn how to do a fakie kick-flip on a skateboard. Users should first know how to do the kick-flip before attempting this trick. Begin in a kick-flip position, with the back foot on the tail and the front foot slightly above the center of the board. Bend your knees and pop the tail. Flick your front foot up and out off the board. Then catch in midair on both your feet. This video will benefit those viewers who are interested in skateboarding, and would like to ...
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 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degrees and radians in Excel with trigonometric functions and formulas. Rad!
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Need four different colored (green "cheat", blue, orange red and purple) Jacks along with a double-sided red card and another red-backed random numbered card for a total of six cards. Shuffle the cards in front of the viewer with the three red cards on top then blue, green, orange then purple. Now show the card (green cheat card) and then mixing the deck rearranging deck. Push one of until you come to the blue one and spread the three red ones again with the blue on top of them. Then perform ...
Place the card in the center tip of your middle finger. The card should balance on your finger and you can test this by wobbling the card on your finger left and right without it falling off of your finger. Try to spin the card with your other hand. If it falls off your finger it may have been off center. Next, use your thumb, placed on top of the card to stabilize the card. Raise your thumb above the card. With your index finger, lightly pull the card toward your palm and generate a spinning...
Robert Scot, from ModernMom, shows viewers how to shrink an enlarged skin pore. Scott reminds us that genetics and aging do contribute to enlarged pores and skin condition, but there is still a way to deal with this. There is no way to permanently shrink enlarged pores but you can handle them with time. You can use cleansers and exfoliation to do the trick. Your cleanser should be for oily skin that will naturally purify your skin. You really want to focus on exfoliation and use exfoliates wi...
Food editor Ian Knauer shows you how to maximize the juicing potential of your citrus fruits. Follow along and learn how.
kammagic shows you the Christ Ace card trick. You start off with a regular deck of cards and choose 4 cards, these should be signed, and split the deck into 4 piles. Place each card into a pile then put all the piles on top of each other. After the first two cards are revealed, you can ask the member of the audience what their card was and using letters as cards, spell that out. You will get to their card. For the final card simply turn the deck and reveal that there's only one card facing do...
Show off your cool skills to your friends by learning how to make a rubber band or hair band jump. This trick is easy and sure to throw people off. The first step is to put the rubber band (or hair band if you life) on your pinkie and ring finger. Now, close your hand and get the band onto all four of your fingers. All you have to do now is open your hand and the rubber band will have jumped.
A few tips and tricks in cooking involving artichokes. A simple trick of the trade made to use while cooking at home or even if you are out preparing artichokes on the grill. One of few examples that artichokes are known for in cooking is first by steaming the artichokes for about 35 to 40 minutes, or until you could take a knife and if it easily penetrates without being tough your artichoke is ready. This video gives you a small demonstration on what you could do with your artichokes. You co...
This video starts off with a neat optical illusion that he uses to demonstrate the effectiveness of force card tricks. He shows a piece of paper with "Paris in the the spring" written on it, most people's mind will skip over the second "the" and will read it, "Paris in the spring." He then goes on to demonstrate a shuffling trick that allows you keep a hold of a given card while shuffling. Finally the presenter explains the difference between asking someone to "Pick a card" and asking someone...
This is an amazing magic trick that can only be done with a new deck of cards. Watch the video to learn.
In this video by Dogmantics, dog trainer Emily Larlham goes over steps on how to teach your dog to love being in a purse.
Get more coins from your Roller Coaster Kingdom! Hack your way to more money using Cheat Engine. If you want more coins fast, Cheat Engine is your best option.
Bloons is a flash game from Ninja Kiwi. Learn how to hack Bloons with tricks and cheats. Watch this video tutorial to learn how to hack Bloons with Cheat Engine (09/29/09).
Bloons Tower Defense 3 is a flash game from Ninja Kiwi. Learn how to hack Bloons Tower Defense 3 with tricks and cheats. Watch this video tutorial to learn how to hack Bloons Tower Defense 3: unlimited money (09/24/09). Get unlimited money! You just need Cheat Engine 5.5.
SAS: Zombie Assault 2 is flash game from Ninja Kiwi. Learn how to hack Zombie Assault 2 with tricks and cheats. Watch this video tutorial to learn how to hack Zombie Assault 2 with Cheat Engine (09/13/09).
This yo-yo tutorial demonstrates the Stall.
This yo-yo tutorial demonstrates the Split the Atom.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Knee stall.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Elastico.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Knee Crossover.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Hocus Pocus.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Reverse Crossover.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Neck Stall t-shirt off.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates:: XOver.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Rainbow (Front way).
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Heel Throw.
Learn freestyle football with Mariusz Chorazy, also known as freestyle soccer. Freestyle football is the art of juggling a football (aka soccer ball) using multiple body parts while performing skillful moves at the same time (and never dropping the ball of course). Freestyle football consists of dribbling moves, fakes and tricks. Master your freestyle football moves with these instructional tutorials. This video demonstrates: Over the World (OTW)
If you're new to freestyle soccer and just want to get a taste of what it is and where to start, this video is not going to help you too much. Unless you need more ideas for what really, really good freestyle soccer players can do. It teaches Mario's Neck Stall (MNS), a really cool trick where the player flicks the ball up, then gets into pushup position and catches the ball on their neck. This one takes some practice, but damn is it pretty!
