What if I told you that you could read minds? You'd most likely think I was crazy, and you'd be right. But what I really meant is that you could make people think that you could read minds, something that's not the least bit crazy.
Already a bona fide friendship bracelet weaver? Then get ready to knock your friends' socks off with this personalized bracelet emblazoned with the letter "A." This step-by-step video will turn your mind to a whole new world of friendship bracelet possibilities, and you may find yourself stringing together batches of these for friends, family, and coworkers.
Physics can be a real mind bender, but this educational video will show you how to wrap your head around Heisenberg's uncertainty principle. And no, that's not the same Heisenberg that's in Breaking Bad. We're talking about the famous German theoretical physicist Werner Heisenberg, someone whose work you'd be more likely to see in Fringe.
You'd think that in the United States we have more of a problem of women wanting to look tan year round than white and pale. But many women actually crave the vampirish pale complexion, and because not all of them are born with it, some turn to whitening/lightening creams. Some women also turn to these creams because they claim to fade dark spots.
Thanks to the fact that Obsidian is filled with a ton of geeks and nerds (the right kind of people mind you!) there's all sorts of movie references scattered about the Mojave Wasteland in Fallout New Vegas just waiting for you to find them! In this video you will get the locations of a couple of obscurer Easter Eggs hidden around the Mojave Wasteland. The first is a Suave Gambler Hat sitting inside a blown apart refrigerator, which is obviously from the Indiana Jones movie that we will not di...
We all make the same mistake at some point. Walking around, minding your own business and then BAM you crush your toe right into a step, a wall, a small raise in the ground. Your toe is broken, you're shouting like a sailor, and your toe now looks like a swollen grape. Don't worry, you don't have to go to the hospital. Instead, check out this great video where you learn how to wrap your broken toe to help it heal.
Looking to hit up DragonCon, GenCon, ComicCon, or any other sort of con and want to dress up? Well, if you're going as your favorite Dungeons and Dragons character (there's others, but this one was first to mind) and that character happens to use an axe, there's a cheap way to make your own with a broom handle, some cardboard, spray paint and time! In this video you will learn how to construct a battle axe, a pole axe AND a war axe, pretty cool right?
Fitness gurus always recommend you have fun during your workouts in order to keep your mind and body stimulated and to get you to keep working out. But we all know that after a few lateral lifts and jumpkin squats we're feeling more exhausted and in pain than excited and energetic.
Altered chords are a great spice to add to any song, especially in Jazz and Fusion. But trying to improvise over them in a solo can be disastrous if you aren't playing on the key tones of the chord, you will just create a large amount of a-tonal and diminished notes that you might not want in your lines. In this great video you will learn one great technique to keep in mind when improvising a solo over an altered chord using melodic minor of the note a half step up from the root of the altere...
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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.
Sadie teaches us how to double down breath to stop smoking, de-stress, and detox. A great place to go is to your bathroom, people won't bother you for at least five minutes while you're in here, allowing you to calm down. This will help bring yourself back to center and cleanse your mind, calming down your brain waves. Start by breathing in for four counts through the notes, allowing the ribs to flair wide. Hold this for a moment, then exhale on eight counts from your mouth. Squeeze the belly...
This may surprise you, but rowers weren't born with a perfect six pack of abs and Incredible Hulk-like shoulders. They happen to be in a sport that revolves around how fast they can move their arms from the front to the back with great water resistance.
To do this tricep and arm toning exercise, just think of the way you take a back scratcher to your back, moving your arms up over your head and then up and down until you finally scratch that itch.
We know those big exercise machines at the gym can be intimidating, but the next time you hit the gym you should consider making friends with one of them because they offer a resistance (often adjustable) that you can't get with workout tapes at home.
Most of the time it's not necessary to have exercise equipment in order to exercise. You can generally use your own body weight as a counterbalancing weight, but if you're interested in building massive muscle, then you do need to either hit the gym or purchase some equipment to achieve optimum bulk.
In order to get those Incredible Hulk shoulders and pectorals, you have to do lots of seated presses with heavy dumbbells. It's not exactly fun, we know, but soon enough you'll have big guns hefty enough to wrestle the best of them.
Perhaps one of the most difficult technical challenges of drawing is creating illusionistic images, mazes, or steps. Like in the movie "Inception," illusionistic spaces involve a dream-like atmosphere and paradoxes in structure, like a neverending staircase. If you're interested in stretching the limits of your mind, go see "Inception." Just kidding. Do go see it, but also check out this drawing tutorial.
If you're like us, you're not the biggest fan of papaya. Sweet but very pungent, papayas are an acquired taste for some and either loved or hated by others. But this recipe for a Thai salad made with green papaya may just change your mind about the oderiferous food altogether.
Tom Pecheaux, Estee Lauder's new creative director, came to the company with a vision in mind: Bold, more unexpected drops of color for their eyeshadow palettes, lipsticks, and glosses. And bold is the only way to describe his Blue Dahlia palette, which is filled with intense electric blues, blacks, and silvers.
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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to play the The Lost Vikings minigame on your spaceship, which is a ...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use Protoss Warp Gates and Warp Prisms to control massive section...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use the Zerg unit the Overseer and their Spawn Changeling ability...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use the Protoss High Templar's Psionic Storm ability most effecti...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to use the Zerg Queen's transfusion ability effectively to allow the...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to build an effective and diverse army of Terran units that utilizes...
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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:
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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...
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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).
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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.
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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS 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 680th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a scenario button to a tToolbar or Ribbon in Excel 2010.
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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE 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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
