In this video tutorial, viewers learn how to play glissando on the piano. This task is very easy, fast and simple to do. Glissando is basically playing all the notes of the piano. When playing glissando, use the tip of the thumb to slide down the piano. When going up the glissando, use the tip of the middle finger and slide it up the piano. The fingers might hurt at first, but you will eventually get used to it with the more you play the glissando. This video will benefit those viewers who en...
In this tutorial, we learn how to increase hair elasticity. A great mixture that will help increase your hair elasticity is honey and water. When your hair is wet, it can stretch up to 50% longer than it is without breaking! If you have low elasticity, your hair will not curl well and the heat will not keep your hair curly. There are many products out there that will give you more elasticity to your hair. Putting moisture in your hair will also help. The last tip is to see your doctor and ask...
In this video, we learn how to whiten yellow teeth at home with a lemon. You will need: a q-tip, baking soda, and a lemon. First, cut the lemon in half and squeeze out all the juice into a container, then add in baking soda to the juice to make a paste and mix together with the q-tip. Now, apply this mixture onto your teeth and leave on for around 10 minutes. After you have done this, you will have whiter teeth in just a few minutes! Only use this mixture a couple times a week, because it is ...
In this tutorial, we learn how to clean an aluminum Apple keyboard. You will need: soap , q-tips, and water. First, remove each individual key to your keyboard gently, then, clean off the keys and the inside with a mixture of soap and water on a q-tip. When finished, place your key back onto the keyboard. Repeat this step for your entire keyboard, making sure to be gentle when you remove and replace the keys back on. Don't do more than two at a time or you run the risk of forgetting where the...
Acne sucks, and don't we know it. Our prom would have been ten times better had we not developed that continent-sized cystic blemish right at the tip of our nose (no concealor invented as of yet can cover up that monster), and the only thing more horrendous than going on first dates is going on first dates with a face full of stress pimples.
In this tutorial, we learn tips from roadies. If you experience a nosebleed and don't know how to handle it, there is a very simple way to cure it. First, take a long string and tie it around the middle of your hand a few times until it's tight. Then, make a fist with your hand and squeeze for two minutes. By the time the two minutes is up, your nosebleed should have subsided. Another tip, is for when you have hiccups. First, take a pen and press it on the inside of the ear. After a few secon...
Is your wedding coming up in a few months? If you're like the greater population of brides, whittling yourself away with all the planning, decorating, and selection of dresses isn't enough to match your standards.
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.
With the release of Alan Wake, gamers were introduced to something they may have never seen before. This game is considered a full blown thriller that is sure to keep anyone on the edge of their seat. In this helpful tutorial from the awesome people at IGN, you'll find out how to fight the baddies in the game using some helpful tips. These tips and tricks will help boost your flashlight, flare placement, and dodging techniques. So check it out if you value your fictional life. Enjoy!
Exercise is not enough for losing weight if you're still getting the supersized Big Mac meal at McDonald's. Food is almost more important than exercise when trying to drop those lose 5, 10, or 20 pounds. But how do you eat right if you're constantly on the go?
iPhones aren't perfect. They can have problems just like every other electronic mobile device. One thing that happens frequently with iPhones is freezing. If you're iPhone becomes frozen, how do you fix it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to safely reset a frozen Apple iPhone.
In this tutorial, you will learn how to dye your hair like a pro. Get tips and tricks on dying your dark brown or black hair to a nice blonde color without going orange. In addition to learning to lighten your whole head, you will also receive tips on how to use a hair cap to highlight your locks. By highlighting you will create a defined, multi faceted look that will look great and unique. So follow along and get ready to give yourself a professional style makeover.
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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
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 and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.
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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).
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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.
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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").
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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.
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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.
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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
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 284th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a line chart from years and percentage change. See how Excel makes the chart wrong, but then see how to fix it.
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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.
Karen shows you how to mix your colors and fill your bags. This example uses red blue and black. Begin by mixing blue. Start with royal blue coloring and add it to your frosting and mix it well. Dump the colored frosting into the middle of a sheet of plastic wrap. Roll it up in the plastic wrap, twist the edges, and now you have a little pouch with your frosting. Now take a bag with a coupler, and stick the plastic pouch of frosting in it. Pull it tight and rubber band the top of the bag, the...
In this video tutorial, viewers learn how to ice cupcakes. In order to ice a cupcakes, users will need a piping bag, tips, coupler and a spatula. Screw the coupler at the end of the piping bag and select a tip to put on the end of the coupler. Fold the bag 2-3 inches downward and place it into a cup to hold it. Now scoop some icing with the spatula and place it inside the bag. Squeeze the bag to bring the icing down and tie an elastic on top to close it. Viewers will learn how to 3 different ...
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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.
This video shows you how to remove acrylic nails using a nail tip. It takes a long time to soak the nails in acetone to remove them, and this method is quicker. To do it, slide one of the corners under any part of the tip. Force it in and slide it over across the nail and you will be able to see the acrylic nail lift up. Gently work on it to pull the nail off. It might hurt a little bit. The nail will look kind of rough, so you'll have to file it, and use some nail strengthener. Nail technici...
In this video, our author, Jimmy Jacobs, shows us how to build a quarter pipe. He shows use many ways to grip the shovel to form our quarter pipe such as “the granny” or the “railroad”. Please make sure your shovel has a sharp tip, otherwise this will be difficult. From here, just repeatedly hit your pile of snow with the sharp tip of your shovel to smooth out the surface. It is important to note that you it helpful to build your pile first, instead of trying to smooth the snow before...
This video shows the method to suture arterial lines using a curved needle. We will use the new arterial line kit for our demonstration. We will use a curved needle as it is safer than the straight needle. Hold the suture with the hamostat at about sixty percent from the tip of the needle. Do the turn the key method to bring the needle out from the other side. Unclamp it and re-clamp it at the tip of the needle. Continue the turn the key method. Pull the suture up and through. Cut the suture ...
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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...
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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.
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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.
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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.
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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.
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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a mean value as a scatter diagram data series to a box plot or box & whisker that is set up as a bar chart.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
