Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.
Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.
Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.
In this video, we learn how to knit with color with Brandon Mably. Get inspiration from the world around you to get different colors and make out different patterns. Carry your colors around the item that you are knitting to make a nice pallet that you love. You can use inspiration from the outside, different states, stores, plants, and anything else that you love! Once you find something you want, get started knitting and find a way to knit that works for you. Use the color range that you ar...
In this tutorial, we learn how to make a small, easy, functional telescope. First, glue a lens in place with glue underneath a piece of cardboard with a circle cut in it. Then, cut this into a circle and tape it to a paper towel holder. Then, you can wrap this in some paper mache around the cardboard. Then, wait for this to dry and spray paint it with gold and black paint. When finished, you will have a functional telescope ready to go and use! This is cheap and a fun project to make with chi...
In this tutorial, we learn how to fit a dry lining back box. This is very easy to install, and the sides will grip the wires on your light. First, determine where you want your switch, then mark a quick line using a sturdy level. Next, you will cut out a hole in the wall the size of the box. After this, push the box into the wall. Then, you can add in the light switch to the box and secure it with the wires that are inside. This will finish up this project, just make sure the wires are place ...
In this video, we learn how to manage two different colors of yarn with Eunny Jang. You can do this all on your left hand, right hand, or with both of your hands. It's all about what is most comfortable for your, even if it's something different. Start out with all your yarn in your right hand then knit with one yard at a time. This means to just knit as usual by dropping the yarn and picking up the next color. This can be a bit tedious because you will be constantly stopping and starting. Yo...
In this tutorial, we learn how to create music with JamStudio. First, open up JamStudio and then open up some beats onto the screen. After you do this, you can add in loops and then change the sound of the tempo. From here, you can add in chords and also change in the bass or piano sounds. There are a ton of different things you can edit and change in here. Play the audio as you make it to test out how it sounds. Once you get the right combination put together, save it! Have fun creating musi...
This tutorial is aimed at those who have at least some moderate experience with crochet. Here, you'll learn how to join two granny squares together using a five chain, flat braid continuous join method that will make your project lay flat all the way around.
In this tutorial, we learn how to make a DIY faux fur shawl. First, hem on end of each of the linings. The linings for them both must overlap, then sew around the edges. Pull this inside out and then hand sew the opening to the shawl. Once you finish, you can put the shawl on and wear it with whatever you would like. This is a very easy project to do, you just need to know how to sew to accomplish the look. Wear with a dress or just jeans and a top, this is a great faux fur shawl that will ma...
In this video we learn how to make a balloon monster truck. If you're new to creating balloon creatures, this may be a bit difficult for you so follow along. Start out with a tan colored balloon and a purple balloon. Twist these together to start creating the truck. You will be twisting many bubbles into both of the balloons so you need to make sure you keep space in the balloon for air. Once you finish this, you will twist four more brown balloons into circles on the sides to make the tires....
These days we're used to triple threat stars who, for instance, act, dance, and sing. But stars that excell at all three are as difficult to find as a needle in a haystack.
In this tutorial, we learn how to install a new mailbox post and box with Lowe's. First, you will need to gather all your tools and a new mailbox. After this, print out directions for the project through the Lowe's website. Now, call 811 to call your utility company to make sure you aren't digging through an electrical line. Mail boxes have a specific height they need to be installed at, so make sure you follow these guidelines. After this, dig out the hold from the ground, then fill in grave...
In this tutorial, we learn how to wash, stain & seal an outdoor deck with Lowe's. First, determine the type of stain for your project, there are four main types of finishes. Check the instructions to calculate the amount of stain you need to purchase. To start, you will need to clean and dry the deck, making sure you cover your body before you begin. You will also need to use sand paper to even out the surface of the deck. After this, start to seal your deck with your choice of color. Let thi...
The Dremel Stylus tool is ideal for any wood worker or wood crafter. This versatile and easy to use tool can let you carve or whittle any number of projects out of wood, such as a wooden relief. This video demonstrates how to carve a piece of ivy onto a wooden box.
This video will show you some methods to create a fake Loch Ness monster photo. You will need a camera or a camera phone for this project. One method of faking a sea monster picture involves creating a clay model of a head and a neck of a sea monster and holding it underwater. The outline of your hand holding the clay will serve as the body of the monster. Another method which can be used to fake a sea monster can be done using a clothes hanger and holding it underwater. The hook of the hange...
In this video, we learn how to hold a hook and yarn in crochet. First, grab your hook at the thumb grip. Then, practice how you like to hold your hook so it feels most comfortable with your hand. After this, grab your yarn and wrap it around the hook, placing tension in the string. To do this, wrap it around your pinkie then your pointer. Then, hold in between the thumb and middle finger. After this, you will be able to place the hook in the yarn easily to start out your stitch. After this, s...
In this video, we learn how to perform a cable cast-on. Start this with a slip knot, then grab your working yarn and create your first stitch. After this, go between the two stitches with your other needle, then tighten the last stitch that you just made. Now, go in between the last two stitches and tighten up the yarn again. Continue to do this by making different stitches and as you go down you will have a cable cast-on. As you finish, you will have a longer and longer row, so tie off when ...
This video will show viewers how to fold a small book out of origami paper. You will need a square piece of paper for this project. First, fold the paper downwards in half, then fold it into quarters by folding down both edges of the paper to meet in the middle. Unfold and fold the two top sections down to make eighths on your paper. Then turn the paper around and repeat. Mountain fold both sides of the paper until you reach the middle, after which you should have a strip of folded paper. At ...
In this clip, you'll learn how to make use of the Type tool to create text when doing design work in Adobe Illustrator CS4 or CS5. Whether you're new to Adobe's popular vector graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
So your in laws are coming over for dinner (big whoop) and you need to whip up something on the stove that'll truly impress, but you don't want something too complicated or else you'll be fanning the flames of your failed cooking project just as they enter.
Remember the heyday of video games during the '80s when all video games were 8 bit and super pixelated? While we're glad to have video games that look so real we mistake them for reality sometimes, pixelation is still a cool way to add retro flair to any crafts project.
When you're making a restaurant, or a house, or any other somewhat modern Lego model, one way to make the interior (or exterior for that matter) come to life is by making furniture, and what better way to start than with a table with a striped table cloth on it? In this great video you will find out what parts he uses and then go through the assembly process all the way to the final project! Pay close attention though as the placing of some of the bricks are absolutely crucial to the model co...
In this video, we learn how to cut acrylic on the Cricut Expression. First, you will need to have an acrylic cutter installed on your Cricut Expression. Now, place the acrylic on the mat and insert the mat into your machine. After this, choose the type of cut you want, then make sure the blade depth is at six and the pressure is at maximum. Now you can start to cut the acrylic, and when it's finished, it will pop back out of the machine and be finished! You can then use the acrylic for what p...
Would you like a touch of mod and whimsy all in one? Then this hat is perfect for you because it strikes the perfect balance between the two. Made of cozy, soft blue yarn, embellished with a pretty pink border, and done up in a sort of inverse bowl shape, this is not your everyday baseball cap or beret.
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
These gold stone stringers look like glistening incense sticks and are incredibly beautiful. Check out this jewelry making tutorial to learn how to turn gold stone lumps in blue and an orangey yellow into long sticks, or stringers, made of these melted lumps.
The Queen of Hearts would simply fawn over this pair of "Alice and Wonderland" inspired earrings, especially since a pair of red heart pendants is the focus. Pretty and uber feminine without being over the top, you can flaunt these earrings at any occasion, from school to a midafternoon tea party with the Hatter.
We've always had the impression that the only women who wear pearls are those who also own McMansions and tie cable knit sweaters around their shoulders at yacht club soirees. But now that we've seen this jewelry craft - a pair of chunky blue green glass pearl earrings - we're taking a second glance at these pearl things.
Looking for a new Lego project? Look no further! In this two-part series you'll learn how to build a great flat bed truck out of lego bricks! Each video starts showing you each brick that you'll need, the first video being the truck cab, and the second being the actual flat bed, and then goes into a great, step-by-step tutorial, showing you where each piece goes and before you know it you'll have a flatbed truck!
This great video series goes through the entire process, from unboxing the Wii Hori fighting stick, to taking it apart, wiring, adding buttons, and everything else that you'll need to finish the project and have it ready to go for play on your Xbox 360!
Whatever happened to the mix tape? A few years back, there wasn't a better and more meaningful gift to give someone than a mix tape full of jams specially tailored to his/her tastes. But with MP3s and internet streaming being the most popular forms of music listening these days, we suppose it's no surprise the mix tape has died out like the dinosaurs.
Summer is quickly coming to an end (oh no!), so bask in your last few glory days of sleeping in and playing all day by, well, sleeping in and playing all day. But you should also consider making this adorable sea crab, a sort of testament, if you will, to the summer months spent out by the sea.
Is your best friend's baby shower speedily approaching and your mind out of ideas for a cute and cheap way to decorate the party? Then you've come to the right place. These tiny blue origami elephants would make great pieces of decor as centerpieces on the dining room table and placed on counters around the house to emphasize the baby theme.
As kids, we had dreams of becoming a fighter pilot, menacing enemies and saving the day with our stealth fighter plane. Needless to say, our pipe dreams kind of went bust, but that doesn't mean we still don't dream of piloting one of those things!
It's safe to say that this is one ape that you won't soon see climbing the side of the Empire State Building, terrorizing Wall Street snubs and taking damsels in distress at his whim.
Do you know how to fold an origami flapping crane? If you do, then great, because that's the only origami project you need to know how to fold in order to complete this origami bird. A variation of the crane, this bird has larger wings and you can make them flap by pulling on the tail.
Origami is a lot of fun (okay, and also a lot of frustration), but what often turns beginners off from the Japanese art form is simply that it requires special origami tissue paper. While it's true that thin paper made exclusively for origami is preferable for any origami project, you can substitute plain old printer paper instead if you're low on money or just out of origami tissue paper.
Think all crochet projects produce yuppy granny squares and are only done by elderly cat ladies who live alone? Think again. With stars like Amanda Seyfried proclaiming that knitting is their favorite hobby, crocheting/knitting is once again becoming hot stuff, kind of like designer cupcakes or pilates.
