Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this how-to video, you will learn how to draw Salvation Army Officer Bob Swanson from the cartoon strip Mustard Seeds. First, you will need a pen and paper. Now, start off by drawing the hat of the figure. From there, move on to the glasses, nose, hair, and mouth. Fill in the hair with the sharpie. Next, move on to the jacket and tie. You can add the arms, hands, notebook, and legs from here. Make sure to add the folds on the pants. The feet are next. Fill in the jacket and hat with the sh...
This video illustrates the quick and easy method to Draw Donald Duck on your own . The process is comprised of the following steps:Step 1: Take a blank sheet of paper and a HB Bonded lead pencil.Step 2: Draw a face that resembles a duck's face. Make sure you don't make the ears too large as Donald Duck has got small ears.Step 3: Another point to consider is the length of the beak. Make sure it is elongated and oval shaped.Step 4: Now , make a oval shaped figure and shade it's outline to form ...
In this video, a young boy shows us exactly how simple and easy it is to draw Stewie from "The Family Guy". Using a piece of paper and a writing or drawing instrument, anyone can learn how to draw this easy cartoon character's face. You should start with the outline of his head, which is a football-like shape. Then, draw two circles for his eyes, adding sharp sloping lines for his eyebrows. His nose is half a triangle and his mouth is a half-grinning sideways check mark. You can then add deta...
Artist Stephanie Valentin takes us through the steps of how to draw the X-Men character Wolverine in Photoshop. She outlines the necessary tools to be able to make the drawing and provides detailed information on width, shading, and opacity to make sure the colors are all accurate. After creating a series of layers, gradients and various sketches, she shows us how to create the character. In just five hours with this tutorial, you can learn how to create Wolverine using Photoshop.
To add a twist to a cupcake, learn how to make cupcakes in ice cream cones by following the steps outlined by Liv Hansen in this video tutorial. You will need wafer cones, cupcakes, mini cupcakes, and some candy (something like jelly beans will suffice). Fill the cone halfway with candy. Remove the cupcake liner and add frosting to the cupcake's top. Place it inverted into the cone. Add more frosting to the top of the cupcake and place a mini cupcake inverted on top of that. Then add more fro...
This is an excellent kids tutorial to draw a koi fish easy and simply using a Adobe Photoshop. The artist shows you how to hand draw the body, add the fins and other features of the fish. Then you create guidelines to make a perfect pattern of scales on the fish. Next he starts texturizing the fins as well as creating a realistic flip of the tail. He then takes the outline of the fish and puts it on one layer then traces it over on the next layer. On subsequent layers, the artist paints the f...
In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that t...
This video is a highly informative tutorial on how to add and control text to a line in Photoshop. According to the author of the video, most people can add text to paths in Photoshop, but are often in the dark about how to manipulate. This, as demonstrated by the author, is quite easy and simple. The tools for path selection, text addition, and various other features which make this particular task very simple are clearly outlined by the author.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
This is a video instruction outlining the technique of the forehand volley shot in squash. With the volley get your racket working up to the ball early 2. Get set to the ball 3. Let the racket head drop 4. Swing across the ball and follow through.
Toologics editor Jude Herr hosts this kitchen remodel series! Jude and her Father, from American Builders, outline the project.
If you're still working your way through the hundreds of features and changes that iOS 13 brings to your iPhone, you might be a bit surprised to learn that your device is now out of date. While Apple only dropped the big update for iPhones on Thursday, Sept. 19, the company has already released its successor. All iOS 13-compatible iPhones can now update to iOS 13.1, out today, Tuesday, Sept. 24.
Just after a month of testing, iOS 12.1.3 has been released for iPhones. Like the previous iOS 12.1.2 update, there's not much to get excited about. There are no new features discovered yet, but there are a few fixes for issues with photos in Messages, imperfect pics when using the share sheet, and disconnecting CarPlay.
Snapchat is rolling out some awesome new features in their update today. The major update comes just two weeks after the company's premiere of backdrop, snap shopping, and voice clip features. They rolled out two new features this time, Multi-Snaps and the Tint Brush.
There's nothing better than gathering up all the cushions, pillows, and blankets in your home and having a good ol' fashion movie night. But if you're still rocking the old 19-inch TV your parents gave you in college, you may want to upgrade to something bigger.
In this how to video, you will learn how to draw an angel. First, start out with the basic sketch of the drawing. Remember, eyes go in the middle of the head. Drawing the head first will help proportion the rest of the body. Use long strokes with the wrist to draw the hair. Try to make the hands the size of the face and try to make the fingers look like fish sticks. It is easier to draw if you study anatomy books. Next, erase the sketch and start going in with further detail. Exaggerate the w...
The video begins with a finished fence being shown as an example of what your final product should look like. The first step is to lay out straight lines with string to create the outline of fence parameter. To set the first post you must dig a five inch hole in the ground which the post is placed in. The post will be set along the string line spaced out about four inches evenly along the parameter. the holes must be filled in with rock or cement to set them securely. You must then nail board...
In this tutorial, we learn how to paint a cabbage rose using the one stroke technique. Start out by mixing together white and red with your paint brush. After this, add yellow to the tip of the brush and paint it onto the paper using your hand to move the brush gently up and down. Do this in a circle to make several petals into one single flower. Then, paint on petals around the inside petals to create a larger flower. Add in additional color to the center of the flower to make it pop out mor...
In this video we learn how to make & decorate a pastel flower cake. You can make a lot of things with just one icing tip. First take a round white cake with white icing. Then, use a start tip to draw three flowers onto the cake. Create a green vine to connect all of these flowers together and a cookie cutter to draw the outline around the flowers to keep it in place. You can use different colors of icing for each of the flowers and draw smaller flowers around the side of the cake as well. Get...
Any medical student should be able to perform a basic cardiovascular exam. This medical how-to video tutorial outlines the guidelines to perform a basic cardiovascular exam. Always begin by by observing the patient from head to toe. Inspect the face for signs of cyanosis. Note visible scars or pulsations in the neck and edema in the feet. This video is intended for medical professionals only.
Issue 287 of the Nanoc the Obliviator level of the game Comic Jumper on the Xbox 360, is the final section of the medieval setting of the game, similar to Thor and other. In this video you will get a complete walkthrough of the final section of Nanoc the Obliviator and also all of its achievements.
In this tutorial, we learn how to draw a horse step-by-step. First, you will want to draw the face of the horse. You can use intersecting lines in the face so you place the features of the face equally apart. After this, draw the outline for the body of the horse. Once you have this perfected, you can start to add in the hair for the horse. Next, draw in the details of the body and draw the shoes on the bottom of the horses feet. Draw in the tail, then add in shading and other lines to make i...
Jeeps, for all their rugged charm, are not very well-made cars. They are rife with mechanical issues, and the '02 Jeep Liberty is no different. In this video you'll learn how to fix the A/C draining issues in these cars that leads to the passenger side carpet getting wet.
In this tutorial, we learn how to make 2-layer stencils in GIMP. First, cut out the background before you begin. Now, right click on your main layer and then select "add alpha layer". After this, select the magic wand tool and delete all the white areas on the outside of the picture. Now duplicate the layer, then hide the top layer and select the bottom layer. Now, go back to threshold and move it all the way to the right to get an outline of the image. From here, go back up to the top layer ...
In this video, we learn how to draw a basic human figure. Start with a circle first as the head, then draw cross hairs over the circle to indicate the tilt and direction the head is facing. Then, add in the chin, shoulders, then circles where the joints are. Draw in the rib cage and spine, then the hip bones. After this, draw the legs and continue down until you reach the feet. When you finished with this outline, use a darker line to draw more details and shading in on the face and body. Whe...
In this video, we learn how to do Batman face paint. First, you will need to apply a metallic silver paint to make a mask Batman design around the eyes. Next, use a fine tip brush to paint black for the outline around the Batman design. You may need to have the logo printed out by you so you know how to paint it. Next, draw a circle around each of the eyes, then you will have the completed Batman face paint! This is great for children and is extremely easy to do. This is great for parties and...
To spray paint graffiti, you will need the following: 2 cans of spray paint and a mask. You will need to have an idea of the design you want to paint, before you begin this project, because you will need to work quickly. Put on your safety/protective gear. Paint an outline of your design, first, with one can of spray paint. Then, you will want to strategically fill in the design. One can is primarily for filling it in and achieving light and shadow. Therefore, you will need a dark shade and a...
In this tutorial, we learn how to draw wispy hair with Matthew Archambault. When drawing these, you will first start off with a light pencil to make the hair look soft. After this, you will want to make the shapes of the strands look unique, then work from light to dark with the different strands. Use a harder pencil mark when you draw the outline of the hair. Make sure you don't do hard edges at all, everything needs to be soft. make sure you are drawing the hair outwards to make it look lik...
In this video, we learn how to draw a game character in motion. First draw the outline of the game character and make the body more prominent with details. After this, start to add in darker lines around the outside, then start to shade in the drawing and make the different parts pop out of the page. Next, add in colors throughout the sketch and add in white marks to show the glare on the picture. You will want to keep adding in all the small details to make this picture look even better. Whe...
In this Arts & Crafts video tutorial you will learn how to use the cross stitch 'n paint technique. It combines simple back stitching and water color painting. Most of the materials are found in your kitchen. You will need wax paper, paper towels, and a plate to use as your paint palette, some water colors and paint brushes. After choosing your design, back stitch the outline on the fabric. Place the white paper towel over the wax paper and spread the stitched fabric over it. Now you are read...
In this video, we learn how to make a sun catcher with your kids. First, you need laminating paper, two paper hearts, and scissors. First, cut the center of one heart out by sticking your scissors in and making your way around the heart. Next, place the outline of the heart inside of the laminating pouch, then decorate the inside of it how you prefer. You can use whatever you want to decorate the inside, including: glitter, crayon shavings, tissue paper, etc. Next, place the paper inside of a...
Simon Solotko outlines the steps necessary to get a desktop PC up and running from scratch using AMD Dragon platform technology. Fragon technology is a combination of AMD Phenom II processors, ATI Radeon HD graphics and AMD 7-Series chipsets. This technology allows you to build incredibly powerful PCs for multimedia entertainment, gaming and advanced multitasking.
In this video, we learn how to draw a polar bear. Start off by drawing a round circle for the stomach, then draw the head next to the stomach. This should make it look like the polar barn is crouching low to the ground. Next, draw on the four legs to make it look like the bear is walking. After this, draw in darker lines to outline the bear further and then draw in a baby polar bear next to the mother. To add a special touch, draw in snow and ice around the bears. When finished, sign your nam...
In this video, we learn how to draw a Halloween witch. There are a ton of different styles of witches you can draw, you just have to choose that one that you like best! No matter which one you choose, you will first start out by drawing the outline of the witch, using a light pencil marking. Draw the head and body, followed by the witch with the broomstick. After this, start to add in more details, such as the face and clothing. Make sure to draw in the hat and add in lines on the clothing to...
In this video tutorial, viewers learn how to draw ocean waves. The image drawn in this video has water waves clashing into some rocks on shore. Begin by drawing the outline of the rocks on the right side. The horizon line of the image is about 3/4 above the rocks. Then draw a large wave that passes the horizon line. Now paint the sky in gray and paint the rock in shades of black and gray. Paint the waves and slowly build the colors. Use the pencil tool with transparent color to fill in the wa...
Keeping things like food and water refrigerated while you're camping in the bush is nearly impossible. Unless of course you've chosen to camp somewhere freezing cold. But if you haven't, evaporative cooling can be an effective technique to utilize for keeping water cool and food from spoiling as quickly. Obviously this can be crucial in a wilderness survival situation when your food supplies may be limited. This video outlines two ways to utilize evaporative cooling, first to cool a water bot...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
