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.
Learn how to pick the right card in this magic card street trick.
You might have to watch this explanation a few times before you actually get the entire card trick, but once you do, hopefully you'll be able to perform the '4 of the same' magic card trick without hesitation. It is a little tricky, of course, but it's worth the lesson. This amazing card trick involves turning a mixd deck of cards into 13 piles from ace to king in piles of 4. This is a great magic trick for beginners and advance magicians alike. Watch the first video for the explanation and t...
If you've never gotten a Rubik's Cube because you thought they were too hard, maybe you should try your hands at something smaller, something simpler, something to get you motivated, something called Rubik's Magic.
Watch this instructional knitting video demonstrating magic loop knitting.
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.
With many office workers in the US being asked to work from home if their job allows, Magic Leap's customary updates for the Lumin OS and Lumin SDK brings some help to keep distributed workforces connected.
Back when I worked in the music industry, I never imagined there would be a day that I'd be able to sit in a room surrounded by virtual album covers while listening to beats, but that day is really here.
