Fat Free Search Results

How To: Use Microsoft Excel macros securely

hether 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 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.

How To: Create quick formulas with Excel names in MS Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.

How To: Use the "Unique Records Only" filter 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 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.

How To: Avoid a #NUM! error when changing NPER inputs in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Remove duplicate entries with Excel's COUNTIF function

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

How To: Find the first instance of an item in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Deliver words to a cell via IF, AND & VLOOKUP in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.

How To: Look up approximate values with VLOOKUP 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 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...

How To: Evaluate a random value against criteria 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 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...

How To: Get started with flash (strobe) photography

New to photography and looking to learn the fundamentals in a flash? This free photographer's guide, which discusses flash photography and its terminology, will help you to accomplish just that. To get started learning the flash/strobe/speedlight basics (as well as to get a basic handle on the jargon), watch this free video tutorial.

How To: Build a photo set

Need to build a for a set for a film, TV, stage or photo production? This free video tutorial will walk you through the entire process, from design and sketching to fabrication and assembly. For detailed instructions, and to get started building your own professional quality sets, watch this free set designer's guide.

How To: Use GPS/navigation free on Verizon Blackberry Storm

In this video tutorial, viewers learn how to use a GPS/navigation free on a Verizon Blackberry Storm phone. Begin by clicking on Browser and go to this web address: Google Maps. Now install the application onto your phone. To access it, go to Applications and select Google Maps. Once downloaded, users will be able to use the application to navigate the map. It will also trace the point of where the user is onto he map. This video will benefit those viewers wo have a Verizon Blackberry Storm p...

How To: Apply makeup for teens

When applying makeup for the first time, it's all too easy to overdo things. This free video guide will help you teach your teenager moderation when it comes to all things cosmetic. Help your teen to achieve a natural makeup look with the help of this free video tutorial.

How To: Do exercises to firm your butt at home

Work those glutes with this free home fitness guide, which presents a number of simple exercises that you can perform at home that will help you to firm your posterior—namely squats and hip lifts. Tune into specific muscles when exercising isolated areas with help from a personal trainer in this free video on glute exercises for moms.

How To: Make a custom paper rose

In the words of Gertrude Stein, a rose is a rose is a brightly-colored cellulose fiber sculpture. With this free video guide, you'll learn how to liven up your home's décor with your own small, custom decorative paper roses. For more information, including a step-by-step overview of the process, and to get started crafting your own paper flowers, watch this free video tutorial.

How To: Cook your food while backpacking

Before you make that extended trek out into the wild, there are a few things any self-respecting camper should know how to do. And one of those things is how to feed oneself. With this free video guide, you'll learn how to safely and efficiently cook food when backpacking. For more information, watch this free video guide to camp cooking.

How To: Fold a small origami rose

In the words of Gertrude Stein, a rose is a rose is a brightly-colored cellulose fiber sculpture. And with this free video guide, you'll learn how to make your own small paper roses from folded paper using the Japanese art of origami. For more information, including a step-by-step overview of the folding process, watch this free origami lesson.

How To: Design a YouTube channel background in GIMP

Want to design your very own custom YouTube background but lack either the money or desire to buy a full-featured graphic design suite like Adobe Photoshop? You're in luck. This designer's video tutorial will walk you through how to make a YouTube background using the free GIMP image editing program from the free software folks at GNU.

How To: Perform a front flip tuck in free run

In this how-to video, you will learn how to perform a front flip. This is an important basic in free running. To do a front flip, have a light step into the flip. Do this as if you were about to step on a glass. Bend your knees and push up. Once you are in the air, stay nice and tight and tuck in. Your chin should be to your chest. The tighter your tuck is, the faster you will spin. Keep practicing in order to get this right. This video shows you the basic steps in to performing a front flip ...

How To: Make free ringtones for your iPhone 3G without hacking

In this video tutorial, viewers learn how to create free custom ringtones for an iPhone 3G. Begin by opening iTunes and select the song that you want as a ringtone. Right-click on the song and select Get Info. Go to the Options tab and make the song last only 40 seconds. Then right-click on the song again and select Convert AAC Version. Now open the file in the iTunes folder and rename the m4a to m4r. Click on Use m4r to confirm and open the file in iTunes. This video will benefit those viewe...

How To: Start and set up a free blog

In this video tutorial, viewers learn how to start and set up a free blog. Viewers will learn how to setup a free blog for a charity, make a blog entry, edit and customize a blog and share a blog with their network. A blog is a online journal that provides the reader with regular posts on various topics. Three of the most popular blogging sites are: Blogger, Word Press and Live Journal. When creating a blog, keep the posts short and meaningful. Try to engage the reader. Update your blog regul...

How To: Delete temp files & free up hard drive space in Vista

In this how-to video, you will learn how to free up space in your hard drive. This example uses Windows Vista. Go to your recycle bin, right click, and select properties. Change the maximum size of the recycle bin to 200 or 300 megabytes. Next, go to the Start Menu, All Programs, and Accessories. Select System Tools and go to both Disk Cleanup and Defragmenter. Setup a schedule for defragmenting, and then click defragment. For Disk Cleanup, select My Files Only, select a drive, and click okay...

How To: Digitally modify your eye color for free with GIMP

Stevmay09 will be teaching you how to digitally modify your eye color for free using GIMP. First you need to zoom in on the eyeball then click on the free select tool. Then start on the corner of the eye and make your way around the entire eye. Once you have the area around the eye selected you need to create a new layer. Make sure its filled with transparency then select the color you would like the eye to be. Then get the paint brush tool and select the icon shown then increase the scale an...

How To: Listen to live radio for free with TVCatchup

This particular How-To Video teaches the viewer how to use the existing website www.tvcatchup.com to listen to radio stations online. The narrator scrolls through the part of the TvCatchup website that is brand new and has a listing of radio stations available for free to listeners in the U.K. The video offers a short tutorial on how to access the site and gives a description of what the user will find.

How To: Speed up your computer easily for free

In this how-to video, you will learn how to speed up your computer for free. You need a computer running a Windows operating system and access to the Microsoft Configuration Utility. First, open the start menu and click on run. Once this is doing, type in "msconfig" and click okay. Press the startup tab on the window that has opened. Here you will see a list of items that start when the operating system starts. You can uncheck the items that are not required to properly run the system. You ca...

How To: Download and burn Xbox 360 games from the internet

Agertech shows how to download and burn XBox 360 games from the internet for free with this step-by-step tutorial. He takes us through the process of downloading, file extraction, and burning for any XBox 360 game. All you need to download any XBox 360 game for free is a DVD burner and discs. He suggests going to Mininova.com for a menu of games. Follow his easy steps and you can have all the free XBox games you can download in a matter of hours.

How To: Watch movies for free on the Internet

PCRescue Repair shows you how to be able to watch movies on the internet. What's special about this video though, is that he shows you how to watch them for free. He directs you to a website that gives you the ability to watch a variety of movies for free, right from the comfort of your home. From his own personal experience in using this particular website that he sends you to, he can explain in detail where to go, and how to locate the movies that you might be interested in. If you're bored...