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 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.
This video tutorial shows how to draw a serene waterfall setting using graphite pencil. First start by collecting reference images for the seperate components of the landscape. Next add in the rocks and erase the areas where water will be. Then draw the sky making sure to leave an area open for the moon. Finally add the trees and shade in the water to create a liquid effect.
This is a video showing how to do hair in a 1980s style in less than 2 minutes. It is the Goth style of hair, like in Edward Scissorhands. All that is necessary is to use a French barrette. She pulls all her hair up on top of her head and then she clips it from underneath. She then continues to pull it however she feels like. She says if it is necessary hairspray can be used. She makes reference to her website The Coveted. She says that it is a really easy technique to use without actually ha...
In this video tutorial, viewers learn how to cite a cereal box in MLA 2009. citation is a reference to a published or unpublished source. In general, a citation requires the author's name, publication information and medium type. Start by examining the entire cereal box for the information. Look on the front, back, sides, top, bottom and even inside. Usually, users will only be able to find title, medium, corporate sponsor and place of publication. This video will benefit those viewers who ar...
Learn how to properly flat iron your hair with Benjamin Lobol. If your hair is curly, start by blowing out your hair with a flat or round brush to smooth it out. The tools you will need are flat bill clips, a heat resistant comb, a flat iron, hair serum, heat spray. Section your hair into the front and back sections, using your ears as a reference point. In the back, create two more sections - the top and the bottom. Start by slowly flat ironing small sections of the back. Once you are done, ...
Have a passion for photography but know nothing about the basics? This video might be a great place to start on the topic of shutter speed. Shutter speed is the amount of time that the film, or your digital sensor, is exposed to the light. Whether it be outdoors, at night, or low indoor light, the shutter speed allows your camera to take a photograph with the correct amount of exposure in reference to how much light is readily available in your setting.
In this video from Polymer Clay Productions, we are shown how to make earrings out of polymer clay marshmallow Peeps. They use holographic yellow glitter for the sugar, polymer clay, and Sunny Side Up yellow coloring. Use a clay color and glitter color that match. Have some real Peeps handy for reference.
The video is a straight forward Photoshop tutorial on how to create a Christmas ornament. The video shows you how to do this with very simple shapes, gradients, and a few layers. All you have to do is keep up the simple instructions. The finished product is very pleasing to the eye, a glossy, shiny, Christmas ornament. The video also provides a link to an external website where the Photoshop project files can be downloaded for reference and are easily customized.
If you are looking to improve your Photoshop skills by learning how to digital paint in it, this video shows you how to do it. To do this, open a new Photoshop canvas and select your brush to paint with. In this example the author shows how to paint a pear for demonstration purposes. You start by drawing a rough sketch, just using your paint brush and reference an image of a pear that you find in this tutorial. Now do the dark textured work on the non lighting side as shown in the video. Now ...
Danby Taylor from the University of Maryland University College teaches how to write an abstract research paper for graduate school Analyze the things that you read so you can extract the essential information such as the goal or the purpose of the reading in your own sentence. Learn the methods or ways of how the author studied the subject and reached the results of the study. Pay attention to details and write in a block paragraph, without indentations. Write one or two sentences about each...
Looking for a pumpkin pie recipe with exact directions for making it? Here's the video you have been looking for! Exact steps are given, begin with precise ingredients. Next you will get a list of utensils needed. A nice feature of this video is not only to watch the steps in the video, but the directions are also written on the screen, making it easy to write the steps and ingredients down for future reference. This is a made from scratch recipe, so fresh pumpkin is used. Holiday traditions ...
You've boxed up and shipped all your other possessions for the big move and all you're left with is the little issue of how your getting your car there. There are companies out there that will ship your car to you, just make sure your car is prepped for the journey.
It's easy to find yourself drowning in a pile of papers and nick-nacks if you're not armed with a good organization system. By taking the time to set up a system where everything is condensed and has a place you'll find it much easier to keep it that way.
A new repository appeared in Microsoft's GitHub account a few months ago for a project called HoloJS. For those JavaScript developers out there that have been wanting to make HoloLens apps, this one's for you.
The first step in any After Effects CS5 project is importing your footage and setting up a custom composition with reference to the technical settings of your individual clips. Learn how it's done with this video tutorial.
In this tutorial, we learn how to draw Sonic the Werehog. Start by drawing the outline of the character, making sure to draw in the spiked hair on the back of the head. Then, draw in the circle for the head and use crossing lines to reference where you want the features of the face to go. Draw in the features and then add in more detail to them as well. Erase the background lines and then draw in the details of the body. From here, color in the body and then shade in corners to make it look m...
In this video, we learn how to draw Darth Vader from Star Wars. Start out by drawing the outline for the body, then draw in reference lines around to figure out where the facial features will go. From here, use a darker paint brush to make the outline darker and then erase any background lines. Then, start to add in the details to the body as well as to the outfit of the costume. Color in the background and then draw on the muscular details to the body. Add in color to the body and the cape t...
In this tutorial, we learn how to draw the 8-Tails Jinchuuriki, Killerbee. Start out by drawing the outline of the character. You want to make sure you draw reference lines on the head so you know where to place the eyes, nose, and lips. Next, you will start to draw in lines to show wrinkles on the face and then the headband on the top of the head. After this, add some shading into the face to add some depth. From here, you will draw in the hair and the band around the head, giving it more de...
In this video, we learn how to draw wolf eyes. Start out by drawing the outline for the wolf head. Then you will draw the eyes in an almond shape dragging downward on the nose. After this, zoom in on the eyes with the computer and then fill in darker lines around the eyes. Draw in the pupils on the eyes and add in the details for the corners of the eyes as well. If you want to draw wolf eyes from a side view, draw the outline of the head to give you reference, then draw the shape of one of th...
In this tutorial, we learn how to make a Duct tape hat. First, grab a hat that you want to duplicate and measure it out with a piece of paper. Then use this piece of paper as reference to how you will cut your pieces of duct tape. Now, cut the duct tape and stick them together to create the top of the hat. After this, you will connect the other areas of the hat together and make the bill of the hat. This will need to be thicker than the other areas and you will also have to cut it into a curv...
In this video, we learn how to draw anime eyes in MS Paint. First, draw the round circle for the head and draw a line in the middle for reference of where the eyes will go. To draw large eyes, draw two round circles and then a small pupil at the top. Color the pupils in black and color the rest any color you'd like. For female eyes, make the pupils much larger and add in eyelashes on the eyelids. Shade in underneath the lids and add white to show they are glossy. These are both great looks fo...
In this video we learn how to draw the iris of an eye. First, draw the outline of the eye and then draw the first layer of crosshatch on the eye. This is just diagonal lines overlapping each other. For the next step get out your 3B or 2B pencil and go over the first layer that you just made matching the tones of your reference image. Then, add in the darkness for the pencil making it completely black. Leave a square on the upper corner of the eye that is white to create a glare. Then, add in ...
In this tutorial, we learn how to draw Sango and Kilala. Start out by drawing a circle and reference lines for the head, then draw a stick for the body and draw a half circle going off the bottom of the page. Then, draw circles on the upper body to create the hands and draw fingers coming off of those. Now, draw in the neck and the clothing that is on the character. Erase the background lines, then all in the features of the face and the hair around the head. Also make sure to draw on the ear...
In this video, we learn how to draw Karin. First, start drawing a circle and then add the eye line to help you place the eye. After this, draw in a triangle at the bottom of the circle as a reference to where the chin will go. Then, draw in a line for the body, then circles for the body and shoulders. After this, draw in the neck and then draw the rest of the body. Now, draw in the hair and the details of the face. Once you have finished this, erase the background lines from the face and then...
In this tutorial, we learn how to draw Tenten. To start this character, draw a light circle along with lines in the middle for reference points. Use a bolder line to draw the chin and then the eyes, nose, and mouth. also make sure to draw in slight eyelashes and eyebrows above the eyes. After this, draw a line around the head and erase the background lines. Draw ears on the top and then start to fill in the hair for the bangs on the front of the face. Finish this off with a headbands, then dr...
In this tutorial, we learn how to draw PokŽmon heads. Start out by drawing a circle for the head, then drawing intersecting lines in it to create a reference point for the features of the face. Next, draw the ears coming out of the head and then draw the eyes, nose, and mouth. Once finished, you will need to fill in the eyes so they have the correct look, then add in further details along the face. Make sure to add lines to the edge of the head to make it look like it has fur, then add in any...
In this tutorial, we learn how to draw manga basics. First, you will draw a circle for the head, then make a point at the bottom for the chin. After this, draw in lines on the face so you can reference where the eyes, nose, and mouth will be. Then, you will need to decide what expression you're going to use. Once you have decided, you will need to draw in the eyes, creases of the eyes, and eyebrows. Then, you will draw in the nose and the mouth. The female eyes look different from the male's,...
In this tutorial, we learn how to draw Karin 2. Start out with a circle for the head, then draw in your reference line so you can align the different features of the face. After this, draw in circles where the joints of the body would be for the upper body, then draw around this using bold lines. Once you are finished with this, draw in the rest of the arms and create clothing on the body as well. Next, you will need to draw in the features of the eyes as you would like, then add in the detai...
In this tutorial, we learn how to draw Itachi. First, draw your reference lines on the head so you know where to place the features of the face. Draw in the eyes, adjusting them so they are more towards the left of the face than the right. After this, draw in the bridge of the nose and the nose, as well as features of the cheeks. Next, draw in the nostrils and the mouth, as well as eyebrows and creases around the eyes. After this, draw in ears on the side of the head, then start to draw in th...
In this video, we learn how to draw Rukia. Start out by drawing a circle with a triangle shape at the bottom. Then, draw reference lines in the face to measure where the features of the face are going to be. After this, start to draw in the details of the face. Draw the eyes, mouth, nose, eyebrows, and any other details you need. Make sure the eyes match the original character and leave white for the pupils to show. Draw in the hair to finish up the drawing, making sure to draw the eyebrows a...
In this tutorial, we learn how to draw Rock Lee. First draw a circle for the head, making a chin underneath and using lines to reference where the facial features will go. After this, draw eyes that are slightly aligned to the left hand side of the face. The right eye should be larger than the left, both off center. Then, draw two dots for the nose and a "u" shape for the mouth. After this, draw a larger circle around the head and then draw in angry eyebrows above the eyes. Start to erase the...
In this tutorial, we learn how to draw Train Heartnet. Start off by drawing a circle for his head, then lines in the head for reference of where the features will go. Next, draw a stick for the body and draw circles where the shoulders and wrists would be. After this, draw in the neck and the upper body. Draw in the clothes after this, adding in as much detail as you would like. Make sure to add in shading and lines to make the clothes look more realistic. Next, you will need to draw in the f...
In this tutorial, we learn how to sketch a female face. Start with an upside down egg shape for the face, then draw in the contours of the chin. Use reference lines on the face to help you place where the eyes, nose, and mouth are going to go. After this, start to draw in the additional features, using a lot of lines to contour the face and make it look as realistic as possible. It's very important to use the lines in the background of the face so everything is even and lined up. After this, ...
In this tutorial, we learn how to draw Marik Ishtar. Start with the outline of the head (in a circle shape) and draw the reference lines around the front of the face. After this, draw in darker lines around the features of the face and start to add in details throughout the entire head. Draw in hair, a nose, eyes, ears, and everything else. Once you have finished with this, draw in the neck of the character and then the shoulders. After this, finish the hair off on the back of the had, then a...
In this tutorial, we learn how to draw Tohru Honda. Start out by drawing a circle for the head, then lines on the face to reference where the facial features go. After this, draw a stick for the body alone with a neck. Draw in circles where the shoulders go, then start drawing around that to create the body. Draw on the school uniform for her, then draw on the ear and additional details for the uniform. After this, draw on the bangs and the hair, then add on the bows to the hair. Then, draw o...
In this tutorial, we learn how to customize bash prompts with the PS1 variable. The PSI variable will say what something does. You can change this using the export command. Basically, you just type in the same thing and add in something. You can do this by simply typing it in using your keyboard. After this, press enter on your keyboard, then continue to change more things. There are a ton of different things you can do with this. You can find more from the website: http://pastebin.com/f2309f...
In this tutorial, we learn how to draw a female anime or manga school girl. Start out by drawing the outline of the character, then drawing in the details along the middle and the body of the character. Use circles inside the body to create a references as to where the body joints would be. Then, draw in clothing on the body and add a sword in the hands of the girl. After this, draw in additional details to the drawing and then focus on the face. Draw in the facial details, then add the hair ...
In this video, we learn how to draw Kagome Higurashi. Start with drawing the head and the reference lines for the face. Draw in the eyes slightly to the left, then draw in the rest of the details of the face. Make sure the eyes are wide and bright, and there are eyelashes on the sides of the eyes. Next, draw in a nose and a mouth, then an ear on the right hand side of the face. Draw in bangs and the rest of the hair for the character. Make sure there is a long neck with shoulders draw in as w...
