Free Tips Search Results

How To: Change focal plane & create custom edges in Photoshop

Learn how to change the focal plane of images and check out tips on creating custom edges! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started using these tips in your own Photoshop, watch this guide!

How To: Use the ADDRESS function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.

How To: Make gluten-free gravy

Don't give up turkey gravy just because you're cooking for a gluten-free diet. Use these tips when preparing this Thanksgiving favorite. Gluten-free diets are proven to help digestion and ease a variety of ailments. This gravy will make your gluten-free meal savory.

How To: Create rounded-off square forms in Blender 2.5

In this quick Blender 2.5 video tip, you'll see how to easily model a rounded-off square form by using snapping/retopology tools. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!

How To: Use MS Excel 2010's NORM.DIST & NORM.S.DIST functions

New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel 2010 video tutorials, you'll learn how to use the new NORM.DIST and NORM.S.DIST normal distribution functions. They have new screen tips to help you select the correct argument.

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: Draw snowy pines with colored pencil

To draw snowy pines in colored pencil, depict the tree with snow weighing down the branches and with snow dunes in the background. Learn to depict snow on trees with tips from a professional illustrator in this free instructional video on drawing. All you need are a few tips and tricks to master the art of drawing snowy pines.

How To: Get a free drink from a bartender

Everyone likes free things, and everyone likes drinking. Combine the two and you've got one happy hour. You will need no expectations, a smile on your face, basic common courtesy, and some money. Never ask for a freebie. It doesn’t work, and since most bartenders have good memories, you’ll always be known as the cheapskate. Be polite

How To: Clean an SLR camera

When cleaning an SLR camera, use a stiff brush to remove dirt and a lint-free cloth to remove grease marks. Clean an SLR camera with the tips in this free instructional video on photography tips from a professional photographer. Clean your SLR camera like a pro.

How To: Clean a camera lens

When cleaning a camera lens, use stiff brush to remove the dirt, then wipe lens with a lint-free cloth. Clean camera lenses with the tips in this free instructional video on photography tips from a professional photographer. Be sure to be sage and avoid scratching the camera lens.

How To: Get geared up for camping

Better TV has some stress-free tips to packing your camping gear. Check out this how-to video for getting geared up for camping. Hopefully you don't have to buy all your gear. Watch these stress free tips for packing your outdoor gear!

How To: Copy user settings in Blender 2.5

This quick Blender 2.5 tip video demonstrates an easy way to copy over your settings from previous testing builds of Blender 2.5 to the latest build you have downloaded. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instru...

How To: Average with the MONTH function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 90th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see a complicated average calculation with multiple criteria using the MONTH function on a date field. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Apply conditional formatting to a row 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 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Save money on your phone bill & upgrade early for free

In this clip, learn how to make the right phone calls and press the right buttons to "trick" your phone company into giving you a free phone upgrade before you are due. You will also learn how to save money on you phone bill by using a few choice words on the telephone. This trick works for Sprint, Verizon, T-Mobile and AT&T, so not matter who your carrier is you will be golden. This clip is hosted by an ex-employee from a cell phone company, so it is full of insider tips.

How To: Render objects in Blender

This clip presents a quick introduction to rendering within Blender, the popular (and free) 3d modeling app. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions on how to get started rendering, take a look!

How To: Animate a 3D object within Blender

This clip presents a general introduction to animating models when working in Blender, the popular (and free) 3D modeling app. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions on how to create your own simple ani...

How To: Make a curtain in GIMP, the free Photoshop alternative

In the mood for a little digital decadence? Learn how to create red velvet drapes using the GIMP image editor. Whether you're new to GIMP or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial. For more information, including step-by-step instructions on how to get started creating your own digital curtains, watch this graphic designer's guide.

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!

Prev Page