Remove Duplicates in Excel

How To : Cast an RTV mold

This animation shows the various steps taken when creating an RTV mold. First, risers are put on the part to allow air to escape from the final mold. A thin film is attached to the part, which will act as a seam for the final mold. A box is built around the entire structure, a ...more

How To : Use the soft light layer mode in Photoshop

In this tutorial, we learn how to use the soft light layer mode in Photoshop with Yanik Chauvin. This will reduce gray in the picture. First, duplicate the layer and then click on the blending mode menu. Click on the soft light option, then your photo will adjust and have satu ...more

How To : Knock out a wall

Many homeowners wish that their master bedrooms were larger or perhaps their dining room and living room were one. You can often create larger living spaces in your home by removing non-weight bearing walls. It is always tempting to just start knocking things down but demolish ...more

News : How Controversy Changed SCRABBLE

OSPD1 In 1978, the first SCRABBLE Dictionary was conceived and published by Merriam-Webster, with the help of the National Scrabble Association (NSA). The idea was to include any word that was found in one of the five major dictionaries at the time: Merriam-Webster's Collegi ...more

How To : Create e-mail icon in Photoshop

This video will walk you through the process of creating your very own icon to use for your email by using Adobe Photoshop. Photoshop is a great tool to use for a variety of purposes and in this instance can make the perfect icon in just minutes. 1. Open New file with 500x500 ...more

How To : Use the paths palette in Photoshop

The Paths palette in Photoshohp is used for saving, selecting and duplicating path information. A very cool hidden feature of the Paths Palette... You can convert a feathered selection into a path to remove its feathered edge.

How To : Automatically color alternating rows in Excel

This video is a tutorial on using the Conditional Formatting function of Excel to automatically color alternating rows, which helps your eye to follow across the row. This can be done manually with the “Fill Color” button, but if you add or delete rows after applying the s ...more

How To : Use Splice to Edit Movies on Your iPhone for Free

Apple is famous for their easy to use consumer software such as Garage Band and iMovie. However, I've found their apps a little hard to use. Why? Because their suite of software, mainly the consumer apps I've mentioned, errs on the side of ease of use. Isn't that a contradict ...more

How To : Convert an image into a sketch in Photoshop

In this video, we learn how to convert an image into a sketch in Photoshop. First, open up Photoshop and open the picture you want to convert. Now, click the layer and unlock the background. After this, go to "image", "adjustments", and remove all the saturation from the photo ...more

How To : Create fog in your photos using Photoshop CS4

In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now selec ...more

How To : Find, replace & sort in MS Excel

In order to Find, Replace, and Sort, using MS Excel, become familiar with your home tab. When you click on Sort, it will give you the opportunity to sort in different ways: e.g. alphabetically. If you accidentally shift your table, you can undo it by using Ctrl + Z. Custom Sor ...more

How To : Add motion to an image in Photoshop

Adding motion to graphics using Photoshop can create an exciting and dynamic effects. Select a picture you want to add motion to. First, duplicate the background layer. Then under Filters, select blur, and then select Motion Blur. Then you set the angle of the Motion Blur. You ...more

How To : Distribute one cell across multiple cells in Excel

Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address ...more

How To : Canon 7d FCP Post Workflow and Stuff

Editing with the Canon 7d and Final Cut Pro couldn't be easier, here are some tips to help you get started. Get the Canon E1 Plugin: The link provided gives you some basic info to get started. The main reason for using this plugin with FCP, is to convert the footage quickly t ...more

How To : Use the filter & sort feature in Excel

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizon ...more

Top 10 : Best Ethical Destinations for 2011

By Ethical Traveler As the world becomes ever more interconnected, being an ethical traveler becomes both easier and more urgent. Travelers today have access to far more information than we did even 10 years ago. We can observe–almost in real time–the impact that smart or sel ...more

How to Act Like a Food Snob : Molecular Gastronomy Edition

I first heard the term molecular gastronomy while watching an episode of Bravo's Top Chef a few seasons back. Intrigued by the concept, I sought to find out more about this modern, deconstructed type of cookery. If you happen to be around foodies and the topic of molecular gas ...more

How To : Find Anyone's Private Phone Number Using Facebook

Facebook really wants your phone number, nagging you for one as soon as you join. This isn't all bad since it can help secure your account with two-factor authentication. On the flipside, this makes it easy to reveal the private phone numbers of virtually anyone on Facebook, i ...more

How To : Turn Your Galaxy Note 9 into a Google Pixel

Samsung Experience isn't for everyone. While it's a far cry from the TouchWiz days, it is still too heavy of a skin for Android purists. But you shouldn't let that dissuade you from a powerful device that checks nearly all other boxes — there are ways to make the Galaxy Note 9 ...more

How To : Boost Your Productivity on Android

Not many people use their phone exclusively for making calls or sending messages today. If you're an Android user, the chances are high that you're using your phone or tablet for work-related activities. However, the basic set of apps and services your device was shipped with ...more

Gaming : The 9 Best Games to Play When You're Taking a Dump

My bathroom is like my own private arcade room. Whenever I'm seated comfortably on the toilet, no one is going to disturb me, so I can play anything I want on my smartphone. You probably do it, too — and your parents, kids, friends, colleagues, and boss — so don't be afraid to ...more

News : The 5 Best Free Twitter Clients for iPhone

Twitter's official iOS app is adequate if you're not much of a tweeter, but if you are, there's a lot of useful features that are missing. Luckily, there are plenty of free Twitter clients available that you can use on your iPhone. These third-party apps have features such as ...more

Compared : The 5 Best Reddit Apps for Android

Whether you've celebrated multiple cake days or you're just now getting your feet wet with Reddit, it's a rite of passage to choose your preferred smartphone client. Quick spoiler: Your best option most certainly is not the official Reddit app. Reddit's mobile site is pretty ...more

How To : Use iOS 11's New File Manager on Your iPhone

Apple has finally given us a decent file manager in iOS 11. The new "Files" app replaces the not-very-old iCloud Drive app that appeared in iOS 9, but you can still access your iCloud Drive files in the new Files app, as well as files from third-party cloud services. A nice im ...more

How To : DIY Stick Welder from Old Microwave Parts

Lurking inside your old junk microwave is an abundance of useful parts that can let you melt metal, spot weld, and make electrifying Jacob's ladders. You can even make a powerful AC arc welder, perfect for making hard-to-solve puzzles and even makeshift weapons for the zombie ...more

  • Hot
  • Latest