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...
Long exposure photography has long allowed photographers to do amazing things with light. Now you can do that! This video will show you how to use a long exposure, sparklers, and Photoshop to create amazing psychedelic art on your photographs. This new art form is called light painting or light writing, looks amazing, and is pretty easy to get started doing. Do it!
The Roland TR-808 drum machine is one of the most important modern instruments, forming the backbone of both hip-hop and electronic music percussion. If you have gotten your hands on one, you're a lucky devil, but you have a long way to go before you can unlock it's true potential. Watch this video to learn how to program an 808 all the way up to a 64-step beat!
Light painting (or light writing) is a relatively new art form combining flashlights and long camera exposures to create amazing still images with designs literally drawn on them in light. This video features an experienced light painter teaching you the basics of the at in only 2 minutes! He covers what you will need, how to use it, and demonstrates the painting of a simple happy face. Now get out there and try it yourself!
Are you an avid runner who's jogged almost every day since your twenties but have found recently that you just can't run as long, or that you start to feel pain more easily? Then check out this running video for a helpful series of technique drills that will help you strengthen your muscles and correct your form.
You've got style. You've got class. You've got... No reason to still be wearing a clip-on. Show off your suave side with a perfectly knotted tie. Watch this video to learn how to tie a bow tie.
Ask any major artist in any time period about the beauty of the female form, and we bet they could go on talking forever. Idealized and revered for as long as time itself (remember the Venus fo Willendorf?), female bodies and their lithe, undulating curves make for great painting subjects and have definitely gotten a good deal of male students interested in art.
Kick up your look by adding dresses you make yourself to your wardrobe. It's simple to create a patter and sew a dress that will fit your exact measurements. You'll be amazed at the differene of having a drees you made yourself makes.
Samsung's next Galaxy Note smartphone is expected to contain some nifty new additions that the company hopes will give it the long desired edge it has been seeking over Apple. One of those features that might make the difference? An iris scanner, which could make it the first major smartphone on the market to have that technology included.
We're not going to lie to you: Creating pottery is a long, arduous, and intense process. But After you throw your charger, come back to reshape offset parts, fire the charger, and then glaze it, you have yourself a homemade work of art you will treasure for a lifetime. In other words, all the hard work you put into pottery is worth it!
Sunflowers possess bright, cheery yellow petals, robust center filled with yummy treats, and long stems that form a maze when many are planted together. They remind us of hot summer days and the lightheartedness of the season.
There's nothing like a delicious chuck roast during a long day at work. But if you're interested in making it in a different form, this may be what you need. In this video tutorial, you'll find out how to can chuck roast with brown gravy using jars and a canner. So check it out, get the materials ready, adn good luck!
Bonsai is an art form that requires patience and a good eye. It's a relaxing hobby that anybody can take up, just as long as they are willing to learn a few things. This tutorial is a beginner video for those who are interested in bonsai. This video will focus on styling a larch tree. So sit back and enjoy!
In this video we learn how to make a puff-pastry cornucopia. This is a great centerpiece for Thanksgiving and can be used to hold different foods such as buiscuts or finger sandwiches. First we need to form the mold for the cornucopia. You take some tin foil and make about 13-16 balls. These are spacers for inside the mold. Then you cut a piece of tin foil about 30" long. You place your balls in the middle and wrap your foil up over. Start to form your cornucopia the way you like. Try to make...
Makeup brushes accumulate a lot of bacteria and dirt. Keeping your makeup brushes clean should be an important part of your makeup routine. And it doesn't have to take very long. Julieg713 has some great advice on how to deep clean your makeup brushes efficiently. Deep cleaning makeup brushes is recommended at least once a month to keep your brushes in top form and bacteria-free.
Hand spinners who want to master long-draw drafting for woolen spinning need their fibers in a special form: carded rolags. Combed fiber won't do it -- neither will carded batts. This introduction shows you how to make carded rolags. Start by washing your fleece....
Want to see your book in print? Going the route of agents and sending your manuscript off for publication is a long grueling process that may not even pan out. If you're not looking to get famous and you're just looking to get your book in tangible form, take a look at this instructional video and learn how to self publish your own book.
Learn how to stop a skin forming on sauces, gravy or custard, no matter how long they wait in the pan with a cartouche.
To create an apostolic or pentecostal hairstyle, start with a poof in the front of the hair. It can be ratted behind for stability. Use two bobby pins to secure the back corner of the poof. Squirt the hair with hairspray before moving on. Then create a low ponytail in the back of the hair, pulling the top up and out slightly while forming the ponytail so it creates another poof in the back of the head. Spray the ponytail with hairspray then smooth out the hair on the top of the ponytail. Wrap...
If you're into arts and crafts then you know that there is more that you can do with a long piece of string than just tie your shoes. On this TyingitAllTogether video you have the opportunity to tie the teacup decorative knot using one long piece of string folded in half. The author of the video first shows you what the end product will look like then methodically begins to walk you through setting up the string in Y-configuration to "crossing each bights crook" which involves overlapping and...
In this how-to video, you will learn how to create a hairy clay figure. You will need to mix basic clay to do this. Rub the clay into a ball and then shape it into the body of the creature. Do not work the clay for too long, as it will harden faster. Use matches to form the eyes. Once the form is complete, move on to the hair. Use a different color clay for a great visual effect. Make the clay into long strings. Once they are done, cut them with a clay knife to form small dots. Rub these dots...
Place you tie around your neck. Make one side longer and one side shorter. Then you will criss-cross the two sides of the tie, with the longer end being placed over the short end. Take the long end and loop it around the shorter end. Then you will take the longer end and bring it through the little loop that you have already formed by looping the end around. This will give you the ascot. To do a scrunchy tie, take the ends and pull them through the loop that has formed, and then you will have...
This video demonstrates how to make a balloon sword and heart. To make a sword, pump up a balloon as long as possible and tie the end. Twist the balloon at this end making a small ball. Bend the balloon at around 20 cms in length and twist both the ends of the balloon at the same level as the ball creating a loop. This is named the 'elephant bend'. Now insert the long end of the balloon into the loop leaving behind a small part. Your sword is ready.To make a Heart flower. Take a red balloon a...
In this video the instructor gives you sample as of how to SLEP long multiplication. You start by breaking the numbers up to simpler forms. If you have a two digit number that your multiplying by a another two digit number you multiply the first two digit number and then buy the second digit of the second two digit number. You have to remember to carry the remainders. You then add your two multiplicative lines together giving you the sum. this can be done to cover any set of multi-digit numbe...
Origami isn't just folding paper, it's a form of art. So, if you want to try a new creative way to express yourself, and if you like birds, try out this tutorial on folding an origami paper swan.
During my early elementary school years, origami was my go-to pastime. When it came to learning about it in art class, I ventured out well past the basics that were being taught.
Light painting or light writing is one of the coolest of the coolest multimedia arts. It consists of setting a camera for a very long exposure in a dark area, then moving light sources around in front of the camera. When the aperture finally closes, you will have a photo where the light is preserved everywhere it was. Basically, you've drawn on a photo with light. How cool is that? This video will show you how to do it quickly and easily, allowing you and your friends to enjoy this exciting n...
This is an instructional video that demonstrates how to make an origami spinning top. You need seven square pieces of paper, and she uses 6"x6" sheets. First fold the paper diagonally. Fold the short edges to meet the long edge. Unfold it and use that as a guide for the next fold. Fold the top triangles down and tuck on corner into the pocket. Make seven exactly the same. She shows how to slide one folded piece of paper into the next one and fold the edges over each other to hold them togethe...
This video shows you how to make a fishing spear for catching fish or small wildlife in survival situation.To start, you need a sapling about 5 feet long and a knife. Make a raw sharpening of the stick. Then split the log at the tip for a length of 6-8 inches. To split, put the knife on the middle of the sapling, near the tip, and press hard against it. Once it is split, find a twig with the width of a pencil and push it inside the split, making the two halves of the stick form a gap between ...
Chris Giorni, Mr. Science with Tree Frog Treks, demonstrates how to make simulated frog skin. To make the simulated frog skin, you will need glue, water, borax laundry powder and food coloring. First, add a pinch of the powdered borax to water and dye it green using the food coloring. Next, water down the glue and place it on a plate. Add the borax solution to the plate. Mix the compound with your fingers. It will quickly form a long chain polymer or sticky frog skin. Frogs breathe through th...
In elementary school, we all experienced the wonders of papier mâché, that wonderfully malleable mixture of paper and glue (or maybe paper, flour, and water). Once it hardens, it's a homemade work of art. And homemade papier mâché is art on the cheap, allowing your imagination to soar without breaking your budget.
Use geometry to make an adorable and fun heel klickin' friend using McCormick vertex elements! You will need:
Adobe is best known for its photo and video editing software, but they also have a number of lesser-known apps that you may be interested in. Adobe Fill & Sign, available on iPhone and Android, is the best way to electronically fill out important documents on your smartphone with a third-party app.
Buns make the look of a woman highly fashionable and cool. Transform your appearance into highly swanky and dashing by following this simple tutorial to make an awesome Long Hair Messy Bun and instantly transform your simple look into a fashionable one. Step 1: Comb Your Hair and Make a High Pony. Now Take Small Section of Hair from the Pony and Start Backcombing the Surface Side. Step 2: Now with Your Fingers
An iconic image of the punk subculture, liberty spikes are well worth the effort needed to achieve this dramatic look.
If you want to submit information to a user, you build a website; if you want to receive information from that user, you use a web form. As such, it's crucial that your web forms be well designed. One easy way to design web forms is with CoffeeCup's Web Form Builder.
Free-form teapots are irregular in shape and made by being thrown and assembled. Learn how to make a free-form teapot with tips from a master potter in this free ceramics video series.
You Will Need * A fire extinguisher
This CoffeeCup Web Form Builder software tutorial shows how to create a MySQL database to be used in CoffeeCup Form Builder to build web forms. Mike Lively shows you how to do this using cPanel and the Site Ground server for hosting since it allows an unlimited number of MySQL databases. Start by creating your database in cPanel and then upload the results to CoffeeCup Form Builder.
The newest trend in couture? It's called 'trashion' - high fashion using trashy things. And we mean trashy! This tutorial shows you how to make a ball gown using trash bags, duct tape and newspapers. You'll also want a dressmaker's dummy to construct your dress around - or at least a model who's okay with standing still for a long period of time. Use the trash bags to form the dress, and then attack the newspapers over it layer by layer. You're ready for your debut!
