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 12th installment in his series of Excel name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
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.
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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 84th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use custom true/false formulas for data validation and also see how to add an error message.
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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function 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 313th installment in their series of digital spreadsheet magic tricks, you'll learn how to get started using array formulas in your Excel projects.
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
Teach Excel demonstrates how to change the columns from letters to numbers in Excel 2007. The first step is to click on the Office button in the top left part of the window. Next, you click on Excel Options and click on the Formulas tab. There should be a heading labeled "Working with Formulas." The checkbox for R1C1 reference style should be unchecked by default. Check that box and click OK. This changes the column headers from letters to numbers. In order to change back to letters, simply g...
Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with the quadratic formula on your graphing calculator.
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 Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
Algebra – The Distance Formula.
Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video will show how to use these formulas and take advantage of Excel date math and time formatting.
This tutorial shows how to identify the slope and y-intercept given the formula y=mx+b. In this formula m is always going to be the slope and b is always going to be the y-intercept. Therefore if your given a problem like the one displayed in this video: y= 8/3x + 9, the slope would be 8/3 and the y-intercept would be 9. When given these problems all you have to do is match the given numbers to the formula to find the slope and y-intercept.
This video describes how to use excel basics formulas to do math. Shows how to create new formulas so that you can complete math functions and how many formulas in excel work. Each step is displayed step by step with an explanation on what is going on so it may be understood. Keyboard short cuts among other tips and trick to help you navigate through microsoft's excel. After this video you would be able to use excel to do a variety of functions to complete math equations.
One day, your car may break down and you won't be able to afford to hire a mechanic, so what do you do... you look on the web for some how-to vehicle repair videos and become your own car mechanic, that's what. You don't need any advanced training to perform repairs and simple maintenance on your automobile, but you may need a few tools. Invest in the basic tools and you'll be prepared for just about any car malfunction you can think of. These tutorials will help get you on your way, as long ...
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, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
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.
The Ukelele is a great little instrument that is easy to learn, sounds good, and is portable. How much better could it be? They work especially well for covering pop songs, since they're very simple and catchy, which is the essence of the Ukelele. This video will teach you how to play the hit song "Party in the USA" by Miley Cyrus on Ukelele. It's pretty easy, and great for those new to the instrument.
If you've ever had a little trouble trying to program your calculator, you may find a little relief with this four-part video tutorial. Here, a Texas Instruments (TI-84 Plus) calculator will be used to explain the programming process. The four parts include:
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.
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...
In this video, we learn how to derive and use the slop formula. The slope of a line is equal to change in y divided by the change in x. First, put the first point on the coordinate point. Then, represent the X and Y by X1 and Y1. Then, put the second point on the plane, representing the coordinates with X2 and Y2. Now, with these two points, draw a straight line and derive the formula from here. The change in X will be from X1 to X2. Now, replace that with the change in X and do the same for ...
In this tutorial, we learn how to find the standard deviation with the Z-Score formula. First, take your problem and write it out one by one underneath each other. Then, you will need to substitute the numbers in for the variables that are in the problem. Once you do this, you will follow the basic rules of math to find out what the answer to the problem is appropriately. Once you have done this, finish off the problem to find the answer, then you will have found the standard deviation using ...
This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the shading, the whole purpose is defeated.
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 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.
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 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.
This video teaches us the method to find the circumference of a circle given its radius. The video tells us to find the answer in terms of pi and also to the decimals value. The formula to find the circumference is two times the product of pi and the radius. The first step involves the drawing the circle and marking the radius. The radius of the circle in the video is 6.5 cm. Now use the formula to find the circumference. Substitute the value of the radius in the formula of circumference. We ...
In this video, you will learn how to find the area of a rhombus. The formula is A = 1/2 d1 * d2. The d1 is the diagonal inside the rhombus, while d2 is the other diagonal inside the rhombus. You will need to find the length of these lines in order to complete the formula. For example, if one length is 5 and the other is 4, then you should plug in the numbers into the formula. This will equal 20 divided by 2, or 10. 10 units squared is the answer to this particular problem. Viewing this video ...
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.
This video describes how to find the area of a circle given a radius of 4cm. The video begins by describing the formulas needed to find the area of the circle. The narrator cautions the viewer on a few common mistakes that people frequently make while using these formulas, such as not properly squaring the radius of the circle. The solution to the formula for a 4cm radius is 50.24 cm^2. The video then demonstrates that this value makes sense by overlaying a grid onto the circle and visually s...
This video is an instructional guide about Graph Linear Equations presented in algebraic form. It is an easy to follow, step by step guide to solving such equations using the graph intercept formula. The first example equation is Y = 2x -1 over y = mx + b. The video then shows you how to breakdown the equation into manageable sums using fractions to represent the data, and then presents the formula for interpreting the answer from these sums onto the graph co-ordinates. The second and third e...
In this video the instructor shows how to find a formula describing direct variation between two variables. Variation between two variables can be either direct variation or indirect variation. If a variable y is in direct variation with a variable x we can write the general equation between them as y = k * x. That is as x varies, y varies directly in relation to x, as a multiple of x. Now if you have the values of y and x, you can substitute them in this general equation which gives you the ...
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 then writes the distance formula on the board. The formula goes like this, the distance between two points, denoted by 'd' is equal to the square root of the sum of the square of (x2-x1) and the square of (y2-y1) where (5,-...
Slope is the change in Y over the change in X. Written out, the formula looks is as follows: (y2-y1)
This video starts out with a basic view of a rectangle and its dimensions. The base is 7 inches while the sides are 4 inches. It then displays the formula for finding the perimeter of the rectangle which is the addition of both bases and both sides. After the substitution of the values into the formula you can quickly come up with the perimeter. Then moving on the area, the formula is the base multiplied by the side. In this case, the base being 7 inches and the side being 4 inches you come o...
