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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF 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, the 153rd installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to the MAX value in a set of three incentive pay plans.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF 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 139th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data validation list drop-down and the hyperlink function to create a list of links.
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 Excel tutorial from ExcelIsFun, the 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your formulas.
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 Excel tutorial from ExcelIsFun, the 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a SUMIFS function to tabulate a monthly running total from transaction data.
In this how-to video, you will learn how to do a cartwheel side flip. First, make sure you can do both a cartwheel and side flip. If you can do these tricks from a standing position, you have more control over the flips. Try to land on the balls of your feet with your legs somewhat apart. Now, come off the balls of your feet and do the side flip. Make sure that you then turn and tuck to perform this correctly. Notice that your arms add momentum as you go through the cartwheel and into the sid...
This is a great way to learn how to upgrade your small house plants into bigger ones. Start over plants once a year. Put rocks on the bottom for drainage. Bugs help your plants to grow. Do not use Pesticides on your house plants. Water weekly. Compost bins make great soil. Sweet potatoes that have roots growing off of them put in a glass of water and wait for them to grow roots. Give you plants at least six hours of sunlight daily. They also like when you talk to them and touch them you can c...
This video shows you how to prepare Chicken and Pears. For this recipe, you will need: one whole chicken, a stand to roast chicken on, a toothpick, salt, pepper, and pears.
Saabkyle04 runs through the necessary steps it takes to clean your wheels so good, they will look like they are brand new! Having a little bit of brown on your tires and dirt collecting in the lug nut area can be fixed by watching and listening to this video. While any wheel cleaner will work, the person in the video uses ArmorAll. You should also have some tire foam, a brush, a toothbrush, a couple of assorted towels, and a brush for getting behind the wheel. First, rinse the wheel. Then, ap...
This video is led by Eddie from Long Island Boaters Club. As the boating season ends, Eddie explains, it is very important to clean and prepare your boat for storage for the winter. An important part of this process is to power wash the algae growth and barnacle debris that can cover the hull very quickly. After taking the boat out of the water and placing on blocks, he lets it sit for one day. Then using a pressure washer, he removes the algae growth. A scraper is used to remove the actual b...
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 393rd installment in their series of digital spreadsheet video tutorials, you'll learn how to remove the last two words from column of data with the LEN, SUBSTITUTE, FIND, REPT, RIGHT and TRIM functions.
New to 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 Excel tutorial from ExcelIsFun, the 246th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a waterfall profit chart from a stacked column chart.
New to 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 Excel tutorial from ExcelIsFun, the 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
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 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
When entertaining, it's great to have fun, colorful ideas to make drinks feel special. By adding a simple slice of fruit or vegetable to a glass of water can impress your friends and make you feel like you're at the spa. It is very important to drink water, and flavoring it with lemon makes it easier if you're not a water drinker. The host cuts slices of lemon and lays them on top of the water or the side of the glass to garnish, and squeezes the rest of the juice into the water. It can be ma...
Have you ever been caught with nothing to eat but canned soup or tuna fish and no can opener in sight? In this video, AJ Conover demonstrates how to open a can with a hammer and nail. First make sure the hammer and nail are very clean. Use the hammer to lightly pound the nail into the can's lid creating holes. Be careful not to pound too hard and drop the nail into the food inside the can. Hammer enough holes to make an opening around the edge of the can's lid and then pry the lid up and open...
In this video tutorial, viewers learn how to wax a snowboard. The materials required for waxing are: wax (cold, medium or warm temperature), scraper, brush, iron, wax paper, cloth and gloves. Begin by wiping the board with the cloth. Now rub the wax on the board. Then hold the wax against the iron to melt it, and then rub it on the board. The press the iron on some wax paper and spread it across the board. Leave it too cool for about 20-30 minutes. Then use the scrape to remove the wax layer....
To change the transmission fluid on a Honda Civic, you will need a good rug, a drip pan, 10 quarts of transmission fluid, a funnel and a ratchet wrench. First, remove the dipstick to release the pressure on the liquid. Then, remove the drain plug with the ratchet wrench. You may need to bang on the bolt with a cheater bar to loosen it. Drain the fluid into the pan. Then replace the drain plug until it is hand tight. Use the ratchet wrench to tighten the drain plug. Clean up the excess transmi...
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...
This how-to video explains the importance of choosing a quality car mechanic and shop. This video is by AAA. They say that by investigating a shop before you trust them making repairs on your car, you can save a lot of money later if they make a mistake. John Neilson of AAA explains to look at the cleanliness of a shop because if it is clean then they probably take customer service very serious. If you follow these easy instruction you will be assured that you can select a quality car mechani...
Dawn5377, teaches you how to use the clear mount stamps. These come in sizes from A to I. They are high cut so you don't get ink on your fingers when using them. The stamps come in a DVD case for easy storage, which also comes with instructions on usage. Remove the sticky part of the image, place it on the back of the rubber stamp. Place image face down on the clear block of equal size. Ink the rubber stamp and just stamp on a piece of paper. You clean the rubber stamp with spray mist and scr...
This video explains how to make pumpkin & pecan pies. Reheat oven to 350 degrees F. Combine pumpkin, 1/3 c. sugar, 1 egg and pumpkin pie spice in medium bowl; stir well. Spread over bottom of pie shell - this is your pumpkin layer.
On this video from Bushcraft Machete, he explains the purpose of a scandi edge and how to use it. He uses the machete as a planer, stripping the bark from a log by holding the machete almost flat against the log and tapping the back of the blade with a stick. He explains that a scandi edge is sharpened all the way down to a point and has a very low angle. This type of edge makes the machete useful for carving off thin strips of wood. He has sharpened his machete with a scandi edge near the ha...
This video, produced by Photoshop Universe, teaches how to reduce beard stubble or 5 o'clock shadows from male pictures. We are shown how to use the dust and scratches filter, layer mask, as well as the advanced layer style command "blend if" on the underlying layer helps us to make this possible. The first step is to duplicate the layer and then select filter, noise, and dust and scratches. The second step is to apply some dust and scratches to the beard selection. Finally we blur the layer ...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
Photoshop can be a confusing program, especially with all the different settings and effects you can tinker with. Learn to master the vanishing point filter in this fun, easy to follow tutorial with the Pixel Perfect team. Clean up your pictures and smooth over any unwanted imperfections as he takes you how to make them "vanish" with the program. Alter the perspective of an image and add it on to another and change that cloudy day into a snowy background. Each step is carefully explained with...
In this video by Photoshop Universe we learn how to reduce noise in a photo in Adobe Photoshop. First we learn that there are two types of noise in a photo, luminance and color noise. Next we learn that reducing noise is balancing act, as we take away noise we also lose some detail of the image. Finally the author goes over the 3 steps it takes to reduce the color noise that can be present in photos. Using these methods we learn that we can quickly clean up images that have noise in them in P...
To build your plate display you will need a plate collection, some plate hangers, and a hammer. A good part of hanging plates on the wall is you can use cracked and chipped plates in your display. To get the plates ready to hang all you have to do is make sure they are clean and measured correctly so that you can get the right hangers for the plates. When purchasing plate hangers go with the smaller size. If the plate is 10 inches buy the 7-10 inch hanger rather than the 10-14 inch hanger. Yo...
This video shows you how to get a New Year’s Eve look that is very fun, flirty, but simple using glitter. For a base use two face eye shadow insurance all over. Take a blue and put it onto the lid up and away. For the bottom use a dark blue and with a small brush smudge it across the bottom of the eye. Use Aqua Black and with an angle brush apply it as a liner. Use MAC glitter liner and put it on the inner corner of the eye. With a clean q-tip take a silver glitter and dotting it into the gli...
Looking to emulate the vixens of the 20's and 30's? In this makeup tutorial hosted by Smashbox Cosmetics, embrace your inner vixen with these tips and tricks on how to steal this look with your makeup. With a clean face, a natural matted eye with nude shades, and a dark winged out liner, you'll be channeling Betty Page in no time!
Aluminum cans are useful for various DIY projects, but they can be tricky to take apart. In this video you'll learn how to easily disassemble cans.
Using all products from Pur Minerals, this look is for the everyday life style. Simple, clean and effortless. Perfect for work or school, it's all about enhancing your natural beauty. This makeup should not take longer than 10 minutes tops, remember less is more, simplicity is natural and natural and wholesome beauty. Watch this video tutorial to learn how to recreate this pretty makeup look.
It's time to disassemble your Eastsheen puzzle, so how do you do it? These puzzles are meant to be solved, just like the Rubik's Cube, but every once in a while it is necessary to take them apart, either for cleaning, lubricating or for replacing game parts.
It's time to disassemble your Rubik's puzzle, so how do you do it? Erno Rubik designed these puzzles to be solved, but every once in a while it is necessary to take them apart, either for cleaning, lubricating or for replacing game parts.
It's time to disassemble your Rubik's puzzle, so how do you do it? Erno Rubik designed these puzzles to be solved, but every once in a while it is necessary to take them apart, either for cleaning, lubricating or for replacing game parts.
It's time to disassemble your Rubik's puzzle, so how do you do it? Erno Rubik designed these puzzles to be solved, but every once in a while it is necessary to take them apart, either for cleaning, lubricating or for replacing game parts.
Instructional 'Do It Yourself' video on how to craft a sweet moustache. Try out some of these bold facial hair styles to celebrate Movember. Movember (the month formerly known as November) is a charity event held during November each year.
This is a step-by-step instructional on how to make a potato gun, otherwise known as the spud gun, potato launcher, potato cannon, etc. Although this can be a fun activity, it is still dangerous, just like a real weapon.
