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 193rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM and VLOOKUP functions to create a grade book based on a given total score that will automatically calculate grades.
An associate from Garden Years discusses the danger frost poses to small, outdoor plants. Since you don't have a lot of control over the weather, there are a few tips you can follow to try an avoid any unwanted damage to existing plants. The host examines a peach tree to identify when a plant is blooming and thus very delicate. If a plant is fully blooming, then any temperature below freezing (32 f) can damage the blossoms. Aside from putting cloth over the plant, mulch is also very helpful i...
Love4Nails demonstrates how to paint nails with a pink and white sparkly design. First, apply a hydrating base coat. On top of the base coat, apply the color of your choice like a light pink color. Then, create the side swipe which is about half of the nail. Create a straight side swipe in a white color. You may need to do two coats. Then, create a flower with the background color on the white polish. Add a pink rhinestone to the flower. Repeat the technique making a white flower on the pink ...
ARHSphysics shows viewers how they can build a simple barometer using household items! First, you need to get a container that is the height of an index card. Your best bet is to get an empty soup can of food can. Make sure you wash the can. Now, you will need a latex glove, cut a semi circle from the glove and attach this to the top of the can using a rubber band. Get two straws and attach them together at the ends. Cut a slit in each one and attach the straws. Attach the straw to the top of...
In this video, Mr. G demonstrates how to draw a wintery snowflake. You will need a plain pencil, or a blue and black colored pencil for this drawing. Start by writing your name and the date on a white sheet of paper. Then, begin lightly drawing the base of your snowflake. After you have drawn your base, Mr. G will show you how to make the lines darker to form the shape of your snowflake. Then, you will learn how to detail your snowflake by drawing small triangles inside the basic shape that y...
This video is about how to paint your nails with a colorful checker art design. The first thing that you will have to do is to apply the hydrating base coat on your nail. After putting the hydrating base coat on your nail, get a piece of paper for you to place the black nail polish. After placing the black nail polish on the paper, use the dotting tool and place a series of zigzags on the nail. The next step is to fill in the zigzags depending on the color you want. After filling in, make a s...
In this video you will learn how to wax, tune, and DE-tune your snowboard. The first thing you're going for tuning and DE-tuning your board is to take a bill file and file your board right where it starts to curve (do this on every corner of your board). Then when you're ready to clean the base of your board you take your base citrus cleaner and pour some onto a rag and wipe it on the board until its clean. Then when you're ready to wax your board take your wax and melt it over the board usin...
She teaches us how to make a beautiful jewelry pendant for a necklace out of polymer clay. She starts with kneading a black base. She then sends it through a pasta machine. After she has a black flat sheet she rolls it into a ball again. Then, she takes the other five colors and starts rolling tiny little ball. She attaches them to the base black ball. Next, she creates a snake with the colors swirling around. She sends it back through the pasta machine to create a perfectly flat surface. To ...
The chef shows how to prepare and cook a perfect roast chicken. Begin by rubbing sliced garlic over the skin of the chicken. Then place the garlic into the cavity, along with some thyme and sliced lemon. Rub the chicken with olive oil and sprinkle with pepper and rock salt.
First, begin by drawing a big circle in the middle of the page. Then draw a smaller circle (about a third the size of the bigger one) above your first circle. This will be the head. Next draw two lines where you want the arms to be, and one leg on the right side. Next draw two big eyes and a big half circle mouth as well as a little curl (for the tail) on the left side, opposite the leg. In heavier ink trace over the head and face and begin to draw arms around the arm lines you drew earlier. ...
Viewers learn that a net is the shape formed by "unfolding" a 3-dimensional figure, so a net shows all the faces that make up the surface area of the figure. Viewers are then asked to determine what type of 3-dimensional figure can be made from a given net (note that a cylinder has 2 circular bases, a pyramid has triangular faces, a cone has 1 circular base, and a prism has rectangular faces). Students are also asked to determine if a given net can be used to make a cube. This video will bene...
I bet you could use a pair of ripped arms, right? Well if you have three minutes and some weights you can be there in no time. This video will demonstrate exactly how to get ripped arms with a daily 3 minute workout.
To cook pumpkin flowers you need some pumpkin flowers and some of the smaller more tender leaves from the pumpkin patch. First thing is to take off the little spiny things from the base of the flower. Then you want to pop the top of the flower off at base of the stem. Remember to save the stems, open up the flower gently and pluck out the thing in the middle. You want to pick off the spinets on the back of leaves, wash them rubbing them to soften the leaves up. Then you would take the stem an...
First neatly draw the outline of the pig, then color the outline with a darker shade as this is the base of the character. Next draw the eyes, nose, and the small curly tail which complete the outline of the pig. For the base color a slightly bright pink color should be selected to shade the inner part of the pig i.e. the stomach, legs, and face. A shiny touch should be added to the face to give it a brighter and happier appearance. The background must be colored also with blue and brown. The...
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...
First, apply base coat to your nails. Then apply 2 coats of pink bubble gum acrylic paint to the nails. Then use a thin brush to draw an off centered cross on the nail with caramel candy acrylic paint. Using a dotting tool, apply hot pink and metallic antique copper acrylic paint in alternating dots along the cross. Then use the caramel candy color again and make a bow in the center of the cross and outline it with brown oxide paint. Let the paint dry and then apply a coat of base coat to sea...
This video shows the detailed procedure to line a cake tin. Firstly, the demonstrator cuts off a square paper just smaller than the base of the tin. Then she measures off a length of paper for covering the sides. She folds it in half lengthwise twice. After careful folding and cutting off small triangular portions at the folds, she then skillfully places it to cover the sides completely. The last step in the procedure is to place the square paper for the base. She thus lines the cake tin full...
Cleaning makeup brush rolls can be quite challenging and frustrating. MakeupByRenRen teaches us an easy and quick technique on how she cleans her sigma makeup brush rolls. Things you will need: an oil-based facial cleanser or a regular olive oil and paper towel. Grab a paper towel and damp it with your oil-based facial cleanser or regular olive oil. Gently rub the paper towel on the surface of your dirty makeup brush rolls. Make sure that you go in every direction to effectively remove all th...
Interested in sketching and drawing some sceneries? We could start it with a palm tree on a beach scene. You'll require a piece of paper, a pencil and a sketch pen. First draw the base (trunk). Then add some details with circular lines going along the trunk. Then we could start up with the coconuts as well as their details to give a rough effect. Now comes the highlight of the palm-tree leaves which have to be drawn properly to have that edgy effect. Finally add some details on the base of th...
BeautifulYou TV presents how a watermelon nail art design is painted. The nail painting starts off with a white line drawn between the base and the tip of the fingernail. Pink is used to cover the base and light green for the section from the white line moving towards the fingernail tip. Streaks of dark green nail polish are then painted on the light green section to give the look of a watermelon. To decorate the watermelon with seeds, draw black tear-shaped designs on the pink section and cr...
May Paris teaches how to use and apply gold foil on your nails. First step is to apply the base coat as it protects from some harm. Carefully tear the foil in small parts. Now apply brown nail color(or any other color you wish) on the base coat of your nails. Let it dry and use tweezers to pick up the foil. Stick the foil very carefully to your nails as shown. Let it dry and follow the same procedure for all of your nails. Finally apply the top coat to secure the foil as shown. The foil can b...
If your into data based business,then this one's for you. Text field's are very much important while making a data based solution in FileMaker Pro 10.You can go to file menu>manage>database and there is the field's tab. Text field is used for storing text and no other such use. Text field's can hold up to 2GB of information. It can help to store raw data and formatting information, i.e., color,point size as well as type face.
Cool tips and tricks on Facebook give you some extra edge on others. This trick will demonstrate that how to talk to your special loved ones that no one else can understand.
This video gives a brief description of how to prepare and cook baby artichokes. Baby artichokes vary in size based on the season, may being the best month to get them. To avoid getting a bitter flavor from your artichokes be sure to remove the skin, this is best accomplishes by brushing,rinsing, peeling, and cutting all of the green outer layer until you can see the pale yellow inside. To preserve the color of your allow them to sit in lemon or vinegar water and drain completely when done. C...
Watch this video to learn how to draw a right trapezoid using given specifications for lengths of sides. A right trapezoid is a four-sided shape with two right angles and two parallel sides. First, draw the long base. Then draw a 90 degree angle at one end of the base, using a protractor. Mark the angle to show it is 90 degrees. Then draw another 90 degree angle at the top. This is the first video in a set--to finish learning you must watch the next segment. If you watch these videos you will...
In this video Jordan Reimer and Twisted Publications show the viewer how to make mini pumpkin pies. For the pastry base you will need a mini muffin pan, cutters and puff pastry, and for the filling you will need a can of pumpkin, half and half milk, eggs, vanilla, nutmeg, cloves, cinnamon, brown sugar, which is whisked together and ladled into the pastry base. Bake for 20 minutes at 370-375 degrees.
This is one of the biggest mistakes women make when it comes to eyebrows. Many women become overly aggressive when it comes to plucking their brows and end up with thin or almost nonexistent brow hairs. Unfortunately, eyebrow hairs can take months to grow back and, in some cases, plucked eyebrow hairs may not grow back at all, particularly after years of over plucking. Stop plucking and give your eyebrows a chance to grow back to their natural state. In the meantime, you can use a soft eyebro...
To make the soap you will need some soap base cut into little bricks so it's easier to melt, a color brick, scent, a knife, a ladle, and some molds. Take some of the soap base blocks and put them in your crock pot. Let it cook for a hour or until it turns into soup. Put in one of the dye color bricks so that you get some color. Put in one cap full of the fragrance. Mix it all up with the ladle. Let the dye brick melt until you have the color you desire and then take it out. Take some of the s...
In this video the tutor shows how to find the volume of a cylinder. He relates the cylinder to real world examples of cans etc. Now he states the formula of the volume of the cylinder as the area of the base circle multiplied by the height of the cylinder. So the formula turns out to be V = Pi * r * r * h, where r is the radius of the base circle and h is the height of the cylinder. He solves a sample example to give you the idea of the problem. This video shows you how to find out the volume...
In this tutorial the instructor shows how to compute the Surface Area of a Cone. He explains that you need to find the individual surfaces areas first. Hence the bottom part of the cone which is circular can be calculated as Pi*r*r, where r is the radius of the base circle. Now for the sides surface of the cone, it looks like a sector and he derives its area thorough some deduction. Now he adds both the base surface area of the cone, and the lateral surface of the cone which finally gives the...
In this tutorial the author shows how to find the area of Rectangles, Triangles and Parallelograms. He says that an area of a figure is nothing but the amount of space taken up by that figure. He now explains that the area of rectangle is length times the breadth. He demonstrates it with an example. Now he says that an area of a parallelogram is base times height. He also demonstrates how to find the area of a parallelogram. Finally he shows the area of a triangle is half times the product of...
This video is about how to draw a cartoon violin. For this you have to remember only a very few easy steps that are the following: (1)Draw a base for the violin. (2)Draw a chin rest. (3)Draw the neck. (4)Draw strings for the cartoon violin. (4)Add graphics, such as outlining the base one more time, making simple designs. Your cartoon violin is ready in just a very few simple steps. Its benefit is viewers can learn the easiest steps to draw a violin.
In this how-to video you learn how to apply neon color nail polish. The process begins by applying a base white coat and allowing it to dry. You use white because it brings out the neon the best. Once you have the base coat you begin applying the neon colors in any design of your choosing. If you use an outline it helps solidify your design and the results are much clearer. The entire process takes about six to seven minuets and is perfect for teenage girls.
The video describes the "Calculation of the surface area of the cone without a slant". If the base circle diameter (d) and the height of the cone (h) are known, then the following procedure can be used for finding out the surface area oh the cone:
To create Converse shoes nail design, you will first apply a base coat in the color you want the shoe to be. Tape off to create a shoe top and paint white. Pull off the tape, but not too soon or line will be uneven. Take a darker color of base coat make a curve on both sides leaving the middle so it's shaded. Repeat on the other side. Using black outline the white nail tip. Using silver make circles, while the polish is tacky make holes in the circles. Using white make little lines for stitch...
Watermelon end of summer nails! All the things you need for this super easy design. apply your base coat first for nails. Apply neon pink base color it is not very watermelon like but it is so summary. Make a French tip with a green nail polish. It divides the pink and green with a thin white line. It is best to use a thin art brush. It make the seeds with black art polish and enjoy the last days of summer time hope you liked this design to you.
Do you win the prize for messiest room in America? That's a difficult contest, but how about messiest room in your house? It’s time to clean your room, so do a good job in the shortest amount of time and get your parents off your back.
Learn to make an easy, winnable bet with a glass of water by watching this video tutorial. First, take a piece of cloth and set it on a table, preferably one that you have bottom side access to, then take an ordinary cup and fill it with water and set it on top of the piece of cloth. Second, take a hat that would fit over the water-filled glass completely and cover it with the hat. Don't touch the hat in any way after it is placed. Proceed to bend underneath the table so you can pretend your ...
Running low on cash in FarmVille? Sell some items and trees, and make it to your next harvest. This video tutorial shows how to sell items in FarmVille. While crops and plots can only be deleted, selling items and trees is a great way to make some quick cash if you're running low. The sell action is also the way to check the value of your various items, so even if you're set on coins, this is a great video to watch for the Farm Ville hopeful.
By monitoring your FarmVille feed on Facebook, you can get a bunch of free stuff for your farm! Be careful though, if you are too ambitious, there won't be anything for anyone else!
