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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal 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 660th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a data set using Advanced Filter.
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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.
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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
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 654th installment in their series of digital spreadsheet magic tricks, you'll learn see when to use line charts and when to use an X-Y scatter diagrams.
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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter 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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
This clip presents a complete overview of how to perform a purl-two-together stitch in the English style when knitting. Purl two together (p2tog) is a very useful decrease used on the purl side of your knitting. For comple instructions, and to get started using this stitch in your own kitting projects, take a look.
This clip presents a complete overview of how to perform a purl-two-together stitch in the continental or European style when knitting. Purl two together (p2tog) is a very useful decrease used on the purl side of your knitting. For comple instructions, and to get started using this stitch in your own kitting projects, take a look.
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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
Want to speed up your C4D workflow? You're in luck: This clip offers an overview of Cinema 4D's most useful keyboard shortcuts. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started using these shortcuts in your own Cinema 4D projects, watch this 3D modeler's guide.
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 638th installment in their series of digital spreadsheet magic tricks, you'll learn how to add two horizontal axes to a chart.
Google Voice is the newest release from the experts at Google. Google Voice is a low-cost Internet phone service that redirects calls to your home phone and works over your WiFi connection. This service is very exciting and useful for those that are looking to save some money on long distance. Google Voice was in limited use for a while and is now available to everyone, so check out this clip and learn how to use it!
In this tutorial, learn all about the newest eBook reader from Barnes and Noble, the Nook. Nook is a fantastic reader that is slim, stylish and useful. Check out this 25 minute tutorial and see how to get started with your Nook with everything from opening the box to using all of its cool applications.
Link constraints are a simple and useful part of the toolset available to you in 3D Studio Max. They allow you to attach one object to another so that when one moves, it will only move in relation to some parameters governing its position relative to the other object. This video will teach you how to use link constraints to make a character toss a ball realistically.
This clip discusses a very useful way to work and organize your 3D scenes—to wit, the 3ds Max Layer system. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the application, you're sure to be well served by this video tutorial. For more information, take a look!
Fake wounds are one of the most popular makeup elements to include in Halloween costumes, and are also very useful in making films. This video will teach you how to create a realistic open facial wound using makeup. It looks so real, any doctors that you run into will probably try to rush you to the hospital immediately.
Want to simulate mouse functions with the Windows 7 Speech Recognition tool? It's easy! So easy, in fact, that this Windows 7 accessibility guide can present a complete walkthrough of the process in just over a minute and a half. For details, as well as to get started using this useful trick yourself, watch this helpful how-to.
The purse string stitch is one of the more specialized stitches used during surgery: the purse string suture. This suture is used to seal an opening in a hollow organ in the body, like when a feeding tube is being inserted. It is a challenging maneuver, and mostly useful in internal medicine rather than external, but knowing it is essential to several types of surgery.
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Meet the Maya 2011 Hotbox tool, a highly useful on-screen device for navigating your projects. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For specifics, and to get started using the Hotbox to navigate your own Maya projects, watch this free video guide.
Learn how to navigate your Maya 2011 projects using a number of keyboard shortcuts and useful on-screen tools. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the new Maya 2011 navigation interface yourself, watch this free video guide.
Learn how to use the Beat Detective tool to convert drum transients into MIDI notes when working in Pro Tools 8. Whether you're new to Digidesign's popular DAW or a seasoned audio pressional just looking to better acquaint yourself with the Pro Tools 8 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using this useful drum replacement trick yourself, watch this free video guide.
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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND function.
Know your knots! With this free video tutorial, you'll learn how to tie a centauri fishing knot. To create a centauri knot, you'll most likely use metal film and start by weaving your eyelet.The knot is easy to tie provided, of course, you know how to go about making it. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Not only is origami useful for making things that appear like they should be able to float (like paper swans), it's actually good for producing things that do — like paper boats. With this guide, you'll learn how to make a paper catamaran with origami, the traditional art of Japanese paper folding. For more information, including a step-by-step overview of the folding process, as well as to get started making your own floating paper boats, watch this free origami lesson.
Looking for a craft project as easy as it is useful? With this guide, you'll learn how to make a paper chopsticks holder with origami, the traditional art of Japanese paper folding. For more information, including a step-by-step overview of the folding process, as well as to get started making your own paper chopstick cases, watch this free origami lesson.
Looking for a fun and useful crafts project? Learn to make the most utile (and simplest) of origami sculptures, the paper box. This video tutorial presents a complete, step-by-step overview of how to make a decorative paper box using origami, the traditional Japanese folk art of paper folding. For more information, and to get started making your own paper cubes, watch this arts-and-crafts guide.
In this calming and useful video, JD of the Youtube knot-tying instructional channel Tying It All Together demonstrates the tying of an obscure knot called a Bumblebee knot, for which good instructions are apparently hard to come by. It is a pretty piece of knot-tying indeed.
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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function 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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
Kim Kardashian's star just keeps on rising, and that is largely due to her beauty. In this tutorial, learn how to create the same look that Kim wears most often on yourself! If you are inspired by Kim's glamour and want an everyday red carpet ready look, this is the style for you!
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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY 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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME 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 and Mr. Excel, the 6th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to retrieve the last value in a row.
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 very first installment in their joint series of digital spreadsheet magic tricks, you'll learn how to do a two-way lookup on a table array.