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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL 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 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.
Just in case you're a yank and don't know who Cheryl Cole is, here's a bit of background before you get into this makeup look: Cheryl Cole is the host of X Factor in the UK and is an accomplished singer, actress, songwriter, model, tv personality...you get the point.
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.
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.
This tutorial will show a simple technique for achieving the bullet time, freezing effect. This is used regularly in TV idents, films and music videos. 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 this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
Pint sized vampire Jane from the "Twilight" series can literally slay others with a glance, but we think she could knock others spellbound with her deviously good looks just as easily. Played by Dakota Fanning in the movies, Jane likes to wear makeup shades in line with her coldhearted character: deep pewters, smoky grays, and of course black.
In this tutorial, learn all about Freecycle and see how you can join and get virtually anything you need for free. Moving into a new home? Nab a free sofa, fridge, TV and everything else online. Looking for a replacement part for your electronics, boxes for moving, lumber, a car.. anything? This website is extremely easy to use and is completely free and if you are willing to haul away the goods you can find many fantastic items.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to use Clojure ratios, and see why the IEEE 754 double is a better tool for most jobs. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to solve the classic FizBuzz problem with Clojure. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to write an inference engine with Clojure 1.1. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to create and work with macros in Clojure 1.1. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to install Counterclockwise, a Clojure plugin for Eclipse. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to install Enclojure, the NetBeans Clojure plug-in. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to install Clojure using Clojure Box in most any version of Microsoft Windows — Vista, XP & 7 included. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip from Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to install Clojure at the command line in most any version of Microsoft Windows — Vista, XP & 7 included. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In this clip, the eighth installment in Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll see how to use Leiningen, a popular Clojure build system. One of the most obvious perks of using the Clojure is the user community organized around it, which make learning the language a pleasure (and a simple one at that). For more information, including detailed, step-by-step instructions, take a look.
In Epicurious' "Around the World" series, we stop by South Carolina to test out a classic American recipe - southern fried chicken. In this how-to video, you'll learn how to marinate, batter, and fry chicken in a most delicious manner. Your guests will be clamoring for second and third helpings of this fried chicken.
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.
In this tutorial, actress and producer Kathleen Cooke tells you how to prepare yourself for stepping foot on a television or film set for the first time. As an actor, you must be aware of the set and protocol. There is a heirarchy on every set, and you must know how to respect it. You must also learn the vocabulary - if you do not know what a gaffer or a honeywagon are, it's time to hit the books and study!
Many science fiction feature films and TV shows feature holographic communication and interfaces. Red Giant Holomatrix allows you to easily recreate that effect with just a few clicks. This clip, in particular, addresses how to make those few clicks as a complete and utter newcommer to Holomatrix. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with Red Giant Holomatrix, you're sure to be ...
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.
Lunges are certainly not as loved as cute bikini bottoms, but the two go irrevocably together. Unless you're a genetically gifted mutant (Gisele, we hate you), you probably don't have a rock solid, perfect pair of butt cheeks and most likely deal with small amounts of chub and cellulite.
Looking to add to your digital bag of tricks? In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to to take any photo and transform it into a dreamy illuminated scene using Camera Raw, Smart Objects, and a little creative brushing. For detailed, step-by-step instructions, and to get started using this eye-popping effect yourself, watch this video lesson.
Fancify your digital images in three easy steps! In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to take any ordinary photograph and spice it up with three-step processing. For detailed, step-by-step instructions, and to get started using this technique yourself, watch this video lesson.
Can't afford a DSLR? Fake it! In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to simulate depth of field using the Lens Blur Filter. For detailed, step-by-step instructions, and to get started using this eye-catching effect yourself, watch this video lesson.
Looking to add to your bag of tricks? In this installment from his series of free Adobe Photoshop tutorials, Justin Seeley shows you how to create a double-stroke layer style on your text. For detailed, step-by-step instructions, and to get started using this eye-catching text effect yourself, watch this video lesson.
Use Microsoft Windows 7? Miss the old Ctrl-Alt-Delete log-in prompt? It's easy to restore. So easy, in fact, that this home computing how-to from the folks at CNET TV can present a complete overview of the restoration process in just over a minute's time. For more information, and to get started restoring this useful security feature on your own Windows 7 PC, watch this free video tutorial.
If you've ever flipped through a Victoria Secret's catalog, you probably have noticed the uber gorgeous Brazilian model, Adriana Lima and her smoldering good looks. In this video presented by Fashion face TV, learn how to apply Adriana Lima dewy makeup for all skin types! Products used in this tutorial to achieve this look, include:
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to determine the eigenvalues of 3x3 matrices in eigenvalues.
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.
With the invention of 3D TVs and a 3D film showing in nearly every theatre, 3D seems to be the biggest craze lately. Did you know you don't have to spend a fortune to create one of these eye-popping movies yourself?