Remove Duplicates in Excel

How To : Remove pimples and wrinkles in Photoshop

This video in the Software category will show you how to remove pimples and wrinkles in Photoshop. Yanik from Yanik’s photo school presents this video. Select the photo you want to work on. First you duplicate the layer by ctrl+J or select from the dropdown menu. You start off ...more

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 : 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 : 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 : 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 : 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 : 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

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 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

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 : 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 : 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

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 : Disable Link Previews in Google Keep

Disabling clunky, revealing link previews on Google Keep can serve multiple purposes. You know, those expanded versions of the same URL you pasted into your note, except duplicated, tacked onto the bottom of your note, and showing a preview picture. Removing these can help opt ...more

News : Apple Just Released iOS 13 Public Beta 4 for iPhone

Apple just seeded the fourth public beta for iOS 13 to software testers today, Tuesday, July 30. AppleSeed participants saw this beta one day early, alongside the release of developer beta 5. Now, developer and public testers alike are up-to-speed with the latest in iOS 13. B ...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 : Turn Your Galaxy Note 10+ into a Google Pixel

The Galaxy Note 10+ is the pinnacle of Android hardware. You won't find many phones with a better combination of specs and design. But you may not love the software. Even with One UI on board, some users still want a more "stock" feel. Thanks to apps from third-party develope ...more

News : 31 New Features for Camera & Photos in iOS 13

While iOS 13 introduces over 200 new features for your iPhone, one of the biggest focuses this year is Photos and Camera. The update completely overhauls the Photos app, creating a more organized and natural way to interact with your pictures and videos. You'll also find a few ...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

  • Hot
  • Latest