Minimum Search Results

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Keep dust to a minimum in your home

In this video, we learn how to keep dust to a minimum in your home. First, keep an eye on your furnace and make sure that when you are doing home repairs, it doesn't get onto your furnace. Also, make sure your filters throughout the home are clean or replaced very often, especially while you are doing home projects. Also, keep windows closed, especially while it's windy outside, because this can let dust enter your home easily. You should also avoid extra aggressive sweeping, because this can...

How To: Perform a general chest exam on a patient

There's no better way to learn then by visual media, and that's what makes this video lesson on performing a chest exam so great. It's perfect for any future doctor, and great for nursing students to understand the proper procedure for examining a patient's chest. Medical students can easily learn how to perform a general chest exam, because ever step and technique is outlined and shown. A chest examination is very important to determining what's wrong with your patient, and you will be able ...

How To: Make pigs in a blanket from scratch

In this tutorial the how2heroes show us how to make pigs in a blanket from scratch. First, take 2 packages of mini cocktail franks, place them in a bowl and set aside. Now, that 2 1/3 cups of flour, pinch of salt, 1 stick of room temperature butter, 1 (8 oz) package of cream cheese and mix it in a food processor until it's made a crumbled texture. Now, add 2 eggs and 2 tbsp of cold water and keep pulsing until the mixture has come together. Now you will place the dough on a counter with flour...

How To: Make Asian vegetables with soy sauce gravy with Betty

Chinese food is delicious, but it isn't very healthy and can be quite expensive. In this video, Betty adds a Southern touch to a traditional Asian dish and makes vegetables with a soy sauce gravy. The veggies are good for you and filling, and the gravy gives them a nice, hearty texture. Enjoy this dish anytime, and if veggies aren't enough for you - toss in some chicken or seafood, or even noodles and create your own delicious meal!

How To: Find the fan tribute room Easter egg in Halo: Reach for the Xbox 360

There is a very special easter egg in Halo: Reach on "The Package", that is almost impossible to find unless someone told you about it. It's going to require a second player at minimum to help you, as well as having to play on Legendary. If you can do it, you will get the holy grail of easter eggs in the game: a fan tribute room built by Bungie for the community! In this video, the guys over at Achievement Hunter show you how to activate the room, and also geek out over seeing themselves in t...

How To: Hack Shopping Cart Hero 2 with Cheat Engine (12/20/09)

This video provides detailed instructions on how to hack into the game credits of 'Shopping Cart Hero 2'. The first step in this process is to complete the first level of the game in order to gain in-game funds. The instructor then shows how to use a cheat engine when buying an item in-game to change values within the game to whatever you choose allowing the player to have unlimited funds and buy everything they want within the game. This means that the shopping cart can easily receive every ...

How To: Speed knit with the world's fastest knitter

Learn how to increase your knitting speed with Miriam Tegels, the World's Fastest Knitter. She can stitch 118 stitches in one minute; a record that appears in the Guinness Book of World Records. Miriam Tegel's knitting secret is keeping all movements to a minimum. Use size 8 knitting needles and DK weight yarn for optimal performance. After casting on sixty stitches, see how many stitches you can knit in three minutes. Good luck!

How To: Make no knead bread

Watch this video to learn how to make no-knead bread. In a large mixing bowl, dissolve yeast into water. Stir in flour and salt (dough will be sticky). Cover with plastic wrap and let sit in warm place for a minimum of 8 hours at room temperature (approximately 70 degrees). Ten to twelve hours may be necessary, so letting it sit over night is a good idea, provided there aren't any dogs that will jump on the counter! The dough will be ready when the surface is covered with bubbles. Lightly flo...

How To: Use a light meter to properly light a digital film

A light meter can prove to be an invaluable tool on any film set, allowing you to quickly and efficiently set lights and know the correct exposure values of those lights. Light meters were initially designed for still photographers and cinematographers can easily calibrate them to a given film stock speed for shooting film. But what about today’s digital cinematographer? I’m glad you asked. In this video tutorial you'll see how you can use a light meter to quickly and efficiently light a scen...

How To: Make Chain Mail Armor from Start to Finish

This article is a guide for making Chainmail Armor from start (simple wire) to finish (a finished chainmail shirt). We will be using the European 4 in 1 weave, as this is the most common weave. This is the weave that you usually see in movies. There are several sections to this guide: Materials, Making the Rings, Weaving the Rings, and Making the shirt.

How To: Create makeshift laundry detergent from a bar of soap and boiling water

If you need to save your money for bills, then this laundry tip will help keep the costs of laundry to a minimum. It's a really simple and cheap tip if you happen to be out of laundry detergent during a load. Simply grab a bar of soap and cut a third of it off. Then place it in a pot of boiling water and let dissolve for about ten minutes. When it's done, transfer it to a large bowl and stir for about thirty seconds. Then it's ready! Makeshift laundry detergent!

How To: Use chickens to control garden pests in orgainic farms

Curtis Smith provides information on how to use chickens to control garden pests. Using chickens keeps the use of pesticides to a minimum and keeps plants healthier. In the organic garden, chickens are used because they'll eat any insect as well. The process is known as Integrated Pest Management, Curtis explains that its basically knowing your pest. It also reduces the amount of feed that has to be purchased for the chickens because they're eating the insects in the garden. It also controls ...

How To: Cut a pineapple in an artistic and less wasteful way

This video showcases the skills of the demonstrator in cutting a pineapple in an artistic manner. He begins by removing transverse sections, one each from top and bottom with a sharp knife. He then cuts off the remaining skin vertically in eight thin sections to keep wastage to a minimum. He marks off oblique lines one above the other all along the periphery. He cuts off very thin and small oblique slices along the marked lines, rotating the pineapple slowly. The resulting shape is now like a...

How to Make Indian food: Mutton curry

The author of this video tells her recipe for Mutton Curry, as well as shows the dish being made at different steps in the process. The dish is made with Mutton as the main ingredient, and includes ginger paste, garlic paste, yogurt, onions, various powdered spices, cloves, and salt. It is cooked in a pressure cooker, and she explains how everything should look at different intervals of cooking the dish. She explains that one might agree that minimum spices can be better than many different t...

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: Make spiced tapioca sago

This video describes how to prepare the tapioca sago. First take 2 cups of tapioca and wash, drain and soak in ¬O cup of water. Soak it for two hours minimum. Then the tapioca will become softer and become larger in size. Next take a pan and take 2 table spoons of oil and one table spoon of oil in that heat it for a while. Next ¬O teaspoons of cumin seeds then add green chilies and then add 2 table spoons of peanuts. Once the peanuts are fried, add the slices of potato. Next add the ¬º spoons...

How To: Dual boot Windows 7 & save YouTube videos

Patrick Norton and Veronica Belmont from Tekzilla will show you how to dual boot Windows 7 and download videos from YouTube. The hosts show viewers how to dual boot Windows XP Pro32 bit and Windows 7 RC 1 64 bit. In the first step as always you will want to back up your hard drive and at the very least they recommend to back up your most important files. In the case that something goes terribly wrong you can use a free program called EASEUS to make a complete image of your whole drive, this a...

How To: Build a wormery

If you don't have room for a full-scale compost heap, you can always employ the services of some worms. In this handy vermiculture how-to, you'll learn how to build your very own wormery.

How To: Pack your wallet for an itnernational trip

With all the documents ready, we need to fill our wallet with money for the travel. This video discusses various ways of filling the pocket. That is how to prepare the money for international travel. Over the years credit cards have been widely used by many travelers, which is safer than carrying cash. In this case we need to contact the credit card provider well in advance and notify them about the travel. Also we need to learn about the various fees applicable to international purchases. Th...

How To: Use optimization methods in calculus

This video shows how to use optimization methods in calculus. Optimization means finding the maximum or minimum values of a quantity or finding when the maximum or minimum occurs.What quantities are optimized in economics?we want to minimize costs or maximize revenue.First steps in any optimization problem1.Identify the quantity to be optimized i.e., read the problem exactly what is exactly maximized or minimized.2.Identified the feasible domain. This is important because the math we can opti...

How To: Make a quartile diagram (aka, box and whisker plot)

This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...

How To: Calculate & compare interest rates in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:

How To: Create a line graph

This video shows the method to make a line graph. First step involves drawing a horizontal and vertical line joined at one end. We have to plot the maximum and minimum temperatures during 5 days. Label the vertical with the temperatures(10, 20, 30...50) and the horizontal line with the days of the week(Monday....Friday). Label the vertical line as 'Temperature' and the horizontal line with 'Day of the week'. Plot the temperatures selecting the day from the horizontal line and marking at the c...

How To: Do a goddess-pose breathing exercise

Wind down with the simple yoga relaxation exercise outlined in this free video lesson. As an added bonus, unlike most yoga exercises, which require some bare minimum of athleticism, the "goddess pose" demonstrated in this tutorial is as simple as reclining. Find out how to do the goddess pose with help from a yoga instructor in this free video on yoga relaxation exercises.

Prev Page