Formulas

How To : Evaluate vendors with array formulas in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find th ...more

How To : Use the slope formula to find the slope of a line

Easily learn how to graph a straight line using rise over run also known as slope. Algebra made easy! You will easily learn the meaning of the algebraic term slope. This video will teach you how to master algebraic problems that require graphing linear equations. In less than ...more

How To : Use the distance formula

YAYMATH. This video is a demonstration of usage of the distance formula to find the distance between two given (x,y) points. In this video, the tutor guy who is teaching the distance formula to his students takes an example of two (x,y) points such as (5,-1) and (11,7). He the ...more

How To : Use a formula to calculate the volume of a cube

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 exact ...more

How To : Use Excel formulas & functions

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 y ...more

How To : Use the quadratic formula on a graphing calculator

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 (or just study for that next big test). With this in ...more

How To : Use simple formulae in Microsoft Office Excel

Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtractio ...more

How To : Use IF function formulas in MIcrosoft Excel

If you're 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! In this free video MS Excel lesson, the 22nd i ...more

How To : Remove spaces from a Microsoft Excel 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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in ce ...more

How To : Use Excel mixed cell references in formulas

Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same ...more

How To : Trace formulas in Excel 2007

This screencast tutorial from Matthew MacDonald, author of Excel 2007: The Missing Manual, shows you how to trace formulas in a Microsoft Excel 2007 worksheet.

How To : Use Excel formulas with cell references

If you're 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! In this free video MS Excel lesson, the 3rd in ...more

How To : Use mixed cell references in formulas in MS Excel

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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Sum with three criteria by array formula in Excel

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 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by ...more

How To : Hide formula errors in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.

How To : Calculate your BMI with a formula

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 7 ...more

How To : Understand polyatomic chemical formulas

This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write ...more

How To : Calculate the area of a triangle by formula

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 c ...more

How To : Return multiple items by array formula in MS Excel

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 609th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

How To : Create a table of formulas and labels in MS Excel

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 lab ...more

How To : Describe chemical formulas

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 sti ...more

How To : Solve a quadratic equation by quadratic formula

This video is describing how to solve quadratic equation by quadratic formula. The quadratic equation is given in the video and we will use quadratic formula. We will put the equation in the formula our equation is 4psquare= -23p - 15. Now add 23 to both sides and then add 15 ...more

How To : Look up formulas in Excel with the CHOOSE function

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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more

How To : Use VLOOKUP function formula in MS Excel

If you're 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! In this free video MS Excel lesson, the nth in ...more

How To : Create simple math formulas in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in ...more

How To : Travel with baby formula

With all of the new travel laws these days, taking baby formula with you on a long trip can be complicated. In this tutorial, join Erin Sheppard, owner of baby boutique and natural parenting store, Austin Baby, as she shares her best tips and advice for traveling with a baby. ...more

How To : Create quick formulas with Excel names in MS Excel

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 t ...more

How To : Work with array formulas in Microsoft Excel

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 313th installment in their series of digital spreadsheet magic tricks, you'll learn how to get sta ...more

How To : Create a Tangent Line with Excel

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 S ...more

  • Hot
  • Latest