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...
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.
For most, anatomy dissections stopped at the frog. We can all experience med school cadaver picking thanks to an excellent library of videos published by the University of Wisconsion. No MCAT's required.
Here is an ice skating technique that no many people know. This how to video shows how to do the "Dime Stop" stop. This stopping techniques is a great way to come to a quick stop on the ice and looking quite fancy at the same time.
Watch to learn how to do stop shots and stun shots in pool by making the cue ball stop and stun at the right time.
This video shows you how to make non-toxic blue goo in your kitchen. You will need 3 eggs, two bowls, milk, coconut or vegetable oils and a spoon. First break the eggs and pour them carefully into the spoon to ensure that you can dispose the egg yellow as you will not need it. Repeat this for each of the three eggs. Then mix up the egg whites, ensuring that you do not beat the egg whites too much. Then add around four tablespoons of oil into the eggs and mix it up once more. As the egg whites...
Watch this video tutorial from the Polish Guy to see how to polish a chrome car rim using Flitz Polish and a buff ball. In this polishing tip we polish a Jeep wheel using Flitz Metal Polish and a Flitz BuffBall. The tutorial includes detailed work instructions and best practices.
In this tutorial, we learn how to speak English: The glottal stop in place of the true T. When you are saying a word like "fountain" you are using a word that has a glottal stop. If you can say two common expressions "uh-oh" and "uh-uh", then you can make a glottal stop. You need to use your throat to make this sound, it's like holding your breath but using the back of your throat to do it. Try to break the word "fountain" into two different parts so you can hear the different in your voice a...
Learn how to ride a motorcycle by performing the alternate MOST quick stop emergency braking skill. This motorcycle driving tutorial will show you how to pass the quick stop portion of the Alternate M.O.S.T skills test. Learn the layout of the test, then how to properly use your emergency brake to perform a quick stop on a motorcycle.
There is more than one way to stop on roller skates. Proper technique is important for your safety and the safety of others. Learn how to stop on roller skates in this video lesson. Take action: each skate should have toe-stop, t-stop drags one foot behind other, keeping feet in shape of letter T, and plow stop points toes towards each other. Catherine Werst, a.k.a Stray Cat from Central Coast Roller Derby and the instructor in this how-to video from Live Strong, is the coach of Derby 101 and...
Without a hockey stop you would turn into a hockey fail. So prevent yourself from splattering onto the walls or crashing into your opponent by learning how to stop while playing hockey effectively. This hockey tutorial will teach you how to perform a hockey stop on stkates.
Activating the body's own immune system to fight cancer is the goal of immunotherapy. It's less toxic than chemotherapy and works with our body's natural defenses. The trouble is, it doesn't work for most patients — only about 40% of cancer patients get a good response from immunotherapy. But coupling it with another type of cancer therapy just might deliver the punch that's needed to knock out cancer.
This how-to video offers some steps for coming to a safe stop and a quick start on a bicycle. Coming into the stop, lift the foot off the bike pedal early so you have a chance to get the foot on the ground before stopping. Use the brakes while in the stop position. Reset the pedal to the midway position while fully stopped. Keep the head up to get ready for take off, and try to get momentum going before getting the other foot back in. Watch this video cycling tutorial and learn how to start a...
Stop motion animation can actually be created at home. Build an armature out of wire and epoxy. Follow along with the step by step directions in this instructional video and learn how to build an armature. Watch this video and start shooting some stop motion animation.
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.
Reduce the stress and complications of castration on both farmers and cattle. The Callicrate Bander is a non-surgical and non-chemical way to castrate. This instructional video shows the simple steps for how to castrate livestock with Callicrate Bander, and how to keep the animals healthy and free from tetanus.
Tim Carter, of Ask the Builder, shows you how to expertly prepare and join PVC piping for a non-leak plumbing connection. Great tips for want-to-be plumbers!
Learn how to play "What's up" by the 4 Non Blondes on the guitar. Chords:
In this video tutorial you will learn to use the lasso tool to create a non-uniform vignette on your images. Learn to set the feather radius and the Hue/Saturation tool. Knowledge of layers is essential to fully understand the tutorial.
Lars shares some tips about using an orange guard non-toxic bug killer. These helpful and easy-to-understand tips will help to keep pests out of your garden. Watch video for best results.
The name may be a bit of a tongue-twister, but we're sure you'll think this healthy dish is a taste-bud twister as well! Patricia Fine, MD gives step-by-step instructions how to make non-dairy penne with fennel pumpkin pasta sauce and gives you some secret tips for keeping the sauce creamy.
Walk on water? Impossible. Walk on cornstarch? You bet! Check out this video to see what happens when you mix up a tub of cornstarch and water. It's goopy cool fun. Mix cornstarch and water in this classic experiment to form a gooey liquid and solid material that behaves like quicksand. Some people refer to this as the Oobleck recipe, others call it a Non-Newtonian fluid. After watching these video segments, you'll call it a great science lesson as your students learn about the amazing proper...
Need to make a custom, digital clock that will run in all major desktop and smartphone browsers? This tutorial shows you how to employ Javascript functions to communicate in real time with web page elements to get a slick CSS animated clock. Cool, eh?
The factorial of a number n can be defined as the product of all positive integers that are greater than 0 but less than or equal to n.
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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart function.
In this clip, learn how to access and use hidden and advanced functions on the iPad keyboard. Whether you're the proud owner of an Apple iPad or perhaps just considering picking one up, you're sure to benefit from this free video tutorial. For more information, including a detailed overview, watch this iPad user's guide.
If you just happen to have one of those SpongeBob SquarePants chatterbox toys that were distributed at fast food restaurants a while back, then you just might be able to pull of this "Evil SpongeBob Toy Prank" from mastermind Kipkay.
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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
See how to create and work with Get functions in FileMaker Pro 11. Whether you're new to FileMaker Pro database management program or just want to learn how to take advantage of FileMaker Pro 11's new features, you're sure to benefit from this free video tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, watch this handy FileMaker Pro user's guide.
Tired of the same old family recipe? Then spice up your family lasagna with a new twist — béchamel sauce. Adding béchamel sauce (a rich white sauce made milk, herbs, and other goodies) will satisfy you family's craving for a new tasty dinner dish. The OriginalNakedChef shares his recipe for his lasagna with non-traditional béchamel sauce and beef. If you're a pasta and lasagna fan, it's definitely worth trying out. Watch the video for the full recipe and ingredients.
The Canon EOS 7D digital SLR is the first Canon EOS camera that can trigger off-camera Speedlites with the cameras build in flash. The integrated Speedlite transmitter is fully compatible with the Wireless E-TTL Flash System. See exactly how all this works and how to use your flash 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 and Mr. Excel, the 627th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create, edit and otherwise work with FREQUENCY array functions.
Need some help figuring out how to find the slope of a linear function? See how it's done with this free video algebra lesson. Need help finding the 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 S...
Need to solve a linear function? See how it's done with this free video math lesson. Need help finding the 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...
Learn how to add numbers using the SUM and AutoSUM functions within Microsoft Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the SUM and AutoSUM functions in your own Excel projects, watch this free video guide.
