Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 74th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to fix bad data with the CLEAN & TRIM functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). 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 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. 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 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost 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 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. 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 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in 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 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP 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 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).
Get in shape and tone your body by getting in that pool for a swim! There's nothing better for your body than swimming and there are numerous techniques and avenues for the swimmer who wants to get in better shape. In this video, get expert tips and advice on how to get in shape with the help of swimming!
Nobody likes having bad breath. Not only does it leave you with a bad taste and scare away potential suitors, it can be a signal of more serious dental issues. This helpful video from Colgate offers up some tips you can use to cure your bad breath and improve your overall health.
Talking on the phone with a girl you like for the first time can be nerve wracking. Luckily, The Wing Girls are here to help with their honest and earnest dating & relationship advice. Learn how to get past that first phone call and get comfortable on the phone with your crush with tips & tricks given here!
Especially in winter time, your immune system can go on a roller coaster ride. In this tutorial, learn how to boost your immune system naturally and up your defenses against things like colds and the flu. In this episode of Ask Amy, Amy takes you through your local supermarket and shows you the right things to eat and drink to build immunity. Follow these tips and fly through next flu season like a breeze.
Marty Schwartz leads you through the basic chords for Weezer's Sweater Song. If you are looking to learn how to play the electric guitar, he gives a simple, easy, effective lesson that anyone can follow. The tips are shown visually, making the lesson easy to comprehend. He goes on to play the chords taught during the lesson, giving an audio reference to how your playing should sound, something I found to be very helpful.
Want a quick meal, but the jar won't open? Here are some tips: try slamming it on your kitchen counter-top upside down, but not with enough pressure to break the jar. Another option is running hot water over the lid of the jar, to loosen it up. You can wear rubber gloves to give yourself a better grip, as well. This should solve any hurdles in the way of last-minute dinner preparations.
If you want to house train your puppy or dog by yourself, this video is for you! It will show you the best tips to make your puppy learn how to live in your house without creating any problems!
In the video Boiling Pasta we are taught that there is actually a recipe for how much water to boil per pasta being prepared--1 liter per 100gm--and also what amount of salt--10gm salt to 100gm pasta, after boil. Most people preparing pasta may not know that adding oil while pasta is being boiled will cause it to not adhere to sauce. The video provides many useful tips in preparing pasta, most important of all when it is done just right.
Thread and clothing designer, Kenneth D. King, give quick instruction to us on the importance of our cutting tools, more especially the serrated scissors. Here we learn what makes this particular style of scissors so efficient and necessary to our sewing work, as well as what types of materials they ought to be used on. He also gives warning that we should never use our fabric scissors on paper. Great tips for the beginning designer in us all.
This Photoshop tutorial video teaches you how to make any photo look like it was hand drawn. The image selected should have a relatively simple background, because a too detailed image will not turn out properly. Use the high pass tool and the sketch paper tool and you pretty much have your hand drawn image. Follow this video for extra tips on how to get your image to look like hand drawn perfection.
If you use these tips, you can help your nails grow faster as well as look longer.
L.A. Lakers superstar Kobe Bryant shares some tips with TIME Magazine's Sean Gregory on how he puts his best foot forward everytime he steps onto the court. Areas gone over in this video include: The proper grip & shooting form, attack the foot & sell the fake, the pull-up jumpshot, the art of the foul shot, playing to the opponent's weaknesses, getting in character, and stretching.
Attention aspiring horror movie makers! Have an interest in making fake heads to use as your gory extras? BITY Mold Supply has supplied the world with this great tutorial on how to cast a silicone head or face from Gel-10 and Polyfoam. In the later half of this video, BITY lends great tips on how to paint your finished silicone face for a realistic look.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Pamela Anderson's makeup look, easy at home. Fun celebrity style tips. This Pamela Anderson look is sexy and fun.
Makeup geek brings you this tutorial on creating celebrity style makeup. Learn how to create the beautiful Angelina Jolie's makeup look, easy at home. Fun celebrity styling tips. This Angelina Jolie look is classic and stunning.
An easy makeup tutorial to look fresh, youthful and effortless. This makeup routine takes me 5 minutes tops! It's all about minimal eye makeup and giving your lips and blushing skin the attention.
In this tutorial Cy starts out a human figure from above in 3/4 view. Some tips for putting the horizon line on the page.
Here is a Harper Point Photography video on gobos for fashion photography. Nathan gives a simple but effective photo tip for creating dynamic light with a cardboard 'go-bo.' The gobo is a lighting element that texturizes lighting by blocking in strategically. Apply these directly to a light to shine texture or to light with words as a projector would.
