This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
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 cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
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 tutorial it shows you how to find the x-bar by using the Z-score formula. In the beginning of this video the formula is displayed on the right, while the values that you need to plug in are on the left. Once you plug in the values and do the cross multiplying, all you have to do is get x-bar by itself on one side of the equation. This is a simple problem on using the z-score formula to find x-bar, it can help you solve more complex problems in the future.
In order to find the cosine of a triangle in trigonometry, you will need to understand the CAH formula, part of the larger mnemonic of SOHCAHTOA, which outlines how to find the sine, cosine, and the tangent of an angle. The video offers accurate diagrams as well as examples in order for their viewers to better understand the CAH formula. The CAH formula simply outlines the fact that the cosine is equal to the length of the adjacent side of the triangle over the hypotenuse of the triangle. By ...
In this video lesson, you learn how to find the area of a circle. The video starts with an explanation of the area's formula. This formula can then be used to find the area of any circle, given its radius, which is half the diameter of the circle. There are many applications for this formula, whether in architecture, or studying for a basic geometry test. Euclidean geometry is the cornerstone of any education, and this video teaches you one of the many formulas in geometry.
This video teaches "How to solve Formula Problems". You will be given numbers to replace all letters in the formula EXCEPT one.
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.
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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.
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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
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.
See how to find the formula for an arithmetical sequence in college-level algebra given two terms in this free video college-level algebra lesson. 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 finish your homework or study for that next big test).
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 finish your homework or 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 write a formal analytical proof of the quadratic formula.
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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.
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 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
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.
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 use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)
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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.
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.
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.
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 the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
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 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS 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 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).
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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.
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 172nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create running total with a formula or a pivot table.
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 Excel tutorial from ExcelIsFun, the 572nd installment in their series of digital spreadsheet magic tricks, you'll learn about how to use conditional operators in your formulas.
This audio production tutorial shows you how to simulate a live crown in FL Studio. Use a microphone or your audio output to trigger cheering or laughter in real-time with 5 easy steps in FL Studio. There's a little formula usage involved, but it's easy. See how to use fruity formula controllers for crowd simulation and reactions.
With the spread of smartphones and free online games, the "Freemium" model of product distribution and monetization has become prevalent over the last several years. At it's essence, it is handing out software products for free and then allowing customers to pay for in-software services using microtransactions. This video features some businessmen who do business in iPhone apps discussing how they use "Freemium" systems in their apps to make the most money possible while providing great servi...
This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...
No one likes a cheater! Well, you don't have to cheat in order to quickly make your farm and profits grow on Farmville. You can easily increase how much money you have on your FarmVille farm without having to use hacks or cheat codes. Follow these four tips - enter the daily raffle, share your friends bonuses, help out on their farms and see what happens!
The best city in CityVille is one which maximizes your profit and production. This video shows you a few useful tips and strategies that you can use when laying out your new city for maximum efficiency and productivity. It's all about roads and decorations.
In this tutorial, we learn how to find the formula of a given sequence. First, you need to decide what you're starting with. Start with a1, then continue on with a2, a3, and a4. Eventually, you will have an "An". You will have an "n" in your numerator and the denominator will start between the numbers of your fractions. Look to see if that works, then you have to see where the signs alternate on the fractions. Write in any negatives that you have, then figure your power out. Once you follow t...
The foreign exchange, or forex, market is a relatively safe place to invest money, but like with any investment research and understanding indicators are key to making profits. Watch this video to learn how to use forex trading spreads to read the market and make sound investments.
Got some old stuff you want to get rid of? This clip'll show you how to do it using eBay. For more information, including detailed, step-by-step instructions, and to get started selling your own things on eBay, watch this helpful video guide from CNET.
In this tutorial, we learn how to use the distance formula for two points. The distance formula is D= the square root of (X2-X1) squared, plus (Y2 minus Y1) squared. It may look confusing, but it's just a derivation of a theorem. First, find the two points that you have and graph them. If you want to know the distance between them, you cannot just count squares if it's a diagonal line. If you remember geometry, you can draw a right triangle over the line to figure out the distance. After this...
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 705th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Ctrl + ] to find dependent or
