Remove Duplicates in Excel

How To : Remove duplicates from your iTunes library

Are you notices tons of duplicate songs in your iPod? Did you accidentally import the same song more than once into your iTunes library? There's a quick fix out in the world of iTunes software! In this video, learn how to quickly and easily get rid of duplicate songs in your i ...more

How To : Sort & find duplicates in Excel

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. In the column next to the sorted column it shows whether the (cell 1 is equal or not equal to the cell 2 directly undern ...more

How To : Remove spaces from a Microsoft Excel formula

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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in ce ...more

How To : Remove the macro warning in Excel

In this video tutorial, viewers learn how to remove the macro warning in Microsoft Excel. When you see the warning, click Enable Macros. Then right-click on of the sheet tabs and select View Code. Open the Modules folder menu. Now right-click on the module and select Remove Mo ...more

How To : Create a magical enchanted dagger in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those dig ...more

How To : Fix a DGET #NUM! error 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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve ...more

How To : Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, ...more

How To : Clear formatting from a cell 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 7th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove th ...more

How To : Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software ...more

How To : Extract the top five records from a table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e ...more

How To : Avoid the #DIV/0! error in fornulas in Excel

Getting errors when trying to crunch your numbers in Windows Excel can be frustrating, but with this fun and easy to follow guide to remove the "#DIV/0!" error. When the computer thinks you're trying to divide by zero, it produces an annoying error, but by following this video ...more

How To : Browse the Internet at work

Learn how to browse the Internet at work and get away with it. Load Excel (Any version will do). Click on the Data tab. Click 'Import External Data'. Click 'New Web Query'. Once the window has loaded, click through the prompts, selecting Yes. When the window has loaded complet ...more

How To : Run advanced VLOOKUP queries in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Cla ...more

How To : Turn off AutoCorrect symbols in Excel

In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now ...more

How To : Prevent duplicate entries in an Excel spreadsheet

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the ...more

How To : Create realistic reflections in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those dig ...more

How To : Remove braces with Photoshop

Learn how to remove braces with Photoshop. First find a photo with some visible teeth; you don’t want a picture with no visible teeth because you would need to redraw an entire set of teeth. Now select the first layer and duplicate it (command control J). Grab the patch tool f ...more

How To : Use Apple Font Book

Apple Font book is a utility included with Mac OS X. Font Book is a utility for managing and maintaining your fonts on your Mac computer. It allows you to enable or disable fonts. It also helps you in creating font collections. Using it you can create libraries consisting of d ...more

How To : Build a sign in Photoshop with 3D lightbulbs

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those dig ...more

How To : Transform a photo into a puzzle in Photoshop

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 p ...more

How To : Dominate the New York Times Crossword Puzzle

First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more

How To : Find & extract duplicate records from a data set

This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or ...more

How To : Do a reverse two-way lookup 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 149th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a ...more

How To : Remove acne spots with Photoshop

In this video, we learn how to remove acne spots with Photoshop. First, open up the picture and zoom in on the acne you want to remove. Now, unlock the layer by right clicking and unlocking it. Next, use the clone stamp tool while pressing alt to clear the skin where the blemi ...more

How To : Color correct product shots in Photoshop

Yanik Chauvin teaches us how to color correct product shots in Photoshop in this tutorial. First, remove some of the black from the image by using your crop tool. After this, if your image is too wide, duplicate your layer and use the marquee tool to edit. Remove any dust spot ...more

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

Prev Page
  • Hot
  • Latest