Knowing Tips Search Results

How To: Get Kim Kardashian's everyday makeup look

Kim Kardashian's star just keeps on rising, and that is largely due to her beauty. In this tutorial, learn how to create the same look that Kim wears most often on yourself! If you are inspired by Kim's glamour and want an everyday red carpet ready look, this is the style for you!

How To: Pick up the samurai army in Black and White 2

In another tutorial from the people at cnet, you'll find out how to pick up the samurai army in the popular PC game, Black and White 2. This little tip will not only ensure that you have some of the most powerful fighters at your disposal, but you'll be able to have an army that can take care of anyone in a matter of seconds. So sit back and enjoy!

How To: Retrieve multiple values from a horizontal Excel table

hether 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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.

How To: Filter data in eight different ways in Microsoft Excel

hether 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 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.

How To: Reference worksheets and workbooks in Excel formulas

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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.

How To: Multiply & sum arrays with Excel's SUMPRODUCT

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.

How To: Create projections for sales numbers in MS Excel

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.

How To: Automatically highlight negative numbers in MS Excel

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!

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

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.

How To: Create an average with multiple criteria in MS Excel

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.

How To: Create an Excel inventory template with running totals

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.

How To: Evaluate vendors with array formulas in MS Excel

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.

How To: Count unique records exceeding a hurdle in MS Excel

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.

How To: Prevent duplicate entries in an Excel spreadsheet

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.

How To: Calculate plate cost for a print shop in MS Excel

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.

How To: Use a VLOOKUP function inside a text formula in Excel

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).

How To: Get in shape with swimming

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!

How To: Freshen your bad breath

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.

How To: Talk to a girl on the phone

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!

How To: Speed productivity in FarmVille w/ a "boxed in" glitch

You can speed up productivity in FarmVille with a simple glitch that everybody knows about by now. Somehow, someway, boxing yourself in on FarmVille allows you to speed up the process, because you don't have to walk around to complete each task at hand. Watch and see how to speed productivity in FarmVille with a "boxed in" glitch (12/13/09).

How To: Play "Sweater Song" by Weezer on electric guitar

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.

How To: Open a stubborn jar

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.

How To: Use serrated scissors

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.

How To: Simulate a hand drawn picture in Photoshop

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.