Free Tips Search Results

How To: Create a chrome text effect in Photoshop

Looking for instructions on how to achieve a chrome-style text effect in Adobe Photoshop? Look no further. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how to create a shiny metal text effect, watch this graphic designer's guide.

How To: Use the T.DIST.2T in Microsoft Excel 2010

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 8th installment in his series of Excel 2010 video tutorials, you'll learn how to use the Excel's new T functions — namely, T.INV, T.INV.2T, T.DIST, T.DIST.RT and T.DIST.2T.

How To: Use the CONFIDENCE.T function in Microsoft Excel 2010

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 7th installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new CONFIDENCE.T function to calculate the margin of error for a T distribution confidence interval.

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: Draw the human neck

Figure drawing is the basis of fine arts education, so watch this how to video on drawing the human neck. To draw the human neck, pay attention to the muscles and bones that represent its shape. Draw an anatomical human neck with tips from a professional illustrator in this free instructional video on drawing.

How To: Travel bed bug free

In this video, Jeff gives some tips to frequent travelers on how to avoid bringing bed bugs home with them. First, you should begin with inspections of a hotel room, making sure to bring a flashlight and looking carefully in the bed for any bugs. After a stay at a hotel, you should always check yourself for bed bugs before going home. This includes methods such as placing your suitcases in bags in order to avoid infesting your car and emptying your clothes from your luggage outside your home ...

How To: Avoid a #NUM! error when changing NPER inputs in Excel

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.

How To: Remove duplicate entries with Excel's COUNTIF function

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.

How To: Find the first instance of an item 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 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.

How To: Deliver words to a cell via IF, AND & VLOOKUP in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.

How To: Look up approximate values with VLOOKUP 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 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...

How To: Evaluate a random value against 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 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...

How To: Create a telephone effect with EQ in Logic Pro 8 or 9

Need some help figuring out how to achieve that classic "telephone" effect in Logic? Let this clip be your guide. Whether you're new to computer recording, new to the Ableton Live DAW (digital audio workstation) or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from NextStepAudio. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a custom multi-sample instrument in Logic Pro 8 or 9

This clip provides a lesson on how to generate a custom multi-sample instrument within Logic Pro Studio. Whether you're new to computer recording, new to Apple's Logic Pro DAW (digital audio workstation) or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from NextStepAudio. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a rhythmic gate effect in Ableton Live 8

This clip provides an overview of how to create a dancy rhythmic gate effect in Ableton Live 8. Whether you're new to computer recording, new to the Ableton Live DAW (digital audio workstation) or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from NextStepAudio. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a multi-band rhythmic gating effect in Logic Pro 8 or 9

Learn how to a create a fancy, dancy multi-band rhythmic gating effect in Logic Pro. Whether you're new to computer recording, new to the Apple Logic DAW (digital audio workstation) or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from Next Step Audio. For more information, including detailed, step-by-step instructions, take a look.

How To: Create a color wipe effect in Sony Vegas Pro 8

See how to create dynamic, eye-catching color wipe transitions in Sony Vegas Pro 8. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Do motion control when working in Adobe After Effects

This clip presents an overview of how to do motion control effects within Adobe After Effects. Whether you're completely new to Adobe's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Add a muzzle flash effect in Sony Vegas Pro

In this clip, you'll learn how to create and apply a muzzle flash effect in Sony Vegas Pro for simulated gun fights and shootouts. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Add background images to a credit roll in Sony Vegas

See how to add an image to your opening or closing credits with Sony Vegas Movie Studio or Sony Vegas Pro. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Speed up or slow down a video clip in Sony Vegas Pro

In this video, you'll learn how to perform simple time manipulations in Sony Vegas Pro. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Make text and titles pop in Sony Vegas Movie Studio

In this clip, you'll learn a few tricks of the trade for making your title text pop. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Create and use Smart Objects in Adobe Photoshop CS4

Learn how to create and utilize Smart Objects when working in Adobe Photoshop CS4. 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 Smart Objects in your own Photoshop projects, take a look!

How To: Automate tasks in Mac OS X with QuicKeys 4

This quick clip presents a general introduction to creating macros and automating processes within Mac OS X using QuicKeys 4. Whether you're new to Startly Software's popular macro and automation application or are merely looking to pick up a few new tips and tricks, you're certain to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this video guide.

How To: Use library linking in Blender

This clip provides detailed, step-by-step instructions on how to link libraries in Blender. 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. For more information, and to get started linking libraries yourself, take a look!

How To: Do real-time texture splatting in Blender with GLSL

Learn how to texture splat in real time with the help of GLSL shading.umetric clouds when working in Blender. 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. For more information, and to get started doing real-time texture splatting yourself, take a look!

How To: Create daytime volumetric clouds in Blender

This clip provides detailed, step-by-step instructions on how to model and render daylight volumetric clouds when working in Blender. 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. For more information, and to get started rendering volumetric clouds yourself, take a look!