Need help in determining the amplitude and period of sine and cosine functions? This free video lesson will show you how. 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...
Learn how to define the three fundamental trigonometric functions using a unit circle. 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 t...
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new CONFIDENCE.T function to calculate the margin of error for a T distribution confidence interval.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel 2010 video tutorials, you'll learn how to use the new NORM.DIST and NORM.S.DIST normal distribution functions. They have new screen tips to help you select the correct argument.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 3rd installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new percentile function, PERCENTILE.EXC.
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 33rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the AVEARGE, MEDIAN, MODE, PERCENTILE, QUARTILE and PERCENTILERANK functions to measure location.
video tutorial from ExcelIsFun, the 64th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to Excel's D (i.e., database) functions such as DSUM, DAVERAGE, and DMAX.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 74th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to fix bad data with the CLEAN & TRIM functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
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 317th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data (specifically, a substring from string) using the MID 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 151st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the days, months or years between two dates using Excel's undocumented DATEDIF function.
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 101st installment in their series of digital spreadsheet magic tricks, you'll learn how to use IS functions (ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF &ISTEXT).
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 9th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Excel's EXACT function to check to see whether two text strings are equivalent and whether or not they have the same case.
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...
Designing a data mapping project in MapForce? The output functions in MapForce let you preview textual or XML output, save it to disk, or look at SQL statements for database output before committing them to the database server. Learn how in this tutorial.
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve problems involving function inverses.
Want to know everything about your new Motorola Droid X from Verizon Wireless? This three-part video review goes through all the features of the Droid X, showing you how to use everything on the Android smartphone. It's got a 4.3-inch touchscreen and HD video capability, something a mobile phone has never had.
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.
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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
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 the method to graph a linear function by finding the X and Y intercept. Only two points are needed to graph linear functions. So we find the point on Y axis or the Y intercept and the point on the X axis or the X intercept. We notice that on the Y axis the X coordinate is zero. So, we find the Y intercept by putting x=0 in the given equation and solving for y. In the same way, we find the X intercept by putting y=0 in the given equation and solve for x. We join the two points...
This video shows how to find the formula of a piecewise function when given a graph. The first step is to write a definition for the graph, which is done by identifying the different domains shown in the graph. The second step is writing formulas for each domain specified by the lines in the graph. The point-slope formula is used to identify the slope and y-intercept for the leftmost domain, which has a sloped line. A point and horizontal line make for simpler equations in the other pieces of...
In this video, one teacher talked in detail about how to solve absolute value functions and how to translate different absolute value functions from one point in the matrix to another one horizontally and vertically. If the function is y=A|x-h|+k, generally, the diagram is symmetric based on the line of X and can be moved vertically based on k. The teacher gave several examples to explain how to illustrate the absolute value function. He started with a simple one: y=|x-h|, then continued with...
In this educational video the instructor shows how to find the slant asymptotes of rational functions. Slant or oblique asymptotes occur when the degree of the numerator is exactly one greater than the degree of the denominator of the rational function. The way to find the equation of the slant asymptote from the function is through long division. In this long division you divide the numerator with the denominator by following the long division method as shown in this video. Before dividing i...
Finding horizontal asymptotes is very easy! Not all rational functions have horizontal asymptotes. the function must satisfy one of two conditions dependent upon the degree (highest exponent) of the numerator and denominator. If the degree of the numerator is equal to the degree of the denominator, then the horizontal asymptote is y= the ratio of the leading coefficients. If the degree of the denominator is greater than the degree of the numerator then y= 0. If the degree of the denominator i...
Learn how to convert your multi-function cleaner from dry vacuuming to washing carpets with this tutorial.
With iOS 11.2's introduction of Apple Pay Cash, you can send and receive money to others directly through iMessage, using the convenience and security Apple Pay is known for. However, if you want to make sure your efforts go uninterrupted, you'll want to make sure you verify your identity with Apple.
All the Driverless news you need to know from the past 24 hours, bundled together in a tightly written package, about Uber, London delivery services, capital investments, and kangaroos.
Augmented reality allows for all kinds of experiences to happen just about anywhere, and that creates some incredible potential for entertainment. While games like Pokémon GO take you out into the world, one crowd-funded game wants to keep you inside—to scare the crap out of you in your own home.
Welcome back to another tutorial on functions. Last time, we looked inside memory to see what functions looked like in the flesh and all that Assembly was pretty nasty. At least you have some exposure to it. This time, we will be examining how functions work with the stack.
In the last tutorial, we learned how to make functions and how they work on the high level. This time, we will take a peek under the hood again, stare deep into its soul and see its ugliness face to face to see how it works in the lower level.
Thanks to Verizon Wireless, I pay over $220 a month for my phone bill. It's just me on the plan—no family members, and it's not even unlimited data. So, when I receive that data alert message telling me that I've used up 90% of my plan and that I've still got a few more week until my billing cycle starts over, you know that I'm left scrambling to connect to some Wi-Fi.
Hello! Today I would like to share a few words about cleaning your crystals. It could be a whole collection or the first shiny object you have ever bought. Here are some hints,...
Camera mapper is a function in Adobe After Effects that lets you take a static, 2-D image and turn into a dynamic 3-D shot. Create a zoom feature and make it look like you have a camera panning through the picture!