Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. 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 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). 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 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this video tutorial, viewers learn how to spot a fake Rolex watch. Rolex watches are made perfectly and will not have any problems. Rolex watches are well maintained and are durable in water. There will be no water in the watch. Fake watched will always leak. Rolex watches will never have a date and day on the dial with stainless steal. A real Rolex has 2 1/2 times magnification, while a fake Rolex will only have 1 1/2 times magnification. This video will benefit those viewers who are plan...
This is a Video clip presentation from all3sports guides us on how to check and assemble the unpacked shipping box. The first step to assemble the motorcycle involves inserting the seat lifter to the reasonable depth and tighten the screws. After that attach the handle bars and front brake and make sure that there is an equal amount of gap between the top and bottom of the handle bars. Then, check the brake cables are properly fit. Then, assemble the arm gauge or arm rest with the two sets of...
Follow along as Sue McMahon, Cookery Editor for Women's Weekly, shows us how to line a tray bake tin.
Photoshop can be a daunting program with so many tools to use and details to adjust. This simple guide shows you how to create realistic textures and details on anything or everything you could ever think of by teaching you a few easy steps. He shows you how to take an existing texture and adjust the angles so that it fits perfectly on the surface you want. Then he displays how to add a bit of detail to make the object seem even more realistic by adding what looks like wear and tear on your f...
Step 1: Film yourself in the first position which you want your audience to see. Step 2: Film yourself in the second position you want your audience to see.
Rings are a great way to start out making jewelry. You can customize your homemade jewelry and make it fit "you" perfectly. Check out this video tutorial to learn how to make a button ring. This is a really simple button ring which you can make easily at home.
Chicken is one of America's most popular foods, and tops beef and pork in consumption. Whether you're grill over gas or charcoal, perfectly grilled chicken is a delicious must-have at any picnic or family cookout.
An installer gives step by step instructions on how to remove decorative panels, remove tow hooks, lower the exhaust pipe, and install a Valley trailer hitch on a Highlander. Video also shows what to do if one of your holes does not align perfectly. If you need help removing the exhaust pipe from the rubber hanger, part two shows that.
Here is the final video in the CNC Stomp Pad Tutorial Video Series. In this video, we go over the final assembly of the stomp pad. Then we watch as we used double sided... More» tape to adhere it to the snowboard. Finally we take a look at some final photos of the CNC Stomp Pad on the Snowboard. One Final Note: The Stomp Pad works perfectly. I love the fact you can customize your life with CNC.
If you want your valentine to die of cuteness overload this Valentine's Day then make this origami heart complete with a necktie. While it's simply a heart-shaped origami project, it can easily be turned into a card if you write a nice message on the front or back.
These star flowers look complex and difficult to fold, but they're actually customized for beginners to the art of origami. Check out this tutorial to learn how to crease and fold several beautiful star-shaped flowers. Stick them in a terra cotta pot for a cute tabletop centerpiece.
If you know how to use your microwave then you can easily make these gorgeous Valentine's Day cupcakes. That's because all it takes is microwaving candy melts - and squeezing some flower and heart shapes - to adorn your baked goods.
What's better than ice cream or cupcakes? Ice cream and cupcakes combined into one taste bud-blasting dessert! Take a gander at this cake decorating video to learn how to make ice cream cone shaped cake pops.
Reduce the human face to a series of basic lines and shapes so you can easily draw anything. This tutorial shows you how to use this technique to draw a realistic and fully proportionate sketch of the rap star Jay-Z.
Draw any face in side view completely from memory! This tutorial teaches you several proportion tricks, such as how to space the ears and eyes relative to each other or the shape of the head, when you're trying to draw someone in profile.
At its core, Valentine's Day is about love, the act of loving, and harmony. So it only makes sense to give your amor a heart-shaped token of your affection this Valentine's Day.
Applique is fabric cut in a fun shape that is applied like a patch, directly onto the fabric. This tutorial shows you how you can use fun woven print fabrics and fusible interfacing to create your own appliques and patches for your projects.
If you've ever had problems with trapezoids in the past, this math lesson should clear some things up. A trapezoid is a geometrical shape, a quadrilateral, that has only one pair of parallel sides. Outside of the US, it's referred to as a trapezium. Yay Math breaks down the properties of trapezoids, including the isosceles trapezoid, the legs of the trapezoid and the median of the trapezoid.
This math lesson from Yay Math covers four-sided shapes in geometry. Learn about the differences and similarities between rectangles, squares and rhombi (the plural of rhombus). The properties of rhombi and squares are covered, so sit back and enjoy this educational (and FUN) math lesson.
You may think that Taylor Swift wakes up every day with her naturally curly hair in perfect shape, without a single hair out of place, but even as genetically blessed as she is, she still needs a team of hairstylists to fix her strands up in the morning.
Don't have a matching glass cup set? No problem. If you have a bunch of variously shaped and sized water glasses, you can make them match easily - and stylishly - by painting on some easy animal patterns.
If you want to create the type of makeup look where the makeup IS the costume for Halloween, then look no further than this video. You'll be guided step by step through creating a facial prosthetic from latex. This prosthetic can be shaped any way you want to form rotting flesh for a zombie costume, scars and wounds, even bullet holes.
Make your own armor with a weathered look out of Sintra (or expanded PVC foam). You'll need a heat gun, a padded cushion, paper towels, rub'n'buff in silver leaf, a knife, a marking pencil, water and a can of spray primer. Trace your piece onto the Sintra, then use the heat gun to shape it. Useful for costumes, Halloween or larps.
Bonsai is a beautiful art that focuses on manipulating a tree to any shape you desire! If you've wanted to grow your own bonsai from a seedling to the full thing and are wondering where to start, check out this video! In it you will learn what sort of trees that you can plant to make into bonsai, as well as how to grow it from seed to seedling!
When getting started with metal work and blacksmithing, you may be confused as to what you can do with an anvil. In this video you will learn every aspect about the anvil and how to actually use each section of the anvil for cutting, shaping and more!
Tomatoes can be cut in many different ways for cooking, or into ornamental shapes for garnish, but there exists a basic way of dicing and slicing them up to make them taste the most delicious when you cook them.
Ever wanted to replicate the effect of writing text in a circle or other shape? You can set up a path for your text to follow using the GIMP free image software. This tutorial shows you a straightforward technique to achieve this effect.
If you're looking for a good tutorial on how to make a classy, minimalist desktop background, this tutorial shows you how! Using nothing more than a single shape and then your brushes and gradients tools, you can create an attractive wallpaper in Adobe Photoshop.
In this clip, you'll learn how to incorporate movable M7th chords into your ukulele playing. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.
In this clip, you'll learn how to incorporate movable 7th chord shapes into your ukulele playing. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.
Are you planning on throwing a memorable Halloween party this year? Give your party invitees a taste (literally) of the treats they'll be experiencing at the bash by including a cookie with your invitation.
Need some help figuring out how to construct geometry in AutoCAD 2011? This clip will teach you everything you'll need to know. Whether you're new to Autodesk's popular 3D drafting application or a seasoned professional just looking to better acquaint yourself with the newest iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
Light, fluffy, and resembling a dollop of melted marshmallows, meringues look like marshmallows (which are yummy to begin with) but taste about ten times better. That's because meringues add egg whites and sugar to the mix.
Need to know how to make a sandwich-style loaf from bread dough? Then you need this quick guide from Apartment Therapy. With the proper technique, making your own loaves of bread can be easy. So easy, in fact, that this free video cooking lesson can present a complete overview of the process in about a minute. For more information, and to get started making your own loaves, take a look.
Feng shui out your drawing skills by doing something a little different this time: rather than focus on architectural buildings and stairways, why not sketch out a soothing garden to ease your tired soul?
Cardio intervals, circuit training, plate exercises...when it comes to fitness, it seems like there's always a fancy name for what are essentially really easy yet effective strength building, fat burning, and toning exercises.
If you're a habitual sewer, especially one who switches between threads and needles frequently to work on a complex project, then a pin cushion is not only a nice tool to have, but also a necessity for good work flow.