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 256th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the most common and useful Excel keyboard shortcuts on a Microsoft Windows PC.
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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a 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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.
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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR 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 181st installment in their series of digital spreadsheet magic tricks, you'll learn how to count words (case sensitive) using the SUM and EXACT 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 178th installment in their series of digital spreadsheet magic tricks, you'll learn how to alculate the best value from two categories of values.
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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the median when you have more than 1 criterion.
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 Excel tutorial from ExcelIsFun, the 554th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to weekends and holidays with Excel's NOT and NETWORKDAYS functions.
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions to increment numbers in Excel 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
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 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
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 prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
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 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
In this video, you will learn a plethora of tricks and glitches in a multiplayer map called High-rise in Call of Duty: Modern Warfare 2. Learn how to access vantage points such as the crane visible on the side of the map, or learn even more obscure pathways to places you probably never thought you'd reach. This video provides an excellent visual guide to dominate the High-rise map. Don't waste your time dying in the middle of the map or sitting in the spots everyone knows about--study this vi...
Just by moving one match you can turn the math problem into a correct answer. Definitely use this to get some free drinks. And you already know the answer, so it won't be hard. If you want to try and figure this one out for yourself, pause the video before the reveal.
To perform the Ronldinho trick you must drag the ball with the inside of your foot in a sweeping motion, this puts you and the ball into a movement, instead of dribbling out of a standstill. To perform the back heel you must step over the ball and push it with your heel to the leg behind. To perform the pullback you have to kick the ball to the other leg, then you stop it at the top, and then you pull the ball back.
This is a magic trick in which you turn one small coin into two larger coins. First you need to place the two larger coins horizontally between your index finger and your thumb. Then you need to place the smaller coin vertically against your index finger and thumb as to conceal the two larger coins. Then when you make a motion with your hand you can slide the smaller coin down and have two larger coins.
The Mach 5 has a cool name, and it's a cool yo-yo-trick. It's not an easy trick for beginners, but if you have some experience you can pick it up. This video tutorial will teach you how to do the Mach 5 and wow the crowds.
Mark Montgomery is an award-winning yo-yo artist and a former member of Team Buzz-On and Team Omega. In this video, you will get step-by-step instructions for how to do an impressive chopsticks trick that Montgomery introduced in 2006, then you'll learn "The Wave", a new trick inspired by Montgomery. These tricks aren't for beginners, so pay attention!
Practice the Hot Shot cut card flourish in magic. This is an extensive tutorial in card magic that shows you how to do the specific move: Hot Shot cut. The Hot Shot cut is an intermediate move in card flourish or card trick magic.
Learn this great trick for getting the sharpest knife. You don't need a sharpener. All you need is a coffee mug. It must be ceramic coffee cup to work. This is how to sharpen your knife using cup! What a magical kitchen trick!
Try out this super easy and accessible trick with a catchup packet in a bottle. Find one packet of ketchup like the ones at McDonalds and put it in a bottle of water. You need to find a packet without air in it. The ketchup magically rises and falls when you squeeze the bottle. Use this as inspiration for one of your April Fools Day pranks!
Check out this bar trick of super sonic hearing. It is the trick that fooled Einstein by Brian Brushwood and Revision3's Scam School. Watch Brian scam Olympic gold medalist Jonny Moseley with a few coins, and some algebra!
Tired of the yo-yo? Try your hands at the diabolo (which most jugglers erroneously misspell as the diablo). This is a step above the yo-yo... it's the Chinese yo-yo... it's the devil on two sticks. Watch this video tutorial on how to do the Infinite Suicide trick on a diabolo Chinese yo-yo.
Tired of the yo-yo? Try your hands at the diabolo (which most jugglers erroneously misspell as the diablo). This is a step above the yo-yo... it's the Chinese yo-yo... it's the devil on two sticks. Watch this video tutorial on how to do the Continuous Mini-Genocide trick on a diabolo Chinese yo-yo.
Remember pulling this trick on friends in 8th grade? It'll be great to try on your wife, because she'll think you're giving her jewelry. Tell her you "found something", then show her the box. Remember to jiggle your finger when she goes to feel it. Good Luck. Lou Ryder.
The goal of this video tutorial is to teach you how to make a card disappear with magic. This instructional is to help anyone wanting to be a magician, helping you understand technique and presentation of simple but effective illusions. These card tricks are pretty easy, but with time, practice and patience you will be able to amaze your friends and your family. Learn the vanishing card magic card trick!
This is a basic trick for little dogs like this Miniature Pincher, Daisy. The dog jumps off a human's leg and does a half turn (180). LIke any dog training be patient, go over each step multiple times in order to help the dog learn. The treats should be broken up so you don't spoil the dog or make him stuffed with sweets.
This yo-yo tutorial demonstrates the trick called The Last Crusade.
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: T-Shirt Trick MCNS.
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: Rolling ball catch.
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 (Sideway)