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...
Whethamsolution’s Quick tip walks us through some of the issues caused by use of add-ons in Internet explorer 8 web browser. The video also shows how to manage the add-ons installed in IE8. Add-ons are software’s which enhance the functionality of a web browser. Though most add-ons enhance the browser functionality to a great extent they often tend to slow down the browser drastically. Moreover unwanted add-ons like toolbar's and malicious scripts may cause nuisance to browsing experience...
This video tutorial shows how to open a port for torrent downloading on your computer. Click Start menu, type cmd command in Search area. In cmd window type ipconfig and press Enter. Remember or write down your IP adress. Type exit and press Enter to close cmd window.
How to sync your iPod to more than one computer
Greasemonkey is a Firefox add-on which works as a script manager for the collection of scripts available on the userscripts.org website. It can be used to manipulate the view and functionality of websites which has a user script. Greasemonkey only works in Firefox and not on any other web browser.
Firstly download the TweakUI into your computer, which is free. Fire up TweakUI and click on menu "Explorer", uncheck menus: "Allow help on start menu"; "Allow log off on start menu" and so on play with the settings however you like. And select "Light arrow", next click on "Thumbnails" menu and drag the slider all the way to the right, increase the size of thumbnails to 120 pixels. Next double click menu "Common Dialogs" and uncheck all three menus. Next double click menu "Taskbar and start m...
If you want to burn a single song or entire cd from your itunes library you will have to create a play list. This video will show you how to create a play list and add songs that you would like put on a cd. You will then see how to burn the songs and you will have created your very own personalized cd. It’s not very difficult and will just take a few minutes.
Windows Vista comes with a list of pre installed fonts. You can also add new fonts to your operating system. To install a font you will need to download it from the internet first. Go to Google and search for you favorite fonts. Open any of the website and download a font. Save the font to your local hard disk. For convenience save it to the desktop. If the font that you downloaded is a compressed file, extract the font file from it. Now open the windows explorer. Go to the local drive where ...
To create almost any headband look, start by using a real human hair headband with extensions. Mostly, the extensions will come with an interchangeable headband for different colors. Now, start by pinning back the front crown area of your hair, if you have bangs you can leave them out of the hair that you are pinning back. Secure the crown of your hair with bobby pins. The headband with extensions should have three little combs. These will help secure the extension and the headband onto your ...
This video tutorial from Britec09 presents how to backup and restore Window 7 registry.First, press Start button and enter regedit command into Start Search area.Registry editor window will open, click File-Export.This option works on all Windows operating systems.Type file name - registrybackup and click Save. You can save it wherever you want, but in this video it was saved to Desktop.Next step is to reboot to Windows DVD. Insert you Windows DVD and reboot computer.Press any key to boot fro...
In this video Lolicup Inc. show us how to make Boba. The ingredients include : 10 Cups of water, half cup of honey, half cup of dark brown sugar and 2 cups of Boba. Utensils required are a drainer, a large pot, a bowl for the sugar water and a timer, which is very important. The listed ingredients will be able to serve 10 people. Boba has a variety of names such as Tapioca Balls, Black Pearls and many others. The first step is to add the water to the pot and wait until it boils. The second st...
In this how-to video, you will learn how to create a dual-booting system with Ubuntu and Windows. First, go to the Ubuntu website and download the latest Desktop Edition of Ubuntu. Once it is finished, burn the download to a CD. Once this is completed, place the CD in the drive and restart. Boot using the CD and select English. Now, click forward and select your time zone. Click forward, select your keyboard type and click forward again. Now, you can adjust the partition sizes for your hard d...
Some times malicious programs can infect your registry and fill it with lots of unwanted information. You may need to clean it to prevent the virus from causing any further damage to your computer or to even disable the virus. It is a very lengthy and complex process to do this manually. So you will need to use one of the powerful free tools available online. Hijack This is one of the most powerful program that can be used for this purpose. So go the website and download this free tool. Insta...
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...
gjtfreak demonstrates a new free tip for the iPhone 3G on how to get free ringtones on a Windows Vista environment in this video. Firstly go into the start menu open control panel option and from that open folder option. Click on view and find a box that says hide extensions for known file types and unclick that box click apply and then OK. Secondly open up iTunes and pick the song you want to use and go into the preferences column at the top left of the iTunes window. Make sure that the ring...
If you've changed jobs or transferred your old Rolodex onto the computer, you will have a ton of left over business cards. Why not go green and reuse the cards as something unique? Check out this video for tips on what to do with all those tiny squares of paper.
For anyone who has ever used a microphone, trying to record something during a windy day can be a bit of a pain. Of course we can eliminate most of the interference with a simple wind screen that can be purchased at the store, but many times they can be a bit pricey. Well, in this tutorial find out how to make your own wind screener for a Zoom H2 mic. Enjoy!
Soymilk is a well known alternative to milk for those who are lactose intolerant or just tired of regular dairy. You can spruce up regular soymilk by maing your own healthy recipe at home with oatmeal in addition to soybeans.
This video shows you two methods to connect to XBox Live using a laptop. For the first method, go to your start menu and open up your control panel. In the control panel window find the area marked Network and Internet and select the option View network status and tasks. In this new window, select Change adapter settings in the left hand pane. You will be presented with another window that has your network connections listed. Right click on your Wireless Network Connection and select properti...
This is a great and easy step by step video on how to fix a simple leaky faucet. It even shows you what tools are needed to complete the job. Barbara K shows you faucet fixing is not just for men anymore!
This video will show you how to use the program Skype for online video calls. Skype is a free program that can be used through your computer to make phone and video calls. Go to Skype and download either Mac or windows depending on your platform. It will ask you to fill out some user information, including a user name. Be sure to pick a good user name as you cannot change it later on. Some features include free Skype to Skype calls, instant messaging, free video calls, calling phones and mobi...
Answer “Why should we hire you?” in a job interview John Heaney from The Job Shopper discusses how to handle one of the toughest questions you will face in a job interview: “Why should we hire you?”
This video shows how to change the advanced settings to make Firefox faster on Mac and PC.
This video shows the method to change a word problem into algebra and to identify rational numbers among a group of numbers. In the first part of the video we take a word problem namely - The product of 9 and seven, less than a number. 9 multiplied by something can be expressed as 9(). The unknown number can be expressed as 'x'. Seven less than a number can be expressed as x - 7, so that the final equation becomes 9(x - 7). In the second part we are given a list of numbers. A rational number ...
Watch this video to learn how to disable auto-correction on your iPhone. Launch Installer (you should be familiar with this application by now) from your Springboard. 2. Go to Install and scroll down to Tweaks 1.1.1; under Categories. kb_fix_iPhone.jpg 3. Select Kb2 from the list of packages. Install it. Click the Home button, and the iPhone will go to the “Slide to Unlock” screen. 4. Go to Settings General Keyboard and you should see a new option, called Enable Autocorrection. Touch it to tu...
Objects used in the tutorial are available free at the website preceding this description. The project here involves two groups of paths. You will be shown three ways to change the order of these groups. Go to one of the groups and right click on the mouse, in the menu that comes up choose Arrange, and within the next box choose bring forward. This works with either group. Go to the other group, right click, choose Arrange, then choose bring forward and now this group will appear ahead other ...
This video shows us how to fix an iPod that is displaying a folder icon and exclamation mark warning and does not function. The first thing you will need is obviously the iPod, typically the 1st Generation to 5th generation iPod. The second thing you will need is your sync cable, and also a wall charger. The first thing you have to do with the iPod is to reset the iPod by holding down the center button and at the same time hold down the menu button. After a few seconds without letting go the ...
The gentleman, acting as the Instructor, starts the session immediately by suggesting that to teach early multiplication all parents should practice a method of "Count-by's" with their children when they are very young using ones to ten, twos to twenty, threes to thirty, fours to forty, and so forth. The Instructor then demonstrates this method of counting by tens using a grid behind him on a chalkboard which depicts columns of ten elements. He counts each column from 10 to 100, and then writ...
Award winning author Susan L. Reid teaches us how to write a great mission statement for your business. 1. First, write your "purpose statement". This answers what your business wants to accomplish and what problem or need your business is trying to address. Simply state the answer to this question. 2. Write your "business statement'. This describes the activities or programs your business must do to support it's purpose. Ask yourself what you are doing to address the need identified in your ...
Things You'll Need: Measuring spoons, 5 zipper plastic sandwich bags, 1 oz. lagniappe water, 4 large cloves of garlic (cut in half), Zatarain's Garlic and Onion Liquid Shrimp and Crab Boil, 3 bay leaves, measuring cup, 2 lemons, 5 oz. salt, ice, large pot, 5 lbs. large shrimp (2 to 3 oz.), cayenne pepper to taste, 1/2 stick butter (4 tbsp.). Step 1: Fill the pot 2/3 of the way full with water and place it on the stove. Step 2: Turn the heat on the stove up to the highest level. Step 3: Rinse ...
In this how-to video, you will learn how to properly study for a test or for homework. The author offers a few great tips. You should avoid cramming and study well before the test date. Make a list of everything that is going to be on the test. Memorize facts and formulas. Make up questions that you think are going to be on the test. Take all the school tools you need in order to complete the test. Lastly, if you prepare well, you will have a great chance of doing well. You should try to stud...
This video tutorial is about removing makeup in a photo using Photoshop. To do this, first of all, open the photo. Then zoom in on the area where you want to remove the makeup. The tool that is to be used to remove makeup is the brush tool. It can be selected from the left pane. After that, on top there will be an option which says mode. Click on the option just near to that and a drop down menu appears. From that list, select the hue option or color option. Both the options serve the same pu...
This how-to video explains how to copy and paste text in the browser in a Motorola Droid phone.
Do you win the prize for messiest room in America? That's a difficult contest, but how about messiest room in your house? It’s time to clean your room, so do a good job in the shortest amount of time and get your parents off your back.
Download LimeWire Pro 5.3.6 and enjoy an easy experience downloading audio, video, and images. Download the Limewire Pro 5.3.6 file here.
To obtain a work permit, you must first have a job offer from a Canadian employer. To get a job offer, you can apply directly and send your resume to a perspective employer, use an employment agency, or post your resume on employment websites. Next, you must have a labor market opinion. To get an LMO, you have to fill out some forms and submit some supporting documents. This process can take from a few weeks to 6 months to complete. After the LMO is approved, you must then apply for a work pe...
Neighbors are a great way to develop your own little community in Cafe World. You can visit your neighbors, sample their special of the day, and leave them gifts.
In this video, learn how to install Install0us 2.5 on your iPhone. This can only be installed on a jailbroken iPhone. Directions, tips, tricks, and tourbleshooting advice from videomaker, grandhustler are listed below.
Speed up and stay rested by simply getting more stamina in this hack for Country Story. Using Cheat Engine, you can easily up your stamina!
Need to cut back on the sodium? Limiting your daily salt intake can help prevent major diseases. Here's how to cut the sodium out from your diet.
