In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...
In this video, we learn how to clean cup-soled shoes. You will want to start off by cleaning the outsides of the shoes with an old toothbrush. The soles will have a lot of dirt on them, so focus on these first. After this, start to clean out the sides of the shoes with a water bottle filled with soap and then after this, use a clean cloth to wipe the shoes down again. To finish this process, use an eraser to help take off any missed spots from the soles. Wear your shoes after this and they wi...
In this tutorial, we learn how to color with Copic pens. First, grab a picture that you want to color with your pens. After this, start to color in the picture with your different colored pens. After you fill in the colors, use a darker colored pen to add in shading and make the lines darker along the sides. Continue to color in your picture, adding shading where you prefer. Add in different colors and make the lines darker when you want them to look more bold. Make sure to add in highlights ...
In this video, we learn how to write the letter "r" in calligraphy copperplate. Start out by dipping your calligraphy pen into ink, then creating a curved line with a dot at the end of it. Next, fill in the line so it is smooth and there are not ragged edges. Next, draw a large swirl on the left side next to the curved line, then draw it over to make the initial loop on the "r". After this, create a loop in the middle, then draw it back down to make the end hump of the "r". After this, draw i...
When we see the word "baguette" in a recipe, we know it's bound to be delish. In this case, we're talking about a Polish baguette, also known as a Zapiekanka. This greasy bread is a popular Polish street food, and in the version you'll learn to make in the video it's filled with oodles of cheese, mushrooms, ham, and any other vegetables and meat you'd like to add.
Telling others that you have crabs isn't always a bad thing. Especially if those crabs of yours are baked into crab cakes! A delicious staple on the east coast, and a favorite in the Hamptons, crab cakes are the ultimate summer dish.
Love purple? Then this purple-filled eyeshadow style is sure to rock your boat. Croatian photographer Marina Filipovic Marinshe sets aside her usual fashion, portrait and art photographs, and brings you this makeup tutorial for recreating her rich purple eyes look. Check it out. You won't be sorry.
In this tutorial, we learn how to create a professional resume with Chuck Aranda. A professional resume shouldn't be very long. It should be around 1 page, and only a half of a page if it needs to be written on another page. Make sure that it not only looks professional and attractive, but it's also easy to read. Tailor your resume to each job you apply to, employers like to know you took time to apply to just their job instead of sending out your resume in mass. Make sure to use an easy to r...
The video covers how to ice a cake. According to the video it is best to start by refrigerating the cake. You will need a 16" pastry bag with an icing tip on it. The tip should have a cerated edge on one side and a smooth edge on the other. Set the cake on a rotating plate. Rotate it and put a layer of icing all the way around the cake and then fill in the center. Once the cake is covered use a spatula and smooth out the icing. Then set the second cake on top of the first and put the icing on...
In this tutorial, we learn how to set up the calendar in MS Project 2007. First, open up your calendar and then click on the "work week" tab. Now, set your working times into the slots for each different day. Make sure you set your start and end times correctly. Now, go to options and change the default start and end times so they match your working calendar. When finished, save this and then start to enter your task information to each different slot. When you enter this, the start and finis...
Gwen Stefani famously said that her makeup and fashion look is a hybrid between '50s pin up and chola. While cholas get a bad rep for going a wee too crazy with the eyeliner, brow liner, and lipliner (black-rimmed lips filled in with nude lipstick? Not attractive), they do their smokey eyes well and for some, red lipstick is practically a uniform.
Whether they exist or not, people believe in the spiritual power of angels. That's why, if you walk into any Spencer's Gifts or novelty store, you'll always manage to find tiny wallet-sized "guardian angels." You apparently slip these in your wallet to feel guided and protected.
In this tutorial, we learn how to make a chicken stock from leftover bones. Ingredients you will use include: roasted chicken bones, celery, carrots, onions, parsley, bay leaves, and peppercorn. First, take a large pot and add in all the ingredients to the pot. You can chop the celery up before you place it in the pot, as well as the carrots. After adding all ingredients, fill the pot with water. Next, place the pot on the stove and add salt to taste. Let this simmer on the stove for several ...
In this tutorial, we learn how to make mashed potatoes and sausages. To start, peel your potatoes and then cut them into quarters. Now, place them into a large pot filled with water and salt, then place the lid on and simmer for 15 minutes. While these are cooking, cook your sausages in a pan with oil cooking until brown on both sides. While these are cooking, heat up a frying pan and chop up your onions, then throw them inside the pan. Cook these until the caramelize, then set aside. Now, dr...
In this tutorial, we learn how to get a Navy sailor's pin-up hairstyle. To start, curl your entire head of hair with both tight and loose curls. After this, clip your bangs back on the top of your head, and place a white sailor's hat behind the clip with bobby pins. To do the makeup look, apply foundation that is the color of your skin, then apply a blush to your cheekbones. After this, apply a bright pink lipstick, or red lipstick. After this, fill in your eyebrows and then apply fake eyelas...
In this video, Jennifer DiDonato shows us how to make healthy tuna salad and veggie dip. To begin, drain a can of your favorite tuna and place it into a bowl. Then, add in 2 tbsp fat free cream cheese, 1 tbsp mustard, dash of dill weed, salt, pepper, and your choice of diced veggies, and mix everything together until well combined. A half cup of this only contains 145 calories and has tons of nutritional value to it. It has a lot of protein so it will fill you up easily, without having to eat...
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...
In order to poach an egg, using plastic wrap, you will need the following: eggs, a bowl, plastic wrap, and a saucepan.
In this tutorial, we learn how to mix an 80s era music as a DJ. There are so many different styles of music from the 80s, start at modern day dance music to see how the beat sounds now from then. A lot of the dance music back in the 80s was off key because it was done by people and not a computer. You will first have to take several hours to construct the mix that you like. Chop and mix the different sounds together, then bring different songs in at different points. For old school, the sound...
In this tutorial, we learn how to draw Aladdin and Jasmine. Start by drawing Jasmine, draw her hair on first, then start working on her face and head. Add on her earrings, eyebrows, and mouth. Make sure to pay attention to details and use a picture as a reference to what they should look like. Fill in Jasmine with the colors she wears in the movie, and then start to work on Aladdin. Draw in his hair to start, then make sure to draw on his hat on the very top of his head. Draw his face, giving...
Sure, you could hit up Target and purchase a large bag filled with cookie cutter ribbons and bows, but why not adorn your next special gift with something a bit more, well, special? In this beginner origami tutorial, you'll learn how to craft a green ribbon banner that can be used to top anything from gift boxes to gift bags.
In this tutorial, we learn how to make a cosmopolitan cocktail with Stephanie Brown. To make this, you will need: ice, lime, 2 oz vodka, 1 oz Triple Sec, 1 oz cranberry juice, 1 oz lime juice, shot glass, martini glass, and a cocktail shaker. First, chill your martini glass by adding ice, Then, fill your shaker half full with ice and add in: lime juice, cranberry juice, Triple Sec, and vodka. Once your martini glass is chilled, remove the ice. Now, shake the shaker until it is ice cold and po...
In this tutorial, we learn how to apply full coverage evening foundation. First, you will want to apply a cream that has Silica in it, which will fill in any fine lines. Next, you will want to apply a powder foundation, something like Mac StudioFix Full Coverage Foundation. Make sure you use a brush on your skin to apply evenly. Next, if have you have light skin, you can apply your favorite type of powder bronzer on your cheeks with a kabuki brush. Now, apply concealer underneath your eyes on...
In this tutorial, learn how to make a super fast, delicious meal that is also good for you! This low-carb, low-fat meal is ready in minutes and will fill you up without weighing you down. You will get a step by step for making this yummy, Asian inspired dish - seared ahi tuna steaks, served med rare with a side of deliciously steamed edamame beans.
Having a patio party this Fourth of July? Kick off Independence Day with a celebratory drink in hand by mixing yourself and your guests this strawberry creamsicle martini.
Looking for an easy way to polish your digital images in Photoshop? Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
In this clip, learn the mysteries hiding inside the Twilight novels and get a better understanding of why women seem to be enthralled with them. If you are like most men, you just don't understand all of this vampire hype. This tutorial will fill you in on just what it is that your girlfriend/mom/sister sees in the Saga that you can't.
Gnocchi may be challenging to pronounce, but eating this oddball potato-based member of the pasta family is seldom a challenge since they are so delicious. This video demonstrates how to prepare a ricotta cheese gnocchi with a pea and mushroom sauce. It is light and delicious, yet filling. A wonderful spring dish for any at-home chef.
If you are looking for a way to kill time while waiting in a restaurant, why not check out this magic trick?
In this tutorial, Emily Dawe, assistant home and crafts editor for Woman's Weekly, demonstrates a simple cross stitch design. Cross stitching is a fun hobby and really helps fill any empty time you may have. If you are looking to start cross stitching, have a look at this video and begin with the basics.
In order to de-hull leafy bean sprouts, you will need a salad spinner. The type of salad spinner you use will make a big difference. Separate the sprouts. Work your way through the sprouts. Separate them as much as you can.
GardenGirltv shows viewers how to plant strawberries as a ground cover! With a strawberry patch or field you will have to always continually plant strawberries! The plants will last a few years and every year you should add new plants to your areas for each year. First, you need to get a bundle of strawberry plants you need to rake the area you are planting them in. Make sure you put each plant 18 inches apart. First, you should take your strawberry plant dig a trench, lay it flat and cover i...
In this Software video tutorial you will learn how to create a vector RSS icon in Illustrator. Open illustrator and open a new document. Select the ‘rounded rectangle tool’ from the rectangle menu. Click and drag to draw a rounded square. Select the gradient fill on the left side and change the color to orange on the right side and make it dark to light from top to bottom. Next grab the corner and turn it around 180 degrees. Move the picture to one side and select the ellipse tool. Draw a...
This video shows how to make a Jalisco Fresca, a cocktail from the Merk Bistro in San Diego. It is made with simple syrup, strawberries, an egg white, lemon juice, tequila and Campari.
Is there anything worse than a leaky toilet? One minute you're flushing the tank and the next you're standing in a pool of water and ruining all your nice towels. In this tutorial, Tool Dude Tony walks you step by step through the process of replacing all the parts in a toilet tank including the fill assembly and flush valve. By following this video, you will be able to avoid a midnight call to the plumber and fix the pot yourself. Don't ruin your tile - or worse, the apartment under yours, w...
In this video Lori Winders shows us how to make ghee from regular butter. Her method takes about two hours to complete but she says that this way you can obtain much more ghee at one time. First, put two pounds of butter in a large cast iron skillet and then put it in the oven at a temperature of 250 degrees for two hours. After this is complete you take the pan out of the oven and with the help of a strainer and lots of layers of cheesecloth you filter the obtained gee in a jar. You will see...
Randy with Yes, You Can Cook! demonstrates how to make a croissant egg scramble. You'll need eggs, ham, bell peppers, onions, tomatoes, and cheese. You will also need butter. You'll need a cutting board, a spatula a knife and a pan. First, chop up the onion, peppers, tomatoes and ham and shred the cheese. Score the croissant and cut a circle out of the top. Add onions to a hot skillet and then add the scrambled eggs. When the eggs are almost cooked, add the bell peppers, tomatoes, ham, ground...
In this video, we learn how to make cream of asparagus soup. First, add in 1/2 stick of butter to a large pot and saute with 1/2 clove of garlic and 1/2 of an onion chopped up. Now, chop the bottom off of your asparagus, then chop into inch length pieces and place into your pot. Now add in 6 c of chicken stock to your pot and mix everything together. Once everything is heated, Place ingredients into a blender, filling it 1/2 way full each time and blend until you have a cream. Once finished, ...
In this video, Graham shows us how to pan for gold. In a few simple steps, an individual could become rich!!! Graham is working with sandstone in Virginia in a swamp like area, but this process could be done in any river. Gold usually gets stuck in cracks in the sides of rivers, and in this case, the cracks are in sandstone rock in this swamp-like area. Shovel up some of the sandstone bed bedrock, or whatever type of material is available, place the shoveled up material in the pan. Fill up th...
Latte art is a fun, creative way to spice up your average cup of joe. Watch this video to practice your latte art with steamed soapy water. First, pour a drop of dish soap into a latte making cup. then using the espresso machine fill it with hot water. Use the espresso machine to help steam and mix the soap, as if it were a latte. It will turn into a white, frothy substance. Then pour the soapy water into a coffee mug. Use the latte cup's guide to make sure you pour at the right angle. Watch ...
