Applied Sorts Search Results

How To: Properly fish in a stream

Fishing is a great way of saving you money on having to pay for over priced pre-cleaned fish at the grocery store, it's also a way to relax and enjoy nature. If you're planning on heading on down to your local stream to get some fish, take these tips into consideration. In this video you will get some tips on what sort of physical characteristics of the stream are and also what sort of fish to expect in what types of waters.

How To: Create multiple inboxes in Gmail using filters

See how to set up multiple inboxes within Gmail and use filters and labels to have mail sent to different addresses automatically sorted (and mail sorted using other criteria too, like subject, or containing certain words). It's easy! So easy, in fact, that this Gmail user's guide can present a complete overview of the process in just over four minutes time. For details, and to get started using Gmail's useful filtering feature yourself, take a look.

How To: Set data up for sorting & filtering 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Sort data horizontally by formula 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 471st installment in their series of digital spreadsheet magic tricks, you'll learn how to sort horizontally with 3 different formulas that use the LARGE, SMALL, COLUMNS, IFERROR and IF functions.

How To: Set up Virtual DJ with two separate sound cards

In this video tutorial, viewers learn how to set up Virtual DJ with two separate sound cards. Users may choose to use a proper PCI or USB sound card. Begin by the USB card. The drivers will already be on your system. Now open the Virtual DJ program and open the Settings. In the Sound Setup tab, click on the Output drop-down menu and select HEADPHONES. Next, click on the Sound card drop-down menu and select 2 CARDS. Now click on Apply and OK. This video will benefit those viewers who enjoy mix...

How To: Make leaf size sorting bags for a kid's fall acitivity

Shelley Lovett shares a great children's fall activity to help develop math skills - leaf size sorting bags. All that is required is three paper bags and some construction paper. Use the construction paper to cut out three different-sized leaves, and to make three labels saying 'small', 'medium', and 'large'. Then simply glue the small leaf and small label on one bag, medium leaf and label on the next bag, etc. To make the loose leaves of the three different sizes they place into the bags, si...

How To: Sort and filter in Microsoft Excel 2007

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.

How To: Shave pubic hair for men

The pubic area is a very, very tricky area, when trying to shave and so in this video, Dan and Jennifer from Ask Dan and Jennifer try to supply some useful tips and tricks for this delicate operation. First, you need the proper tools. These include, Dan and Jennifer say, a good electric trimmer, a razor that's not a straight razor and of course shaving cream. Secondly, always use the trimmer and then razor on the surrounding pubic hair, not the main area, first. Third, you want to go, from ar...

How To: Apply snow queen or winter themed costume makeup

Whether you're dressing up as a snow queen, maybe from Narnia, or just going for some sort of wintery look, this how-to video shows a way to make some stunning costume makeup. The cosmetics used to create this look are Coty Translucent Setting Powder, Matte Texture Cream, Sugar, Brows: Platinum Plus Pro Lash Mascara, MAC Pixel Paint, MAC Silver Fog Pigment, MAC, Dovefeather Eye Shadow liner, MAC Facsinating Eye Kohl, Dovefeather Eye Shadow, Platinum Plus Pro Lash Mascara, Makeup Forever White...

How To: Perform the instant sort card trick with ease

This trick is great for beginning magicians! A very simple concept: You mix up the deck, mixing face up and face down cards, and then you sort them instantly with just a little bit of magic. In this video you'll see a demonstration for the trick and then a great, step-by-step, tutorial on how to perform the trick and some techniques to get you going.

How To: Use the filter & sort feature in Excel

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...

How To: Set up your Gmail account in Mozilla Thunderbird

In this video from MegaByteTV we learn how to set up a Gmail account in Mozilla Thunderbird. First go to your browser and download Thunderbird from the Internet. Once downloaded, go to the Thunderbird application. Go to New and Account. Click on Gmail and enter your name and email address. Click Next and check off download messages now and click Finish. Your messages should now appear there. The first time you do this, all of your messages will look new but you can change that. If you'd like ...

How To: Build a laser tripwire that can trigger anything out of a photoresistor

This video, incredibly short for it's massive content, will teach you how to make a laser tripwire that, combined with a photoresistor, can trigger just about any device. You can make traps, alarms, awesome party decorations, and all sorts of other awesome things with this easy-to-make device, provided you have a soldering iron and a local electronics store to buy some parts.

How To: View and sort email messages by date or sender in Microsoft Outlook 2010

Need some help figuring out how to sort your emails by date or sender in Outlook 2010? This video will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.

How To: Manage photos in Aperture

Instead of using Photoshop, why not give Apple's Aperture a try? Aperture is designed more for post-production work for professional photographers, letting you cull through shoots, enhance images, manage massive libraries, and deliver stunning photos.

How To: Apply makeup to be "scene"

Scene style makeup is in, and in this video we are given the essentials in creating this sort of look. Beginning as you begin with any makeup, we are advised to apply a base, consisting of either a general foundation or a powder. As we go, the video author offers specific brand recommendations and shows the results, via pictures. Now, after our base, the steps are as follows.

How To: Create a Pareto chart for categorical data in MS Excel

If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.