This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
Xara Xtreme works with 2D image rendering and comes with a number of features to support your tasks. Removing a background in a bitmap can be done with ease. You can either fill the background with a solid color or just delete the space around it. You can also overlap the image and delete the remaining background then finish editing your image. There are a number of ways to remove space in your image and this video will demonstrate how to remove the background from a bitmap in Xara Xtreme.
In this video, the narrator presents the viewer with a quick, painless way of simplifying cube roots. The narrator presents many methods to simplify square roots to appeal to different learning styles. By doing things like dividing the power by the root to figure out the power of a number x, the viewer is better able to tackle square-rooting numbers that may not have friendly roots. The video gets more complex as it goes on, eventually teaching the viewer to split the inside of a root up if t...
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 video Dionne shows how phone calls can be made by PC. There are a number of softwares available in the internet for making phone calls, but the best and the cheapest is Skype. Skype is easy to download and install in your computer. Then you can enter the contacts and their phone numbers. After that you have to buy Skype credits so as to start making calls anywhere in the world. Calling from Skype is so cheap that if you buy a credit of 10 pounds, it will last many days no matter where...
When you are solving inequality for a rational function you don't do it the same way as you would solve an equality. Now the instructor shows how to solve an inequality with the help of an example. Now to solve an inequality which is in the form a/b first take the numerator and denominator as separate equations of two lines. Now graph the two lines on coordinate axes. Using the graphs of the lines plot the intercepts of the equations on the number line noting down the sings. Now you can compa...
To find the slope of a line you must have two points and then you must plug in the two points into the slope formula. The slope formula is m= y2-y1 over x2-x1. If the slope is a fraction be sure to reduce to the lowest. Remember if a number is divided into zero it is zero, if zero is divided into the number it is undefined. A calculator can help one remember this. Horizontal lines have slopes and vertical lines do not. Drawing the lines on a graph can help you see the actual slopes and which ...
Crochet the half-double stitch with these easy steps and achieve that beautiful design you've been longing for. Insert your crochet hook to the two loops found at the end of your cross stitch. Yarn over your stitch and make three loops wrapped around the crochet hook. Always count the number of stitches that you do and continue step number 2 to the rest of the yarn. Skip the first loop at the end of every row and insert your hook on the second loop. repeat the process until your desired desig...
Need a little help in understanding the number line and graphing an inequality? Great! Here you will learn a valuable lesson with this how to do video. A basic tutorial, it explains what kind of dot to use when you are graphing inequalities. Then it shows you how to place the dot on the line and where to draw the line in answer to the problem. If you are just beginning your pre-algebra, then this quick video will get you pointed in the right direction.
In this simple tutorial the tutor shows how to solve equation by the distributive property. He states that when there is a number which is multiplied to a full equation, we have to multiply each and every term of that equation by that multiplying number. This is called the distributive property as the value is distributed to each and every term inside the equation. He goes on and solves a problem based on this property to give a clear idea of the property. This video shows how to solve equati...
A simple video showing how to subtract fractions with common denominators. The denominators is the bottom number of a fraction and the numerator is the top number. So in the fraction of one half 1 is the numerator and 2 is the denominator. If you have fractions with same denominator you can subtract the numerators to find the difference. After the subtracting the numerators add the common denominator to complete the fraction. So five sevenths subtracted by one seventh equals four sevenths. If...
For more advanced math, you will need to use the difference of squares in order to factor certain polynomials. This video offers the basic technique for this factoring method as well as a few examples to get you started. In order for this factoring technique to work, you will need two numbers which are squares and are being subtracted from each other. The two factors will be the original numbers added to each other as well as subtracted from one another. This fast and simple factoring method ...
Learn how to use Excel stylistic and number formatting by watching this video. You'll learn how to format a cell. These have different types of formats like general, time, date, etc. You'll also learn how to create a table. There are different types like names, values, time and time etc. Learn to create names like employee name and fill in the borders, and create thick lines. Watch this video for more information!
This how-to video explains about how to add fractions with uncommon denominators. To add fractions with uncommon denominators three steps are involved:
Software expert David Steinlage guides the viewer through the step-by-step process of installing VMware and Windows XP on a computer driven by Ubuntu Linux. The first step is to get a serial number, which can be obtained free by visiting the site www.vmware.com and filling out the registration form. The VMware installer application Automatix is then opened and upon clicking the desired options, the installation of VMware starts automatically. At the end of installation, the user is prompted t...
Watch this video to learn how to multiply fractions by fractions. First multiply the top numbers together. For example, if you have 3/5 * 4/7, multiply 3 * 4 and put your product on top of the fraction you will get as a product. Next, multiply the bottom numbers together and put them on the bottom of your resulting fraction. Next see if you can reduce your product to simplify it. You could also do the reducing step first by canceling out any common factors in the numerators and denominators o...
In this tutorial the instructor explains the percentile formula. He says that the percentile formula is used to find the percentile rank of a data point in a group of data. He takes an example that consists of the lengths of puppies. Now he intends to find out the percentile rank of any puppy in the group. He shows that the formulate to compute a percentile rank of a particular puppy is rank R = 100 * (N< + (1/2)N= )/ Nt, where N< is the number of puppies whose length is less that the length ...
The video teaches the viewer to divide one fraction by another. The process involves taking the reciprocal of the second fraction (flipping it upside down); so if you want to divide 7/3 by 1/2, you flip 1/2: it becomes 2/1. Then it is a multiplication problem: 7/3 x 2/1. The way to multiply two fractions is to multiply the top numbers (here, 7 x 2) over the bottom numbers (here, 3 x 1). So the product of 7/3 x 2/1 is 14/3.
This is a tutorial on the basics of dividing fractions. The process the video teaches are linear equations where one fraction is divided next to another with a division sign in between. The top numbers are divided and then the bottom and thereby you get the answer. However not all numbers are divisible. When this happens the video teaches the method of multiplicative inverse whereby the divider fraction is flipped upside down which then changes the problem to one of multiplication--think of t...
In this tutorial the instructor discusses about the numeric coefficients that we come across while we work with polynomials. He goes on to discuss the numerical coefficient of a monomial stating that it is the number that is present before the variable in the monomial. He states that the numerical coefficient can also be negative or if there is no number present in front of the variable, it indicates that the numerical coefficient is one. This video helps in understanding what the numerical c...
This video will show you how to carry out multiplication of fractions using cancellation, which will make your fraction multiplication problems simpler to solve. You will need to look at the numerator of the first fraction and the denominator of the second fraction and see if you can find a common factor between the two numbers. If one does exist, you can simply divide both numbers by that common factor and simplify. Repeat this for the other numerator and denominator and if possible, your fr...
In this video the tutor explains about the standard error of the mean. He starts explaining by drawing the diagram of a distribution and now he takes ten samples from the distribution and starts plotting them. He says that in theory if we do it infinite times then we can obtain the sampling distribution of the sampling mean. For the example he takes the number of samples as 10. Now depending on these values of n we can get different sampling distributions. Now he intends to find the mean of t...
This video is about the mathematical calculation to convert decimal to percentages. In this video, step by step calculations are shown. Let us take an example of a number; say 0.345, and we want to convert this decimal number to a percentage. Then we have to shift the decimal to two places to right side. We then get the answer in percentage but don't forget to put the sign at last. This video has made it easier for me to make my children understand about the decimals and percentages.
This video teaches you how to convert fraction to decimals in three easy steps. The process of decimal to fraction conversion involves the use of the fundamental rule of fractions; the fraction should be written in its lowest terms.
You want to use the websites you want to use, regardless of any school blocks or other hindrances, so how? This video tells us by using the IP addresses of your favorite sites. To find this IP address, at your home, or an other unblocked location, in your start menu, you must access Programs, then Accessories, then Command Prompt. When the window pops up, then type in "Ping http://www.myspace.com" without the quotations, for instance. Write down, then, the string of numbers that appears, whic...
This video shows you how to recover and read someone else's text messages with a SIM card. It's called a SIM reader professional. It reads the information on the SIM card. You can either buy one or rent it. This device can give you information that has been deleted from the user's phone such as phone numbers, phone calls, contacts, text messages and MMS messages. Then you can block numbers and control who is calling your child.
This video teaches "How to solve Formula Problems". You will be given numbers to replace all letters in the formula EXCEPT one.
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
Have a hard time figuring out what a geometric sequence is? This video will help you to identify different geometric sequences as well as determining its nth term. A geometric sequence is a group of numbers that follow a certain pattern of multiplying a fixed number from one term to another. The tutorial uses 4 different examples of geometric sequences and also shows you how to solve each of these sequences as well. Take some time to watch this video if you are a pre-algebra student, it is a ...
In this video tutorial the author shows how to convert between customary units. He gives a chart which contain various convention tables showing the equivalents of various measurement units. He says a general rule that when converting a smaller unit to large unit we divide the numbers and when converting a larger unit to smaller unit we multiply the numbers. He takes a few examples and shows how to convert between various units like feet, yards, inches etc. This video shows how to convert bet...
This is a one of the coolest videos about arithmetic sequence, it has a very clear explanation about the arithmetic sequence formula and also more than one example which would help the viewer to learn this formula and its implementation in a easier way. This video is a also very helpful for the people who appear for interview since it is a very basic formula that every science student must remember.
Knowing your BMI, or Body Mass Index, is a great way to see if you are at a healthy weight. In this simple and short video provided by Children's Hospital Boston, you will figure out how to calculate your BMI by taking your weight (in pounds) and multiplying it by the number 703 and then dividing it by your height (in inches) squared.
Want to switch your Blackberry Curve's service? Here might be your chance. In this tutorial, learn how to unlock (or jailbreak) your Blackberry Curve in just a few steps, listed below (from Killer Number X):
In this video tutorial, learn how to play the "Dice or Die" drinking game. The premise? A drinking game played by two people, possibly a couple, that enables massive drinking & fun.
Impress your friends! Learn the game of kings and queens. Step 1: Set up the queens and kings
This is the guide of how to cheat in my brute to gain Exp. much faster then the normal people. Click the link www.cheatengine.org to get cheat engine!
An invisible number controls your financial destiny. So until the revolution, you might as well learn how to raise your credit score.
This how-to video demonstrates the process of switching gears on a bicycle. Depending on the number of chains and hubs, your bike will have a varying number of gears. You should be aware of the terrain and make sure you are in the appropriate gear. Don't change gears under power. Know how and when to change gears to make the bike ride smoother and more enjoyable. Watch this video cycling tutorial and learn how to shift gears on a bicycle.
The colors demonstrated in this how-to video are especially flattering on brown eyes and making them pop. Use Pur Minerals's color correcting primer in peach, 4 in 1 pressed mineral makeup in medium dark, mineral split plan in mineral glow/mineral light, blush in plum adalite, universal pencil in natural (eyebrows), eye prep, beauty in numbers eyeshadow palette: numbers 10, 8, 3, MAC kohl power pencil in feline, Revlon Colorstay liquid liner in blackest black, Model Co. lashes, MAC zoomlash m...
According to a U.S. survey, the crud in our garages is taking up most available floor space. Hence the average North American chucks up to $6500 worth of mostly useless stuff on the floor of the garage, while the $20,000 vehicle sits outside in the cold, rusting. It's time to get our cars back into garages. We spent more than $688 million dollars last year on garage organization and it barely made a dent. If you don't believe me, walk down your street and count the number of houses with cars ...