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.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determine an increase in salary based on a rating scale.
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...
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...
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.
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.
In this video tutorial, viewers learn how to change/convert a pivot animation into an AVI video format. Begin by loading the animation in the Pivot program. Now click on File and select the Save as type to Animated gif. Nam the file and click on Save. Then open Windows Movie Maker and add the pivot animation into the time line. click on Publish Movie and select This Computer. Name the file and select the save location. Click on More Settings and select DV-AVI (PAL) and click on Publish. This ...
In this how to video, you will learn how to open an SWF file the easy way. First, download the link shown at the bottom. It is a flash player that will open flash movies saved on your hard drive. You can view these movies in full screen mode and control the play back. Once it is downloaded, install it. Open the program and then open an SWF file that you have saved. You should be able to watch it play in this program. You do not have to drag and drop the file on to the player in order to watch...
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...
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.
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.
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.
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.
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.
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.
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 ...
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...
This video is about how to download movies, music, and software using torrents. The first thing that you will have to do is to download either uTorrent or BitTorrent. After you have download either of the two, go ahead and browse for a torrent website. After you have found the torrent website that suits you best, just browse or search for the file that you want to download. A list will appear, then you just have to look at the most number of seeds since this increases the speed download. Also...
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...
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...
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...
This film technique is one that is not only used on movie sets, but with journalists as well. This is a great way to shoot a discussion that is going on between two people. In movies, it's a great way to help add some emotion to a dialogue that both characters are having with one another. In broadcast journalism, the same technique is used in order to portray a relationship between the interviewer and interviewee. It's a great way for them to communicate and is really easy to use. So sit back...
Follow along as we learn how to get free ringbones for your cell phone. -To begin you are going to go to myxtertones.com/make. This site will be used to email your ringbones to your cell phone.
The video describes how to use Pinnacle Plus Studio. The narrator first describes the various tabs and features of Pinnacle Studio. He then describes how to import a video into Pinnacle Studio for editing. The video demonstrates how to add still photos, sound effects, music, and transitions to your video using the various tabs and options along with what the narrator calls the timeline. Finally, he describes how to make a movie after you have finished editing your video. He gives a good overv...
This short video shows you how to create an animated fashion style logo in Flash. First he changes the background and frames per second to black and 24 respectively. He chooses the font for his text and then he converts the text into a movie clipping by hitting f8 and choosing movie clipping. He shows us how to make special effects by using the text in different frames. He creates layers and adds more text with special effects that create a flashing logo.
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.
Burn downloaded movies onto a DVD. Open your browser, go to the Google website and type axxo torrents in the search bar. Then select the homepage of axxo torrents, and download the favorite video in to your computer. Then open the DVD flick, you select burn a DVD. In that you select the files to be burned on to a DVD, and then click ok. Then the general settings appear on screen, about the name of video. Then also select how to burn and writing speed, and check the box of verify the data on w...
This video tutorial shows you how to improve the performance of your Windows XP PC by freeing up disk space. This is done by running xp's Disk Clean up utility
All those apps, but you can't preview them without buying. Wouldn't it be great if there was a way to check out these games for free. Check out this tutorial to get started!
This is a video by Indy Mogul. For making a script or screenplay, first write a short heading about the situation and where the characters are to be at that time. Then write the actions the character must do. Then the dialog the actor must tell along with the emotion. Now write the dialog the another actor must say. Like wise write all the dialogs. Time must be ascertained for each dialogs. Dialogs must be written according to the time.
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...
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.
Gluten-free batter tends to be very dense, which results in not-so-fluffy crumb cakes. To fix this problem, you only need to add some hot water at the end and mix it till the batter becomes loose like pancake batter.
Add another web game to your list of what to do on a bored evening... Bejeweled Blitz! In this video, learn how to play Bejeweled Blitz on the web for free. To play this online game, go here.
You have many great memories to share. Why not collect them all in one book? Learn the fun and meaningful craft of scrapbooking. In this video how-to, learn how to get started on your scrapbooking adventure.
You can't have a werewolf movie without a werewolf, but how do you make one. Well, you should start of small. Try your hands at the wolf claws. To create these furry werewolf claws, you'll need a glove and some other materials. Watch this video tutorial to learn how to make a breakable prop computer. For written instructions on the actual claws, check out the WikiHow article, "How to Make Origami Paper Claws".
Have Sony Vegas, but don't know all that it can do, like masking? Well, this video tutorial about masking in Vegas Pro 9 will get you started in movie visual effects. As in the video, you can give an illusion that there is a real tank in your backyard with masking. See how to use the mask tool in Sony Vegas Pro 9.
You've drafted a promising team, and the season's under way. Now increase your chances of making the playoffs.
