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.
There are many different things that could contribute to a power or gas outage or accident in your home. To be properly prepared for an emergency or other situations that endanger you, take a look at this video from SDGE on simple tips to keep safe, including discovering gas leaks and using power generators to maintain eletricity in your home during an outage.
In the mood to play your favorite Game Boy, SNES or Sega Genesis game? If the cartridges have been sitting around for a while, they probably need cleaning. Watch this video to learn how to properly clean a video game cartridge.
This video shows you a few stretches you can use that focus on your abdominal muscles. These practices will also help strengthen this area of your body. Make sure that you are breathing properly while performing these exercises, and be aware of where your feet are!
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.
If you spend a lot of time alone or close to it in the wilderness, then hopefully you already know how important it is to bring a properly packed survival kit. This is true for offroading enthusiasts as well as pedestrian outdoorsman, but the kit requires some great specifically related to your being in a 4x4. This video will show you what you should pack in your 4x4 offroad recovery kit and explains why this stuff will keep you safe.
The TB-303 is nothing short of legendary on the electronic music scene. It is possible there would be no such thing as house music without it. They are rare and extremely complicated, so if you're lucky enough to have one you should pursue whatever help you can get on playing it properly. Enter this video, which will teach you how to quickly and easily program your 303 and get on your way to making phat old-skool tracks.
D.Gray-Man is still going in manga from, although unfortunately the anime show is done. It did leave us with this amazing song though, called "Musician". Watch this video to learn how to play it perfectly on piano and show you love for Allen Walker properly.
Fireworks are beautiful, but they can be extremely difficult to capture on digital cameras. This tutorial for digital photographers shows you how to optimize your DSLR camera's settings and use just the right techniques so you can get the most out of your next fireworks shoot.
If you've done enough Brazilian Jiu Jitsu to know what a flower sweep is, then you've probably had the problem where you can't bring your foot around for the sweep properly. Watch this video to learn how to maneuver from the failed sweep into an armbar and end the fight.
Fishing is a great way of saving you money on having to pay for over priced pre-cleaned fish at the grocery store, it's also a way to relax and enjoy nature. If you're planning on heading on down to your local stream to get some fish, take these tips into consideration. In this video you will get some tips on what sort of physical characteristics of the stream are and also what sort of fish to expect in what types of waters.
In this video, we learn the basics of breastfeeding and how to do it. Breastfeeding is natural and it helps connect the mom to her baby and give proper nutrition to the baby during the most critical months of their life. You will first need to start a technique of hot to breastfeed the baby and what works best for you. You may need to have a midwife help guide you or a counselor to help you learn how to breastfeed properly. You want to position your baby so their head properly hits the right ...
Xtracharts, a control for Winforms, allows the user to easily export charts made using the program into a PDF, HTML or MHT, Excel spreadsheet or standard image. This tutorial shows the Winforms user how to properly code and then export the chart.
A truly mesmerizing trick if performed right, the "This 'N That" magic trick is a demanding trick that requires a great amount of technique. This video will go into great deal explaining each step of the trick and also breaks apart the way you'll be approaching the spectators and where to go with each step.
Eggplant has been prized for being a delicious, nutritious and versatile food, used in many dishes. The easist recipe to make is to fry fresh eggplant as a side dish. Properly prepare your eggplant by cutting and frying it in oil until golden brown for a tasty addition to any meal. For extra flavor, add some spices to the cooking oil!
The pool hall is one of the most traditional places to meet and socialize with others in both East and West. If your crappy pool skills keep you from enjoying your time out at the pool hall properly, try pulling some of these pranks on people better than you! They range from the extremely simple beat-me-without-scratching gambit and other tricks that defy convenient naming but are hilarious and involve both pool and beer.
If you're playing as a Terran in StarCraft 2: Wings of Liberty, then you're going to have to deal with those pesky Zergs. This video will show you how to stop a Zerg baneling bust as a Terran. The Terran needs to scout early for a baneling bust so he can properly defend it. This game happened on Steppes of War, which is an optimal baneling bust map.
If you have a damaged toilet tank fill valve, you'll need to replace it as soon as possible. It's an important part to your toilet that makes sure your toilet is working properly.
Performing regular maintenance on your bike is something that should be done to help extend the life. Not doing so can result in pieces working improperly, falling off, or lead to injury.
One of the big responsibilities when owning a car, bike, or anything is making sure that it is taken well care of. Bicycle's, just like cars, need their parts to be well taken care of using the right tools.
In this free video language lesson, you'll learn how to say "excuse me" in perfect Japanese. With Japanese, as with any other language, a few key nouns and phrases (and knowing how to properly pronounce them) can go a long way. For more information, and to get started speaking Japanese yourself, watch this video tutorial.
In this tutorial, we learn how to properly tie a winter scarf. First, take a long scarf and wrap it around the back of your neck. Next, take the short side of your scarf and place it in your left hand and place the long side of the scarf in your right hand. Now, cross the two and hold the bottom with your right hand. Next, wrap the long side around the back of your neck while holding the side with your right hand. Put the long side through the loop in the scarf and then pull down so the scarf...
In this video, Jenny Jones talks about produce. Make sure you know where to put all those veggies when you get into your kitchen. Storing veg the right way will make it last much longer and taste better. Don't lose any of that fresh, healthy taste. Store your veggies the right way by following these tips.
Cheryl Cole is known for her many talents, but her hairstyles tend to get overlooked, but the fact is, Cole has had some wonderful, elegant hairdos in her lifetime, one of which is her blow-dried hair. Primp Powder Pout provides this hairstyling tutorial to teach you how to recreate the blow-dry hairdo which Cole effortlessly flaunts. If you do this properly, this look could last a couple days!
Caulking can seem like a tough job that requires a lot of patience and skill. In fact, it only requires a couple of tools: caulk, some tape, and a wet rag. In this tutorial from the DIY network, you'll find out how to caulk like a pro using those tools listed. It's an easy task that will have your kitchen or bath looking brand new. Good luck and enjoy!
Sure, there are other origami fish tutorials out there, but they're usually either difficult and long, or short and unsatisfying. Find the perfect medium with this origami video. You just need one sheet of origami paper, like most paper folding projects, and the instructions in this video. Try pausing after each fold to make sure you learn this fish properly.
Wolverine is unquestionably the most popular member of the X-Men superhero team created by Marvel. If you like Legos, the chances that you also like the X-Men are pretty good. Combine your two loves by watching this video, which walks you through the process of making a Lego minifigure of Wolverine using only paint, some paper, and a properly-colored Lego minifigure.
Eating the proper food before you work out is crucial for your body having enough energy to excel. This video features a nutritionist explaining why fueling up before a workout is so important, then breaking down what you should eat to fuel up depending on how long you have until your workout.
In this clip, learn how to drape the front and back bodice on a dress form for fashion design. In order to sew your designs properly, you will need to be versed in draping. This video will explain to you exactly how to do this relatively simple process and you will be on your way to becoming the next Tom Ford or Vera Wang.
Bunting is one of the most beautiful, most finesse-requisite parts of the small-ball game that has been enjoying a resurgence in the post-steroid era of Major League Baseball. This video features MLB outfielder Travis Buck explaining when and how to bunt a baseball, including how to analyze a situation to determine if a bunt is appropriate and how to place a bunt where you need it to be to create the play that you want.
Donnie Edwards is one of the premier linebackers in the NFL. In this video, he teaches some young linebackers how to take on a block from a offensive lineman properly, allowing you to get more penetration when rushing the quarterback or get to the runner if attempting to make an open field tackle.
There are a lot of different types of sutures out there, as any of your doctors, nurses, and medical students know, and performing them properly is a vital part of your job. This video details how to perform a figure of eight suture on a surgical patient. It is definitely made for the professional or student, so please, do not try this at home!
While the front brakes get all the love and attention, the back brakes of your mountain bike are nearly just as important and more difficult to install. You have to run the hose all the way across the bike without it getting in the way of your feet or any other parts of the bike! This video shows you how to install the rear brake hose properly, whether the bike has brake hose guides on it or not.
Ledgers and feeders are important parts of bait preparation, and thus crucial to successful fishing as a whole. This video features a professional fisherman explaining how to use these two tools to bait your pole properly, maximizing your baits performance, your fish catches, and the amount of fun and relaxation that you and your friends can derive from a day spent fishing.
Check out this tutorial for tips and advice on how to combat and upgrade in Batman: Arkham Asylum. This game is so fun and even better when you have these expert tips from IGN. Combat and upgrade starter tips for the Dark Knight in all of us.
