Largest Search Results

How To: Extract the three largest values from a list 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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

How To: Find the largest increase in a data set in MS Excel

Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.

How To: Sum the 3 largest or smallest values in a set in Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.

How To: Visit the world's largest fish market

Learn how to visit the world's largest fish market in Tokyo, Japan named Tsukiji. Follow along as you learn what to wear, what to watch out for, and most importantly, how to get the best sushi you'll ever eat. Visit the world's largest fish market.

Lightning on Demand: Building the World's Largest Tesla Coils

Electrical engineer Greg Leyh and company are currently creating a pair of 118-foot Tesla coils! The largest coil built to date is an 18-story tower constructed back in 1903 by Tesla himself, but Leyh has decided to not only recreate the huge coil, but double it in size. The project goes by the name of "Lightning on Demand" and is currently being constructed on an 81-acre plot in the Nevada desert. Once it's finished, the pair of coils will output 10 million volt acres 100 yards long—the size...

Size Matters: World's Largest Touchscreen Hacked Together with Ordinary Hardware

It's gigantic! It can handle over 100 simultaneous touch points! It has a curvature of 135 degrees! And best of all, it is not the newest, insanely expensive gadget to hit the market. Instead, this touchscreen was hacked together with a bunch of PCs, video cameras, projectors and cheap infrared illuminators at the University of Groningen, in the Netherlands. It works like this: "The cameras, illuminators and projectors are all placed behind a large, cylindrical screen (formally used as a 3D t...

How To: Shop iTunes on the Apple iPhone 3G

Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to shop iTunes on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.

How To: Enhance your breasts

In this video from TheCurrentCustom she teaches how to enhance your breasts. First she says you need to measure your breasts to figure out the right kind of bra for you. Take the measuring tape below your bust, and wrap around back, and then measure right above your bust. Round down to the nearest even number if you get an odd number. Then measure your bust size by wrapping the tape measure around the largest part of your bust, typically where your nipples are. Then subtract the bust size fro...

How To: Draw the human skull in frontal view

Halloween is the holiday of goblins, ghouls and witchcraft, and also death. So, what better way to celebrate the spooky season than with a skeleton drawing? More specifically, a human skull? Merrill K has you covered with this drawing tutorial. He'll show you the trick to sketching out a human skull (frontal view) in step-by-step instructions. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.

How To: Select and prepare Jackfruit

Have you ever heard of the East Indian fruit Jackfruit or Kanoon? The Jackfruit is one of the largest of fruits and almost every family in Thailand has a Jackfruit tree in their backyard. You can learn how to properly select a Jackfruit based on ripeness and learn the proper way of cutting it. Since the fruit is very sticky, it is best to oil just a little bit before cutting into the fruit. You can eat the fruit cold or use it as an ingredient in a meal. Save your seeds, and you can roast the...

How To: Create a plate wall

To build your plate display you will need a plate collection, some plate hangers, and a hammer. A good part of hanging plates on the wall is you can use cracked and chipped plates in your display. To get the plates ready to hang all you have to do is make sure they are clean and measured correctly so that you can get the right hangers for the plates. When purchasing plate hangers go with the smaller size. If the plate is 10 inches buy the 7-10 inch hanger rather than the 10-14 inch hanger. Yo...

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: Sprout a home terrarium

You can use either an open or a closed container for your terrarium. Because there is no drainage hole in the container it's really important to have a false drainage system. So you can add river gravel or rocks to the bottom of the terrarium as a drainage level. Put about one inch of rocks in the bottom of the terrarium. Add a layer of charcoal on top of the rocks and it will help to keep the whole terrarium fresh. The charcoal will help keep mold and bacteria from growing in the terrarium. ...

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: Adjust a front derailleur on a mountain bike

The video is about adjusting the front derailleur of a performance bike. To adjust the front derailleur you have to first adjust the rear derailleur to the smallest gear. To adjust the front derailleur shift the gear to the largest. If it does not slip into largest gear then adjust the barrel adjuster by turning it counter clockwise till it settles into the largest gear. Turn the barrel adjuster until it stops rubbing against the chain. The full process can be carried out whilst riding, it is...

How To: Make prawn cakes with potatoes

In America, the only seafood cake most people are familiar with is the crab cake. This video will teach you a recipe for a whole different kind of fish cake: prawn cakes. Prawns are the largest and most savory member of the shrimp family, and this recipe combines them with potatoes and some vegetables and then fries them in a pan to create a savory, whole-meal-in-one-piece final product.

How To: Make lollipop flowers out of fabric

In this video, we learn how to make lollipop flowers out of fabric. First, start out with dye that has four circles in different sizes. You will also need the Big Shot to cut out the circles and wool cut out to fit on the cutting board. Put the board through the machine and your circles will be cut out. After this, start with the largest circle and start to add the other circles on top with a hot glue gun. Now, add a button to the middle of the top smallest circle using a hot glue gun. Add a ...

How To: Defeat a Terran Mech unit as a Zerg in StarCraft 2: Wings of Liberty

As a Zerg, you'll be facing Terran armies, time and time again. But how do you beat them? How do you beat a Mech unit? This video will give you some strategic advantages to defeating a Terran Mech army unit as a Zerg in StarCraft 2: Wings of Liberty. For the Zerg, positioning is your largest factor in winning a battle. Can you surround, flank, can you sneak in, can you drop on them? Any of those allow your shorter ranged troops to close the gap and get into range of your enemies troops faster...

How To: Sort data in Excel

ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure u...

Prev Page