Specific Filters Search Results

How To: Use Snapchat's Hidden Filter to Add Color Overlays to Your Photos & Videos

Snapchat has built upon the photo-sharing service it once was to become a money-sending, commercial-shelling, video-messaging giant. They improved their user experience by adding Stories, Geofilters, and even the rarely-used Snapcash feature, but why isn't there something as simple as color filters? Yes, they have filters for black and white, saturated, and sepia, but that's it as far as color goes.

How To: Ignore filtered values making calculations in MS 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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Blur and feather with Photoshop's Gaussian Blur tool

Gaussian Blur is a filter that blurs an image. But it's also the math behind the Feather command, drop shadows, and everything that is soft in Photoshop. Watch this video and learn why Gaussian Blur is so important. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including d...

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 a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.

How To: Create & work with pivot tables (PivotTables) in 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:

How To: Simulate snow in Photoshop

Learn how to simulate snow in your photograph in this video tutorial by photoshopuniverse. For this you'll need a photo depicting winter scenery. Add a new layer, fill it in with black, go to filer noise and add noise as shown using the given amounts. Go to filter effects and add blur to the layer. Go to images and adjust the levels to reduce the snow-flakes as shown. And add some motion blur to it. Change the blend mode to screen, duplicate the layer, rotate the new layer, apply the filter c...

How To: Create a studio background in Photoshop

This video by photoshopuniverse shows you how to make any photo seem as it was taken in a studio. Take the working photo and add a new layer over it and fill it in black as shown. Add a newer layer over that and add the filter> render> clouds effect. Increase the opacity of the cloud layer and merge it with the black layer as shown. Add the splatter effect and the sprayed stoke effect as shown onto the merged layer and add a hue and saturation adjustment layer and colorize it as desired. Go t...

How To: Create an overprocessed effect in Photoshop

This step-by-step instructional video shows how Photoshop can be used to purposely over-process a photo and give it a more gritty effect. First, a High Pass filter is applied to give the photo a gray buzz. Next, hard light blend layers are applied to give the photo more contrast. A few approaches for applying noise filters are described next. Finally, de-saturation is applied to produce an amazing finished product. A must-see video for anybody looking to add a fantastic grunge effect to a photo!

How To: Reduce beard stubble in Photoshop

This video, produced by Photoshop Universe, teaches how to reduce beard stubble or 5 o'clock shadows from male pictures. We are shown how to use the dust and scratches filter, layer mask, as well as the advanced layer style command "blend if" on the underlying layer helps us to make this possible. The first step is to duplicate the layer and then select filter, noise, and dust and scratches. The second step is to apply some dust and scratches to the beard selection. Finally we blur the layer ...

How To: Create a ghost effect in Photoshop

To manipulate photos and turn someone in a photo into a ghost, there are several filters that can be used in Photoshop. This video takes us through the steps of how to take an ordinary picture and turn the subject into a supernatural being using the motion blur technique and the diffuse glow filters among others to alter an image. The best types of pictures to use are ones where the background is relatively dark. By following these simple steps in Photoshop, you can turn anyone in an ordinary...

How To: Master the use of vanishing point filter in Photoshop

Photoshop can be a confusing program, especially with all the different settings and effects you can tinker with. Learn to master the vanishing point filter in this fun, easy to follow tutorial with the Pixel Perfect team. Clean up your pictures and smooth over any unwanted imperfections as he takes you how to make them "vanish" with the program. Alter the perspective of an image and add it on to another and change that cloudy day into a snowy background. Each step is carefully explained with...

How To: Setup a playlist in iTunes to organize your music

Music today is easily and readily downloaded, and because of that, many of us end up with giant music collections. If you're using iTunes, you can organize your music into specific playlists so that you always have what you want to listen to easily accessible. Take a look at this guide on how to create an iTunes playlist.

How To: Make your photos look like they were taken with a great camera

If you take a lot of photos with your smartphone or cheap digital camera, you can see the difference compared to results from a pro camera. So, if you want to get a professional camera look without dropping the money, check out this video to learn how to enhance your pics. This trick works with Photoshop, or any photo editing software that has a selection tool, a gradient tool and a gaussian blur filter.

How To: Read sheet music on the guitar

In the studio world, and the ensemble scene, you're going to be handed ALOT of sheet music, sometimes it has only a few notes for a specific melody, and sometimes it's a whole lot of notes for the entire song. Knowing how to read these notes are important, and it can be very daunting at first, but if you practice every day anybody can read. In this video you will learn the basics of reading the notes on the staff with the note names for the treble clef.

How To: Read basic rhythms on a chart for the guitar

In almost all charts and forms of sheet music, the composer will more than likely have added rhythmic dictation to the staff, a specific rhythm that he wants you to play over the progression using the chord. In this video you will get a breakdown of basic rhythmic dictation of a quarter note, eighth note and more on top of how to read these in notation format!

How To: Color correct digital footage in Adobe After Effects and Photoshop

With this thorough guide, you'll learn how to color correct footage in After Effects of Photoshop using the Curves tool. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

How To: Find all hidden spiders on Hobgoblin in Spider-Man: Shattered Dimensions

If you're struggling to find all the hidden spiders on Hobgoblins level, you're in luck! Some can be pretty tricky due to specific circumstances that you will need to meet and some are harder to find if someone doesn't tell you about them. In this video you will get a full walkthrough of each spider location as well as commentary explaining each location and the circumstances you will need to put yourself in to get them.