Mind Filing Search Results

How To: Unroot a Motorola Droid phone and restore it to stock settings

The Motorola Droid is getting a little long in the tooth, but it is still a remarkably capable phone with full keyboard, which makes it almost unique among it's Android-based competition. If you've rooted your phone (good for you!) and for some reason want to go back to the stock configuration that your phone was in when you took it out of the box, this video will show you how to do it. One good reason is if you want to update your phone's firmware, which will not work if you phone is rooted ...

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: Stealth patch XBox 360 ISO's with AGBX 360

If you have a hacked XBox 360, you've only accomplished part of the process required to allow you to played burned copies of games on your console. You also have to burn the games correctly, and part of doing that is stealth patching you ISO files to make sure that they are up-to-date and won't get you noticed by Microsoft. This video will show you how to use AGBX360 to stealth patch you files and make them ready to play.

How To: Multiply radicals in algebra

Looking for a primer on how to multiply two or more radicals? 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 follow in their footsteps (or just finish your homework or study for that next big test).

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: Complete quadratic equations by factoring

Scouring the web for instructions on how to factor quadratic equations in algebra? Look no further. This free video algebra lesson will teach you how. 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).

How To: Solve a linear equation for x in algebra

Need a little help figuring out how to solve a linear equation in algebra? Learn how with this free video 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 follow in their footsteps (or just finish your homework or study for that next big test).

How To: Calculate the GCF & LCM of a given number set

Need help figuring out how to find the greatest common factor and/or the least common multiple of two given numbers? Learn how with this free video 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 follow in their footsteps (or just finish your homework or study for that next big test).

How To: Solve a set of two linear equations by graphing

Need to know how to solve a set of linear equations by graphing? Learn how with this free video 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 follow in their footsteps (or just finish your homework or study for that next big test).

How To: Use the Adobe Camera Raw plug-in for Photoshop

Want to work with RAW image files in Adobe Photoshop? With the Adobe Camera Raw plug-in, it's easy. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from Tutvid. For more information, and to get started using and editing RAW image files in Photoshop yourself, watch this graphic designer's guide.

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: Conditionally format a vertical histogram in Excel 07

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 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.