Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.
In this video the instructor shows how to calculate the area of a circle using squares. She starts with the formula of the circumference which she says is circumference C = Pi * D, where D is the diameter of the circle. Now she says that you can turn the shape of circle into a square and compute the area of the square there by calculating the area of the original circle. She shows how to do this by cutting up the square into sectors and arranging them in the form of a rough square and calcula...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 92nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how the AVERAGE function sees zeroes and uses them in calculating an average but does not see blanks.
Having trouble figuring out percentages? If so, you'd be well served to give this free math lesson 100% of your attention. After watching it, you'll be able to answer questions like, "What's 25% of 38?" or "What's 38% of 25?" For more information on calculating percentages with simple arithmetic, watch this free video guide.
Lowe's a leader in the retail home improvement business, brings you this instructional video on how to measure and prepare for hanging wallpaper, for the do-it-yourselfer at home. In this video you will learn useful tips on calculating just how much wallpaper you will need to wallpaper your room, as well as a list of the tools and materials you will need to achieve a good finish, and get the job done right the first time, every time.
From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. This is Mathematics for Dummies. Just watch this video tutorial to learn how to find approximate area using sigma notation, For Dummies.
The discriminate of any equation in any degree plays an important role in determining the roots of that equation.
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
When flying, having a well constructed flight plan is the key to flying safely and effectively. This video will teach you how to calculate the perfect flight plan, research flight paths, traffic, and calculating fuel flow and flight time. There's so much in this video it'll make your head spin!
Need a primer on how to discount outliers when calculating a statistical average within Google Spreadsheets? It's easier than you might think. And this free video tutorial presents an easy-to-follow, step-by-step guide of the entire process. For detailed instructions, and to get started lopping off outliers in Spreadsheets yourself, take a look!
Need help calculating the volume of a cylinder? It's easy! So easy, in fact, that a complete and thorough overview of the process can be presented in forty-five seconds' time. Study for your next geometry test or just finish your homework with this free video math lesson, which demonstrates how to find the volume of a cylinder using v=pr^2h.
Do the words point-slope equation send your head into a spin? Well hold on tight, because the mathproblemgenerator.com has your cure? Here you can find a informative video about calculating slope, as well as finding points to substitute into the equation. After watching this video, you will be well prepared to produce a point-slope equation from any graph.
Calculating resistance and power isn't hard... and, as David explains, knowing Ohm's Law and the Power Triangle can be darn useful when you're designing a project, sorting out power supply issues, or want to keep from burning your car down.
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 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability:
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
In this video, Mr. Maisonet provides a quick and easy method for calculating the area of a trapezoid. In the first step, The lengths of the two bases (the two sides of a trapezoid that are parallel to one another) are averaged. The lengths of the bases are first added together, and the sum is divided by two, yielding the average. The average is then multiplied by the height. The resulting product is the area of the trapezoid. This method for finding the area of a trapezoid is mathematically s...
This video both shows the viewer how to calculate the volume and surface area of a cylinder. It also explains what these different numbers mean. The volume is the amount of ‘matter’ that the cylinder can hold. The surface area is literally the area of the cylinders curved face and the two end circles.
In this video, it is shown how to calculate the area of a circle where the diameter is given. The formula for calculating the area of a circle is pi multiplied by square of radius. Radius is actually half of the diameter. In this video, the diameter is given as 10.6 meters. Hence, the radius will be half of 10.6 which is equal to 5.3 meters. Now, to find the area we shall multiply pi with the square of 5.3. Square of 5.3 is 28.09. If we multiply 28.09 with pi we shall get the area of the circ...
The parts of the compass are a base plate with different measurements for calculating mileage and distance. The magnifying glass is used to magnify things on your map. The arrow at the top of the compass is called the direction of travel arrow. To find the degrees on your compass, use the rotating bezel ring, with North being "0", East being "90", South being "180", and west being "270". The magnetic needle inside has a red magnetic north end, which is used to locate "North", and the black en...
Slope is the change in Y over the change in X. Written out, the formula looks is as follows: (y2-y1)
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A general knowledge of Excel is helpful for navigating the menus in Excel, but if you pay attention during this presentation you'll pick up the skills quickly! Several ideas covered in this video are Formulas with cell references, how to find various Excel functions to use in formulas, and the Effect f...
In this video the author show how to find the volume of a sphere. The formula for finding the volume of a sphere is 4/3 * Pi * r*r*r, where r is the radius of the sphere. Now to compute the volume of a sphere you have to note down the radius of the sphere and substitute it in the above formula along with the other substitutions. The author shows this with an example by taking a sphere of some radius and calculating its volume. To find out how to calculate the volume of a sphere watch this vid...
In this tutorial the author shows how to find the circumference of a circle. He says that the circumference of a circle can be calculated by using the formula circumference C = 2 * Pi * R, where R is the radius of the circle. He shows how to solve these kind of problems using some examples and calculating the circumference by substituting the value of radius in the formula. This video gives a good introduction on how to find the circumference of a circle.
This science video explains the relationship between buoyancy and density using hot air balloons, fish and cruise ships as examples of objects using buoyant force. This video tutorial also includes instructions for calculating the density of a rectangular prism and a liquid. If you like science experiments, you can't miss this one.
Grandmaster Alexandra Kosteniuk shows you how to play chess in this chess video tutorial, but wait, where's Alexandra? For this chess master class, guest star GM Laurent Fressinet from France will be filling in to show you how to play one of his games from Warsaw (2005), Fressinet vs Postny.
This tutorial describes the method to calculate the area of a triangle and a parallelogram To calculate the area of a triangle:
One of the easiest ways to measure body fat is by using hydrostatic weighing. It is based on Archimedes' principle, the law of buoyancy. It works by calculating body fat from measuring the amount of displaced water after a person has been immersed under water. Since muscle is denser than body fat, a person who has more muscle will displace less water than a person of the same weight with more body fat. This test is usually performed for a couple times for averaging accuracy. If the test is do...
In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...
Hurting for cash? Need an interesting, and fun way of making more? This video will show you all of the steps to turning your car into a piece of moving ad space! Everything from finding the right agency, to deciding which brand that you want to support, and calculating the amount of money you'll make!
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this free math tutorial, you'll learn how to calculate the area of a triangle by formula. In this clip, you'll learn an easy finger-counting trick for quickly calculating multiples of 9.
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...
You may not know it, but the IPv4 address of your computer contains tons of useful information about whatever Wi-Fi network you're on. By knowing what your IPv4 address and subnet mask are telling you, you can easily scan the whole network range, locate the router, and discover other devices on the same network.
The video shows us how to find the area of parallelogram using geometry. Here in this video it is done by using an example where the parallelogram is given ABCD. The area of the parallelogram is base times height (bh). Here the base is given as 15 but the height is not known but it is represented by the segment BD. To find the value of h, let’s use right triangle BDC on the right side of the figure. Since base is 15 and the opposite side of the parallelogram is congruent, the hypotenuse of th...
Whether you're white hat, black hat, or some shade in-between, navigating through a network is a core part of hacking. To do that, we need to be able to explore a network to discover the addresses of gateways, interfaces, and other attached devices. When ifconfig just isn't enough, you can steer your way around a network with a convenient tool called Ship, the script for everything IP.
If you're interested in nabbing superhero memory strength, the secret behind training your brain is not necessarily what you might expect. Your standard G-rated brain strengthening exercises range from crossword puzzles to Sudoku to calculating fairly simple math problems to improve short term memory, but the real clincher used by some of the pros is essentially... porn. Yep, you read right.
Online glasses retailer Warby Parker built its reputation by selling fashionable yet affordable eyeglasses, so it perhaps a surprise that it's one of the first developers to take advantage of the technology in the least affordable iPhone yet.
4DViews, the volumetric capture company that films actors and performers in augmented and virtual reality for things like movies, TV series, and applications, has just released the app 4DViews: Raise Virtual to Reality, to demonstrate its technology for smartphones.
