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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating 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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
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 613th installment in their series of digital spreadsheet magic tricks, you'll learn how to
Need a little help figuring out how to find the inverse of a function in algebra? Watch this free video 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). With this free math tutorial, you'll learn how to calculate the inverse of a given algebraic fun...
Looking for an easy way to find limits? Watch this free video 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). With this free math tutorial, you'll learn how to find limits using series expansion and little bit of algebra.
Need help figuring out how to work with circles in basic geometry? 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 about how to calculate an...
Need help figuring out the sine, cosine, and tangent of an angle in a right triangle? Need to know how to solve a matrix-form linear equation in algebra? Need help solving problems involving 45°-45°-90° right triangles? You're in luck. 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 stu...
Looking for an easy way to solve rate-of-change problems? Use the chain rule! 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 calcula...
Learn how to graph the amplitude and periods of sine and cosine functions in basic trigonometry. Learn how to use trigonometric functions to calculate the sides of a right triangle. Need to know how to solve a matrix-form linear equation in algebra? 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 h...
New to trigonometry? Learn how to calculate cosine, sine and tangent with this 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). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how t...
Want to know how to sum a series of consecutive integer numbers (e.g., 1+2+3+4+5)? You're in luck. 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...
Need to know how to figure out the least common multiple or LCM of two given numbers? 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...
Need to know how discover the area of a triangle or rectangle? 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 find the area and peri...
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 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
If your students are having trouble remembering how to calculate density properly, check out this video. In it, you will learn the lyrics to a very fun song that will help your kids with the equations and vocabulary. Follow along with Mr. Edmonds as he shows you his favorite song to the tune of "Popular" from the Broadway show "Wicked".
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 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.
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 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...
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 10th installment in his "Excel Statistics" series of free video lessons, you'll learn how about data sets and the nominal, ordinal, interval and ration scales/levels of measurement and see two Pivot Tables that...
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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
In Chemistry weight of some elements are measure in the form of Average Atomic Mass. Isotopes are found in different abundances in nature. Certain elements have many isotopes and certain elements have few isotopes. Regardless of the number of the natural isotopes, the weighted average mass takes into consideration not only the mass of each isotope, but what also its natural abundance in terms of percent as found in the nature. So when you have the mass of two isotopes of an element and are gi...
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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
In this video you learn how to make a digital pinhole camera. The video begins with an introduction addressing the main themes to be dealt with in the video - tight budgets, photography and specialized lenses. In this video, Kai modifies a photo lens cap by poking a large hole in it. After making this large hole, he makes a smaller hole in a thinner material and lines the hole up in the center. He calculates the size of the hole he needs based on the wavelength he will be photographing. He us...
Need a new prank or trick to play on your friends? Well this video is your solution. All you need a non-transitive dice and to follow this video and you will be cheating your friend in no time. The idea behind this video is to use dice that are non standard, which means instead of having from 1 to 6 on the sides, they have other numbers. By playing with what numbers go on the faces, the viewers can skew with the probabilities of what number comes up. With this idea, the viewers can make dice ...
Ever wonder how to measure the height of a building, without using a tape measure? Well, this crazy science experiment will show you how. Just watch and you'll see how to measure the height of a building with a CRT monitor, gravity and math.
The multiple award-winning card game Sixteen is packed with head-to-head action. If you can you count to 16 and take calculated risks, then you can force your opponent to bust. But play your cards defensively at the right time or the tables will turn! Win the most sets and you'll win the game. It sounds simple (and it is), but Sixteen's unique strategy and cribbage-like counting will hold the attention of even the most seasoned game players.
The first video introduces the basic electrical quantities of charge, current, voltage, and resistance. The concept of quantities and units is explained. The units of Coulombs, Volts, Amperes, and Ohms are described. The three basic formulas of Ohm's Law (E=IR, I=E/R and R=E/I) are also introduced.
New to the Ubuntu Linux distribution (or one of its derivatives) and looking for a way to start programs automatically when you boot up your machine? Take heart: This video tutorial will show you how to accomplish just that using your system preferences. Take a look!
By default, images embedded using external links will not automatically load in any emails that you get with ProtonMail. This is a security mechanism that can prevent malicious code from being executed on your system, but it can also be fairly annoying to have to manually load images in email after email.
A group ironically called the "Guardians of Peace" hacked into Sony Pictures' computer systems and released a mountain of internal information such as medical records, leaked scripts, work complaints, and even celebrity aliases.
The concept of percentages may be a bit difficult to grasp for some beginner level learners. This video attempts to explain the concept of percentages in an easy to understand way.
In this video, Daddy Troy teaches us how to star gaze with your kids. This can get your kids interested in space and teach them a thing or two, while still having a good time. First, Google offers a service called Google Earth, which will show your child the entire earth, moon, and mars. Kids can use these programs just like a video game. They can see real pictures as well as their own home or grandma's home. This is free and a lot of fun! Next, you can see satellites with your naked eye in t...
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...
The discriminate of any equation in any degree plays an important role in determining the roots of that equation.
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 calculate unknowns in proportions in algebra.
Learn how to calculate BPM for different types of DNB. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions,
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 calculate the probability of two dependent events in statistics.
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.
Could you use a little help figuring out how to find an unknown angle in a paralellogram? Watch this free video geometry 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). With this free math tutorial, you'll learn how to calculate a missing angle in ...
Need to calculate the area between two curves? 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 math tutorials, you'll learn how...
