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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
Want to test whether the soil sample or a water sample contains boron, watch this video. As shown in the video, the first step is to create test specimens of various concentrations using a simple turmeric and ethanol solution as a base for comparison. The basis of this experiment is the fact that curumin present in turmeric reacts with boron to form a reddish compound and so the result of this reaction can easily be verified visually.
Watch this video to learn how to make a balloon elephant. This tutorial will teach you a vary simple animal design thats great for beginners. This is another balloon animal that is based off the dog design.
Here's the secret to making a perfect pie crust for your holiday desserts. You can fill this crust with all sorts of fruits, nuts and filling. This recipes requires a pastry blender and uses shortening. Water varied based on the humidity of the kitchen.
This video gives a brief description of how to prepare and cook baby artichokes. Baby artichokes vary in size based on the season, may being the best month to get them. To avoid getting a bitter flavor from your artichokes be sure to remove the skin, this is best accomplishes by brushing,rinsing, peeling, and cutting all of the green outer layer until you can see the pale yellow inside. To preserve the color of your allow them to sit in lemon or vinegar water and drain completely when done. C...
How to keep your pansies healthy year round
This is a series of videos on wingsuit flying techniques, varying from basic flocking maneuvers to advanced aerobatics. Wingsuit flying is a type of skydiving or controlled falling, and on thing you'll learn in this series is that upfloating is the technique of raising your legs to deflect the wind and rise upward. Also learn how to barrel roll, front loop, backfly, dock, increase forward speed, and control speed.
Don't let the TV ads convince you to buy some bulky contraption that will gather dust in your closet, crunches are safe and effective! This how-to video shows how to do crunches with varying degrees of difficulty based on your ability. Remember that ab exercises alone will not give you abs! If you have the best abs in the world they will be completely invisible if you are overweight. Aerobic exercise and proper diet are even more important than ab exercises in getting that sought after 6-pack...
The Knit Witch shows you how to do wet blocking to a knitted piece. With specific tools like a blocking board with a grid, a tape measure, and a few other items. The items used can vary based on what kinds of material you are using so it's important to know what each one needs. Reminders and tips are explained when the pertinent step is reached so that you can keep them in order and apply them when needed. Wet blocking will be a breeze after watching this video and following the steps closely.
In this five-part tutorial, learn how to make the perfect pizza crust with chef, Mark Gill, the executive chef at Little Creatures Fremantle WA. In each of these five short & informative videos learn how to start by mixing the ingredients by hand, how to knead the dough, shape the dough balls then pizza base, and finally, how to toss the pizza like the professionals! Make the perfect pizza dough for your pizza from today forward!
Leah for May Arts Ribbon shows how to make a flower loop bow. The following items are needed for it: Needle and thread, scissors, May Art Ribbons and a ruler. Buttons or flowers may also be needed to put on top of your bow as per your selection.
Following are the steps to describe how-to make small decorative bowls using polymer clay at your home:
This video from Betty's Kitchen demonstrates a step-by-step recipe for chili cheese fries. She uses frozen French fries and cooks them in peanut oil on the stove top. After the fries are cooked, she puts them into a 9 x 13 casserole dish. She tops the fries with canned chili that has been heated on the stove top and emphasizes that the recipe can be varied based on your personal taste. She sprinkles shredded cheddar cheese over the hot chili and then bakes it in the oven at 400 degrees for fi...
Add music content to your website! If you want to add a scrollable, clickable playist to your Flash-based website (like to show off your band's music), this tutorial shows you a step by step process to building this interactive .mp3 player using Adobe Flash CS3 and Action Script
This tutorial is for anyone who wants to create their own Flash-based website, even those with little to no coding experience. You're shown how to incorporate animations, loader bars, and other interactive content into your website; as well as how to manage it all from the admin side.
Code your Flash-based website so that your content can remain the same, no matter if visitors are viewing your site on a computer screen, smartphone display or even a high-definition TV. This tutorial shows how you can code your fluid website to achieve the true fit effect.
While you cannot directly open a Microsoft Access database file in OpenOffice Base, it is possible to connect Base to an Access database, and manipulate the data contained within it.
Databases allow you to store data in a systematic and organized format, making it easy for you to search, sort and edit.
United States Womens Softball Team members discuss and illustrate how to run the bases correctly. The main techniques used are how to lead off then steal each base as the technique is different for each one, and perform the hit and run. The breakdown is great!
Rum is no ordinary liquor. If you have a yearning for some rum, you need to know the basics of rum culture, like what rum is (and isn't), what kind of rums are available, and how is rum made. Once you know this information, you'll be a rum master. Rum is available in a wide variety of weights, ages, and blends. If you aspire to become a connoisseur of fine rums, start with the basics.
Watch this five part instructional video series to experiment with base coats on your Warhammer miniatures. Using thin coats of paint and small brushes, leave a wider margin for experimentation and highlight coats. The rich and impressive detailing on Warhammer figurines comes with patience and perseverance. Warhammer miniatures need several layers of primer and original fill color for a deep base coat.
This is a video tutorial in the Education category where you are going to learn how to draw an isosceles trapezoid. This video demonstrates how to draw an isosceles trapezoid with a long base (B), a short base (b) and a 35 degree angle. First you draw the long base. Now center the short base at the center point of the long base and mark the end points of the short base with dots. Next draw perpendicular dotted lines from the dots extending upwards. Draw 35 degree angles from either end of the...
A rough definition of standard deviation is that it is a measure of expressing the observed variations about the average in statistical data i.e. by how much do the observed values vary from the mean. This video continues from the previous solved example and demonstrates the mathematical interpretation of the standard deviation that was calculated. We begin with stating the mean and standard deviation values and then calculating the upper and lower bounds of the data based on the standard dev...
HTPC. It stands for Home Theater PC. Some refer to it as simply a Media Center. But no matter what you call it, you're going to learn how to build one today. Why would you want to do that? Because one of the main advantages of creating your own home theater system is that you are control, not only of the cost, but the features and functions, as well.
In this tripartite video tutorial, you'll learn how to create image-based lighting and depth-of-field effects within C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
Learn how to make an origami "orchid" by slightly altering an origami iris / lily flower. This origami video shows how to make what I call an orchid flower... really it's something I made by mistake when first learning to make an origami lily / iris. You'll need to start from the frog base.
If you play Elder Dragon Highlander, the awesome Magic: The Gathering variant, check out this video for a guide to building a cat-based deck that will ravage people. Cat attack! If you haven't played EDH, check out the link above and come back.
This video is about deriving the area of a circle of radius 'r' using polar co-ordinate. First, we draw a circle and its radius 'r'. Then draw another radius close to it, so that it forms a small triangle-like figure. To find the area of the complete circle, divide the circle into similar small triangles. The area of each triangle is given by half the product of its perpendicular and the base. We give the angle between the two radii as d?. We get the area of the small triangle by substituting...
In this video tutorial the instructor shows how to solve exponential and logarithmic equations. Solving exponential equations can become very difficult if it involves large numbers. To solve these kinds of complex equations you need to get all the numbers to the same base number. The base number raised to some number should give you your original number. Now if you write the numbers as exponents of your base number you can directly equate the exponent part and solve for the missing variable. ...
This tutorial video shows how to make an origami bird base. As you might guess from the name, the bird base is used when making the traditional origami crane; however, it can be used as a starting point for other origami patterns as well, so it's good to learn how to make this fold. Follow these steps to learn how to fold an origami bird base.
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
In this four-part video tutorial series, you'll learn how to compile a Linux kernel on a Debian-based system (e.g., Ubuntu). You'll learn two separate methods for kernel compilation, both (1) how to make the kernel into a Debian package, which can be handy if you're using a package manager and (2) how to install the kernel manually with make and make install. Take a look!
A really beautifully painted Warhammer miniature mounted on a stock base is like Christina Hendrix at the Emmy's, but with trash bags wrapped around her feet instead of shoes. It cheapens your work. This video will show you how to make really cool miniature bases out of cork board and a hot glue gun.
Mix the Brandy Alexander, the Pink Squirrel or the Grasshopper! Each cocktail uses creme de cacao and whipping cream. The Brandy Alexander cocktail uses a brandy base, the Pink Squirrel uses an almond liqour base, and the Grasshoper uses green creme de menthe base. All are shaken with ice and strained into a martini glass. Perfect after dinner cocktails and very easy to make!
In this Achievement Hunter guide to unlocking PS3 trophies in Resistance 3, the guys walk us through how to unlock 'Grenadier', 'Access Denied', and 'Cheap Shots.' It may take a few tries to earn the Access Denied trophy because the shields are time based instead of damage based, but if you're in an area with enough enemies you can get it after a few attempts.
Who doesn't want their own dragon or two? Well, this clear, step-by-step turorial shows you how to fold two different versions, using the standard origami bird base. This craft requires one piece of paper, your hands, some patience and no fear of dragons!
With the TSA's full-body scanners occupying a great deal of airports nationwide, the debate remains as to whether air travelers should continue to be subject to immoral security techniques and possible health risks due to the x-ray scanning devices. The "advanced imaging technology" may help keep obvious weapons out of major airports, but scanning naked bodies seems more voyeuristic than crucial to national security. But while the argument continues, one woman is taking a stand… well, not rea...
In this video, we learn how to find the surface area of a prism using a specific example. First you will need to find the base and height of your prism. If the base edge is 6 and the height is 8 you will do the equation Area= 1/2 bh. Doing this math out on your calculator, you will get the answer of 12.39. This is what the size of each triangle in the prism is going to be. The area of one pentagon (or the base) is 61.92 inches squared. If you need help with this, you can try drawing the pictu...
A pyramid is a three dimensional figure with the base in the form of a triangle and three slant sides to it. To find the surface area of a pyramid you have to find the area of the different pieces that make it up. The pyramid base can be triangle or even other geometric figure like pentagon. So first draw the base of the pyramid separately and compute its area first. Now compute the area of each sides separately. The area of each side can be same if the pyramid is a regular pyramid. Some time...
This video in the Education category will show you how to use a protractor to measure an angle. This video is from Brightstorm. In Geometry it is important to know how to measure an angle. This is a very simple and easy process. In order to measure an angle, you will need a protractor. Every protractor has a base and a center point marked on the base. You will put the center point on the vertex of the angle. Then align the base line of the protractor perfectly on one side of the angle. Now ch...
