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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
Need a little help in your Statistics class? In this statistics tutorial hosted by The Free Math Tutor, a demonstration of how to use the Sharp EL531W calculator to find the correlation coefficient (r-value) and the equation of a regression line is given. Want some more practice? For exercises and answer sheets, go here.
There are different techniques to apply the glue on the latex sheeting, none of them is right or wrong. All that matters is what works best for you. This latex tip is helpful for making fetish clothing or latex fashion pieces. Latex clothing is integral to fetish clothing and used frequently in BDSM or S&M sex.
What’s a more sensual dessert than chocolate-covered strawberries? Learn how to make chocolate covered strawberries for your next date.
There’s nothing quite like a thick slab of Irish soda bread slathered with butter—be it St. Patrick’s Day or just any old day.
Folding a paper ninja star is like riding a bike - once you learn how, you'll never forget. Watch this video to learn how to make a paper ninja star, also known as a shuriken. All you need is one 8.5 by 11 sheet of paper to make your own ninja star.
The horror! This video shows how to make a white candle bleed red wax by using a microwave?! You need a cookie sheet, box cutter, soy wax, wax paper, and a microwave.
With just a few things from around the house, you can turn your bedroom into a fortress! Learn how to build a fort in your bedroom for your next sleepover. Forts are fun & materials needed are easy. You will need:
Watch this instructional origami video to fold an origami samurai helmet. Kabuto is the Japanese word for the traditional Samurai helmet. You will need one sheet of newspaper to fold an origami hat big enough to wear.
This Houdini 9 CHOPS lesson shows one aspect of the usefulness of the Channel Operator editor. In this case we extract a curve from a geometry surface and use that curve to animate a ball moving across the surface. To learn more about animating with chops in Houdini 9, check out this tutorial.
This is an instructional video on how to fold an origami Butterfly. Origami is the Japanese traditional art of paper folding to make just about any shape. All you need is a square sheet of paper. Watch this video origami tutorial and learn how to fold a paper butterfly.
The rocket stove, invented by Dr. Larry Winiarski, was developed to require much less cooking fuel than a traditional stove. The rocket stove also emits less dangerously, as most of the energy burned turns into heat. To build this rocket stove, you will need sheet metal or a 5 litre metal can, clay, water, sawdust, a wooden mold, a clay brick, vermiculite or perlite, and cement. Learn how to build a rocket stove by watching this video tutorial.
This video tutorial show how to make a scaled octahedron. Modular origami varies from regular origami in that it uses multiple sheets of paper to fold instead of just one. Learn how to fold this scaled modular origami octahedron by watching this instructional video.
Never again will changing your duvet comforter be a chore--use this quick trick, and bed sheet changing will be a blast. See how to put easily put on your fresh duvet cover.
This is a Cascading Style Sheet (CSS) Tutorial that will help you position an image using a Div layer.
Learn how to animated sprites from a sprite sheet for creating video games or video game-style cartoons using Flash.
Using a computer screen and a sheet of glass you too can create a hologram! As this video shows, simply use the correct monitor (depending on what you want to do) and a piece of glass positioned appropriately to create the holographic image.
Bob Fenwick shows us how to add a vent to the existing heating and A/C system of your home.This can be accomplished with a few sheet metal parts from your local home improvement center.
Who would have thought that dryer sheets can be a quick remedy for super-staticky flyaway hair? But it's true. It's all about the positive charges in the sheets and their ability to neutralize electron buildup. And that's not the only surprising quick fix for hair problems that you can easily find in your home.
In this Computers & Programming video tutorial you will learn how to get widescreen videos on YouTube from normal videos. This can be done in Sony Vegas Movie Studio. Go to project > properties > video. Here you set the template width to 640, height 360, frame rate 30, field order as none, pixel aspect ratio to square, full resolution rendering quality to good and deinterlace method to blend fields. Next you save this template for future use and click apply. One of the quickest ways of conver...
Tired of cleaning the stove and oven every time you cook? (It always gets so messy, doesn't it?) Well, there's one solution to keep the cleanup to a minimum, albeit a little unconventional, and that is to use your dishwasher!
In this video Sarah Magid shows how to make dark chocolate cupcakes with espresso butter cream along with sugar flowers as follows:
For a fun novelty project, try making a zoetrope at home. * A plastic coffee can lid
If you need to know how to make an arrangement on an acoustic solo fingerstyle guitar, you've come to the right video tutorials. This three-part instructional guitar lesson will show you want you need to know about arranging.
BlackBerry has formally announced the arrival of its flagship, the KeyOne, during Mobile World Congress 2017 in Barcelona. The all-Android KeyOne looks distinctly BlackBerry, with its 4.5" screen and physical QWERTY keyboard. Here's the lowdown on this elegant handset that hearkens back to BlackBerry's heyday, which had previously been known by its code name, the BlackBerry Mercury. Aluminum Unibody with Physical Keyboard
At this point, you probably think that you've read everything there is to read about different ways to prepare eggs. There are the usual ways (scrambled, soft-boiled, hard-boiled/steamed/baked, sunny-side up, poached, the "overs") and the more unusual ways (in clouds, crispy poached, deviled, golden hard-boiled), but this way tops them all.
Take to the skies with this incredible realistic paper jet. With just a sheet of paper you can create an awesome flying machine. Fly it indoors or out, and enjoy an aerodynamic wonder after you've learned how to fold the most realistic paper jet ever.
Want to film underwater, but can't afford the expensive professional camera rig? This tutorial shows you how you can construct your own functional underwater camera rig for about sixty dollars. You will need: small ankle weights, threaded seal tape, waterproof sealant, Velcro, a rubber washer, a sheet of plexiglass, PVC pieces, metal ring clamps, hot glue and a dremel.
You don't need to buy an expensive ring light, you can make your own at home. You'll need a sheet of sturdy plywood, a pencil, some string, a dimmer switch, the light bulb sockets, some electrical wire, a drill and some hardware.
Sure, it's tiny, but it can still fly farther than many larger paper airplanes! This tutorial shows you how to make the world's smallest paper airplane out of some plain white paper and pair of scissors. You can get four airplanes out of one sheet of paper.
You can also use this as a method to make some easy gift boxes! All you need are three sheets of plain paper, some scotch tape, a pair of scissors, a knife and some markers (or your favorite paper decorations).
This tutorial shows you how to make a beautiful green embossed Christmas card, featuring the words 'Christ is Born,' for those who celebrate the religious aspect of Christmas. Make sure you have enough stamping supplies and embossing powder for this project!
Melody Town is full of musical instruments, and you can play them for beads, or navigate sheet music to get stars. This walkthrough shows you how to get through this park of Treat Land, a level in Kirby's Epic Yarn.
You can download Freemind for free from SourceForge.net, which will let you create and customize your own mind maps. These, in turn, you can use to plot a dramatic and exciting crime novel by organizing all the different aspects of the story, such as plot, setting, characters and motive.
This tutorial covers several aspects of using Pro Tools. You'll learn not only how to record an audio track to include in your final project, but also how to record at a specific point and make use of cycle or loop recording.
Sometimes, you want to focus the attention of your viewer on a particular aspect of your image, or get rid of extraneous or distracting details. This retouching tutorial shows you how to use Adobe Photoshop to reduce detail and simplify your selection without losing much meaningful content overall.
Sometimes black bars can appear on videos you have uploaded to YouTube (or any other video sharing website). This can get annoying, and is usually the result of uploading a video whose aspect ratio is not synced up with YouTube. This video shows you a couple fixes to getting rid of those bars.
Print out a black and white image of the Firefox logo, then paste it to some solid sheet metal or thin wood. Then cut out your Firefox shape. Make sure not to cut yourself! Then sand the edges, drill a small hole and run your chain through!
In this clip, you'll learn how to create a vertical nav bar from an unordered list with HTML and CSS (cascading style sheets). For more information, including a complete demonstration, and detailed, step-by-step instructions, as well as to get started creating your own navigation bars, take a look.
In this clip, you'll learn how to swap between CSS styles with PHP cookies. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look
