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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 82nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma value (the population's standard deviation) in NOT Known using the TINV...
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area using the Herons formula. First to use it you need to computer the semi perimeter of the triangle S, which is S = (a + b + c)/2, where a, b, c are the lengths of the sides of the triangle. Now the area of the triangle i...
This video is about Annual percentage Rate(APR) and the Effective APR rate.The video begins with an example of a credit card which has a APR rate of 22.9% and daily periodic rate of 0.06274%.You can get the APR rate by multiplying the daily peiodic rate with 365, which in this case will be 0.06274*365 which is equal to 22.9.If you convert the daily periodic rate into decimal values , it will be 0.006274.So for example, if you have 1 dollar in your balance on day 1, on day 2 you will owe 1.000...
In basic algebraic equations all the variables are on left side of the equation. But as the complexity of the problems increases you will find that the equations will contain variables on both sides of the equation. To solve these kinds of problems first simplify the equations on each side of the equation. You can use the distributive law to do this. Next try to cancel the variable on the right side of equation by adding the negative value of that variable to both the sides of the equation. N...
Decimal numbers, fractions and percents are pretty much three versions of the exact same value. In this tutorial, learn how to work with all three and convert them within each other.
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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.
Given a point through which a line passes and the value of its slope you can graph the line. To do this first plot the given line. Now taking the slope and using the rise over run method plot a second point. Connect these two points and this gives you the graph of the line. Extend this line further on both sides to get the complete line. The point where this line cuts the x-axes is called the x-intercept and the point where this line cuts the y-axes is called the y-intercept. The important po...
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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
This video shows the method to use differential equations to represent growth. Consider the function y=multiple of C & e raised to kx or Ce^(kx). Differentiating it with respect to x, we get dy/dx=kCe^(kx) or ky. So, the solution of the differential equation dy/dx=ky is Ce^(kx). There are two possibilities in the function y=e^(kx). It can be exponentially growth or decay function. This depends on the value of k. If k is greater than 0 or k>0, we get an exponential growth function. On the othe...
This video shows how to use optimization methods in calculus. Optimization means finding the maximum or minimum values of a quantity or finding when the maximum or minimum occurs.What quantities are optimized in economics?we want to minimize costs or maximize revenue.First steps in any optimization problem1.Identify the quantity to be optimized i.e., read the problem exactly what is exactly maximized or minimized.2.Identified the feasible domain. This is important because the math we can opti...
This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...
In this two-part video tutorial, learn how to make a beautiful quilt out of recycled t-shirts! Include t-shirts with sentimental value to your family or friends, and create a keepsake that will last a lifetime and touch the hearts of your loved ones. Get step-by-step instructions on how to make this precious item in this two-part series of sewing videos.
When you think about it, your bathroom is one of the most visited rooms in your home. A great way to impress guests and increase the value of your home is to remodel and update your bathroom. In this two part tutorial, follow along with the Home Depot as they show you the best and most inexpensive way to create a luxurious bath.
This video shows how to get more value on your GoDaddy account. You have to have a deluxe account to share domains. You have to pay an extra $2 a month to get this account. Once you sign in go to "hosting" then my "hosting account". To add another domain you move it over to a new folder then put the site files in there. To do this, click add domain then go to bulk. Then create a folder and name it what you desire. Sometimes the file folder doesn't always appear immediately, but it is there, i...
Are you interested in 2D animation in Flash? First import a image in flash. Then create a new layer and choose oval tool and take a radial gradient. In the middle of the shape, we need to have zero alpha value and pick the colors from the background of the image. Create the shape over the image and take another frame at no.10 and increase alpha. Then create another keyframe and convert it to movie clip. Then create shape and motion tween. On the new layer, write a stop command in action scrip...
This video will show you how to quickly get rid of a pimple. To quickly get rid of a pimple, simply do the following: Take 1 or 2 aspirins and put them in the palm of your hand. Add a few Visine eye drops and make a paste. Apply the paste to the pimple and allow it to dry. The acidic value in the aspirin will help to dry up the pimple, and the Visine will help to get rid of the redness.
If you are a user of FileMaker Pro then this video teaches you how to use calculation and summary fields in it while making new files. In Filemaker you can create a various kind of fields that you want your file to contain. In Filemaker a calculation is a data that gets computed depending up on the formula that is set in the Filemaker database settings. Calculations are very critical in file management. Open the Manage Database and there you can find some of the calculation fields. There in t...
Ever since Supergirl was introduced in the DC world of comics she has always been the youthful, ambitious protagonist that everyone knew to respect. Her strength and value made her entrance on the scene a remarkable one, even though she never got too much limelight. This video is focusing on portrait of female character design for manga, video game, and comics basic. The process shows BASIC drawing and sketching video series of comic book characters that will help you gain knowledge of anatom...
In this video the tutor shows how to calculate the area of a rhombus. He gives the formula for the area of a rhombus as area a = ( D * d ) / 2 where D is the length of the longer diagonal and d is the length of the shorter diagonal. He shows how to solve such problems by taking an example of rhombus with lengths of longer and shorted diagonal and computes its area by substituting the values in the area formula. This video shows how to compute the area of a rhombus when the lengths of its long...
Impress others with your artistic skills by learning to paint a gypsy dancer on the computer. Construct a rough sketch line drawing of a girl dancing. Use a soft brush to airbrush some colors in. Use as few colors as possible. Don't worry about the value yet. This will be a basic map of what colors you want to use. Start adding darker colors in. Use a highlighter to add lighter colors. Use the soft edge brush to blend and a hard edge brush to define forms. Experiment to your liking. With this...
This video will show you how you can easily find out what your IP address is for a computer which is running the Windows XP operating system. You will first need to go to the start bar and click on the button which says "Run". Choose to run a program called "cmd" by typing this into the bar that appears. This will then open up a black box, where you should type in "ipconfig/all". Typing this in will offer you a list of information about the internet service you are currently using and one of ...
In this video the tutor shows how to find the mirror point using a quadratic equation. He says that to graph a parabola you need to find the mirror point symmetrical to the Y-intercept. Now he explains how to find a mirror point using an example with sample values. He begins with saying that the Y-coordinate of the mirror point is same as the Y-coordinate of the Y-intercept. Now you have to find the x coordinate of the mirror point which he shows that it is double the x-coordinate of the vert...
In this tutorial, the author shows how to determine if a point lies on a given line which is in Point Slope Form. To show the method he takes a sample point order pair and an equation of a line in its point slope form. Now he substitutes the value of the x, y order pair and the equation of the line, and solves the equation on both the sides. If both sides match it means that the point lies on the given line, or else it does not lie on the current line. In this video, the instructor shows how ...
This video is a detailed step by step explanation as how to solve a two step equation. The video provides an example of how to go about a two step equation problem and the steps necessary in order to solve for the value of one of the variables. This video uses very simple mathematical terminologies, therefore, most people should be able to understand and learn the concept easily. The video is very helpful and recommended to anyone who plans on taking algebra in the near future.
In this tutorial the author shows how to find out the missing part of a triangle that is similar to another triangle. He explains the concept of similar triangle diagrammatically by showing that similar triangles have similar angles and parallel sides. Now he labels sides of similar triangles and marks the value of unknown side as variable x. Now in similar triangles as the lengths of sides of proportionate he shows how to write a equation of proportion and solves it finding the missing part ...
Math Problem Generator gives a video about how to add and subtract variables. All you have to do is combine the coefficient, which is the number that comes before the variable. The numbers are added or subtracted but the variable remains the same. In the video, the example given is 9x + 6x - x. First you add 9x + 6x, giving you 15x. The equation is now 15x - x. If a variable has no number written in front of it, that means the value is 1. So the equation is 15x - 1x and that is equal to 14x.
This video tutorial by Tasktutorial shows you how to create an Apple style bar in Illustrator. First, select the rectangle tool in Illustrator and draw a bar as shown. Now select the path, go to gradient and choose the black and white gradient from the swatches. Select two shades of gray and change the angle to -90 degrees as shown. Tweak the colors and go to effects-stylize and select drop shadow, change the opacity value and select black color, normal blend mode as shown. Select the type to...
In this Math Made Easy tutorial the author shows how to subtract positive and negative numbers. He says that because of the numerous combination of positive and negative numbers it adds to a lot of confusion. Now he shows a trick of how to add positive numbers to negative numbers showing that it's equivalent to subtracting the negative number from the positive number. He shows that if you want to subtract a negative number from a positive number we should actually cancel all the signs and the...
In this video tutorial the author shows how to find the surface area of a cylinder. He shows a four step approach to solve this problem. First he gives us a formula to find the surface area of a cylinder, where Surface area A = 2 * Pi * R * R + 2 * Pi * R * H, where R is the radius of the base of the cylinder and H is the height of the cylinder. Now he identifies those values and substitutes them in the formula giving the surface area of the cylinder. This video shows how to compute the surfa...
In this tutorial the instructor shows a method to compute the interior angle sum of a polygon. He gives us the formula for the interior angle sum of a convex polygon as (n-2) * 180 where n is the number of sides of the polygon. He goes and take a 6 sided polygon as an example and does the math by substituting the value of 'n' in the equation and arrives at the result. This video clearly gives the formula and demonstrates with an example of how to calculate the sum of interior angles of a poly...
In this video the author shows how to find out if a Point lies on a Line in Slope Intercept Form. He shows it by an example where he takes a point, which is an ordered pair in the form (x, y) and a line, which is an first degree equation. Now he substitutes the values of x and y in the equation and checks if both the sides of the equation match. If it matches we can conclude that the point lies on the line. By following the method given in this tutorial you can find out if a given point lies ...
Learn how to draw Watchmen superhero character Silk Spectre in this lesson tutorial for quick concept illustration, cartoon and comics. Learn from basic sketching to finish drawing quick color concept painting for illustration. Learn how to draw and sketch this Watchmen character using values. This tutorial video focuses on drawing and sketching step by step: female character design for manga, video game, and comics basic. Silk Spectre is a character in the new Watchmen movie.
See how to choose a tattoo that’s right for you. A tattoo is forever – unless, of course, you want to go through the pain and expense of removing it. So think long and hard before you get one!
Part 1 of a three part video showing how to paint a tranquil harbourside scene in acrylics. Part 1 deals with the composition and tonal values. Part 2 continues by adding the base colours and developing aerial perspective. Part 3 concludes with the details and highlights.
You can make saline (salt) or lye (NaOH) solutions. So first you will have to arrange these things to do it which are 2 500ml bottles, 1/2 LB table salt, measuring cup, kitchen scale (optional) and pan for heating. Now first heat the
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...
