Free Tips Search Results

How To: Build web icons for a navigation bar in Photoshop

Looking for a guide on how to create icons for your website? With the Adobe Photoshop, it's easy. 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 Tutvid. For more information, and to get started creating navigation bar-style web icons yourself, watch this graphic designer's guide.

How To: Use the Adobe Camera Raw plug-in for Photoshop

Want to work with RAW image files in Adobe Photoshop? With the Adobe Camera Raw plug-in, it's easy. 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 Tutvid. For more information, and to get started using and editing RAW image files in Photoshop yourself, watch this graphic designer's guide.

How To: Create a quick wooden texture in Adobe Photoshop

Create a cherry wood texture in Photoshop with the noise filter and few other built-in tools. 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, which offers a step-by-step guide on how to generate wooden textures at any resolution in under five minutes.

How To: Restore an old film photograph in Adobe Photoshop

Want to preserve an old family photograph for posterity without also preserving the physical imperfections of the print? Touch it up with Photoshop. 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 the folks at Britec Computer Systems. This video offers a step-by-step guide on how to restore images within Adobe Photoshop.

How To: Use Crayola Hassle Free watercolor paints for projects

Crayola Hassle Free Watercolors are like regular watercolor paints, without the mess! There are no cups of water to tip over and no paints to spill. The specially designed paint pots contain a bright, solid color that is only activated when you dip in the brush tip. You can even turn them upside down and they won't spill or drip. This tutorial teaches how you and your kids can use these innovative hassle free watercolor paints from Crayola.

How To: Clean up under your eyes with Brooke Burke

Brooke Burke shares a personal mini tip. According to her under eye cleansing is important because usage of different shadows cause some spillage. She used a cotton bud to apply cleansing cream in her under eyes area. She applied little cream on her hand and then with the help of cotton bud, she applied it on her under eye. She shared with her viewers that during a busy working day, she always keep eye buds and eye cream in her purse and clean her under eyes. This ensures to keep wrinkles hid...

How To: Count unique values greater than 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 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Add a workbook reference to an Excel VLOOKUP formula

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Play the basics in Evony

Learn everything you could possibly want to know about the internet, multiplayer game Evony with tutorials from EvonyTutorials. Watch this video tutorial to learn how to play the basics in Evony online. See exactly what the game Evony is!

How To: Get over a broken heart using 15 tips

This video is a how-to video on how to get over a broken heart using the authors fifteen tips. The video scrolls through the fifteen tips one at a time with encouraging sounding music playing in the background. The segment explains different ways of fixing that broken heart by deleting an ex from your contacts and friends lists to getting rid of those sappy love songs that are on your MP3 player. This video is to help those girls with a broken heart. By using these fifteen tips to get over an...

How To: Choose the right speed film for cameras

When choosing camera film, use slow film for bright day light, medium speed film for a cloudy day and high speed film for low light conditions. Choose the right speed of film for a particular camera with the tips in this free instructional video on photography tips from a professional photographer. The speed of the film is essential in determining what type of environment you will be taking pictures, so listen up!

How To: Load film into a camera correctly

When loading film into a camera, never touch the blades of the shutter and make sure to advance the film a couple of times in a manual camera. Load film in a camera with the tips in this free instructional video on photography tips from a professional photographer. Loading film is an important first step for new photographers.

How To: Develop film for a black-and-white photo

When developing film for a black-and-white photo, first extract the leader of the film from the film canister and then pull out the rest of the film in total darkness. Develop a black and white photograph with the tips in this free instructional video on photography tips from a professional photographer. Good information for black and white photography students.

How To: Choose the right camera lens

When choosing a camera lens, use a telephoto lens for a zoom or a wide-angle lens for a broader view, which allows photographers to fit more of a subject into a photo. Choose the right lens for a specific photo with the tips in this free instructional video on photography tips from a professional photographer. Lens are very expensive, so make sure you are educated before you buy a new camera lens.

How To: Read a hand-held light meter

When reading a hand-held light meter, make sure the ISO setting is correct and point the cone of the meter toward the subject to get an accurate reading. Learn how to read a hand held light meter with the tips in this free instructional video on photography tips from a professional photographer. After learning about the light meter, you won't make any aperature mistakes in the future.

How To: Buy a camera flash

When buying a camera flash, make sure it is compatible with the camera and can act as a fill flash for daylight photographs. Purchase a camera flash with the tips in this free instructional video on photography tips from a professional photographer. Now you will know what to do when you are hunting for a camera flash.

How To: Take a free kick in soccer

Become a better footballer with Coach King's Skills School from the UK's best selling footy magazine, MATCH. Learn how to take a free-kick with the tips in this how-to video! Follow along with the step-by-step instructions in this video soccer tutorial and learn how to take a great free kick.

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Retrieve data from many tables on many sheets in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...

How To: Clean up a bad data set for a pivot table 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 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate variable commission totals in MS Exce

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...

How To: Convert a text formula/function to a number in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Hide columns and select only visible cells 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 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Do a driven free kick

This video instructs the viewer on how to do a powerful Driven Free kick for soccer. First, you will need to come on to the ball and strike it with your in-step. Your in step is the inner part of your foot that is right next to the laces. The most important tip is that when you do strike the ball, come through the ball and not around it! Finish with a hop at the end which will create more power! You'll want to kick the ball just under the center for proper height and maximum power. Kick the b...

How To: Do a Trivela free kick

This video shows the viewer how to take a ‘Trivela’ free kick. This is where the player kicks the ball with the outside of their foot. This makes the ball curve towards the foot that the player kicked the ball with – a right footed shot will curve to the right and vice versus. The main point the video makes seems to be to make good contact with the ball. This is very crucial. The video also contains other tips and tricks as well as some footage of successful ‘Trivela’ free kicks taken by the ...

How To: Apply professional, flawless foundation with tips

There are lots of key parts to creating beautiful makeup, but if you had to ask us for the most important step we'd without a doubt say foundation. Good skin looks good no matter what other type of makeup you decide to you put on, whether it's smoky eyes or red lips. That's because beautiful, flawless skin acts as a smooth, pretty base.