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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
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 279th installment in their series of digital spreadsheet magic tricks, you'll learn how use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA, AB, ZZ with a 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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.
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 160th installment in their series of digital spreadsheet magic tricks, you'll learn how to find all the occurrences of a word, number, format or formula and then change or replace all of them! See how to use the Find and Replace feature in Excel with this free video tutorial.
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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.
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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...
1.Here 10-50 and 300-400 numbers are taken for example to generate the random numbers within the limit in Excel. We using the command of "randbetween" for generate the random numbers and we won't get the decimal or fraction values.2.Now type "=randbetween(10,50)" which means to generate the random value between the bottom value of 10 and top value of 50 and click enter now we will get 11 as random generated number.3.Do the same thing for 300-400 as "=randbetween(300-400)".You will the 303 wil...
This is a video tutorial describing how to use a microdermabrasion tool to induce flawless skin. The first step is to wash your face and pat it dry. Next you should use a facial rejuvenation formula lotion and place it on the parts of your face that you think need the most work. You can even put some of the lotion on the microdermabrasion brush. Then you should set the timer on the brush to two minutes and begin to brush it across your face. You should only use the brush two to three times a ...
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Create a table with sales data with this video.
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...
In this how-to video, the author, , Davitily, has a simple drawn out diagram of a cone figure and it's measurements, and also has the mathematical formula of how to find the surface area of this and any other cone figure.
In this tutorial the instructor shows how to graph a parabola and also how to find its roots which are also known as zeroes. He gives the quadratic formula of how to find x-intercepts of a parabola. He takes an example and substitutes the values and finds out the values of the roots of the parabola. Now he substitutes these values in the equation to obtain the corresponding y coordinates. Now using these pairs of values he plots the parabola on a graph and draws it. This video shows how to fi...
This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...
In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...
In her video, Carol describes her skin care regimen, which she claims has been very effective in treating her acne and improving her skin. This regimen is for acne-prone / combination skin types and involves the use of multiple products, including cleansers, scrubs, masques, washes and moisturizers. Carol takes us through her morning, evening and weekly cleansing routines, explaining which of various products she uses for each such routine. She also discusses each product, explaining its stre...
Steps involved in calculating the lateral surface and total area are:
In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...
Pixie Lott is an English music artist whose song "Boys and Girls" topped the UK charts in September of 2009. If you want to look like her from the music video, just watch as Princess Pinkcat shows you how to create a Pixie Lott "Boys and Girls" makeup look.
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to
This video shows how to find the area of a circle using a formula. The formula for area of circle is pie multiplied by square of radius. Pie is actually an infinite number but for the sake of convenience we consider the value of pie as 3.14. So we multiply the square of radius with 3.14. Radius is the distance between the center point of the circle to any of the outside arcs. It is actually half of the diameter (diameter is the distance between two arcs of a circle). As an example here the ra...
Learn how to find the area of circle by activity method. Requirements: A circle cut out, a pair of scissors, sketch pen, and a ruler.
Improve your skin’s appearance by choosing the right foundation formula and shade. You Will Need:
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 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:
First of all cut of the top and the bottom of the cylinder to get two circles. Now take a scissors and cut of the cylinder into two halves from the top to the bottom as shown. Now you get a rectangle shape. You can easily measure the length of the cylinder but to measure the base is a problem. So mark a point on the table with tape and also make a mark on the can or the object you want to measure. Now place the two points over each other. Now use a ruler as a guide and move the can so that th...
This is a great Halloween look for those of you who do not one to wear masks are a bunch of gory effects. You can even use this look for other dress-up parties. Princess Pinkcat shows you how to do her evil fairy makeup look.
Ouch! Is your baby's bottom red and sore? Say goodbye to diaper rash with these tried-and-true remedies.
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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.
Looking for a primer on how to create and work with lookup queries 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 very first installment in his series of Excel lookup formula series, you'll learn how to use the VLOOKUP function to deliver a value to cell.
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 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...
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 learn about the SUMIFS function and how it blows SUMPRODUCT away when it comes to calculation speed.
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 35th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate the service charge for a checking account and see how to create a formula for the balance in a checkbook or checking register.
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 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
Looking for a primer on how to create and work with arrays 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 array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.
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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for stock portfolio return & standard deviation.
