Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
The Pythagorean theorem is a simple theorem that states that - for a right angled triangle the square of the length of the hypotenuse is equal to the sum of the squares of the length of the remaining two sides.
This is a video tutorial in the Education category where you are going to learn how to describe chemical formulas. A chemical formula represents the actual number of atoms of each element within a molecule. Different visual representations of molecules include the ball and stick three dimensional model, a line drawing that represents the structure in two dimensional terms, and a shorthand used by organic chemists. If a molecule has 4 green atoms and 2 orange atoms, the ratio of green to orang...
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 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
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.
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
Calculating the volume of a cube is very important in high school geometry classes. Calculating the volume of a solid can be confusing at first, but with a little practice you will be able to get it right. In this tutorial, high school math teacher Doug Simms teaches you exactly how to calculate the volume of a cube and offers examples so you can follow along. Listen to Mr. Simms and you will be at the top of your class!
The video is a tutorial in trigonometry. The teacher teaches that the tangent or the tan of an angle is the ratio of the opposite side to the adjacent side of a right angled triangle. If one side and one angle is given then the value of the unknown side can be found by solving the equation tan of angle is equal to opposite upon adjacent side. If the angle is to be found then the tan inverse of the value is seen in the calculator.
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.
Free Math Tutoring teaches you in this video how to calculate the area of a triangle using a basic formula. The area of a triangle is (b times h)/2. B is the base of the triangle and h is the height. This formula works for all kinds of triangles. Sometimes you won't have the height in the triangle, so you need to draw a line from one angle to the base opposite that, at a 90 degree angle. Measure that and you have your height. It might seem difficult at first, but practice helps you understand...
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.
Larry Keim, the host of "Rolling R's", teaches Junior High School Spanish in Mesa, Arizona. He has a passion for Spanish, and has created this video podcast to give away Spanish lessons for free. For the lesson portion, Larry describes an easy way to talk about future action, using the formula of “Ir + a + Infinitive.”
In this free video math tutorial, we learn how to use the Z-Score formula to find a data point (Xi) in statistics. With mathematics, as with anything else, not everyone progresses at the same rate. Stats is no exception. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up. Whether you need help finishing your homework or studying...
The battle between Pepsi and Coke has been a grueling one, with both sides securing their secret formulas for great tasting, addicting sodas behind lock and key.
In this tutorial the instructor shows how to find the area of an oblique triangle using different formulas. To find the area of an oblique triangle there are different formulae. The first formula to calculate the area of a triangle is area A = (1/2) * a * b * Sin(C), where a and b are the lengths of the two sides of the triangle and C is the value of the angle of the triangle that lies in between the two sides a, b. Now substitute these values in the given formula to find the area if you have...
The Movie Trailer for "The Baby Formula"
Parents everywhere should pay attention to this stain removal tip for removing baby formula stains. Remove baby formula stains from clothes.
Scientists have recently released a mathematical breakdown of the perfect handshake. The University of Manchester researchers discovered that nearly one-in-five people hate the handshake, listing complaints such as sweaty palms, limp wrists, gripping too hard and no eye contact.
Oh, don't look so grumpy, Coco. I'm sure Nylon's secret formulas will only be used in the direst of situations:
Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.
In this how to video, you will learn how to find the volume of a sphere and surface area. Let's say you need to find the volume of a sphere with a surface area of 200 cm cubed. You will need to know the formulas for surface area and volume of a sphere. The formula for surface area is 4 pi r squared. The formula for volume is 4/3 pi r cubed. Plug in the surface area of 200 cm cubed and plug it into the formula. You should get an answer of about 3.99 cm. Now you just have to solve for the radiu...
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
This video tells us the method to find the surface area of an aluminium can or cylinder. The surface area includes the outside area of the curved portion and the aluminium top and bottom. The formula to find area is the multiple of 2, pi, r, r+h or (2)(pi)(r)(r+h). The radius of the cylinder is the radius of the circular top or bottom. In the example shown in the video, the radius is 4 inches and the height is 12 inches. Substituting the values in the formula, we get the surface area as (2)(3...
Learning how to play and connect arpeggios is the beginning of getting into not only creating interesting and fresh melodies but also sweep picking! It's very simple to do, you just need to know the formula for the different types of arpeggios out there. In this video you will learn what an arpeggio is and also how to play a few basic arpeggios!
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to allocate $950 across 7 days including the extra penny with a single formula.
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 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
Traditional bookbinding can be a complicated job requiring specific tools and crafts. But when you're making a personalized homemade journal or diary at home, anything goes. This video will show you the basics of making a simple, small book using easy methods with materials you likely have around the house, like index cards (for the folios), a cereal box (book cover), paper, duct tape, scissors, dental floss (binding), glue, Sharpie marker, and an awl or sewing needle.
For beginners, you may learn a few basic chords here and there, but somewhere in your mind you must think about why do these chords sound like this, why is this an A chord and this a G chord? Well, wonder no more! In this video you will learn how the construction of a chord works, which is basically taking the root and adding a specific formula for what you're looking for. Let's say you want to build an A major chord. Well, you first have to build the triad which is the 1st note of the major ...
Need to color correct your photos and you're not sure how? In this video, the basics of RGB and CMYK colors are discussed as well as how to use them to color correct everything from everyday snapshots to portrait photographs. By using the eyedropper and the info palette to read the colors in the photos, you can then color correct. Based on the CMYK read out of the color sample targets, you can then adjust the color channels using a curves adjustment to achieve the kind of colors you'd like. A...
The first video is an elementary explanation of triangular numbers and a Gauss demonstration for the sum of the first 100 natural numbers.
The single-player campaign mode in Call of Duty: Black Ops may be intense, but the multiplayer mode is a bloodbath of pure addiction. Black Ops takes the super successful formula of Modern Warfare and adds its own special twist. There's some changes, and Jessica Chobot from IGN Strategize is going to tell you all about them!
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
