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 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...
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 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...
In this how-to video, you will learn now to dismantle an iPod Nano 3rd Generation. First, run a plastic tool on both sides of the device. Once this is done, remove the back cover with your fingers. Next, unscrew the six screws on the circuit board. Store them in a place where they will not be lost. Next, remove the click wheel ribbon cable from the jaw connector. Lift the jaw connector with the tool and use a pair of tweezers to gently remove the cable from the jaw. Next, remove the small met...
In order to clean and restore your headlights, you will need the following materials: razor blades, tape, liquid rubbing compound, and a power polisher.
In this video tutorial, viewers learn how to make a tea bag fly with a home experiment. Viewers learn how to make a tea bag fly using convection. The materials required for this experiment are: tea bags, matches, tin foil and scissors. Begin by cutting the top of the tea bag and open it. Empty out the tea. The tea bag should be a cylinder shape. Place the tea bag on top of a piece of tinfoil and use your matches to light the top of the tea bag. This video will benefit those viewers who enjoy ...
Magicinwords teaches viewers how to change their facebook network! First, you will want to log onto Facebook.com. When signed in, go to the settings tab on the right of the screen. Under this, click on 'account settings'. Under account settings choose the tab that reads 'networks'. Here, you can click 'change your region' and then you can update it. Be sure this is right though, you can only change your regional network twice every 60 days. Under this same tab, you can also join any other net...
In this video, you will learn the best way to throw cards. This takes practice, as many people who first try to throw card do not have the right grip. In order to throw the card properly, you will need to place your thumb on the center of the top side and the index finger on the corner. When you throw the card, use your index finger to create spin. You can use your wrist to add more power, or put your entire arm into it to increase throwing distance. You must work up to using your entire arm....
In this tutorial, we learn how to install a replacement LCD screen on a Blackberry Pearl. First remove the cover and battery from the phone. Then, you will take a tool and remove the clips from the left and right side of the back to remove the bottom. You will now find two more screws that need to be removed from the phone that are on the top. Once done, you will nee to pry open the top and bottom of the phone and take it apart. You can now remove the motherboard from the casing which is wher...
In this video tutorial, viewers learn how to make Sada Roti. The ingredients required are: 3 cups of all purpose flour, 1 tsp of baking powder, 1-2 cups of water and a dash of salt. Mix all the ingredients together to form a dough mixture. Then cover the bowl with the mixture for 15-20 minutes. Then break the dough into 3 pieces and flatten each of the with roller. Now cook on an oven at medium-high temperature 2-3 minutes on each side. Finish by placing it in the microwave for 1 minute on hi...
In this video, we learn how to kill and cook lobster. It's much more humane to kill a lobster before cooking it, so it has a quick death instead of boiling to death. First, you want to freeze the lobster for 20 minutes, which will numb it down and slow down its movements. Place the lobster on its back and grab a sharp knife. Now, chop into the lobster and chop all the way down until you slice through its head. You can now throw the lobster on the grill or in a steamer basket. It will move sli...
Rick Steinow shows how to detect bedbugs using tape. Rick shows that obvious signs would be fecal matter and blood stains. If you're still unable to detect bed bugs, you can purchase a roll of double-sided carpet tape. You're also going to need a roll of painters tape. Apply a strip of the double-sided tape all the way around the mattress. Place another strip of tape around the head board. Make sure to add a strip of painters tape first when doing the headboard. You'll do this because the dou...
A whole is drilled into the cap of a barrel with a 3 1/4 inch bit and another one an inch or more below the top and one of 3 inches width on the next side. Spreaded adapters ends are wrapped with plumbers tape; to prevent water leaks. The ends are then screwed together and placed into the top hole in the barrel. The spiget is held into the side hole with a piece of pvc pipe and a garden hose is attached. A funnel is made with a piece of window screen mesh slightly bigger than a pvc pipe it co...
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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.
This video explains how to solve several problems associated with gardening in arid environments. Rhubarb is a plant that is commonly grown in colder environments. In arid environments, its very important to not over water it, so keep it in a sandy soil with lots of organic compost material. Plants such as the peace lily also need well irrigated soil, so it is important to pot it in an organic potting soil in a location that allows the water to drain away from the pot instead of soaking back ...
In this video, we learn how to identify common tree problems. If you use too much fertilizer you can find a burn scar that is left on the bark of the tree. You can avoid this by making sure fertilizer spikes are placed away from the tree. Tree splitting is also an obvious sign that a tree is in bad shape and needs to be cut and taken down. A common leaf problem is Pear Slug Damage. A great way to help this to use wood ash on the tree, which will kill the insects that cause this and it's safe ...
This video demonstrates how to make a funky yarn pom pom. Take a yarn of your choice that matches your scarf. Take one end of the string and start winding it not too tightly around your fingers. Leave back enough string for the pom pom for the other end. Cut the string using a pair of scissors and set it aside taking care not to mess the ball. Cut another piece of string with appropriate length that goes around the ball of string kept aside. Place the cut string over the table and place the b...
Jennisse shows how to do your nails ‘Fruit Style’, using acrylic glitter, in this tutorial. She begins by taking the natural shine away and bowing the nails down. A few coats of acid-free protein primer are then applied onto the nail beds. Next, some bright green acrylic glitter is taken onto a small brush and applied side to side, at the point where nail grows beyond the finger line. The nail is turned over to create a smile line. Then a thin coat of yellow glitter is added next, halfway beh...
This video shows that it is possible to plant 100 tulip bulbs in less than 50 minutes, and it is easier and less expensive than you think.
This video is about how to supplement water in the desert using a trash bag. You find a tree that is edible and not poisonous and you open the trash bag and place it over a few of the branches with leaves and seal the opening off. Then you take a little cord and tie off the corner of the bag and find something heavy to weigh the branch down. You want to make sure the corner of the bag is down so that all of the water will run down to that corner. When you feel some water in the bag you can cu...
A good place to start when you want to learn how to find a midpoint of a line is a circle. Take the diameter of a circle, for instance if the coordinates of the starting point are (1,6) and the coordinates for the ending point are (11,6). The midpoint of a line is the exact central point where a line through these two points would meet. Now the value of y is a constant one as the line runs parallel to the x-axis, the value of x changes by 10, the half of which is 5, this is not the midpoint t...
This is a video tutorial describing how to use a microdermabrasion tool to induce flawless skin. The first step is to wash your face and pat it dry. Next you should use a facial rejuvenation formula lotion and place it on the parts of your face that you think need the most work. You can even put some of the lotion on the microdermabrasion brush. Then you should set the timer on the brush to two minutes and begin to brush it across your face. You should only use the brush two to three times a ...
In this video tutorial, viewers learn how to make a char cloth. The materials required for this process are: cloth, container and tinder. The cloth must be made of any woven, cotton material. Begin by placing the cloth into a container. The container should be a metal material. Then close the container and make a while on top to allow the smoke and flames to escape. Leave the container in some fire and wait for it to finish. Then take it to cool and take out the cloth. Now strike some spark o...
Yo-yo's are not just for kids anymore. Check out this funky tutorial and learn how to yo-yo like a pro. You can do way more than just pull your yo-yo up and down, with a little practice you will soon be performing tricks and spinning your yo-yo all over the place!
You don't need a fancy panini press to make a good panini! Check out this video for tips on how to make yummy grilled sandwiches using items you already have in your kitchen. Save time and money with this method!
Stuck on one side of a river or ditch? If you are stranded with no other way to get to your destination you will need to build a bridge! Without many supplies, your best bet is a beam bridge which can be made with just a single piece of wood. This video will show you how to get from one place to another.
If you are stuck in the wild and run out of matches, dip into your food supply and start a fire that way. This handy tutorial will show you how to stay warm with nothing but a can and a chocolate bar.
Quitting smoking is incredibly difficult. It's hard enough to break the habit, but the withdrawals are even worse. In this tutorial, learn how to make the transition a little more bearable.
If your a kid or adult it's never too late to learn how to do a somersault, although it might be a little more difficult for the latter. Somersaults are one of the first and easiest things you can learn in gymnastics. If your ready to turn your world upside down, then get somersaulting.
You don't have to eat out just to get to enjoy this impressive layered treat. You can add a decadent finish to your next dinner by showing your family your culinary skills and unveiling a homemade tiramisu for dessert.
Here's a fun experiment you can do that will demonstrate the effects that pressure has on the freezing point of a liquid. You will amaze your friends as you do what seems to be impossible, turning water into ice without sticking it in the freezer.
Here's a classic throw-back to times past with a timeless game of kick the can. Just because you don't need expensive equipment doesn't mean you can't have tons of fun. You can play this game just about anywhere.
If you're Christian or Catholic you're probably familiar with the infamous Hail Mary prayer. It doesn't require much. Just memorize the prayer and the next time you find yourself in need you will know just what to say.
Each player starts with 15 marbles that are a color distinct from his opponents marbles. Toss a coin to choose a start line, placed 3 meters from the hole. The players then take turns shooting marbles, first from the start lines, then from wherever the marbles land on the field, all the while trying to make their marbles in to the hole. The player to shoot all his marbles in to the hole first wins. In a case where both players have 1 marble left and the final shot is made by the person who to...
This is a delicious and very simple salmon with mango recipe that couldn't be easier to prepare. Not only does it taste great, it looks even better.
Adrienne shows how to quickly make a delicious snack using one of the most nutritious foods around in this video. Wash large and fresh ocean artichoke with water. Trim its stem and snip its leaves with kitchen knife or scissors. Trim the top part with knife. Microwave about 3 cups of water with the artichoke until boiling. After 5 minutes, cover it with Pyrex bowl and microwave it for about 15 minutes. Let it cool and separate leaves from the choke and place it in a food storage bag. Put butt...
Using multiple layers of clay, garden of imagination shows how to make a hamburger and fries out of polymer clay. This decorative item would then be placed into a miniature dollhouse being displayed as a food item. She rolls a peppercorn on brown clay to give it the texture of meat. She mixes together green and whit clay for lettuce, and uses another piece of clay to ruffle the edges of the lettuce. She uses small round cuts of clay for tomatoes. Using an embroidery needle with a clay handle ...
Take the clay, roll it out to make a pretty thin sheet. Take the square cutter and cut out two pieces from the clay sheet. Meet opposite corners of each square to form a triangular form but squishing only in the middle. Bend slightly outwards the unsquished corners of each triangle for decorative purposes. Place the triangles facing each other with the squished corner overlapping, pressing and joining them in one single piece. Take another little piece of clay and make a small ball with it. P...
