Unique Features Search Results

How To: Use macros in Microsoft Excel 2007

Looking for an introduction on how to work with macros in Microsoft Excel 2007? Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using absolute and relative macros in your own Excel 2007 workbooks, watch this free...

How To: Use the bristle brush tools in Adobe Photoshop CS5

This video tutorial demonstrates Photoshop CS5's bristle brushes, which simulate traditional paint brushes—the kind your local art-supply store sells—and its new Mixer brush, which lets you give a photo a painterly look. Along the way, its host passes along a tip for customizing Photoshop's interface—one of those little chores that can save so much time but that so few of us do. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking...

How To: Adjust brightness and contrast in Adobe Photoshop CS5

Have a digital image that's a little bit too dark or otherwise lacking in depth? Your fix is just a few mouse clicks away. This free software tutorial will teach you how to use the new Brightness & Contrast tools within Adobe Photoshop CS5. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.

How To: Make a unique paper rose

In this video we learn how to make a unique paper rose. First, grab a square piece of paper and fold it into quarters while maintaining the fold. Then, fold along the diagonals and fold lower in half twice and the top in half twice. Then, fold the halves in half and repeat the previous steps. After this, follow the folds that you created, rotating the paper as you continue to fold. After all of the lines are lined up and you have folded it, it will become a unique paper rose that you made! En...

How To: Make a multi-colored duct tape wallet

Why buy a brand new wallet when you can make one? And out of duct tape! Take the original duct tape wallet idea and kick it up a notch with help from this tutorial presented by Seasonal Science on how to make a multi-colored duct tape wallet. Show off your unique style at school with this unique accessory!

How To: Use the "Unique Records Only" filter 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 63.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the advanced filter "Unique Records Only" option and the VLOOKUP, COLUMN, IF, ISERROR and IFERROR functions to merge 2 tables.

How To: Count unique & duplicate records 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 272nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count unique records and duplicate records using the SUMPRODUCT, COUNTIF, COUNT, COUNTA, IF and SUM functions.

How To: Build a simple electromagnet

Electromagnets are super cool to experiment with. In this educational video, Science Bob teaches us about electromagnets - what they are and how to build one of your own. These magnets are are very powerful and make an extremely neat experiment for the science fair. Electromagnets are unique in the sense that they convert electricity into magnetism. Try this experiment with your kids for a unique science lesson.

How To: Create a shocking Cirque Du Soleil makeup look

Halloween is coming sooner than you think; have you decided what you're going to dress up as yet? While going with the wicked witch or sexy black cat route is always fun and unfailingly cute, the easy choice quickly becomes the dull one, especially if you're essentially worn the same costume time after time.

How To: Enhance your digital photos in Adobe Photoshop CS5

Looking for an easy way to polish your digital images in Photoshop? Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.

News: YouTube Pinch-to-Zoom Comes to More Devices

Google launched the Pixel 2 XL with a unique pinch-to-zoom feature in the YouTube app. The feature is pretty basic, allowing users to expand the video to full-screen on devices with 18:9 aspect ratios with a simple pinch gesture. Considering its simplicity, it was strange that the feature was limited to the Pixel 2 XL. Today that exclusivity has ended as the feature is rolling out to the Galaxy S8, Galaxy S8+, Note 8, LG V30, and LG G6.

How To: Make a cute Thanksgiving card using stamps

In this tutorial, we learn how to make a cute Thanksgiving card using stamps. First, cut an oval shape with an oval template. After this, you will stamp the image from the harvest home stamp set on watercolor paper. After this, outline the image with SU markers and color the image in with an aqua painter brush. From here, scallop the edges of the design to make it look more unique. Then, glue the stamp to the card stock and use it as the front of a card for the holidays! Experiment with diffe...

How To: Create a distribution for categorical data in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 12th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Advanced Filter 'Unique Records Only" to extract a list of unique items from a data base, and then use the COUNTI...

How To: Make a ring from a coin without power tools

Looking for an incredibly unique gift? In this video, learn how to make a cool, long lasting ring out of a coin! All you need is the coin (whichever size is best suited for your finger), hammer, file, emery cloth, saw and a hand drill. With this method, you will be able to see the writing on the outside of the ring, so everyone will know how unique it is. This would make a perfect gift, fashion statement or even wedding ring!

How To: Fold an origami Christmas tree ornament

Origami is simple and fun and our host proves that right off by displaying how little we actually need material wise, to make something unique and pretty. Just two swathes of patterned paper, put flush together and a paper clip. First folding your little construction into the shape of a tiny kite It gets very precise from there. Incorporating smaller and smaller folds, but with a close-up view and a step by step explanation, this video will ensure success. After creating your unique abstract ...

How To: Draw Naruto's 4-tails form

In this tutorial, we learn how to draw Naruto 4-tails. First, draw the outline of the characters and the four tails. After this, draw in the rest of the outline in the final stages using a darker stroke of the pencil. Start to add in the details of the figure of the body and then add in the shading around the sides. Make sure you draw in the hands and the fingers as well as the facial features to make it look more realistic. Add in any more details that you would like to make it unique, then ...

How To: Create a simple and elegant fishtail braid

Fishtail braids are really not much different from your typical braids, only that they trail off from being thick at the top to very thin and delicate on the bottom (yes, like a fish tail). But this one feature is what makes them infinitely more elegant and romantic than the typical braids we wore in 5th grade.

How To: Draw smile now cry later clowns

In this tutorial, we learn how to draw smile now cry later clowns. Start off by drawing a large laughing mouth with the tongue inside of it. Next, draw the eyes and then the nose and chin. Draw the eyebrows on the clown so it looks like a clown, with makeup on the eyes and face. After this, add details to the tongue and fill in the back of the mouth with black shading. After this, draw neighboring clowns the same way as the first, just changing up facial features to make them different. This ...

How To: Create an HDR image in Adobe Photoshop CS5

If you want to take a boring photo and pump it full of life, Photoshop CS5's two methods for making a High Dynamic Range image will do just that. The first is a streamlined and improved merging tool, and the second is a new HDR tool that turns a single image into a trendy HDR masterpiece. Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find ...

How To: Set the defrost timer on a True Freezer

True's Owner Maintenance Video Series shows us how to set the defrost time clock on a True freezer, and also how to cut the shipping band on the compressors of all larger freezers. The time clock is behind the grill at the base of the unit, behind a gray box. There are instructions in the inside of the lid for setting the time clock and for setting the defrost settings, and the video goes through the entire process, as well. Next, the man shows how to remove the shipping band protecting the c...

How To: Build a simple Core Data application in Mac OS X

Core Data is a powerful data-management framework introduced with Mac OS X v10.4 Tiger. When you take advantage of Core Data, it slashes the amount of custom code you need to write in order to manage application data. Opening, saving and undo management can all be handled by Core Data, freeing you to concentrate on creating unique features for your application. This video tutorial, which presents a general introduction to using Core Data, will walk you through the process of building a simple...

How To: Place a Google SketchUp model in LayOut

Working closely with SketchUp models is key to LayOut and the primary feature that makes LayOut so unique. Take a look at this instructional video and learn how to place a SketchUp model in LayOut. To place the model, go to file and simply click insert. Find your model and then open it. The great thing about viewing a model in LayOut, is that it is presented in 3D form and you can build complex documents with infinite views of your model all with just one SketchUp model.

How To: Make a beautifully unique beaded windchime

Do you have a bunch of flawed beads left over after you make your crafts? You know the ones, the chipped, cracked, sharp ones that don't make the cut and usually get tossed in the garbage? Why not make those into something lovely, where the cracks don't matter? In this two part tutorial, learn how to turn your discarded beads into a beautifully shiny wind chime for your backyard. This chime is unique and makes a lovely noise in the wind. Let's get crafting!