Mind Complicates Search Results

How To: Use AGGREGATE instead of SUBTOTAL in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Draw martial artist Bruce Lee (face, body and shading)

When you think of martial arts, only one name comes to mind, and no… we're not talking about Steven Seagal or Chuck Norris. We're talking about Bruce Lee, the epitome of martial arts. Not only was he the best martial artist known to man, he was also an accomplished actor, instructor, director, producer, screenwriter, and philosopher. But there was one thing he wasn't. An artist. Okay, he was a "martial artist", but he wasn't a visual artist, master of the pencil, kind of the drawing world… bu...

How To: Use FREQUENCY array functions in MS 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.

How To: Con a free meal from the drive-thru at McDonald's

Want a free meal at McDonald's restaurant? Forget those money-saving (supposedly) weekly coupons, that's nothing compared to an actual free meal. Coupons won't get you that. But this method of free food, perfect for the freegan or the poor (or maybe just the rude). This would technically be qualified as a prank or con, but hey, you got to eat, right?

How To: Solve dog counter surfing with a clicker

It's a timeless doggie no-no, and one that has been paradied in numerous dog scenes in movies: A plate of delicious fried, steaming food is left by the owner on the table. The owner then leaves for a brief moment. His dog, smelling the delicious goodness, seizes the moment and quickly jumps up, snatches a piece of chicken, and devours it under the table.

How To: Mod your PS3 to have more USB ports

You can add USB ports to your PS3 at home. Put two new ports onto the back of your PS3 for a total of six ports to get even more out of your machine. You will need a basic knowledge of circuitry and some electrician equipment to do this the right way. This video will show you how to add USB ports to your PS3. Keep in mind that this video does not show you how to reassemble it so be sure to keep track of your work.

How To: Throw a great baby shower

Baby showers are a great time to bond with your girlfriends and help out new mommies. In this tutorial, learn some helpful tips to ensure your baby shower goes smooth and everyone has a fantastic time: especially the guest of honor!

How To: Act and be like a Scene girl

So you're into Emo music and are looking to dress the part? Look no further! EmoWorldTV shows you a few simple steps to make yourself totally Scene. Scene girls are unique, cute and always check their MySpace pages. So, get out your makeup, your digital camera and some scissors and start styling yourself Scene.

How To: Use ActionScript 2.0 and Flash 8 Professional

Shown here is another video tutorial made possible through TutVid. In this video, you are learning the basics of Action Scripting in Flash. This lesson is titled "Action Scripting:101." Action scripting is one of the coolest thing about flash. The thing that makes flash special is the ability to make simple actions interactive. Flash possibilities are endless!

How To: Pitch a tent for a campout as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Prepare and cook your patrol's meal as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Tie two half-hitches knots as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Hike safely during the day and night as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Display, raise, lower and fold the flag as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Identify local poisonous plants as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Save someone from choking as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Show simple first aid knowledge as a Boy Scout

Tenderfoot is the first rank earned as a Boy Scout. The requirements of becoming a Tenderfoot provide basic skills to begin preparing the scout for higher adventure outings. Earning badges and receiving recognition can be very satisfying to boys. However, keep in mind that the badge is only a representation of a valuable set of skills that a scout has learned and demonstrated. The skills, wisdom, and experience gained through the activities of the scouting program are of much more value than ...

How To: Tag like a real graffiti artist

Graffiti— do you have the guts to get out there and tag some property? There's a whole lot more than just spray paint involved. To be great, you'll need things like a sketchbook, pencils, pens, markers, spray can tips, latex gloves, legal (or illegal) wall, and most importantly… creativity. If you think you’ve got what it takes to be an urban graffiti artist, follow these steps to become da ’hood’s next da Vinci.

How To: Use the LARGE and SMALL functions 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 616th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the LARGE and SMALL functions to retrieve the 1st, 2nd, and 3rd largest values from a list. You'll also see how to do each of the following:

How To: Make a Scottie dog from folded paper with origami

Take a piece of paper and fold it triangle wise. Then unfold it and fold two edged sides towards the center. Then turn back in the same manner and fold right there. Then again turn back and fold two sides as done before. Then straight that part and fold into two sides and then fold one side to an upside direction. Then fold it downwards holding the center part. Then again fold downward the folded portion and a little bit upward the edged part. Keep intact the edged portion. Then fold the next...

How To: Break up with your crazy girlfriend

In this how to video, you will learn how to break up with your girlfriend. First, you should make sure that problems have been building up. This is the initial part that should make you decide whether or not you want to go through with it. This includes your girlfriend nagging and complaining at you. If you are prepared to do this, the next part is the actually break up. You can approach your girlfriend in person and tell her it is over. Tell her why you are breaking up. Another method is bre...

How To: Do a fakie on a BMX

In this How To Video Kurtis Elwell will walk you through how to do a fakie on a BMX. The best place to start learning how to roll a fakie is on a steep hill or incline. As soon as you start to lose momentum on the hill you will stop for a moment then start rolling backwards. If your BMX is equipped with a cassette wheel it will start to force you to pedal backwards. Then, when you are rolling backwards and want to turn around, turn your front wheel to a 45 degree angle. Lean back a bit so all...

How To: Encrypt files in Mac OS X with the Disk Utility app

The Mac OS's Disc Utility allows for the encryption of files. To open Disc Utility click on the magnifying glass (spot light) up in the top right hand corner, and search for Disc Utility. Click on the first result in the list. Once Disc Utility is open, click on "create a new image" in the top tool bar. A new window will drop down, where you choose what you want to save the new image as. Give it a name, and choose the size you want it to be. Moving down, choose the encryption you want to use ...

How To: Create a grip with paracord

When is a knot not a knot? When it's a grip. The knot outlined in this video isn't a knot per se but a way to wrap objects to increase their grip and also to store extra paracord. Specifically, this video demonstrates how to County Comm Micro Widgy Bar, which is a miniature pry bar. It’s made from hardened D9 steel and is around 3? in overall length.

How To: Become a dentist

Does dentistry sound of interest to you? If you don’t mind spending the day in other peoples’ mouths, dentistry might just be the career for you. In this video, learn what steps need to be taken to break into the field of dentistry.

How to Walkthrough Bayonetta: Epilogue - Requiem

This is the last of the Xbox 360 game Bayonetta, where it's all or nothing. In Epilogue - Requiem, you're playing a Jeanne. On verse one, you're on a motorcycle headed toward the camera. There are some enemies chasing you, so shoot them. You'll need to evade when they shoot at you. Ride in a serpentine (zig-zag) patter to avoid their shots. For more info, watch the whole gameplay.

How to Walkthrough Bayonetta: Ch. 16 - The Lumen Sage

In this level on the Xbox 360 game Bayonetta, make sure the bullet enters Balder's head. In Chapter 16 - The Lumen Sage, keep that bullet in line. Father Balder doesn't do much damage, but he tends to stay out of range. When you do have him in range do as much damage as you can. Keep fighting until you get his health meter down to zero and can do a climax attack. For more info, watch the whole gameplay.