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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the COUNTIF, IF, COLUMNS, INDEX, TEXT, SMALL and COLUMN functions in an array formula to return multiple items (e.g., list free periods for a list of students).
Katy Perry is an absolutely cool chick. She is always wearing and updating the funkiest styles. In this tutorial, learn how to recreate Katy's look from her new music video with Timbaland "If We Ever Meet Again". This look is retro, classic and still bold and shiny. If you are a Katy fan or are just looking for a great period style that you can accessorize, check this out.
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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
Have you met a guy you really like and you want to see him again? Make sure you check out this video, and avoid common mistakes that girls make when they meet guys.
This video describes how to make a "no calorie" birthday cake centerpiece with carnations in soft and sweet hues of pink, yellow, white and cantaloupe. first a flower foam was taken. Then the toothpicks were used to join the flower foam together. Then trace out a circle from the foam using a kitchen knife. Add some water to the base of the cake. With equal size flowers decorate the base of the cake. Then the cake is beautifully covered with different types of flowers. decorate with as many fl...
artjewelrymag teaches you how to use a liver of sulfur solution to create a patina. First, be sure to wear protective gloves and eye gear. Be sure to perform this operation in a well-ventilated area because sulfur smells like rotten eggs. To get started, add a few small pieces of liver of sulfur to a small dish of warm water. Use a wooden stick or a small PVC pipe and stir. The temperature and the amount of time you leave the metal in the solution will affect the patina. You can dip the metal...
Fashion Face shows us how to create a 30's all over face look inspired by Marlene Dietrich. To create this look you will need full coverage foundation, concealer, a range of matte eyeshadow from taupe to brown, eyeshadow brushes, brow highlighter, mascara, liquid eyeliner, false eyelashes, pressed powder, beige contouring powder, powder and contouring brushes, highlighting powder, red lip liner and red lip cream or gloss. Specific brands are used and suggested, but you could create this look ...
Regardless of where you are, there will probably be a period when your lawn will turn brown and possibly go dormant when there is a drought. Contrary to popular belief, it is okay to use fertilizer on your lawn when there is a drought. Using a higher setting on your lawnmower will allow the grass blades to be longer, allowing them to retain more moisture. When you are finally able to water your lawn again, make sure to water it twice a day, hopefully in the early morning to avoid the heat of ...
Many foods that you cook in the microwave create a very strong odor. That odor can last for a period of several hours or days. To remove the odor take a bowl and wet a paper towel and fold it in half and then in half again and put the towel in the bowl. Put the bowl in the microwave and heat the bowl and paper towel for one minute. Heating it will create steam and the paper towel will absorb the odor.
Bummed about your divorce? Feeling like a failure? Oh, stop! Get off the couch and jump-start your social life because there is life after a divorce! A great life! Get back into the swing of things by taking steps towards building a better you and regaining the confidence you once had. You might just look back on this period in your life and realize it was for the best!
Battery life is precious to all mobile device users, and nothing is worse than running out of it. The only thing that can save a device from the dreaded low battery warning is the charger, but who carries those around?
Hardscope. What it is? The answer is simple. It's when you look down your scope for an extended period of time, then shoot and kill, as compared to quickscope, which is when you look through your scope and shoot almost instantaneously. If you want to learn how to improve your hardscoping technique in Call of Duty: Modern Warfare 2, then watch this NextGenTactics walkthrough of hardscoping in the multiplayer map of Underpass.
No, this isn't an elaborate paper helicopter design that will take you weeks to master. Just because it can fly doesn't mean it's difficult to make. In fact, this is one of the simplest paper helicopters you could make. And it's a great instructional tool for a science classroom to learn about the principles of flight and the heat of the sun. It flies like it has a mind of it's own! Sometimes it will even hover in one spot for an extended period of time. Check it out, both videos, then make y...
Rest in between long bouts of exercise is recommended, since muscles need time to heal and patch themselves up after tearing (yes, any form of exercise makes micro tears in your muscles that must be healed. These tears are a good thing because once you get patched up, your muscles become stronger than before).
James shows us how to prevent stinky pits without using deodorant, but instead the Japanese Urawaza secret of baking soda and lemon.
Quince is a fruit very similar to apples and pears in that it grows on a deciduous tree, but it is far too astringent to eat raw. Quinces are usually cooked for a long period of time until they lose some of that acidic flavor and become tender.
The turkey is the A-list star of your Thanksgiving table, so it only makes sense to make sure it's as savory and enjoyable as possible, right?
If you think thrifting just involves hitting up your local Salvation Army and picking up a few pieces of secondhand clothing plus a cute little old-looking vase for your dining room table then you've got some learning to do.
This is a video tutorial in the Electronics category where you are going to learn how to calculate compound interest using a TI-84 and solver. Press the apps button on the calculator and press enter to load the TVM Solver which is the 1st choice. Here the meaning of various notations are N is time, I% is the percentage, PV is present value, PMT is payment, FV is future value and C/Y is compounding period. The problem is find the compound amount and the interest earned on $12,903.45 compounded...
If you want to prank a friend or family member, this next tutorial is one that is really easy to perform. This is called the exploding soda can prank.
In this video tutorial, viewers learn how to find their I.P address in Windows 7 and Vista. Begin by clicking on the Start menu. Then type "cmd" into the search bar and press Enter. When the command prompt window opens, type in "ipconfig" and press the Enter button. Now search through the list and find a line that says "I.P address" or "IPv4 address". The numbers will be divided by periods. Another way is to open Control Panel and select Network and Sharing Center. Then click on your local ar...
It may not seem like a big deal, but it can be for some homeowners. Shoe molding around your cabinets and island tables, can asily be damaged or become worn out over a long period of time. Replacing it, may seem like a pain, but it's really simple and can be done in no time. Check out the tutorial above on how to replace old shoe molding in your home today. Good luck and enjoy!
In this tutorial, we learn how to read body language and how to flirt with your own body language. The first way to attract someone's interest is to look them in the eye, without glaring or staring at them. When you get eye contact for a short period of time, you will get the other person's attention. If you want to get attention from another person, face towards them and adjust your hair. Another way to show someone you are interested in them is to lean towards them and point towards them wi...
Once grout has been layed in between the tile, it's stuck there for a long time right? Well not necessarily. Grout can last for a long period of time, but if needed, it can be removed using the right tool. This is important, especially of you have any grout that may have become stained or damaged. For more information on how to remove the grout and how to replace it, check out the tutorial above. Good luck and enjoy!
During this rough economic period, more and more people are looking for better ways to save on money, but still look good in the process. One of the best ways of doing that is by making your own jewelry. Much of the materials can be bought at stores like Target and Wal-Mart and are easy to put together. So in this tutorial, you'll find out how to make beautiful looking pearl cluster earrings. Good luck and enjoy!
Over time, rust can develop on pots and pans if they're not used for a certain period of time. Rust can also develop on other items as well, if they not taken care of properly. This can hurt any possibly resale value of the item and can look ugly. So in this tutorial, you'll find out what items are needed in order to remove rust. Good luck and enjoy!
Orbit Downloader is a Windows compatible tool that helps increase your download speed by up to 500% and uses less than 3MB of memory and 3% of CPU.
In Part 6 of a series of video clips, `ClickHerePhotography` gives tips on how to select the right tripod for various outdoor environments and conditions like snow, rain (hail and thunderstorms), mud, dirt (dust) and waterbodies (river,streams or oceans). It is important to use a sturdy tripod designed to withstand the elements. After using the tripod for the day, it is essential to clean it. For instance, sand or salt water will weardown the legs of the tripod if left for long periods of tim...
Scott from Spring Hill Nursery with Step by Step Gardening teaches you some basics about hydrangea plants. He talks about how to take care of the plants, how to ensure blooming, and some planting considerations. Hydrangea plants need at least five hours a day in order to bloom so they should not be planted in very shady locations. The blooms can be pink, blue, green, or white, depending on the variety and soil conditions. The blooms can be used in bouquets, or dried for use in crafts. The pla...
Chef Stephen Gibbs shows you a good cooking technique: blanching and shocking vegetables. Blanching is letting vegetables in hot, boiling water for a short period of time. Shocking is putting hot vegetables in ice cold water. These methods are used together in order to precook certain vegetables or even take the skin off.
snow mold occurs in round patches of grass in the lawn. The patches contain a fussy substance (the mold), that appears in grey or pink; the most dangerous of the two. Mold is formed whenever a lot of snow is left on the lawn for a long period of time, this causes the mold to grow underneath. Late fertilization with a lot of nitrogen promotes mold. Dead grass or thatch can cause mold to develop. Gently raking allows airflow into the grass and promotes new grass growth. The putting down of gras...
Cars are expensive to buy, replace or repair. Check out this video and learn how to avoid the most statistically dangerous parking areas. There is no guarantee that no one will touch your vehicle, but by take precautions you are much less likely to be targeted.
An atom is a basic unit of matter consisting of a dense, central nucleus surrounded by a cloud of negatively charged ions. The nucleus itself is a mixture of positively charged protons amd electrically neutral neutrons. Different groups of elements have respective atomic numbers. You can use the periodic table as a tool to draw atoms of elements. The periodic table is organized into periods, groups and families. This video is a tutorial that reviews the subatomic particles found in an atom. I...
Robert Scott shows us in this video how to remedy stretch marks. Stretch marks can be caused by excess of weight gain, muscle building or anything that occurs over a short period of time and breaks down the fibers in the skin. They are not really curable but they are treatable. They can be minimized by a few different treatments. Laser treatment can be done in an aesthetician or physician's office, depending on which state you live in. This builds up the collagen and rebuilds the dermal layer...
If you're camping or stuck out in the middle of nowhere, chances are, you could be faced with dark and freezing cold nights. Learn how to make a simple camp fire out of flint and birch bark. This is for in case you do not have a lighter on you at any given time. To start the fire, you're going to need some bark from a birch bark tree. You're also going to need a flint and a paper napkin as well. After you've gathered the proper materials, just look for a barren spot on the ground, place your ...
In this video tutorial, viewers learn how to use the Peter Answers - Virtual Tarot website. Peter Answers is a fake fortune telling website that is usually used as a prank. Begin by going to the website. In the Petition space, type in a period. A "P" will be displayed. Then type in the answer too the question and press the space bar until it spells "Peter, please answer the following question:". Then type in the question in the bottom space. This video will benefit those viewers who enjoy pla...
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Excellsfun also shows you how to incorporate various pay periods including weekly, semi-weekly, bi-weekly, and monthly on the same form using the same calculation for the entire spread sheet. After watching this video, you w...
The tutorial teaches the audience an alternative way to make jerky without the fire. The ingredients needed include soy sauce, garlic powder, brown sugar, white sugar, black pepper, ground ginger, onion powder, oriental five spice, cayenne pepper and kosher salt. Meat is put into a metal bowl with the mentioned ingredient and after a period of time, the meat is tossed around in the metal bowl so all the meat will have a chance to soak in the solution. After soaking off the solution from the m...
In this video tutorial, viewers learn how to convert music to ringtones using iTunes. Begin by finding a song. Right-click and go to get info. Go to Options and change the time to any 40 second period (check both boxes). Covert it to AAC. Delete New Version, but keep file. Then close iTunes. Find AAC song file and drag it to the Desktop. Rename from .M4A to .M4R. Double-click and it will open in iTunes under ringtones tab. Sync just like you normally would. This video will benefit those viewe...
1. This video describes how to warm tortillas. If you have a gas stove, set the burner to simmer and put the tortilla on the burner and keep the tortilla for 8 to 10 seconds on each side. After that transfer it to a pan covered with foil to keep tortilla warm.
