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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF 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 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW 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 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.
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 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
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 the demonstrator shows how to make an alternative style rock star bead necklace. She uses purple cording, pink round beads, and a pink and purple heart bead to construct this fun, original piece of jewelry. By using a headpin and pliers, she shows how to turn the heart bead into a charm to use in the center of the necklace. She also shows us how to knot the beads in place for a polished look. Follow her unique tips including using nail varnish to sting beads easier, seed beads t...
In this video from KatiesTeachings we learn how to write an annotated bibliography with 4 easy tips. Katie Mitchell gives this tutorial. Once you find your sources you need to record the bibliographic information like who wrote it, when they wrote it, and when it was published. Next you need to summarize the source. Third, you want to assess the source. In doing this you want to answer questions such as was it good and is it valid. Finally the last step is to reflect on the source. These four...
Vista Tips teaches the viewer how to easily get the task manager in Windows Vista. Vista Tips warns that the simple way to get task manager used to be to simply hold the keys Ctrl, Alt, Del down simultaneously. Now, these keys yield a menu. The way to get task manager on Windows Vista has now been changed to Ctrl, Shift and Esc. Simply hold down Ctrl, Shift and escape simultaneously to directly yield the task manager. Another way to do this is to use the start bar to get the task manager. Sim...
In this Outdoor Recreation video tutorial you will learn how to make fire in multiple ways. For this you will need either cigarette lighters or matches. There are also a variety of fire making kits available with fancy strikers to produce sparks and chemically coated paper strips or ropes that catch fire easily. Another method is a fire piston. Put the ‘O’ ring on the plunger and some charcoal powder on the tip of the plunger and bang it in. when you pull out the plunger, the charcoal will be...
Adam Harrel a lead master instructor at Jim McLean Golf Academy is going to help improve your golf game by showing you how to improve the use of your delivery position in your golf swing. The delivery position in your golf swing is when bringing the club down to hit the ball the club is parallel to the ground. Some tips to improve is first your right knee and right arm should be bent inward and on the same line, reverse is true if your a lefty. Common problems of getting t far on your back le...
In this video tutorial from RenaissanceRentals you will learn how to maintain and troubleshoot your home garbage disposal. First thing to do is to keep the water running during garbage disposal. Ensure that the leftovers are cut into small pieces and you put only small quantities for disposal at a time. Things like plastics, glass pieces, rocks and food items like egg shells, starchy foods like pasta or rice should not be put into the garbage disposal system. If you follow these simple tips, ...
Gabrielle demonstrates how to bleach your eyebrows with peroxide at home. Bleaching your eyebrows is helpful for people who frost or bleach their hair and need to lighten their eyebrows to match their new hair color. Put a little bit of everyday household peroxide on a q-tip and swipe it across your eyebrow. Make sure there's not too much peroxide on the q-tip so it doesn't drip down. Leave the peroxide on overnight. When you wake up the next morning, just wash your face and you will see your...
In this video, Andrea Albin, Assistant Food Editor at Gourmet Magazine, explains an easy tip for measuring honey. She says that it can be difficult and messy to measure honey because it sticks all over the spoon when you try to get the spoon out of the jar. She suggests taking a small bowl of neutral flavored oil, such as vegetable oil, and dipping the spoon into the oil first. Next, pour the honey into the spoon. When you turn the spoon over, the honey slips out of the spoon easily without s...
First, prep the nails. Apply the white tips to the end of your nail. Use a nail clipper to clip the edges and a nail file to round the edges so they are not pointy. Next, apply primer to the bed of the nail. Then apply white acrylic with a brush to the tips that you put on earlier. Use the brush to make sure it fits the shape you want. Next, apply nail polish on the nail bed until it is the same height as the acrylic. File the edges down again if needed. Coat with transparent pink mix (a mixt...
Has your car recently had a leak and left your garage floor looking stained and grubby? Get your garage or driveway sparkling clean with this video from Danny Lipford.
This video shows how easy it is to make a great looking cupcake bouquet. You will need half a Styrofoam ball, a flower pot, some toothpicks, a piping bag with a flower tip, some colored icing and, of course, the cupcakes. Place the piece of Styrofoam in the flower pot and arrange the toothpicks to mark where you will place the cupcakes.
In this video, Yuri Elkaim will teach you how to get six pack abs using cardio and strength training. He breaks down the discussion of cardio vs. strength training for burning fat and building muscle. In the video, Elkaim stresses high-intensity interval training (HIIT), in which he says you will burn more calories, and therefore lose more fat if that is your aim. Furthermore, working at a higher intensity for longer periods of time increases your cardiovascular strength to an even higher deg...
Darin Stein from Fat Loss Lifestyle demonstrates how to build your pectoral muscles with exercise tips. Put two medicine balls into the butt of your palms, not your fingertips, for pushups. Lower your body for two seconds, keeping your elbows apart. Get a real nice stretch in the chest and push your body up. Do fourteen pushups. For an advanced workout, elevate your feet when doing the pushups. Walk a 65 millimeter resistance ball to your toes and continue doing the pushups. In addition to to...
Starting out with a brief summary of what type of pliers to use when making a wire loop with tips on how to prevent markings on wire when using a certain type of plier. This video is used to teach crafters on how to make loops with wires that are useful for many jewelers Making the loop requires 2 certain types of pliers, one called needle-nose plier used to create the loop. Tips near the end on how to fine-tune the loop so it ends off perfectly as well as explanation on why a 45 degree angle...
BeautifulYou TV presents how a watermelon nail art design is painted. The nail painting starts off with a white line drawn between the base and the tip of the fingernail. Pink is used to cover the base and light green for the section from the white line moving towards the fingernail tip. Streaks of dark green nail polish are then painted on the light green section to give the look of a watermelon. To decorate the watermelon with seeds, draw black tear-shaped designs on the pink section and cr...
Follow this video to learn how to make your own paper airplane that can really fly. Acquire a sheet of A4 paper and fold it in half. Afterwards fold two of the edges towards the center line set out when folding. These should be folded in the form of two triangles. After doing so fold them downwards, towards the center line lower down. Fold another two triangles towards the center, one from each side. At this point a small edge will be formed at the tip of the two folds. Simply fold it upwards...
Scott Cook gives you some very easy tips to use your pocket knife carefully. Some of the tips to use your pocket knife carefully are: Always choose a knife with a lock so that it does fold accidentally and a firm handle comfortable to use. Always use your knife away from you while carving. Hold it firmly to carve easily and make sure nobody is around you while using your knife. You can also dig using it and to drill hold it firmly straight and rotate the knife.
QueenofBlendingMUA teaches us how to paint our nails purple black and add rhinestones. For the rhinestone nail you only need to add black nail polish two times and then add rhinestones individually. For the diagonal silver nail you use the Art Deco 3D silver to draw a diagonal line from the top on your nail. You then color it in using a silver nail polish called Chrome. You then use the black Art Deco to create a diagonal line on the clean line, in the opposite direction. For the purple tip n...
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.
Anastasia Khozzisova, runway coach, explains that many women do not know how to walk properly down the runway. Follow these tips and learn now to walk in high heels as a model. The basic parts of the walk are: -Hips, this is where your movement comes from. -Head, make sure your neck is relaxed. Keep your head back and chin up. -Toes, practice walking on your toes before putting a pair of heels on. -Arms,make sure you are swinging and moving your arms. It helps for a great picture. Learn to be...
Ocean Mist Farms shows you how to quickly cook fresh artichokes in a microwave. You'll learn a few simple tips and techniques to properly cook an artichoke using ingredients such as lemon, water, salt, and olive oil. After following the preparation tips, microwaving the artichoke will take approximately 18 to 20 minutes, depending on the size of the artichoke and the power of the microwave. You'll be shown what to look for to know when the artichoke is ready to eat, and saving the leftovers i...
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.
This is a video tutorial on how to solve a 2x2 Rubik's cube using the Ortega method. The tip from the author is to go for the color whose maximum squares are already together. It is also pointed out that not only does the Ortega method involve three steps, which is time consuming, people using it also tend to take pauses in-between, drastically reducing one's solving speed. This tutorial provides tips on how to reduce and eliminate such time consuming pauses.
This video is a tutorial that gives very helpful tips to viewers on how to pass any urine screening THC test. Viewers will learn how to prepare for a THC test and how to successfully pass the test. This video is for those who are currently doing drugs. This video will benefit those who are doing drugs because it will allow users to avoid failing the test and any consequences for failing. Viewers learn helpful tips such as: do not eat before taking the test, drink water and exercise.
Happiness is very unique thing. Everyone knows this word but can't explain properly what happiness actually is. There are top five tips to be happy in home or workplace in the video. Staying positive is one of the tips. Whatever happens in life you should be happy. You can write down all your tasks as a list. After finishing the tasks, scratch them out. When difficult tasks come, laugh for a while. It will lighten your pressure. After following the steps you will be interested in your life an...
Do you want to get started in the world of eBay but are you stuck on how to get started? In this instructional video, Ask the Auction Guy will give you some basic tips on how to get over that initial hump and get into the world of online auctions. He'll give you tips on where to find your eBay items, what will make you more money, and which areas to steer clear of. This easy to follow video will help give you a push into the world of eBay.
Would you like to learn how to draw amazing anime cartoons? This excellent and entertaining video demonstrates step by step how to draw a flawless female anime face in 3/4 view. It discusses the challenges of 3/4 views, how to practice difficult facial drawing techniques, and offers helpful tips on how to produce anime drawings that really stand out. It provides helpful tips on proper pencil and lead choice to quickly and easily get fine, clean and perfect lines that are a must for modern ani...
In this video the author talks about the secrets of quitting smoking forever. there are basically four tips to achieve this result. The first is you need to keep your hands busy, so that you can avoid the desire to hold a cigarette. Similarly you also need to keep your mouth busy, by chewing gum or anything to draw your attention away from cigarettes. It also helps to keep a pack of cigarettes in your pocket all the time to continuously remind yourself that you have to stop smoking and there ...
In this video, potter Simon Leach offers tips on how he decorates the ceramic pots that he has made. This video offers some great suggestions on decorating pottery that you have made, or have purchased unfinished. This video does not teach any specific decorating techniques, but focuses more on the process of a potter when contemplating decorating their creations. This video does cut off at the end, so do be sure to watch the continuation of Leach's tips in which he gets into more specific de...
The pubic area is a very, very tricky area, when trying to shave and so in this video, Dan and Jennifer from Ask Dan and Jennifer try to supply some useful tips and tricks for this delicate operation. First, you need the proper tools. These include, Dan and Jennifer say, a good electric trimmer, a razor that's not a straight razor and of course shaving cream. Secondly, always use the trimmer and then razor on the surrounding pubic hair, not the main area, first. Third, you want to go, from ar...
This how-to video demonstrates a how to create an image of the comic-book superhero Spiderman in a basic generic pose. The artist, Xia Taptara, sketches out the basic figure, then gives advice on how to practice drawing tricky features like musculature, hands etc. as he adds more definition using a darker line. As the drawing progresses, Xia Taptara offers tips on perspective and more.
This golf tips video features Eddie Lee, who demonstrates how to use bounce to get the ball out of a bunker. Lighten your grip and rotate the club about 15 degrees to the right to expose the bounce. He demonstrates how to swing, keeping the club face open, with the club head pointing at himself like a mirror. He aims for 1-2" behind the golf ball, creating speed on the finish of the swing. If you remember these tips, you will be a very efficient bunker player.
Austin from 'Best Buy Tips and Tricks' give out a mobile tip on how to extend the battery life of your Blackberry by using the Blackberry's built-in function called the automatic black light dimmer. This function changes the brightness of the back light automatically depending on the light intensity of the environment you use the phone. Activate this function as shown in the video so that your phone changes the brightness of your Blackberry screen to an optimal level depending on the environm...
Bobby Flay gives three useful grilling tips and explains the common mistakes. To grill properly he suggests you follow these rules:
