Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
The white bits on a person's face are often what make them appear healthiest and happiest. In this tutorial, learn how to enhance someone's face by improving the white areas of their faces. In it, you will learn how to focus on the eyes and teeth of your subject to whiten and enhance them. With this trick, your subject will appear cleaner, healthier and more alert.
There are so many ways to enhance your photos in Photoshop these days, it is amazing we need actual models at all! In this video, learn how to add or change the makeup on your model. If you have changed your artistic idea after shooting, or feel like your subject could just use a little something, check out this tutorial and learn how to add color to your photos.
Sick of seeing that little AT&T logo in the corner of your iPhone screen? Looking for a way to personlize your device even further? Well, you're in luck!
Most people know how to take a screencap on their PC or laptop, but what about your mobile device? Taking a screencap on your phone can be very useful. For example, if you are reviewing an app you may need screencaps, or if you are having a problem and wish to ask someone else about it in detail, you may also need screencaps to remember a moment on your phone that you would have otherwise forgotten, or to post an image of your screen online.. whatever the reason, this tutorial will show you how.
If, for whatever reason, you need to show someone else a photo of your computer screen, you will need to take a screen shot. In this tutorial, learn how to copy your screen on a Windows based PC.
Project Linus is an organization that provides security blankets for seriously ill or traumatized children. In this tutorial, learn how to make an easy fabric panel quilt to donate to a child in need. Project Linus is a great organization that provides warmth to every child, no matter what the season. So, if you would like to donate to this worthwhile cause, follow along with this video and learn how to make an easy but comforting cover that any child will love.
Want to play the Eagles' "Hotel California" on your ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Hotel California" on your own uke, wa...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 99th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create and use the mathematical constant e in Excel. Also learn about the EXP function.
In this tutorial, learn how to make a basic Christmas card in under 5 minutes using paper and glitter glue.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this drawing tutorial, learn how to draw a Native American Indian teepee with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Big fan of the Vocaloid Character Vocal Series? You're definitely not alone. In this drawing tutorial, learn how to draw Rin Kagamine from Vocaloid with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
In this tutorial, learn how to make a very cool wet writing effect that you can use for graphics and logos. You will be creating this effect in Photoshop CS4. In this video, you will learn how to take tons of different layer styles and transform a basic text layer into a majestic piece of artwork. You will be shown the process step by step from the very beginning. This tutorial also shows the use of gradients and color corrections tools to optimize the full piece of work.
Kid Goku is a martial arts master with superhuman strength from the ultra-popular anime series, Dragon Ball. Learn how to draw Kid Goku with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Don't have enough cash to go to Paris this summer? Bring Paris to your bedroom for no money down with help from this drawing tutorial. Learn how to draw the Eiffel Tower with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of sujects, characters and cartoons!
Are you a fan of the teletubbies? You're not alone: You and millions of other kids across the globe. In this video, learn how to draw your favorite teletubbies with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Are you fan of the Canadian-American children's educational show, Arthur? Learn how to draw the main character, Arthur, from the series with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Learning to decorate cakes? Try this design on for size. In this video, learn how to decorate a buttercream tulip cake with a basket of tulips on the front face of the cake. Get tips on how to perfect this design from cake decorating expert, Serious Cakes.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. 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 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. 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 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $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 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assign the macro to a form button. 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 make candy corn out of polymer clay. Users will need yellow, orange and white polymer clay. The yellow is the largest, the orange is the medium and the white is the smallest. Begin by rolling each of the clay into balls and stack them on each other like an ice cream cone. Then flatten it and press on the sides to inflate and square it. Make the top part the widest (yellow) and make the bottom the most narrow (white). It should be in a shape of a tr...
In this video tutorial, viewers learn how to reupholster the seat of a chair. Begin by taking the seat off the chair and remove the staples on the back of the fabric. Remove the fabric and cushion, leaving you with the wood base. With polstry foam, cut the foam out 1/8" larger than the board. With wool batting, cut the batting 4" larger than the board and then staple it to the board. Finish it by covering it with some decorative fabric. Cut the fabric 4" larger than the board and staple it on...
In this video tutorial, viewers learn how to rent bikes in Europe. The cost to rent a bike is about $15 and the cost decreases per day the longer you rent it. Bikes can easily be rented in towns in small rental shops. Europe has many bike paths with signs for tourists to travel along without any traffic. To find these paths, users should get information from the tourist information centers or bike rental shops. This video will benefit those viewers who will be visiting Europe and would like t...
In this video tutorial, viewers learn how to make swirled chocolate heart cake decorations. Users will need a heart shape cookie cutter. Brush some oil inside the cookie cutter and some butter one the outside. Then press on some wax paper on the outside of the cookie cutter to create mold. Now pour in some melted white chocolate and fill in the heart shape. Now add the chocolate. Using the sharp point of a knife, swirl it around the chocolate to create a swirl design. Place the cake into the ...
In this video tutorial, viewers learn how to change the flashing white screen-shot on an iPod Touch or iPhone. Users will need to have their iPod device jail-broken and have the Winter board application. Begin by opening the application and install SB-Flasher. Now go to the link in the video description and select an image that you would like. Rename the image to "SBScreenShotBG.png". Then download the file from the video description and extract it. Now drag the image into the SpringBoard.app...
Stampin' UP! punches make just as fun designs as their line of stamps. In this tutorial, learn how to fashion basic flowers out of punches. These flowers make great additions to your scrapbooking or greeting card crafts.
Believe it or not, you are more likely to hurt yourself or others with a dull knife. Not only are sharp knives better to cut with, they are much safer to use. When you are fishing, the fillet knife is one of your most important instruments. In this tutorial, you will learn how to sharpen your knife on the go and keep your instrument in tip top shape. In order to sharpen a fillet knife, place the blade of the knife in the "V" of an Accusharp tool before following the blade off the table. In th...
A roll cast is a way to throw your rod and catch more fish. Specifically, in fly fishing, a roll cast is performed by tipping the rod back to two o'clock and throwing it as if it were a ball. You would use a roll cast on a windy day to get the best toss. You will learn how to perform this maneuver with help from an experienced fly fisherman in this tutorial. This video will show you exactly what you need to know to roll cast your rod and line. You will learn everything necessary, step by step.
The most important aspect of fly fishing is the fly! In this tutorial, learn how to tie a fly to your line for fly fishing. You will learn how to attach a fly to the leader on your line. A fly isn't attached to a fly fishing line because the leader is attached to the fly line, and the fly is attached to the leader. Find out how to moisten fly line to reduce friction and strengthen the knot with help from an experienced fly fisherman in this instructional video on fly fishing equipment.
Rainbow trout are a unique, elusive catch. When you are hunting this fantastic fish, you will need to have specific skills and certain equipment. In this tutorial, learn how to fish for rainbow fish like a pro, with expert advice.
In this video tutorial, viewers learn how to de-stress with a self massage for the shoulders and neck. This process can be done anytime of the day and only takes 5 minutes to do. Begin by squeezing the sore shoulder with the palm of your hand. Now raise the massaging arm up and hold the elbow. Now start massaging the back of the shoulder blades. Then use the palm of your hand and press it against the neck. Continue squeezing the neck and shoulders until the pain is relieved. This video will b...
Just because you are not at home is no reason to abandon your healthy eating lifestyle. In this tutorial, you will learn all about planning healthy meals and snacks while you are on the go. Discover how to pack your backpack with the right, lightweight snacks and maintain proper nutrition when out and about. Of course, when planning caloric intake and healthy eating for a backpacking trip, it's important to create a backup plan in case something doesn't go according to plan. Learn about carry...
In this video tutorial, viewers learn how to apply foundation on the face. The material required are: liquid foundation, concealer stick, loose powder, foundation brush and powder brush. All the products are from the brand, BYS. Begin by adding some liquid foundation onto your hand and apply it on your face with the foundation brush. Now apply the concealer stick around the eyes and nose. Then finish by apply the loose powder all around the face with the powder brush. This video will benefit ...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
Some people believe that it is disrespectful to fold your American flag the wrong way. In this tutorial, avoid any confusion and learn how to properly fold your flag for storage or display.
