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 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
In this video, Blair describes how to fix oily hair with Fakkai dry shampoo. First, she brushes out her dry hair so it's smooth and evenly parted. Next, she puts several drops of the dry shampoo onto the roots of one side of her hair. After this, she rubs the dry shampoo into her hair in a circular motion. She then repeats this on the opposite side of her head as well as the back portion of her head near the roots. After rubbing in all the solution, she grabs the hair brush and brushes the en...
You will be using a picture of a Nintendo character and perler beads to make the necklace. Start by making an outline of the character using black perler beads. Then begin using colored beads to fill in the character. The color beads allow you to fill in the character and they also allow you to create all the detail on the character. You can shade and use multiple colors in making the characters. After you have put all the beads on the card put a sheet of waxy paper over the character and iro...
Yanik Chauvin demonstrates how to create a batch using Photoshop and them Lightroom so you can decide which is faster and more convenient for you. In Photoshop, he first changes the color in the image, which he explains step by step the process, then saves the image as an action. He then shows you the process to batch the images so they will appear on your desktop. He also does the same thing with the image in Lightroom and shows you the process in which you would change the color and sync th...
Milking a cow can yield multiple gallons of milk per session. This video tutorial demonstrates how to milk a grass fed cow by hand, and provides ways to make your cow more cooperative throughout the process. All you'll need is a cow, a stool, and a patient work ethic.
In this video tutorial, viewers learn how to simplify expressions involving algebraic ratios. In some ways, simplifying algebraic radicals is easier than numeric radicals. When we are working with square roots, we need to find the highest even power of a variable to act as out perfect square. When working with cube roots, we look for the highest multiple of 3 as an exponent for our perfect square. This video is very descriptive and clearly explains all the functions of the formula. This video...
This is an Electronics video tutorial where you will learn how to use the RPT mode on a Nikon SB-800 and SB-900. Repeat mode gives a flashing strobe effect with which you can take multiple shots in one single long exposure. In Nikon SB-800, switch on the flash and select the RPT mode. The video then demonstrates the various selections available in the RPT mode. In Nikon SB-900, again switch on the flash and select the RPT mode by pressing on ‘mode’ button. The video then goes on to demonstrat...
Kathy Kaehler, a Personal Trainer, talks about how to use an exercise ball. Exercise balls are very effective because they allow you to do multiple exercises at once. Even just sitting on an exercise ball makes you use your core muscles, so you can sit on an exercise ball at your desk and exercise your core muscles at the same time. First you will want to buy your own ball. Make sure to get a quality ball from a reputable seller or brand. Make sure that it is the right size for your height. S...
In this video the instructor shows how to find a formula describing direct variation between two variables. Variation between two variables can be either direct variation or indirect variation. If a variable y is in direct variation with a variable x we can write the general equation between them as y = k * x. That is as x varies, y varies directly in relation to x, as a multiple of x. Now if you have the values of y and x, you can substitute them in this general equation which gives you the ...
In this video we are shown a workout that targets your stomach and helps you to lose belly fat and tighten your lower abs.
For anyone new to Twitter, this video tutorial shows how to utilize TweetDeck. Following a lot of people and having a lot of people follow you is the whole point of Twitter. On the top tool bar of TweetDeck, there is a magnifying glass tool, you can run a search of someone and the search will bring up multiple listings of various avatars. If you keep the cursor over the avatar, select on the user prompt and then add the avatar to your group. Following these steps allows you to follow someone ...
This video goes through the step by step process of doing long division with remainders. Multiple examples are used throughout the video to give the viewer a better idea of how to properly complete the difficult task. Perfect for anyone learning long division for the first time, or for anyone attempting to relearn long division after forgetting how to do the process (an all to common occurrence in a world with calculators on every cell phone).
In this tutorial the instructor shows how to calculate the greatest common factor, or GCF. While computing greatest common factor, you are pulling out the smallest exponents of any common factors along with the factor. Finding the greatest common factor is similar to finding the least common multiple. When given any numbers to find the greatest common factor, the first step in the general procedure to be followed is to break each number down into its factors. You need to break down the number...
HelpVids user mel_bone teaches you how to cut, copy and paste to the clipboard in Microsoft Word 2007. Select the first paragraph by either triple clicking on it or selecting it with your mouse. Click "Copy" in the top ribbon or press "ctrl + c". Then use "Paste" or "ctrl + v". To cut a paragraph, select it and click "Cut" or press "ctrl + x". Using the paste options, you can only paste the text, without its formatting. By clicking the small icon next to the Clipboard tab, you will open the p...
This is a tutorial video on how to use a virtual CD/DVD drive software tool called Furius ISO Mount. Furius ISO Mount is an .ISO, .IMG, .BIN, .MDF, and .NRG image management utility, that allows you to automatically mount and unmount disk image files. This utility application will allow you to mount multiple images at once, burn image files to optical disk, and create MD5 and SHA1 checksums to verify the that the image files are not corrupted. This program also automatically creates mount poi...
In this video, Dan and Jennifer answer a 71 year old woman's question about her relationship. The asker has been staying with an 80 year old man that she met online, for three years. Throughout the duration of the relationship, the man has not told his family (which comprises of his two children) about the relationship. The woman is unsure about what exactly this means. In addition, the man has been over to the woman's house multiple times, but she has never been to his house. Dan and Jennife...
This a video tutorial on how to levitate a card. This is basically a card trick. The effect created is that the spectator's selected card is magically revealed by rising out of the pack. The secret to the effect is your little finger. Shuffle the cards and then let the spectator select one card. Show the card to the spectator and tell him/her to put the card back anywhere they want. As the card is placed back, get a pinky break with your little finger above the card. Use multiple cuts to get ...
The video gives tips to participate in a toilet paper wedding dress making contest. It gives the participant tips on how to make a winner's dress. Contestants are asked to begin with some inspiration by looking at previous winner's dresses, going through real dresses or by using their own imagination. Their next step is to gather the required materials. Participants must take good photos of their dresses in multiple angles and they can even shoot a video of their dress making. Some points on ...
In this video the instructor shows how to add and subtract rational expressions. When you have an addition or subtraction problem of rational expressions, first look and compare the denominator of all the terms. If all of them have the same denominator then the expression can be written as a fraction whose denominator is the original common denominator and whose numerator is the sum of numerators of all the other terms. Simplifying the numerator by adding and subtracting the like terms gives ...
To simplify a complex fraction, turn it into one fraction on the top divided into a fraction on the bottom. Once this is complete, you will turn the division into the two into a multiple by the reciprocal, factor, and then cancel. To make a division, find the lowest common denominator of both the top and the bottom. Once you get this division equation, look carefully at the equations. If something can be easily canceled, go ahead and cancel it out at this time. If you cannot cancel anything a...
This is the video about how to add a rational expression. So to add a rational expression first of all find the common denominator. To find the common denominator, just find the least common multiple (LCM) of the denominators. There are at least a couple ways of doing this. To convert each fraction to the common denominator, you multiply each denominator by what it needs in order to turn it into 6x. For instance, in the x+4/5x, the denominator needs to be multiplied by 6x, since 6xX5x = 30x. ...
"Owens Drywall" wall describes how to coat a drywall corner bead. 1. Fill pan with drywall. 2. Take a eight inch knife and use to spread the drywall on wall, starting from the bottom and working your way up. If you drop any on the ground, go ahead and pick it up with knife. 3. Go over the same spot multiple times from the bottom up to ensure the drywall is on evenly and clean!
Cardcrazy09 teaches you how to make a Halloween mini tag album using Cricut. The album itself is made using different types of double sided cardboard. They're stuck together using a metal spiral. Each of the elements use different types of cartridges for Cricut. Simply cut all of them and stick them in place on each page. You can also add photos to give it a more familiar look. Multiple tags are inserted in little cardboard pockets. There is also a demonstration of the Cricut Gipsy, a useful ...
If you own a 2010 Toyota 4Runner then this is a great video to watch to learn how to load your CD's into the car. On the Toyota 4Runner there are three different ways that you can load your CD's based on the system in your 4Runner. If you have a standard audio system you just slowly insert the CD into the CD player. The CD player will "grab" the disc and pull it in. If you have the multi-disc CD audio changer you press the load button next to the amber button. Wait til the amber button turns ...
This video shows you how to photograph lightning in the daytime. Set the ISO to 100.The aperture set at f32 and set for half of a second. Meter should be showing averaged. Photograph in the manual mode so that the setting won't change between photographs. Manually focus lens to infinity so you won't have to wait for the focus to lock on. A remote shutter to just hit the button. Be safe and keep camera safe when taking lightning photographs. Don’t get under trees. When lightning starts strikin...
In this video tutorial, viewers will learn how to create a navigation bar, using Adobe Photoshop. Adobe Photoshop is a graphics editing program. Viewers will learn how to use multiple layers, layer effects, gradient options and drawing tools. Viewers will be able to customize their own color and designs. This video provides voice narration and a visual demonstration that allows viewers to easily understand and follow along. This video will benefit those viewers who design websites and web pages.
In this tutorial the instructor shows how to calculate the sum of reciprocals of complex numbers. If you have to find out the sum of the reciprocals of two complex numbers first you will have to find out the least common multiple of the denominators. To do this multiply the numerator and denominator of the first fraction by the second complex number. Similarly multiply the numerator and denominator of the second fraction by the first complex number. Now you will have two fractions whose denom...
In this video, viewers learn how to install and setup JDownloader on Ubuntu Linux Downloader is open source download manager. It simplifies downloading files from One-Click-Hosters like Rapidshare.com or Megaupload.com - not only for users with a premium account but also for users who don't pay. It offers downloading in multiple parallel streams, captcha recognition, automatically file extraction and much more. Of course, JDownloader is absolutely free of charge. This video will benefit those...
Lyndapodcast teaches you how to create a database using FileMaker Pro 10. You can link one contact with multiple addresses and information and store that into a single database. You can also add content from the web into your FileMaker layout, including maps, pictures and music. You have a security module where you can set permissions for the users using the database. You can also publish the FileMaker database to the web. For this go to File - Sharing - Instant Web Publishing. Another featur...
This video shows how to start a continual round in single crochet, half-double crochet and double crochet. The photography on this video allows you to see the motion of the crochet hook and the thread and really see observe the techniques as they are explained. Techniques are explained for starting and ending the continual round. This continual round technique including transitions between single, half-double, and double crochet allows you to crochet projects like skullcaps and hats using one...
No need to spend money at the beauty shop when you can make your own green tea facial scrub at home. This video tutorial demonstrates how to mix together a homemade facial scrub that you can store and use multiple times. This homemade mask is inexpensive and great for getting rid of dead skin cells (which can pile up giving you a dull complexion). By using the scrub when it is slightly warm, it opens pores allowing the nutrients of the mask to cleanse deep within.
.Zip files are a convenient way to store and send multiple files in one neat little bundle. When you receive a .zip, however, you will need to unzip it to use the files inside. With this tutorial, learn exactly how to unzip a .zip folder on your PC and access all of the information within. Follow this step by step and next time you receive an e-mail or a download containing the filename .zip, you will know just what to do.
This video demonstrates the proper way to sharpen knives with a steel. First, the blade of the knife should be held at about at 22 degree angle to the steel, Second, the knife should be slid along the steel in a sharpening motion. The steel should run along the blade of the knife from one edge to the other. Both sides of the blade should be sharpened in this manner. The steel has a guard to prevent the knife from accidentally cutting your hand, but if you are afraid of being cut, the steel ca...
Watch this video to learn how to calculate the area inside complex figures--shapes composed of multiple smaller, simpler shapes. The first step is to break the shape into its simpler component shapes. Then, using the information you have about the large shape, find all information you can about the smaller ones: base, height, etc. Next, find the areas of the smaller component shapes. Finally, add the areas of each of the component shapes together to find the area of the complex shape. Now you...
Want to stay warm while out in the cold without looking like a frump? This video is for you! Stylist Jackie O Dee shows you multiple ways to tie a scarf to keep looking stylish during the cold winter months. Some styles work well under outerwear while others can be pinned and worn indoors with your regular outfit. The great thing is that many of these techniques can be transferred to lighter spring scarves as well as this instruction can be used all year long.
Multiplying positive and negative numbers may seem confusing. However, in this math tutorial, multiplying numbers with different or same signs is made easy and eliminates all confusion. The narrator of the video explains the key rules to remember when dealing with the possible combination of positive and negative numbers. The video breaks it down to two key rules. When you have a negative and a positive number; the result will always be negative. When you are given two numbers that have the s...
Gary Rosenzweig of MacMost is describing how we can use sound input and output controls on one's Mac computer. He mentions of the availability of multiple input and output devices like built-in mic; line-in etc and speakers , USB headset and provides a detailed information of using each of it; by selecting the one the user requires. He shows how the user can use popular communicating tool the Skype with the Mac laptop. One must go through this video to understand the selection of the output o...
In this tutorial, we learn how to draw a manga girl. He uses a Photoshop-like program on the computer to generate this character. He starts off the picture by starting off with a basic shape for the body and face. He uses light sketching, before using more thick lines to create the details of her face and body. He draws a lot of lines, to make sure that the girl is symmetrical. He makes it look even more elaborate, to parts such as the hair and face, by layering multiple details.
In this video tutorial the instructor shows how to enable usage rights for Adobe reader. She begins by showing a multiple page PDF which can be viewed by anyone having a Acrobat reader. She goes to advance menu and chooses the option of expand features in Adobe reader. She says that by granting these rights in Adobe 9, we can let other people write into the forms of the document, comment it and even sign the document. Now she applies the features and saves the document to the desktop. Now she...
Want to access files from multiple computers at work or home? An expert from PC Remedies explains how to set up a Home Group network on Windows 7 systems. Includes a how-to of setting up your location, and managing the set-up wizard. Finally maximize your current resources by networking your work and entertainment files, as well as hardware such as printers. The excellent video gives you an exact snapshot of what you can expect to see on your own Windows 7 system. Includes advice on setting u...
