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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.
Widgets are invading our computers and mobile phones, and the new HTC Hero Android-enabled device is no different. If you want to get the most out of your widgets, you're going to have to first learn how to add new ones to your home screen. Best Buy has answers. The Best Buy Mobile team explains how simple it is to add widgets to your HTC Hero cell phone.
The iPod kids shows viewers how to covert movie files that are already on your computer into a format that will work with your iPhone or iPod Touch (2nd generation).
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
Frederic Patenaude demonstrates selecting and cutting a fresh pineapple. To select a fresh pineapple, he discusses that the color is not a great indicator. Instead he suggests looking at the bottom of the pineapple to make sure the base is yellow, indicating ripeness. He also smells the pineapple to make sure it smells ripe. he also checks for bad spots, softness or leakage around the whole fruit. He communicates that any tests with leaves are also not indicators. One way to cut a pineapple i...
In this how-to video, you will learn how to add movement to still images using Final Cut Pro. Click on the view mode button in the canvas window. Set the mode to Image and Wire Frame. Move the canvas play head to the clip you would like to affect, and select the time line. To control the scale, grab the corner to shrink or enlarge. Reposition the clip by clicking on the image and dragging it around. To rotate the clip, move the mouse over the edge and click and drag it to spin it. Select the ...
Yes, you can use GarageBand's Auto Tune to sound like T Pain and Kanya West. To start with, in GarageBand, click the plus sign in the bottom left hand corner to create a new track. A window will pop up, Real Instrument Track should be selected by default. Click the Create button. In the Track Info window check to make sure your Monitor is set to On. In the bottom left hand corner, click on the button with the scissors in the middle of the sound wave. This is the Edit Track button. Click on Ad...
This tutorial describes how to make a list with unique values in Excel.This procedure makes the defined cells in a column (called as list) NOT to accept repeated values, which makes the list more simple, readable, easy to manipulate when preparing a worksheet.
This feature also comes with Windows 7. Right click on desktop then click "Personalize". You can see the numbers of themes for example choose Nature theme and click "Desktop Background". You can see the some pictures and a tick mark on the corner of the pictures which tells these pictures are the part of my slide show. Also you can set the time for new pictures to come.
The video demonstrates how to add animated images and video content to your Microsoft PowerPoint presentation.
Windows 7 has an interesting new feature by which you can pin your programs to the task bar and this video shows you how to do it. In Windows 7 if you have any frequently used program you can improve its ease of access by pinning it to the task bar. Now to do this first open the start menu, go to the programs, and now browse to any program and right click it. From that menu select the Pin to task bar option. When you do this the program icon will appear on the task bar. Now the program is pin...
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...
This video will go over how to insert a check box in Microsoft Word for printing or for electronic distribution. With just a few clicks you can get a check box. You can even add different symbols or styles for your check box.
1. This video describes how to use the application Infinidock for the iPhone and iPod Touch. This is used to set how many icons to be placed per page, this Infinidock Cracked is doing full document customization like scrolling, adjustable icon amounts and can add as many icons as you want. We can download and install in the phone 2.For using Infinidock first click the "Settings" and select the Infinidock into that you can see the "icons per page" options now you can add the number of icons yo...
If you ever wondered how to create a buy now button for your website this video shows how to do it using Photoshop. To do this open Photoshop and start with a new file. First draw a rectangle which will be now modified into the buy now button. Set the radius of the rectangle to forty pixels. Fill it with gray color. Duplicate the layer. Open the layer options of the duplicated layer and set the stroke position option to inside. Set its weight to 6 pixels and set its colors to light gray. Now ...
Select a hard object for mold making. Oven safe items work best. Knead the polymer clay between the hands. The polymer clay must be pliable before wrapping it around the mold.
pbj746 is here to teach you on how to create a glossy rainbow effect using Adobe Photoshop CS4. This can be easily done in a matter of minutes and you can try experimenting with other colors and effects to get variant number of sassy backgrounds.
There's plenty of reasons why one would want to convert a webpage to a PDF document. And there's numerous ways on how one can convert that web page (HTML) into a PDF file. Check out this video tutorial on how to convert webpage HTML to PDF on Ubuntu Linux.
Pull off this easy prank, and – without causing any permanent damage – watch your coworker squirm with frustration.
Check out this video tutorial on how to make your Firefox smarter using SmarterFox. Wikipedia sidebar SmarterFox adds a "related articles" sidebar to the left side of Wikipedia.
If you're tired of the boring old ringtones on your iPhone but don't want to shell out extra dough to buy a new one, here's an easy way to make your own.
This is a guided video tutorial on how to install Rockbox onto your Apple iPod. In case you don't know what Rockbox is... it's a program for your iPod that you can play games, programs, Game Boy games, and more!
Included in Logic Pro is a vocoder called the EVOC 20 PS (PolySynth), a very hand tool when it comes to audio editing. The EVOC 20 PS is a combination of a vocoder and polyphonic synthesizer, which can be played with an external controller keyboard. But let's concentrate on this video tutorial, where you'll learn how to use and record the vocoder synth in Logic Pro. See the steps below:
One can easily get rid of acne scars without surgery by means of following steps. Identify the type of acne scars you have. See a dermatologist who can tell the difference between types of scars. For example, scars may be classified as ice pick, boxing, rolling or hypertrophy scars. Not every nonsurgical removal techniques will work with each type of scar. Get a chemical peel. A solution is applied to the skin which causes the top layer to peel off. This encourages new skin growth. Peels are ...
Sure, not everyone will want to create brochures, but for some of us, it's the best way to get around paying a design firm— making them yourself in Word 2008 for Mac. The tools and templates inside Word 2008 make it easy to create visually stunning brochures for any occasion. The Microsoft Office for Mac team shows you just how to design a professional brochure in this how-to video.
Depending on where you live, you will have to prepare for the hazards from different types of natural disasters. You can sleep easy if you have a secure location, stalked with food and supplied you might need if there is an emergency.
Learn how to make your countryside garden a unique place by respecting it's natural beauty and landscaping.
Install & boot Mac OSX on an external hard drive
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.
The iPhone is great. And so is Google Maps. And together, they define mobility. They go together perfectly. Like yin and yang. But how do you get the most out of Google Maps on the iPhone? Best Buy has answers. The Best Buy Mobile team explains how simple it is to use Google Maps on your Apple iPhone for directions.
Did you know you can talk to more than one person on your iPhone? You can talk to two, three… four people, and it just takes a little knowhow. Conference calls are easy, so how do you set one up? Best Buy has answers. The Best Buy Mobile team explains how simple it is to set up a conference call on an Apple iPhone.
In this video tutorial, viewers learn how to use a USB flash RAM in a Windows XP computer. Begin by plugging the flash drive into the computer and do not remove it when it is being used as RAM. Then click on the Start menu and click on My Computer. Right-click on the flash drive and select Properties. Name the drive, RAM drive and click OK. Make sure that there are no files or folders in the flash drive. Now right-click on My Computer and select Properties. Click on the Advanced tab and click...
In this how to video, you will learn how to make a LEGO stop motion movie. First, you must create your set. The base plate must be taped down to the table or a hard surface. To create the animation, move the LEGO man's leg and take a picture. Move it again and take another picture. Keep on doing this until he reaches the destination you want. The more pictures you take the smoother the video will be. To edit the animation, import it to your computer and open up your movie editing program of c...
This video tutorial from tarunkumarsinghal shows how to change Mac address on Windows XP. Click Start menu and then Control Panel. Make sure control panel window is in classic view mode. If not, change it to classic from the left pane.
This is a how to video to prepare a bootable USB installer for windows 7/XP using wintoflash. Here are the steps to do.
Howard demonstrates how to control sharpening on your image in Photoshop. First, you want to copy your layer by dragging to down to the new layer icon at the bottom of the box. Next, go up to the menu bar at the top of the screen and click Filter, select Sharpen, and go to Unsharp Mask. A dialogue box will pop up so that you can adjust the how sharp your image is by using the sliders. Click OK when you are done. If you want adjust where you sharpen the picture go to the right side and click o...
This video tutorial from radeon4350 shows how to connect dualshock PS3 console controller to PC. First, download driver software from here: http://www.motionjoy.com/download
In this how to video, you will learn how to run Windows inside Mac OS X. First, download VMWare Fusion 3. Install the program and run it. Insert your Windows installation disc into your computer. Next, select install this operating system and click continue. Enter your information and continue. Next, you can choose more seamless or isolated. Choose more isolated so that files will not require Windows to open. Click continue and select the hardware settings such as RAM and processing speed. Cl...
This video tutorial from ruralgeek shows how to set up and use Wippien VPN on Windows XP. First, download Wippien client from here: www.wippien.com.
John Roy demonstrates the tutorial to view or retrieve layouts that ens with .swf. SWF files can be viewed by pasting the url in the address box.
