Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function in a formula to replace a long IF function formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 59th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an aged accounts receivable report using a pivot table (PivotTable) and grouping.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
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 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. 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 37th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a table of formulas and labels based on formula inputs in an assumption area.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 36th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP function to determine an increase in salary based on a rating scale.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
Surprise your kids or grandkids with a delectable and unique cupcake cake for the fall! Cupcake cake, you ask? A cupcake cake is made up of a number of cupcakes grouped together and then iced and decorated as if it were a single cake, creating a wonderful pull apart style dessert! In this video, learn how to make a beautiful fall-themed cupcake cake the kids will love!
This is a video tutorial showing its audience how to play the song "Sea of Love" on the ukulele. The first step is to hold your ukulele properly. Then you can begin to play the notes. The notes in this song are in the following order: G, C, E, A. Then play the chords, B flat, D7, E flat, C7. Next to play the song you will play a loop of eight beats when you strum. Each beat is a down or an up strum. If you sing along to this song then you will be able to easily keep in tempo. Next you should ...
Are you not really a big fan of sewing but love making things? You're in luck! Learn how to make a no-sew blanket with help from this tutorial! Keep yourself and the ones you love warm with this amazing blanket design that crafters of all levels can complete!
If you love fantasy books and love to draw, this video is for you. Learn how to draw a spooky, haunting fantasy tree with help from fantasy artist, Wayne Tully. Apply this tree to your fantasy drawings to make something worth hanging!
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to take advantage of metadata embedded in an image to create live captions and then automatically and flexibly place them in your layout.
When someone you love asks for money it can be very hard to turn them down; especially since you are usually put on the spot. Check out this tutorial and discover ways that you can help your friend without having to spend a dime, and make things easier for everyone.
Don't you just love Lucy? I know I do, especially that hair of hers. This video will show you exactly how to get that "I Love Lucy" signature hairstyle.
Everybody loves Tommy Johnson's music, that is, everyone who loves the blues. And in this video lesson, you'll learn how to play Johnson's song "Big Road Blues" on your blues guitar. If you want to learn the delta blues, this is a good starting place.
This video demonstrates an easy exercise, that anyone can do at home to get rid of love handles and improve overall physique. Lying down on the floor, you must bend your knees and keep your feet 18 to 24 inches apart. With your arms straight down on the side of your body, crunch forward and to the side a few inches, reaching for your left heel with your left hand. Return to the starting position and repeat the exercise to the other side. This is one repetition. This video is a good visual dem...
In this video from theXBox360GameReview we learn how start and join an Xbox Live party. Once signed into Xbox live, scroll to the friends channel, and select the friend you want to have your party with and press Y. Now that you have a party going, you can play some Halo wars. If you want more friends to join the party go to your friends list using the guide button and tap X to select who you want to invite. If you want everyone in the party join in, select Party and choose Invite Party to gam...
Worried about your or someone you love's relationship with alcohol? Not all alcoholics fit the stereotype of the down-and-out drunk. Learn to recognize the warning signs in yourself or a loved one.
Trying to trust again after your loved one fell into an emotional affair? It can be incredibly difficult, so here is some advice from two "love experts" who say if you can't get over it, to cut that person loose. Watch this YourTango advice video to see why it might be the best alternative.
Although very strange, after watching this video, you'll know how to make your very own voodoo love doll!
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to use GPS maps and the compass on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
This tutorial will show you how to use live paint in Illustrator. Using live paint in CS2 recognizes empty spaces even those with gaps.
This beauty video demonstrates how to create a St. Patrick's Day makeup look.
Learn how to play "Spiralling" by Keane, an acoustic guitar tutorial. Follow along with this demonstration, tabs and lyrics here:
Learn how to play "Don't Forget" by Demi Lovato, an acoustic guitar tutorial. Follow along with this demonstration, tabs and lyrics here:
People are very opinionated about what version of Microsoft they like. Some people love the easy-to-use nature of classic Windows 2000 and stick with that, whereas others love the upgraded, super sleek Windows Vista version which has its faults but at least looks amazing.
Learning to play your favorite songs will, down the road, help you to make the sort of music you want to make. In this free video guitar lesson, you'll learn to play John Mayer's "Love Song for No One" on acoustic guitar. While this video assumes some knowledge on the part of its audience, beginning guitarists will find much to take away. Get started playing John Mayer's "Love Song for No One" on your acoustic guitar with this video tutorial.
Do you love Gossip Girl? Then you will love this playground workout routine. Follow along in this fitness how-to video as Self Magazine and Jessica Szhor show you how to get in shape with a few exercises you can do at the park. Watch as the gossip girl learns to chin-up, dips, balance bends, crunches, slides, pulls and a combination of a few other exercises on the monkey bars.
Check out this instructional acoustic guitar lesson that shows you how to play the classic song "I Love Rock and Roll" by Joan Jett. Improve your guitar playing skills by learning this song by Joan Jett with this tutorial video. Practice your guitar technique and soon you will be playing "I Love Rock and Roll"!
Check out this instructional cross country video that demonstrates how to eat properly so that you love running more. Because every runner is different, develop a nutrition plan that works for you. Experiment to find out what meals work best for you. Check out this tutorial that provides tips on eating properly to enhance your running workout.
Check out this instructional cross country video that shows you how to increase your speed so that you love running more. Most runners have long term goals to increase their speed. Speed is a sign of progress. Whatever your motivation, introducing speed drills just once a week will improve your fitness and stamina. Speed workouts don't have to be intimidating at all with this tutorial.
Check out this instructional cross country video that shows you how to increase core strength so that you love running more. A lot of people underestimate the importance of a core strength routine. Your core muscle groups consist of your abs, lower back, glutes, and obliques. Improving your core strength does several things to make you a better runner and avoid injury.
If you love shellfish and barbecuing then you'll love this recipe. Watch this cooking how to video as our host demonstrates how to make lime, chili and garlic prawns cooked on the grill. You could also cook this shrimp recipe in a wok or fry pan if you wanted. Enjoy this spicy and tangy prawn recipe.
If you love seafood you will love this breaded fish recipe. Watch this cooking how to video as our host prepares a crumbed snapper recipe in a wok. This snapper recipe is similar to popcorn fish. Cut your fish in tiny bite size pieces, cover them in batter and deep fry them in your wok.
If you love barbecue and shellfish, then you'll love this recipe. This cooking how to video demonstrates a great seafood recipe for the outdoor grill. Watch as out host shows you how to prepare and cook honey soy prawns on the BBQ.
Microsoft Office Live Meeting is a conferencing solution that you can use to engage audiences in online meetings, training, and events. Learn how you can schedule, join, or present a Live Meeting by using new features such as audio, video conferencing, uploading handouts for distribution, and using Microsoft RoundTable.
