Free Websites Search Results

How To: Automatically highlight negative numbers in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.

How To: Count unique values greater than a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Add a workbook reference to an Excel VLOOKUP formula

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use a VLOOKUP function inside a text formula in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).

How To: Make a dinosaur birthday cake

Learn from Betty Crocker Kitchens, how to easily and quickly make a dinosaur birthday cake. You do not need a special cake pan for this recipe. She uses two 9" round cakes, to cut all the shapes you need to make the dinosaur. It is only required to cut out 3 shapes, and you can print the templates from their website. After the shapes are cut, you use the frosting to "glue" the cake to the platter you are working on and then spread a thin layer of the frosting all over the cake to seal in the ...

How To: Remove the LCD display from a G5 iMac

In this Computers & Programming video tutorial you will learn how to remove the LCD display from a G5 iMac. This video is from powerbookmedic.com. First, loosen the rubber band around the display by inserting a pointed object and freeing it slightly with your fingers. On the bottom, free the lower end of the sheet and lift it up. Now remove the two screws and dismantle the part as shown in the video. Then on the top of the display unstuck the two stick pads and remove four screws from the fro...

How To: Make sugar-free organic chocolate truffles

In this tutorial, we learn how to make guilt free chocolate truffles at home. Cocoa powder, coconut oil, Stevia, dates, coconut oil and apple sauce are used in this recipe. First, take your sugar free chocolate truffles you created and chill them in the fridge for a few hours, so they are hard. Once your truffles are made, you can now dip them into your choice of toppings. You can choose chopped nuts, coconut or any other topping that you enjoy. Once you're done dipping, you can place into tr...

How To: Step down or end your patio wall

In this Home & Garden video tutorial you will learn how to step down or end your patio wall. This video is from www.allanblock.com. Get the installation details and the location of the nearest dealer from the website. The instructions are on How-to sheet #160. The easiest way to create step down is to create corner blocks. Simply place corner blocks at the end of each course overlapping the block as the wall steps down. Finish the wall with wall caps. Once the wall caps are in place, you can ...

How To: Use WeFollow to get more Twitter Followers

In this how-to video, you will learn how to use the website Wefollow for twitter. This will allow you find more people to follow you on twitter. You can list yourself under a category so people can find and add you. If you are an antique dealer, you can label yourself as one. This allows you to be searched for and added. You will get higher on the search list as you get more influence and more people following you. If you are looking for people to follow in your niche, you can type in the nic...

How To: Crack crab legs and get the meat out in one piece

This video from the website What to Cook When shows us how to crack open the crab legs and get the meat out of them. Firstly starting with the cluster of legs, simply grab one of the legs and break it off of the cluster. Now simply grab the leg and starting with the joint, break it into half and pull it apart. Then take the middle section which you just broke and put your fingers right in the middle of that section, crack that one leg and then flip it over and crack it the other way. And once...

How To: Clean your car windows so they are streak free

In this Autos, Motorcycles & Planes video tutorial you are going to learn how to clean your car windows so they are streak free. You will need ammonia solution and a mixing bottle. Mix one part ammonia with ten parts of water in the mixing bottle. Make sure you take sufficient quantity of ammonia. Then get a spray bottle and pour the solution into it. Get a piece of rag and a micro fiber towel. Spray the window liberally with the solution and wipe with the rag. Now wipe with the micro fiber t...

How To: Suggest a friend to someone on Facebook

Facebook is a social networking website where you can stay in touch with your friends and even make new friends. Using Facebook you can suggest your friend to some one else on Facebook. To do this first open the profile of the person you want to suggest. Scroll down and to the left you will find a link which says suggest friends to others. Click on it and this brings up a list of people who are in your friends list. Now select all the people you want to suggest this person. You can select mul...

How To: Install Mac OS X on a Windows Netbook

This video shows you how to install OSX on a Windows Netbook. They create a "Mini Mac" and show you what the steps are. This is a good thing to do for someone who is used to a Mac but wants the portability of a Netbook, which weighs only 2 pounds. They start with a Dell Netbook that has Windows XP on it, which they covert. One thing that you need to do is to increase the memory in order to install the new operating system. There is an informative website called MyDellMini that has helpful inf...

How To: Preview iTunes songs on the web with Tekzilla

Veronica of Tekzilla shows you how to browse iTunes without launching the application on this episode of Tekzilla Daily. To check the availability of a specific song without launching iTunes go to URL given which is located on the Apple website and browse the artists that are available in the iTunes store. Although there is no search feature you can hover over a desired song. A play icon pops up; click it to hear a 30 second preview of the song. You'll have to launch iTunes if you want to pur...

How To: Determine the IP address of a email

The author shows how to identify the IP address of a email. He shows how to check the 'Show Original' options in Gmail and in that content how to identify where the email came from and exactly its IP address. Now we can take that IP address and go to any of the many IP lookup websites and trace the original geographical location of that IP address. By following the steps in this tutorial you can easily trace out the origination IP address of an email from which you can extract a lot of useful...

How To: Configure two IP addresses for your Mac Mini server

How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.

How To: Setup FTP on your computer for your Mac Mini server

How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.

How To: Design an icon set in Adobe Photoshop and Illustrator

This software tutorial takes a look at how to design an icon set in both Photoshop and Illustrator. An icon set is a set of icons that you can integrate into a number of different projects, like a website or a company letterhead, logo and identity set up. Having an icon set readily available for all your project needs will make your workflow faster and simpler. So watch and see how to make an icon set first in Photoshop and then in Illustrator.

How To: Use Google Hacks to access free media

Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.