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 290th installment in their series of digital spreadsheet magic tricks, you'll learn how to count codes from a column of text strings that have multiple codes.
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 275th installment in their series of digital spreadsheet magic tricks, you'll learn how to reduce a column of numbers by a set percentage (in this case, 35%) quickly!
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS 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 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).
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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks in Microsoft 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, the 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new 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 MS Excel tutorial from ExcelIsFun, the 250th 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 representatives using a pivot table (PivotTable).
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 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.
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 231st installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP on 3 tables on 3 different sheets.
To play off Gertrude Stein's famous quote, a rose is a rose is a magic paper cube. And with this paper folder's guide, you'll learn how to make your very own magic rose cube from paper using the Japanese art of origami. This design by Valerie Vann, and folded by YouTuber German Fernandez, is great for Valentine's Day or any other day where a paper puzzle rose is needed. Just be prepared... it's a not just a puzzle origami rose, it's a puzzle folding it.
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 176th installment in their series of digital spreadsheet magic tricks, you'll learn how to get the last number or word from a column on a different sheet.
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 174th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup up the last value in an unsorted list.
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 172nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create running total with a formula or a pivot 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 170th installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to hide or show items in a list using a TRUE/FALSE 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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF 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 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF 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, the 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your 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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
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 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
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 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
If you've ever wanted to do card magic tricks or just want to know how a certain magic card trick is done then watch and learn how to perform the slip cut sandwich card trick. This is a simple card trick can be done by anyone regardless of experience, you want to being by stating that the two jacks are going to assist you in finding the card. Then have a spectator tell you when to stop when your riffling through the deck. When told to stop just pull two cards out as one and place at the top o...
Tutorial of how to quickly make and Origami Magic Ball! Get a piece of 20x40cm paper. Fold along side in 32 equal parts, by repeatedly folding the paper in half - using genderless folds. Fold the short side in 8 equal parts- using valley folds. Turn the sheet over and start diagonal folds - using valley folds into 32 parts. Roll paper out flat, and fold it zigzag following previously made genderless folds. At corner of paper, create a "water bomb" by pressing together previously made folds fo...
Watch this video tutorial to learn how to perform a "one face up" false cut card flourish. A card flourish is something a magician uses, a technique for handling playing cards, mostly during magic card tricks. Is it magic though? No, just a little sleight of hand a fancy showmanship. See how to do the OFU (one face up) false cut.
Card flourishes are more of an art form, not really necessary for your magic card tricks and illusions, but really cool to impress your friends. Watch this video tutorial to learn how to perform a riffle fan card flourish, which you can use to either fan your cards out, or as a riffle by itself. This riffle fan card flourish is an impressive card trick, no magic involved.
This yo-yo tutorial demonstrates the Magic Drop.
What to be a magician, but only when it comes to card tricks? Just Flourish will help you improve your magic skills with that deck of cards. This video specifically covers how to perform the one-handed revolution cut card trick. This basic "magic revealed" tutorial into the land of card tricks will show you just how to do the revolution cut.
This image editing software tutorial shows you how to use clipping masks on monster images in Photoshop CS3. Discover the magic of clipping masks and how you can create complex masks with this simple technique. Russell Brown shows you how to create Halloween magic right in Photoshop CS3.
If you already have movies and photos on your hard disk and want iDVD to automatically create a DVD that includes Apple-designed menus, you can use Magic iDVD.
How to make jumping magic beans with marbles and tin foil.
A Photoshop tutorial on how to use the Magic Wand Tool. This covers the options within the tool that are available and helps you gain maximum knowledge and control of the tool.
Learn how to pick the right card in this magic card street trick.
This ball isn't like any you've ever seen before. It's stubborn, it's unpredictable — it's practically immovable. Gravity cannot control this magic ball.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to edit Super Mario World levels with Lunar Magic.
Kipkay shows you how to make a magic lightbulb like the magicians use. Great practical joke or prank. All you need is a couple of lightbulbs, an LED and some batteries.
Magic Glos is a fun product that you can add to polymer clay or resin products to make your project glossy and shiny. You can even apply Magic Glos to paper projects, though you'll need to seal it to prevent bleeding.
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 725th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate quartiles with the MATCH and QUARTILE function.
