Entering into the world of hip-hop dancing? Impress the rest with pulling off an impressive slide glide taught in this video for free. The basic form of slide gliding begins with getting the hands loose and the feet a little wider than shoulder-width apart. Find out how to manipulate the heels and toes and slide glide like Usher with help from this free lesson.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.
In this video, David teaches us how to clean the inside of windows easily and quickly. You don't need fancy tools, all you need is a terry cloth towel, a squeegee and dish washing detergent. First, put a little bit of the soap into a bucket and wash down the windows. Next, take a squeegee and wipe horizontally making clean lines. The excess water should drip down and you will catch it with your next squeegee wipe. If you have extra wetness on the edges, grab an old t-shirt and wipe the sides ...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
In this video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...
The video explains how to change the background color of objects using Photoshop in a simple manner. This way is better quick mask mode, because this way is more efficient and more advanced. First you click control G, Image control color and then you take the Image samples. The tutorial shows how the oranges are changed from their original color into a reddish color. Then it shows you how it adjusts the shadows of the oranges and the color of the leafs. The video is quick and it explains full...
There's nothing like milking a dairy cow straight from the teat. Of course, before milking you'll need to sanitize the teat with a sterile solution and paper towel. This video tutorial demonstrates the proper methods of milking cows using a standard milk machine pulsator for professional results.
In this video tutorial, viewers learn how to make a batch render in Sony Vegas. Sony Vegas is a professional non-linear editing system. Viewers will learn how to use the batch render. At default, it is located on the toolbar. Begin by importing your clips or images into the time line. One of the batch render's features is to render regions. Begin putting regions around the clips by highlighting the clip, press R and press Enter. The add the Add Regions To Event script to automatically set reg...
De-fragmenting a hard drive improves the performance of a hard drive and it is recommended to de-fragment your hard drive from time to time as shown in this video. In Windows 7 you can use the Disk De-fragmentation tool. To do this go to the start menu and open the Control Panel. In the right column select the Performance Information and Tools. Now in that window in the left hand column select the Advanced tools option. In that new window scroll down to the Open Disk De-fragmenter link. Click...
Looking to learn the Bachata? We've got a string of videos that will get you on your way. In this dance tutorial, learn the reverse cross-hands turn, which starts with the ladies on the left and ends with the ladies on the right. Learn how to do the reverse cross-hands turn with guidance from a professional dance instructor.
Switch things up with the Bachata dance with pivot dance steps! For women & men, the Bachata pivot dance steps are slightly different, so be sure to watch carefully! Get your pivot down with help & tips from a professional dance instructor.
Not really the choreographer type? Have no fear - In this Bachata dance tutorial, learn how to put together Bachata steps to make your dance floor experience a fluid one. No more jerking, stopping, or stepping on one's toes... Learn how you can master your Bachata moves with help from a professional dance instructor.
In Bachata dancing, there are many turns one must learn in order to master this Dominican Republic based dance. In this video, learn how to do outside turns by starting in an open position with the ladies hands on top of the gentleman's hands. Follow the steps in this video to perfect outside turns with help from a professional dance instructor.
The Bachata is a style of dance from the Dominican Republic. Accomplished with a Cuban hip motion to a four-step beat, it's a dance sure to get you sweating and grooving. In this dance tutorial, learn how to do the reverse step with a little help from a professional.
The first operations you will need to know when learning to use algebra to solve for an unknown variable “x” will be using addition and subtraction. You can check you work by checking the balance of the equation when you are done.
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Band on the Run" by Wings & Paul McCartney. He begins by playing the song for more advanced players to watch and learn from. Then follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song, teaching you the intro, verse, bri...
Chad Perkins shows how to use the Bezier pen tool in Photoshop, Flash, and After Effects. Perkins attempts to shed light on how the tool can be used and dispels certain misconceptions about the pen tool. The pen tool allows users to create various types of paths, either open or closed, at the most basic level of use. At the more complex level, the pen tool can be used to create professional looking curves. For better understanding of what the pen tool can do for graphics and other designs, fo...
Halloween is just around the corner and this spooky paper bag album you can really create a masterpiece. If you love scrap booking this project would be a blast for you. All items were bought for less than a dollar at the local dollar store and the detailing is quite manageable from intermediate to advanced scrap booking. So if you have time and patience to make this then get ready to create an album ready for any Halloween adventure. In this video you will learn how to make a spooky Hallowee...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Use Somebody" by Kings of Leon. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song. With the help of this video you will be play...
In this video from Tiffany0x we learn how to change your profile background on youtube. First she goes to google, then clicks on images and type in whatever image you're looking for for your background. Then copy the image's link in your browser. Then go to youtube. Click My Account. Then you'll see Channel Settings. Click that, then click Channel design. In Advanced Customizations you'll see a place where you can put in a Background URL. Paste the URL into that box. Once you have done that, ...
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Can't Buy Me Love" by The Beatles. He begins by playing the song for more advanced players to watch and learn from. Then he follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song.
This video shows you how to create a glowing object in Adobe Flash CS3 Professional software. This is a tutorial video for beginner level viewers. Making objects glow is one of the many effects that can be applied in Flash. In this video the narrator draws a shape, converts the shape into a movie and adds a glow filter to the object. Watch this video and learn the correct parameters to be supplied to the program to get the desired glow effect.
In this video from VvCompHelpvV we learn how to get a free redirecting domain name which would be any one of these: .co, .cc, .co, .nr, and .tk. This is basically a redirection URL that brings you to the same site but with better words o more professional looking. The first way he shows is and then the next one is [http://www.freedomain.co.nr] and the final one he shows is [http://www.dot.tk]. He recommends using the co.cc domain because those get indexed apparently.
Getting a professional looking mohawk can be done quicker and cheaper than you probably thought. All that is needed is Neutrogena, Aqua Net, a comb, and a blow dryer. Use the comb to gather and pull the front section of your hair straight up and hold in that position with the comb. With your other hand apply the hair spray and then the hair dryer repeatedly until the hair stands on its own. Do the same thing with the next sections of hair until all the hair is spiked. Then give the whole moha...
Elaina Love, a Professional Raw Food Chef teaches how to make Tamale-enchilada sauce. Ingredients: 1 1/2 Tbs. Mexican chili powder blend, 1/4 tsp. cocoa powder 1/2 tsp. garlic powder, 1/2 tsp. dried oregano, 1/2 cup water (more or less to make an enchilada sauce consistency), 1/2 cup sun dried tomatoes soaked in enough water to cover 2 tsp. olive oil (used as an emulsifier), 1/2 tsp. salt. Put all the ingredients in a blender. Blend until smooth. Pour inside a squirt bottle. Refrigerate. Foll...
This video shows the procedure to draw a face. The video shows various stages to draw a face. These include drawing an egg on the paper, dividing the egg into various parts by horizontal lines, drawing the nose and lips, drawing the eyes and ears. The video cleverly deals with issues relating to the evidence of not being a professional. The video shows the various choices that can be made by the artist in drawing the face like the pencils to use.
PerformanceBikes will show you how to install a bicycle computer. Whether you have a simple computer or a more advanced computer you be able to see the basic instructions. Start by reading the instruction, install the handle bell mounts, install the wireless transmitter. You then install your spoke magnet, then calibrate your computer for your wheel size. Make sure you have read your own particular directions. If its not working, make sure you re-read your instruction, check your set up or ch...
Learn how to touch up images in Photoshop and bring out the true potential of your art. Using subtle strokes of image enhancement you can redefine the effect that shadows have on your images and use them to bring out the aspects of the photos that you want to highlight. Similarly you can hide those nasty imperfections with ease as shown in this tutorial. Never again let your images befall an embarrassing fate. You too can produce professional quality work with minimal effort and time on your ...
