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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
There's a lot of conflicting information out there when it comes to the best habits for charging a smartphone's battery, so let's clear some of that up right off the bat. Lithium ion batteries (the type used in most modern electronics) start to lose their ability to hold a charge over time, and the two biggest factors that contribute to this are excess heat and overcharging.
There is no such thing as too much space when it comes to our smartphones. Space is the great equalizer of all things. No matter how many awesome features a device has, the amount of storage space available will always be a determining factor. Be it music, apps or photos, it's easy to fill up your phone's memory fast.
Hey all, I've introduced myself in the forum, but for newcomers, I'm former admin of Giveaway Tuesdays, and current moderator of Phone Snap!
In this tutorial, we learn how to replace bathtub caulk. First, fill your bathtub halfway full with water, then grab your caulk and caulking removal tool. After you have done these steps, apply your caulk remover. Next, scrape it with the remover tool. After this, use bleach and a toothbrush to remove any excess. Now, use rubbing alcohol on a towel to clean the edges of the bathtub. After this, apply mold resistant caulk, then smooth it evenly. Next, wipe the excess caulk with a clean washrag...
Thread banger, Kenneth King shows you how to save your good fabric scissors by using thread snips, a simple but important tool you must always have in your sewing workshop. Thread snips are small pairs of scissors that are specifically used for trimming off any excess thread in your material. Kenneth explains that using fabric scissors to trim these excess threads eventually causes them to wear dull spots. Always keep your thread snips handy and do all your thread trimming at the machine.
In this video, we learn how to make a vertical striped bracelet cuff out of beads. Start with a long piece of string and string on your beads until you have a length that fits well around your wrist. After this, tie the ends together and cut the tails off the excess string on the short side. now, start to thread through new beads around the entire bracelet. At the end of every few rows, tie it to keep it tight at the end. When you are finished, tie the string and make a knot, then cut off any...
In this video, David teaches us how to clean the inside of windows easily and quickly. You don't need fancy tools, all you need is a terry cloth towel, a squeegee and dish washing detergent. First, put a little bit of the soap into a bucket and wash down the windows. Next, take a squeegee and wipe horizontally making clean lines. The excess water should drip down and you will catch it with your next squeegee wipe. If you have extra wetness on the edges, grab an old t-shirt and wipe the sides ...
To remove a bookplate, you will need paper towels, wax paper, distilled water, water colored paper, a weight, and a blunt knife. Cut the paper towel slightly larger than the bookplate itself with scissors. Wet the paper towel and blot it dry with another piece so it is damp. Fit the paper towel over the bookplate, put the wax paper on top of it, and let it sit under the weight for twenty to thirty minutes. Once the paper towel has soaked into the bookplate, gently peel the bookplate off with ...
Installing a ceramic tile backsplash in your kitchen or bathroom can not only add a great new look, it can help prevent your walls from crumbling due to excess exposure to water. This simple little vid from buildipedia will walk you through the process.
In this video, we learn how to use a head pin while making earrings. Start off by grabbing a 1" long headpin and feed a bead through it until it reaches the other end of the pin. Now, decide how you want to close the loop. The first way to close it is to make a single loop by using pliers and making a 45 degree bend. Cut off any excess wire with wire cutters. The next way to do this is to wind the excess wire around the base until it comes to the bottom of the bead. This is visually appealing...
In order to glaze a lamp base, you will need the following: glaze, warm water, a sponge, copper carbonate, paintbrush, and sticks.
In this video tutorial, viewers learn how to tie pointe shoes in ballet. Begin by putting on the shoe and tie the small lace. Then cut off most of the excess of the small lace (about 1 1/2 inches) and tuck it inside the shoe. Now wrap the inside ribbon of the shoe one time around the ankle and tuck it back. Do the same with the other ribbon, except do it the opposite way and then tie the ribbon together. Now cut off the excess ribbon and tuck it in. This video will benefit those viewers who a...
In this tutorial, we learn how to do a Konad zebra nail design in 5 minutes. You will need: Konad white nail polish, stamper, zebra stamp, and scraper plate. First, place white nail polish onto the zebra stamp until it's all over the stencil. Then, use the scraper to remove the excess nail polish. Now, stamp the stamper onto the stencil and then stamp it onto your nail. You can clean up the excess white nail polish with nail polish remover on top of a Q-Tip. Before you begin this, you will wa...
This video demonstrates how to matte down your pointe shoes for a recital or performance. For this, you will need a makeup brush and a container of translucent loose face powder. You may cut the powder in half, adding baby powder to it. This will lighten the powder a bit.
Creativity Prompt demonstrates how to make a hybrid board book. First, select printed paper of your choosing. Cut off the excess paper with a cutting blade and crease the paper for the spine. Fold and burnish the paper. Apply a generous glue stick layer to a recycled board book and adhere the paper to it. Burnish the paper with a brayer to strengthen the adhesion. Let the glue dry and trim off the excess paper. Cut the rest of the paper for the board book pages. Cut out photos and titles for ...
How to spackle a crack or a hole
To throw a clay pottery fruit bowl, place a lump of clay on the potter's wheel and wet it with water. Use the foot pedals to spin the wheel while shaping the clay with your hands. Draw the clay up and then use your thumbs to create an indentation in the center of the clay. Apply slight pressure and the clay should assume a bowl form. Use water as necessary to create the right clay consistency. Draw the clay up to make the bowl walls thin. While shaping the bowl walls with one hand, create a r...
How to caulk the baseboards in your home
This video is a must-see for all those freshman pledges headed to toga parties down on fraternity row. Or better yet, the girlfriends that are dressing those guys! She begins by wrapping the sheet around the back of the male model. One end is at the chest while the other end is wrapped over the opposing shoulder after making the entire loop around his body. She pins one corner at the left shoulder blade, pulling the loose excess to the back. She pulls the other corner underneath his arm and t...
In this video, Betty shows you how to make southern oven-fried chicken breast. She starts out with two pounds of chicken by cutting each breast in half and removing any excess fat. Next, she sprinkles meat tenderizer on each breast and dredges it in flour. After coating each chicken breast in flour, it is lightly fried in a frying pan on the stove and sprinkled with some black pepper. When the chicken breasts turned golden brown, the pan should be removed from the stove and placed into a pre-...
Fish & chips is the most popular fish meal in the country, & you can make it yourself instead of paying a fortune at your local fish eatery. The special ingredient for these fish and chips… beer.
Have some spare time and looking to pick up a new skill? Learn how to paint with watercolors in this tutorial. Watercolor painting is a great medium for all skill levels.
Looking for an easy way to share big files over the Internet without having to pay for the privilege? With the right Internet services, it's easy. This home computing how-to from the folks at CNET TV presents an overview of a number of the better and most popular file sharing websites, some of which will permit you to upload files in excess of 1 GB. For more information, and to get started sharing your own big files over the web, watch this free video tutorial.
Want to replicate that cool effect when you can watch Christmas lights flash in time to music? It's easy! You'll need a set of speakers, an outlet adapter, excess power cord, a solid state relay and, of course, Christmas lights! Once you've gotten all your project pieces assembled, follow this tutorial so you can wire them up to your music.
In this clip, learn how to alter your vinnegarette so that it is not as greasy and heavy. Average dressings contain a lot of excess oil and in this quick tip from CHOW you will learn how to be healthier by cutting some out.
Video Joe Knows demonstrates how to install an inside corner ceiling patch when installing drywall. First, give the paper tape a definitive crease. Then, wipe quick set on the ceiling and the wall. Make sure you get enough material behind the paper tape. Have more quick set on than you need because you can wipe off the excess. Build it up on the edges using a three or four inch knife. Next, apply the tape by pushing it into the corners of the desired area. Finally, wipe off the excess quick s...
Create dramatic mask like look makeup using red, white and black color, inspired by the pantomime. Use toner to remove excess oil/grease from the face. Cover up the entire face with clown white grease paint, set the paint with white eyeshadow. Paint the outline of your face using a thick paint brush using black cake eyeliner. Remove any excess white paint outside the black line using makeup wipes. Powder eyes with white matte eyeshadow, then blend in black eyeshadow to create smoky eyes. Use ...
Bollywood dance is any dance from an Indian film. These dances have traditional Indian influences mixed with hip hop moves. Bollywood dancing is a fun way to get a great workout. Learn the easy dance steps and burn off some excess calories at the same time with this how to video.
Watch this video and learn how to make your makeup last longer by simply removing any excess oil off your skin.
During the winter and freak weather events in spring and fall your garden can take a beating from frost and excess cold. Watch this video to learn how you can protect your plants and flowers during the cold so they are healthy and ready to grow when the weather improves.
If you've recently purchased a new fridge and have hooked up the line for the water dispenser, you need to get rid of any air before trying to drink water. Having excess air in the line can result in you getting more water than you may have wanted. It's easy to do and will make things easier when trying to get water. So good luck and enjoy!
Have a bunch of apps crowding your iPod Touch or iPhone? Get rid of the excess with help from this video. In this tutorial, learn how to move and delete apps on an iPod Touch or iPhone in just a few easy steps!
Have an excess of small things and no place to put them? Learn to make the most utile of origami sculptures, the paper box. This video tutorial presents a complete, step-by-step overview of how to make a paper box using origami, the traditional Japanese folk art of paper folding. For more information, and to get started making your own paper cubes, watch this arts-and-crafts guide.
Princess Pink Cat demonstrates how to use Vaseline to apply pigments and hold them into place. Dip a finger into the jar, spread the tiniest amount possible across the lid. You can go all the way to the brow bone or just to the crease. Wipe the excess Vaseline off to avoid creasing. The remaining Vaseline will make your pigment colors pop by gripping the pigments to the skin.
Acne develops when pores become blocked with dead skin cells and oil. They usually disappear over time but sometimes they leave a scar. When those blemishes form white blood cells rush to the surface to help heal the area. But occasionally a scar forms. Popping and picking can send bacteria further into the skin and increase the blemish and it greatly increases the likelihood that a scar will appear. Nodules and cysts are more severe blemishes and have an increased likelihood of leaving scars...
Dogs need occasional bathing to clean off excess dirt, and even to inspect general health. This how-to video demonstrates the simple steps to safely washing a dog. Learn how to bathe a dog by watching this video pet and animal care tutorial.
If you are a dedicated model maker, watch this instructional video to make a handy tool for sculpting and working with miniatures. These homemade wood tools are good for a variety of purposes. It can be made from wood as small as match stick stock up to 1/2'' by 1'' stock. Use this wood tool for modeling clay, greenery or spreading glue plaster and wiping off the excess.
Watch this instructional fashion design video that teaches you how to turn your regular or baggy jeans into skinny jeans. Just follow these easy steps: put on the jeans inside out, pin them, sow along the pins, cut off the excess fabric, turn it right side out again,
This video tutorial is on how to make one' favorite superheroes with playdough. This video tutorial is especially for kids and everyone that loves playing with playdough.