Tips Yang Search Results

How To: Create a 3D ice object in Photoshop

Looking for an easy way to create 3D abstract art? Have Photoshop CS3 or later? 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 your own custom three-dimensional ice sculpture and how to create and apply textures, watch this graphic designer's guide.

How To: Create basic 3D shapes in Photoshop

Looking for an easy way to create 3D shapes? Have Photoshop CS3 or later? 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 your own custom three-dimensional shapes and how to create and apply textures, watch this graphic designer's guide.

How To: Add or remove tattoos in Photoshop

Want to separate a foreground object from its background? 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 get started doing digital tattoo removal yourself, watch this graphic designer's guide.

How To: Remove glasses from a face in Photoshop

Want to digitally remove a pair of glasses? Given patience and a little Photoshop know-how, it can be done. 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, including step-by-step instructions, watch this graphic designer's guide.

How To: Composite and combine images in Photoshop

Ever wanted to combine two or more images? With Adobe Photoshop, it's a simple process. 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 composites in Photoshop yourself, watch this graphic designer's guide.

How To: Create a wipe image transition in Adobe Photoshop

Learn to use Photoshop's new timeline animation system to create a wipe-style image transition! 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 wipe transitions yourself, watch this graphic designer's guide.

How To: Sharpen and smooth skin in Photoshop CS4

Touch up your digital photographs for studio-quality images. 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 pixel-perfect images yourself, watch this graphic designer's guide.

How To: Remove a timestamp on a photo in Adobe Photoshop

Accidentally stick a time stamp on an image file? Get rid of it with Photoshop's touch-up 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 from Tutvid. For more information, and to learn how to get rid of digital photo time stamps yourself, watch this digital photographer's guide.

How To: Use layer, vector, and clipping masks in Photoshop

If you're not familiar with its mask tools, you're not taking full advantage of Adobe Photoshop. Learn how to use them with this clip. 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 layer, vector and clipping masks yourself, watch this graphic designer's guide.

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: Sum and average statistical data within MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Use some tricks in Alan Wake for the Xbox 360

With the release of Alan Wake, gamers were introduced to something they may have never seen before. This game is considered a full blown thriller that is sure to keep anyone on the edge of their seat. In this helpful tutorial from the awesome people at IGN, you'll find out how to fight the baddies in the game using some helpful tips. These tips and tricks will help boost your flashlight, flare placement, and dodging techniques. So check it out if you value your fictional life. Enjoy!

How To: Safely reset a frozen Apple iPhone

iPhones aren't perfect. They can have problems just like every other electronic mobile device. One thing that happens frequently with iPhones is freezing. If you're iPhone becomes frozen, how do you fix it? Best Buy has answers. The Best Buy Mobile team explains how simple it is to safely reset a frozen Apple iPhone.

How To: Lighten dark hair & how to cap your head to highlight

In this tutorial, you will learn how to dye your hair like a pro. Get tips and tricks on dying your dark brown or black hair to a nice blonde color without going orange. In addition to learning to lighten your whole head, you will also receive tips on how to use a hair cap to highlight your locks. By highlighting you will create a defined, multi faceted look that will look great and unique. So follow along and get ready to give yourself a professional style makeover.

How To: Sort numbers with a formula in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.

How To: Count Mondays between 2 dates in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 44th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to count the number of Mondays between two dates using the WEEKDAY function or the TEXT function wrapped around the ROW and INDIRECT function.

How To: Create random dates within a set range in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

How To: Display trend arrows in a Microsoft Excel spreadsheet

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

How To: Use the concatenate function & ampersand in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

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: Use SUMIFS or SUMPRODUCT to get invoice info in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.

How To: Create an amortization table in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...

How To: Enter VLOOKUPs in 4 different ways in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP

How To: Count blanks in an dynamic range in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).

How To: Check to see if a string contains a value in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").

How To: Look up & retrieve a row of data from a table in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.

How To: Extract the nth word from a text string in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.

How To: Extract first, middle, & last names in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.

How To: Create a line chart with time as its x-axis in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 284th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a line chart from years and percentage change. See how Excel makes the chart wrong, but then see how to fix it.

How To: Use numerical truth values in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.

How To: Color mix and fill your bags for cookie decorations

Karen shows you how to mix your colors and fill your bags. This example uses red blue and black. Begin by mixing blue. Start with royal blue coloring and add it to your frosting and mix it well. Dump the colored frosting into the middle of a sheet of plastic wrap. Roll it up in the plastic wrap, twist the edges, and now you have a little pouch with your frosting. Now take a bag with a coupler, and stick the plastic pouch of frosting in it. Pull it tight and rubber band the top of the bag, the...

How To: Ice cupcakes like a professional

In this video tutorial, viewers learn how to ice cupcakes. In order to ice a cupcakes, users will need a piping bag, tips, coupler and a spatula. Screw the coupler at the end of the piping bag and select a tip to put on the end of the coupler. Fold the bag 2-3 inches downward and place it into a cup to hold it. Now scoop some icing with the spatula and place it inside the bag. Squeeze the bag to bring the icing down and tie an elastic on top to close it. Viewers will learn how to 3 different ...

How To: Return multiple items for a single Excel lookup value

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to return multiple items from one lookup value and see a formula to return just the numbers from a column containing both text and numbers.

How To: Make wire-wrap links to make your own jewelry

First of all you need to have a piece of silver wire which is about three inches long and twenty-two to twenty-four gauge. Now take pliers and bend the wire into a right angle. Now take round nose pliers and wrap the wire around the tip. At the half way reposition the wire and then complete the loop. Now look at the loop which should be nicely stemmed in the middle. No insert the bead into the wire and grab the bead with thin nose pliers. Bend the wire at the right angle. Now take round nose ...

How To: Remove acrylic nails without soaking or salons

This video shows you how to remove acrylic nails using a nail tip. It takes a long time to soak the nails in acetone to remove them, and this method is quicker. To do it, slide one of the corners under any part of the tip. Force it in and slide it over across the nail and you will be able to see the acrylic nail lift up. Gently work on it to pull the nail off. It might hurt a little bit. The nail will look kind of rough, so you'll have to file it, and use some nail strengthener. Nail technici...