Filtering Search Results

How To: Set data up for sorting & filtering 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 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.

How To: Filter data using MS Excel 2010's PivotTable slicer

This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...

How To: Create multiple inboxes in Gmail using filters

See how to set up multiple inboxes within Gmail and use filters and labels to have mail sent to different addresses automatically sorted (and mail sorted using other criteria too, like subject, or containing certain words). It's easy! So easy, in fact, that this Gmail user's guide can present a complete overview of the process in just over four minutes time. For details, and to get started using Gmail's useful filtering feature yourself, take a look.

How To: Filter your Gmail with the 'plus' sign

Looking for an easy way to cut down on the spam you receive at your main Gmail account? With plus (+) sign filtering, it's easy! So easy, in fact, that this free home computing how-to can present a complete (and somewhat talky) overview of the process in just over a minute's time. For specifics, and to regain control over your email account, watch this PC user's guide.

How To: Use an advanced filter to extract table data in 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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Use an array formula to filter data 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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...

How To: Use Excel data analysis filter & dynamic ranges

We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...

How To: Make a simple coyote well water filter

When you're trying to survive in the wild, clean water is an absolute must. This video shows you a simple and easy method to build a basic water's edge, water filter device called a coyote well water filter. Though this filter will NOT remove toxins or pathogens, in an emergency it's an effective way of filtering out the big, nasty stuff.

How To: Undo Instagram's Photo Filter Magic with Normalize for iPhone

Tired of the Instagram wave? If you're sick of having to view the world through low-contrast and sepia-toned filters, there's a way to get them back to how they're supposed to look, and it's called Normalize, which undoes the magic filtering that Instagram and similar photo filter apps provide. The process of un-Instagramming your (or anyone else's) photos with Normalize is perhaps easier than Instagramming them in the first place. All you need to do is copy and paste them into the app and wa...

How To: Filter Unknown Senders in iMessage to Block Unwanted Notifications & Keep Your Messages App Clean

If your job revolves around prospective clients and customers, you may frequently receive iMessages from unknown numbers. Although this isn't necessarily a bad thing, being bombarded with messages from strangers can create disarray in your inbox if you're not careful. Luckily, Apple makes it easier to organize your conversations by allowing you to filter unknown numbers in the Messages app.

How To: Filter Potential Matches on Bumble

Despite Tinder's tremendous popularity, Bumble has carved out a billion-dollar business by focusing on women (they message first), simplicity (ice breakers less wordy than OkCupid), and relationships past romance (friends and prospective jobs). Now they're diving into customization, with filters that allow you to pore over prospective matches by height, religion, education, politics, and more.

Better Than Brita: Water Filters with No Plastic Parts

I used a plastic water filter for years. Who wouldn't? It cuts down on buying bottled water, which, as it turns out, is pretty much the same as unfiltered tap water. Plus, bottled water is terrible for the environment and your wallet, too. Water that costs only pennies a day and actually was purified as opposed to just saying it was? That's a no-brainer.

How To: Advanced Techniques to Bypass & Defeat XSS Filters, Part 2

Cross-site scripting can be one of the easiest vulnerabilities to discover, but to be successful with this type of attack, it is essential to learn how to get past filters. In the previous guide, we explored some ways to do this, such as abusing attributes and event handlers and tricking the application into accepting unusual characters. Now, let's take a look at more techniques used to defeat filters.

How To: Sneak Past Web Filters and Proxy Blockers with Google Translate

Do you need proxy access, but cannot have it for some reason? The most common perpetrator behind the issue is the network you're trying to access the pages from. Some networks will block websites, then go as far as filtering out all of the web queries for terms like "proxy" because it can get around their filter. Quick web proxies can be used for tons of other things, though.

How To: Create glitch type drum effects in Reason 3.0

This music production software tutorial shows you how to create Glitch-type effects for use with your drum patterns in Reason 3.0. It is an advanced tutorial only because of the speed at which he has to cover the material. In this example Ace Pincter will be adding glitch effects to drum patterns using Dr. Rex, but you can use any Reason drum pattern. Included: RV7000 Gating, Automation, Matrix offsetting, Filtering by gate, and Distortion.

How To: Color correct photos using Photoshop adjustment layer

Photoshop is a place where we can edit the image in different styles. One of the features is adjustment layer of a photo that is also called as filter correction. It is an easy step to color filtering of a photo. Open a picture in a Photoshop, and select add layer option that present at the right bottom of the screen, then a pop up menu appears. Select filters from the options available, then dialogue box appears consisting of sub options filters and colors. then select the main color from fi...

How To: Get started with Wireshark

In this tutorial Mike Lively of Northern Kentucky University shows you how to get started with Wireshark. Wireshark is a network protocol analyzer for Unix and Windows. It is used for network troubleshooting, analysis, software and communications protocol development.

How To: Change your NAT settings to OPEN using Netgear router

Be warned before hand that by making changes your router settings that you know nothing about can damage your router. Start off by opening your internet browser and then in the address bar either type 192. 168. 1. 1 or www.routerlogin.com. A prompt will come up in which you have to fill in "admin" in the first box and "password" in the second one. Look for the "Advanced" option and under it will be "WAN", click it. Now change your "NAT filtering" to "open". Make sure that "Disable SPI Firewal...

Prev Page