Classic Display Search Results

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 brightness to save battery life on an Android

The new Android enabled phones can take up a bit of power, so knowing the best way to manage your power settings is crucial in having a fully-charged cell phone all the time. The biggest key is making sure your screen brightness isn't more than it should be. Best Buy has answers. The Best Buy Mobile team explains how simple it is to adjust screen brightness to save battery life on an Android cell phone.

How To: Change the accessibility options in Windows 7

This video teaches how to change Windows 7 accessibility options. Choose Start, Control panel. This opens the Control Panel window. Choose Ease of Access in the control panel window. This opens Ease of Access window. Inside the Ease of Access window, there are various links that allows you to set various accessibility options in windows 7. You can use these settings for options like "Optimizing Visual Display", "Replace sounds with visual cues" and you also have settings to choose how the way...

How To: Use basic functions in Excel (AVERAGE, COUNT, MIN/MAX)

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...

How To: Pin recent Excel documents to the office button menu

This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn t...

How To: Manage all your passwords on your iPhone

Mike Callahan from Butterscotch describes how to manage the passwords on your iPhone by using the 1Password app. The application costs $5.99 for the Pro version. First, you enter an Unlock Code to give you access to the app. The icons across the bottom of the screen correspond to different features of the app. The Logins icon stores your login information. The Wallet icon stores information about your credit and bank cards. The Passwords icon holds all your passwords. The Add icon allows you ...

How To: Tie the Trilobite decorative knot

Learn the right way of tying the ‘Decorative Trilobite Knot’, by watching this video. Take a rope and form two bends, as shown. Now pass each bend over a hook to form two loops at the center, resembling number eight. The free end of the rope on the right side is then passed over the lower loop of the eight, to the left. The free end of the rope on the left side is then passed under the rope, just passed from the right. Thereafter, it is passed under the lower loop of the eight, and pulled thr...

How To: Check for a HomeGroup setup on your PC in Windows 7

In this video the instructor shows how to check if your computer has a home group setup or setup one if required. Home group is Microsoft's new way of making networking easier with computers. They allow you to share documents, pictures, videos and all kinds of media between computers that are a part of a home group. Go to the start menu and go to Control Panel. In the Control Panel select the Network and Internet link. Now in the Network and Internet window select the Home group. In this page...

How To: Make Shrimp Tempura Sliders

This is a refreshing spring update on your classic hamburger slider. Instead of using a ground beef patty, I am using shrimp tempura. This recipe calls for fresh truffles, but fresh truffles are hard to come by so feel free to use truffle oil (it is much more affordable and what I usually like to use). The flavor will be just as good.

How To: Measure intraocular pressure to diagnose glaucoma with a Diaton Tonometer

Attention all optometrists and ophthalmologists— there's a new tool in town, and it's called the Diaton Tonometer. Diaton's tonometer is an easy-to-use and accurate instrument for measuring intraocular pressure (IOP) through the eyelid, which makes it simple to diagnose patients with glaucoma during the early stages, so that immediate treatment and medicines can be administered. This transpalpebral tonometer is handheld, pen-like and no-contact, which provides absolutely no risk of infection....

How To: Create Fringe-style floating titles in Adobe After Effects CS4 or CS5

If you're looking for a cool way to add text to your videos, like for an opening sequence to a film where the credits are displayed, embedding the text directly into the scene is the way to go, especially if you like the hit television show "Fringe", who used these kind of embedded title effects in establishing shots. Car adverts use this technique a lot, as well. "Panic Room" also use this effect in the opening title sequence.

How To: Discipline your toddler without spanking

At one time or another, every parent has thought about taking off the belt, but that's frowned upon in our current society, perhaps even illegal. Even using you hand could be too harsh for the child's sake, but there are ways to get your unruly tot under control. Toddlers are often headed for trouble, but you can steer them in the right direction without spanking.

How To: Grill churrascaria-style

Churrascaria? What's that? It's a meat-lover's dream… if you're in Brazil. But you don't have to travel abroad to enjoy the meaty goodness of this awesome grilling party! A churrascaria is an all-you-can-eat Brazilian steak house that features an amazing array of spit-roasted meats. Recreate the experience at home with these tips. The churrasco grilling style was inspired by Brazilian gauchos, or cowboys, who cooked their meat on skewers over open fires.

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: Pickle cabbage

A clear and easy method of making the traditional and healthy Russian food pickled cabbage is displayed in this video. Our chef begins by highlighting the nutritional values of the food, then goes on to detail the type of cabbage suitable for the dish. The chef then demonstrates how to correctly slice the cabbage with both a standard kitchen knife and a slicer, and then garnishes the cabbage with sliced carrots and salt - a vital part of the meal, explained by the chef: too much would be unpl...

How To: Find the capital to start your own clothing line

The video presents "How to start your own Clothing Line Business". The steps include getting the financing, designing the prototype outfit/s, producing the line of clothing, promotion and sales. A good way of financing for a small business such as this is to sell your idea to family, friends and even colleagues. Research and prepare the business plan for your clothing line and be passionate about it in your presentation to convince them to fund your business. The next step is to get the produ...

How To: Create a custom caption box in Wordpress

In order to create a custom caption box in WordPress you'll need to go to your dashboard. Here click on appearances, then on editor. Now over on the right select the sidebar option. Here you'll see some code, what you need to do is find the word that you want to replace on the main page, you can use ctrl+F to find the word. When you've found it within the code just replace it with whatever you want and then press the 'apply' button. You'll see that the main page will now be displaying the wor...

How To: Autoplay, loop & change the size of YouTube videos

YouTube videos can be embedded in other websites like MySpace. Go to the YouTube page of the video that you want to display on other websites. In the right had side of the page there are details of the video like the URL to it and below it is the Embed link. This link can be used to embed this video in other websites. To do this first copy the embed code and go to your MySpace edit page. Copy the code over there. Now delete everything that is there between the embed tags. Now in the code afte...

How To: Play "Stuck on You" by Lionel Richie on ukulele

In the left side of your screen you can see the brown color bar which shows the different strings sections of the Uke Player. When a particular note has to be played that shall also be displayed by blue buttons on the screen. You have to watch these blue buttons and then follow it to pull the strings on your Uke Player. First you have to pull the second section of second string, third section of the third string and the second section of the fourth string. In the next note you have to pull th...

How To: Use Handbrake to rip DVDs to your Mac OS X hard drive

HandBrake is an application that lets you to burn any DVD into any other format for any of your devices like music and gaming devices. Open the HandBrake application. Initially it displays a menu that can be used to rip a DVD. First select the source. You can browse your computer for the source. Insert a video DVD that you want to rip and select it from the source menu. Now you set the destination. Browse to any of the folder on your computer where you want to put the output video. HandBrake ...

How To: Connect your bluetooth phone to your PC wirelessly

The video demonstrates how to connect your Bluetooth phone to your computer and send/receive files between them through Bluetooth. You need to first switch on Bluetooth in your phone and then click on the icon for Bluetooth connectivity in the computer. Then click on the option called 'Add a Bluetooth Device'. You can see a setup wizard pop up in your computer screen where you have click on the check box and then click on Next button. Once the phone is detected, select it and click on Next. T...

How To: Spy on someone using your iPod touch or iPhone

Ownspy is powerful program which can be used to backup your iPhone remotely. This program can be used in both good and bad ways. If you have children you can keep track of them by installing this program on the phone. This regularly uploads the content from the phone to the website. So in this way you can know in what way the phone is being used. Also this can be used by a jealous boy friend to spy on his girl friend. This programs tracks your location, backs up your messages, pictures. It al...

How To: Shrink a Windows Vista partition and install iATKOS

This video presents how to defragment and shrink a Windows Vista partition using Perfect Disk 2008 Professional program.First you need to download and install software application named Perfect Disk 2008.Type Perfect Disk 2008 into Google search engine, choose first link from the list.On the Raxco software home page choose Free Evaluation option from the list to the right.Download and install Perfect Disk 2008 Professional.Once it is installed, run the application. From Menu choose Analyze op...

How To: Remove a Windows partition from your Mac hard drive

techstuff1227 narrates an HD-quality educational video about how to remove a Windows partition from a Macintosh computer using the Bootcamp software. To accomplish this easy task: open the Finder application, view your installed Applications, browse to the Utilities list and expand it to view the Disk Utility. Open the Disk Utility application. Once the hard drive information is displayed, click on the Windows partition, click on the minus (-) button, and a confirmation dialog will appear. Cl...

How To: Download torrent files

This video is about how to download torrent files. The first thing that you will have to do is to open your uTorrent. After opening your uTorrent, open your browser and browse torrent sites that suit you best. Once you have found the site that you like, search for torrent files that you are interested in. Once the results have been displayed, refer to the number of seeds since this increases the download speed. Once you have found the largest number of seeds, click on the title of the file. A...

How To: Use the levels and histogram in Photoshop

Deke McClelland explains what the Levels and Histogram commands can do in Photoshop in this video tutorial. Levels allows you to adjust the luminance levels allowing you to adjust the contrast and colors within each color channel of an image. Thus, Levels allows you to adjust the individual colors that can be found within a gradient. This command is very similar to the curves command but to a less powerful extent. It is also more efficient than the curves command. The Histogram is another col...

How To: Build confidence on the phone and in voicemails

In this video Patricia Stark shows how to display voice mail confidence. Studies show that it takes only three seconds for somebody to size you up over the phone. You can know a lot about the person speaking on the other end of the phone and so you need to sound very confident while speaking to other persons. It is proved that when you smile when you are speaking on the phone it changes the whole delivery of your tone and if you are sitting there carelessly it will be reflected in your voice....