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.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 141st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to generate a series of dates with the TODAY and ROW function that will always show today plus the next 10 days.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 99th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create and use the mathematical constant e in Excel. Also learn about the EXP function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 84th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use custom true/false formulas for data validation and also see how to add an error message.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function in a formula to replace a long IF function formula.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 59th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an aged accounts receivable report using a pivot table (PivotTable) and grouping.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
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.
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.
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.
This video describes how to illistrate simple reflection and shadow tutorial using Adobe. The first thing you want to do is to get the image you are going to be working with, touch up the colors. Make sure the logo is cleaned up, and ready to use. Make it more useable by making it 140x25 cm. Make a copy of your imag, flip it upside down, make sure it is pretty close to the base of the other one. This will look like the first one has a reflection right under it. Next make a 142x 27 box, put it...
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 is a demonstration of making a felt flower accessory for your head bands, waist band and even for your clothes. You will require wool fibers, bubble wrap, felt sponge rolling pin, washing bags and a container of hot water and a spray for soap water. First loose fibers are taken of the color you prefer for your flower and laid in one direction to the size and shape of the flower. Then a second layer is laid at right angle to the previous layer. Some strand of fiber is twisted and laid on ...
How to create a flawless look to your skin:MakeupbyCheri here show us how to create a complete flawless look to your skin. It isn’t as difficult as you feel. Let’s see how it is done. Start off by moisturizing your skin. It’s better to use Clean & Clear Dual action Moisturizer. It is oil free and you might get a slight reddening on your skin as you apply it. That is fine ladies, no problem as such. Next, just pep your lips with a little CarMax. Now, use Max Prep n Prime and prime your skin al...
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...
In this video, Tony Reale describes some cinematography tips for video lighting. He focuses mainly on different ways to capture the look of video. The lighting style he's using in this video is a 2-light setup. One light is reflecting off a foam core and is placed at the right side of the room. The second light is acting as background light and is smaller and placed in the back, right corner of the room. This is a very simple setup and, with a cost of $100-$200, it is an inexpensive, effectiv...
Tim Brownson talks about how to tap into self-confidence during this video. This technique is called anchoring. An anchor is an idea or event that links to another event that is usually not related in some way but provides some kind of reminder of an emotion. This can also be called a conditional response. Tim gives a lot of real examples of anchors and conditional responses. First start by calming down as much as possible. Then think of some activity that you are confident you can do, and th...
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.
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.
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
