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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.
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.
In this video, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...
In this video tutorial, viewers learn how to sharpen photos in Adobe Photoshop CS3. Begin by opening the image in the program and duplicate the image layer. To duplicate, press the control and J button. With that images, go to Filter, choose Other and select High Pass. The images will now be covered entirely of gray. It is recommended to set the radius as 5-6 pixels and then press OK. Change the layer blending mode to overlay, soft light, hard light, vivid light or linear light. This video wi...
In this video tutorial, viewers learn how to make a reflective text in Adobe Fireworks CS3/CS4. Adobe Fireworks a bitmap and vector graphics editor. Begin by opening Fireworks and create a new project. Create your text and then duplicate it. Align the duplicated text under the original and flip it vertically. Click on the color and select Fill Options. Select Gradient and keep the second option at Linear. Drag the opacity on the left to zero and the right to 100. This video will benefit those...
Are you bored with the similar font styles? Open Adobe Illustrator, click the text tool. Select Arial font, bold & italic and a size of 48. Type some text and give its fill color-white and stroke color-black. Duplicate the layer text by going into layers. Then change the duplicated path's color to black. Then create a new background with some different color and keep it below all layers. You can change the opacity of the text for a shadow effect. This will help in bringing innovative presenta...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 514th installment in their series of digital spreadsheet magic tricks, you'll learn three methods for conditionally formatting duplicate values:
In this how to video, you will learn how create glowing eyes in the darkness using Photoshop. First, open your image in Photoshop. Next, duplicate the background layer. Go to hue and saturation and make the image really dark by turning down the lightness and saturation. Next, select a paintbrush for the eraser and start erasing around the eyes. Once this is done, make a selection around the pupils. Create a new layer and paint the selection red. Next, lower the flow of the paint brush and cho...
This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.
This video is about creating sunbursts using symbols in Illustrator.
In this tutorial, learn how to get Katy Perry's blue haired punky style from her new music video, "California Gurls". This video (featuring Snoop Dogg) is one of her most anticipated clips yet and is definitely a popcorn and bubblegum trip down Candy Land Lane. So, if you are looking for a cute, girly look to go out in, follow along. And don't forget to complete the look with daisy dukes with a bikini on top!
Your Pixel has a few hidden features you probably don't know about, like the ability to clean up your funky contacts list. Since I'm sure you haven't manually organized your contacts since the inception of Android, there are likely some incomplete and duplicate contacts. Thankfully, your phone can fix this automatically.
In this tutorial, style your hair like "Harry Potter" star, Emma Watson. Emma is known for her adorable, yet sophisticated, looks and in this video you will learn exactly how to duplicate one of her most famous red carpet styles. This look is quite easy to achieve and you can wear it to school, work, parties or just everyday. Have fun!
Before you rush out of the house to see "Sex and the City 2" this weekend, why not really get into the part? In this video, learn how to duplicate one of Carrie's Middle Eastern inspired makeup looks from the film and look fabulous in the theatre. This flick is a great time to have an old fashioned girls night out, so why not do your makeup, have a cosmo and get the full SATC experience?
Ke$ha has some funky looks. She has captured the ultimate party girl image with a lot of her videos and album covers. If you are looking to get a great club style like Ke$ha, check out this tutorial. In it, you will learn how to duplicate her album cover for "Blah Blah Blah" and make the look your own.
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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a value in a table and then return the row or column value when there are no duplicate values.
This video shows you how to form an eye-catching border around any photograph by placing a photo within (or on top of) itself using Photoshop. The process includes duplicating the image, adding a layer mask, adding an inside layer stroke and drop shadow, changing hue or saturation, and using a blur effect. If your vacation photos or family pictures are putting your visitors to sleep, try this easy and fascinating technique that will be sure to draw attention.
This image editing software tutorial shows you how to create an array from a rasterized object in Photoshop CS3. An array (in design terms, not programming terms) is an object that duplicates itself around a pivot point. So learn how to work with arrays to create designs in this Photoshop video.
This software tutorial shows you how to mirror geometry when modeling in Zbrush. This is a more non-organic method of sculpting in Zbrush but it allows you to duplicate details on both sides of an object without having to redo the details. Learn how to mirror geometry in sections using masks, and how to make sure the seams line up and keep your scuply accurate in Zbrush.
You don’t have to be a psychic to read someone’s mind – or, at least, to make them think you’re reading their mind, as shown in this how-to video. You will need one card with an "X" on back, an envelope with "you will choose (blank card)," a duplicate of the third card, and a flat surface. Watch this video magic tutorial and create the illusion of reading someone's mind while performing a card trick.
» Homeland Security Report Lists ‘Liberty Lovers’ As Terrorists. A new study funded by the Department of Homeland Security characterizes Americans who are “suspicious of centralized federal authority,” and “reverent of individual liberty” as “extreme right-wing” terrorists. » British police get battlefield weapons.
In this video, learn how to use a push mold to form your polymer clay. Molds are easier ways to make designs in your clay so that you don't have to shape the entire thing with your hands. This video will show you how to make earrings using a mold with an example that you can duplicate at home.
The Orton effect in Photoshop is acheived by combining an image with a duplicate that has been softened or blurred slightly. This will give you original image a luminescent appearance and enhance most portraits and landscapes.
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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
Nicole Scherzinger is one pretty Pussycat Doll, and in this tutorial, you will learn how to duplicate her look for yourself. This video shows you how to create a Nicole inspired makeup look that will have you turning heads, just like she does. So, grab some supplies and get ready to head out looking like a bonafide rock star.
If you're bored at school, this trick will be sure to amaze your friends and give you something to do. With only a few slight modifications to the pen, you can give the illusion that you are making a penny appear out of nowhere.
This is a basic tutorial which teaches how to get free stuff in Second Life and use it to build large structures fast. It is for beginner Second Life users and teaches linking, unlinking, and duplicating commands. If you are new to Second Life, watch and learn how to build big buildings fast with stuff that's already there.
Famous food cloner Todd Wilbur wraps his head with tape and attempts to duplicate the world's most popular candy bar. You will need water, vanilla extract, peanut butter, powdered sugar, chocolate chips, caramel, and peanuts. Watch this video cooking tutorial and learn how to make a Snickers bar at home.
African violets are a beautiful and delicate plant. It is possible to duplicate African violets by propagating them. In this how to video, Danny Lipford talks with Trisha about propagating African Violets.
This is a how-to video explaining how to copy a key with a can of cola. All you need is an aluminum soda or beer can. To make it come out better, add a additional side to the one piece. This technique works well when you don't have time to get a new key cut. Watch this video tutorial and learn how to duplicate a key with a Coke can.
Check out this SEO video tutorial on Google's supplemental index. What could cause your webpage to fall into the supplemental index? There's duplicated content, content taken from other sites, too many query strings in the URL, etc. See what you can do to get them out of Google's supplemental index, with some good search engine optimization.
This video tutorial shows how to use Smooth-On's ReoFlex urethane mold rubber to cast a simple 1-piece block mold. Learn how to mix, pour, form, and create a one piece mold to create duplicates of an original object.
This instructional video shows the simple steps for how to cast a cavity pour mold with Mold Max 30 RTV Silicone Rubber. Learn how to make the mold and make duplicate models of statues, sculptures, or figures, with this casting technique.
If you think you have all the essential tools figured out in Autodesk Maya 8.5, you probably don't. So, if you want to create awesome 3D animated characters, then maybe you should watch this Maya video to make sure you know how to keep faces together after you already know how to merge, merge duplicate, average vertices, and bridge.
Duplicate the OS X's CoverFlow effect inside Windows and say goodbye to ugly thumbnail views! This tip from Tekzilla only works for image files.
You can learn how to color adjust in photoshop. You can select one color and let the rest of your picture be black and white. First, you select the picture and make a duplicate layer for the background.
This video from photoshopuniverse shows us how to make your picture look like it's a puzzle by using Photoshop! First you want to open up the layers palette and duplicate the layer. Now add a new layer and bring it down to the middle and fill it in with black. Now to get the puzzle into place, go to Filter---Show Menu Items---Texture---Texturizer. Click the arrow to load texture. Load in puzzle texture. Now you can set the scaling to however many puzzle pieces you want. He put it at 75% and t...
When OS X Lion (10.7) debuted last year, a lot of Apple users were dismayed that the "Save As" option had disappeared, replaced by the "Duplicate" function. Most felt that it just wasn't the same, so when Mountain Lion was released, the "Save As" option was brought back… sort of.
In this Software video tutorial you will learn how to make animated GIFs with Adobe Fireworks CS4/CS3. It is easier than Photoshop and Flash. You can create a picture or you can drag and drop a picture. To drag and drop a picture, find out the dimensions of the picture. In the example, it is 420 x 420. Now open fireworks, open a new document and set the height and width to 420 pixels and click OK. Now drag the picture and drop it in to the blank canvas. On the top bar go to window > states. T...
As a regular Mac OS X user, I have a love/hate relationship with the "Open With" contextual menu. Sometimes, it has just what I need. Other times, it's often packed with unnecessary or duplicate items, or missing the app I want to open the file up with the most.
