Clean Mind Search Results

How To: Create and build chords on the guitar

For beginners, you may learn a few basic chords here and there, but somewhere in your mind you must think about why do these chords sound like this, why is this an A chord and this a G chord? Well, wonder no more! In this video you will learn how the construction of a chord works, which is basically taking the root and adding a specific formula for what you're looking for. Let's say you want to build an A major chord. Well, you first have to build the triad which is the 1st note of the major ...

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Get the Raynor's Back achievement in StarCraft 2 campaign mode

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 get the Raynor's Back achievement in the first mission of the sin...

How To: Unlock the secret mission in the StarCraft 2 campaign mode

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 unlock and beat the secret level in Starcraft 2's campaign mode, ...

How to Beat Mission 1: Liberation Day of the StarCraft 2 campaign

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 beat the very first level of the game's lone campaign mode. It's ...

How to Beat Mission 4: Smash and Grab of the StarCraft 2 single-player campaign

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 beat level 4: Smash and Grab of the single-player campaign game.

How to Beat Mission 8: Welcome to the Jungle of the StarCaft 2 campaign

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 beat mission 8: Welcome to the Jungle in the single-player campai...

How to Beat Mission 13: Whispers of Doom of the StarCraft 2 single-player campaign

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 beat level 13: Whispers of Doom in the single-player campaign mode.

How to Beat Mission 14: A Sinister Turn of the StarCraft 2 single-player campaign

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 beat mission 14: A Sinister Turn of the single-player campaign mode.

How to Beat Mission 15: Echoes of the Future in StarCraft 2 single-player campaign

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 beat mission 15: Echoes of the Future in the single-player campai...

How to Beat Mission 16: In Utter Darkness in the StarCraft 2 single-player campaign

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 beat mission 16 In Utter Darkness in the single-player campaign.

How To: Use Terran Siege Tanks to defend ledges in StarCraft 2

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 Terran Siege Tanks to defend ledges, allowing Terran players ...

How To: Use the Protoss Colossus unit effectively against Zerg in StarCraft 2

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 Colossus unit effectively to decimate Zerg players.

How To: Make a wall of supply depots for Terran players in StarCraft 2

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 you can make a mobile wall of supply depots on your Terran base's...

How To: Use ledges to make the Terran Viking unit more effective in StarCraft 2

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 take advantage of ledges on the map to make your Terran Viking un...

How To: Use the Protoss Sentry Force Field against the Zerg in StarCraft 2

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 unit the Sentry and their force field ability to ...

How To: Use the Nony's Dual Gate Phoenix build order for Protoss in StarCraft 2

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 a build called Nony's Dual gate Phoenix for Protoss against Z...

How To: Use teamwork to win 2v2 multiplayer games in StarCraft 2

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 teamwork to achieve victory in 2 vs. 2 multiplayer games on B...

How To: Master the downward facing dog pose with Yogatic

In this tutorial, we learn how to master the downward facing dog pose. When you do this pose, you will be opening up your entire body. Start by centering yourself for a few moments and center yourself. Place your hands on your stomach and feel yourself deep breathe. Start to clear your mind and stop thinking about your problems and issues for the day. Stay in this seated position for several minutes before you come into downward facing dog. When you get into this position, feel yourself breat...

How To: Simplify radicals & square roots using exponent rules

See how to apply exponent rules to simplify radicals or square roots with this free video math lesson from Internet pedagogical superstar Simon Khan. Looking for a primer on how to solve matrix problems using a TI-89 graphing calculator? See how it's done with this free video algebra lesson. 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 follo...

How To: Use FOIL to distribute two binomials in algebra

Learn how to use the FOIL method to distribute two binomial expressions in algebra. The FOIL method — which stands for first, outer, inner, and last — takes two binomials and multiplies them for a single quadratic equation. Solving for binomials with FOIL takes just a few steps. Could you use a little help figuring out how to divide fractions? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have b...

How To: Turn a men's dress shirt into an adorable dress

What is more fun than wrecking your boyfriend's shirt and turning it into a cute dress? In this tutorial, learn how to take a super oversized men's shirt and make a totally adorable summer dress with it! You will need to know sewing basics and be sneaky enough to get a shirt out of his closet, though! But in the end, this dress is so adorable, he probably won't even mind!

How To: Use Vonage anonymous call blocking feature

If you are looking for a way to prevent telemarketers and nothing else is working, consider signing up for Vonage's call blocking feature. In this tutorial, brought to you straight from the professionals at Vonage, learn how to set your phone to block any incoming call without a number attached to it.

How To: Play a Bo Diddley beat on the ukulele

This how to video shows you how to play the Bo Diddley beat on a ukulele. You will need a tuned ukulele and basic knowledge of chords to do this. First, form a D chord. That is, place your fingers so that the first string first fret, second string first fret, third string second fret, and fourth string third fret are pressed. Use your right hand go up and down. Do not place your fingers all the way on to the fret. Only press down at the right times to create the beat. You will be making muted...

How To: Create an acid-base indicator using purple cabbage

Purple cabbage is a natural indicator and this video teaches you how to easily prepare purple cabbage in the comfort of your own home to be used as an acid and base indicator. Take one leaf of your purple cabbage, tear it into smaller pieces and place all the pieces into a beaker or bowl of boiling water for an hour. Collect the liquid from your mixture into a bottle. You’ll notice that the liquid is now dark blue or purple at which point is neutral. It is ready to be used as an indicator. ...

How To: Tag people and fan pages in your Facebook status

In this video, we learn how to tag people in pages in status updates. To do this, you need to open up your browser and log into www.facebook.com. Once you get to your profile, you will see a box that says "what's on your mind?". Type whatever you want to into this box, and to tag someone all you do is write "@" followed by their name, and their profile should pop up. Click on their picture and the text will now show a blue hyper-text when you post it. Now when people see your status, they can...

How To: Check the fluids in your car

What runs underneath the hood of your car is pretty important. No, scratch that. IT IS VERY IMPORTANT. That is the life force of your vehicle and if you want to make sure you are able to make that car last and use up every penny you have spent on that beautiful piece of machinery, then you better make sure that you constantly check the fluids throughout your car frequently. Oil, transmission, clutch, brake, etc. those fluids help make sure your car will run nice and smoothly for years to come...

How To: Create a Twitter account

In this video, Brian from Trutricks shows us how to create a new Twitter account. First, go to Twitter and click on the "sign up now" button. You will now be brought to a new page where you can choose your user name and enter your email, password and full name into the information boxes. Once finished, click "create account". After this, you will be able to follow people you want as well as have other people follow you. Once you are ready to tweet you can type whatever is on your mind in 140 ...

How To: Generate random numbers not divisible by 3 in Excel

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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.

How To: Teach your dog loose leash walking

In this two part video Tab and his German Shepherd "Solea", show exactly what you need to do to stop your dog from pulling on his lead. Eventually, your dog will be walking on a loose leash where they'll feel safe, satisfied, and help keep your dog healthy. While there are many dogs that pull on walks, any dog can learn to walk calmly on a loose leash if we create a positive learning environment and teach them in the way that their minds understand. Find out how using positive reinforcement y...

How To: Install memory in a 17" MacBook Pro laptop

The geniuses at Other Word Computing (OWC) show you how to install new memory cards in your 17" Macbook Pro pre-unibody, only by using a screwdriver and a little elbow grease. The only thing to keep in mind is that your laptop must be an older model, created prior to February 2009. Newer unibody models will not allow you to crack the case. Once you have your screwdriver, it's as easy as flip, unscrew, slide the old cards out, and slide the new modules in. Don't be stuck with an out of date Ma...

How To: Stop your car during sudden acceleration

With the recent recall of 3.8 million vehicles from Toyota for falty acceleration pedals or the "floor mat problem", it's important to know what to do if your car gets a mind of its own and starts accelerating out of control. If you own any of the recalled car models including the Camry or Prius, be sure to listen up! This video might just save your life! Learn how to stop your car during sudden acceleration with help from the car safety video.

How To: Origami a Christmas star aka Spiked Dodecahedron (SPD)

The Origami Spiked Pentakis Dodecahedron is an excellent Paper Christmas Decoration Star made out of 15 paper squares. In spite of the large paper size I was defeated by the last module after nearly 2 hours (!) of trying to lock the last unit in place each time another one dislodged. Never mind, it is still a remarkable sound structure once (nearly) completed and you can not see which one is not locked anyway.