Anonymous Tips Search Results

Dark Side of the Prism: Get Alerted Whenever You Visit a Website Owned by a PRISM-Targeted Company

Since The Guardian published leaked documents exposing the depth of the NSA's spying powers, many people who've never put much effort into protecting their privacy are finally starting to pay attention. Evidence of public opinion concerning PRISM can be seen from the rise in traffic for pro-privacy sites like DuckDuckGo to the petitions demanding that the program be scaled back or done away with altogether. Some would argue that you waive your right to privacy by signing the terms of agreemen...

How To: See Who Has Viewed Your LinkedIn Profile Without Paying

When LinkedIn first arrived on the scene, I thought it was a great resource for staying connected and getting in touch with those people in your desired career path. Keyword: Thought. Like most businesses, money and shareholders seem to have taken over the driver's seat, pushing the company towards a business-first, users-second approach.

How To: Change the Number of Search Results Displayed Per Page in Google, Bing, and Yahoo!

People use search engines for a wide variety of subjects (just look at some of the results that pop up in autofill). The results you get with each different search engine are usually different, but almost all of them display the same number of results per page by default—ten. If you find what you're looking for at the top of the first page, great. But if you have to do a lot of digging, it can be a pain to load so many different pages to find it, especially if your connection is slow.

How To: Stop Facial Recognition Software from Finding Out Who You Are on Camera

Facial recognition software is being more widely used with every passing day. Your local law enforcement is probably already using it, and it will be even easier for them now that the FBI handed out its own facial recognition software to state authorities. Even the fine folks at Facebook are using this technology. Obviously, this brings up some pretty serious privacy concerns amongst most people, because honestly, who wants to be tracked? Right now, there's not a lot we can do about it being ...

How To: Determine your skin tone

In this editon of Tip Tuesday from Pursebuzz we are shown how to determine your skin tone. This tip is a pretty simple way to determine if you're a warm or a cold tone, and if you are pink-based or yellow-based. That's the first question you're asked if you go to a counter and you're trying to figure out your foundation colors or your blush colors or shadows, or what will work for you. The first test is the fabric test. You don't even have to buy this fabric. You could just go to a fabric sto...

How To: Cook gypsy A1 BBQ

In order to prepare Gypsy A-1 Barbecue Ribs, you will need the following: ribs, tri-tip, black pepper, seasoned salt, cayenne pepper, onion powder, soy sauce, Worcestershire sauce, paprika, brown sugar, honey, vinegar, molasses, ketchup, mustard, and garlic powder.

How To: Use a bead reamer to smooth sharp edges on a bead

This video teaches us to use a bead reamer to smoothen sharp edges on a bead. You need a reamer, some water and the reaming tips. We need the large tip for enlarging and smoothening the holes and a 45 degree edging point for smoothening the edges of the hole. Twist the handle of the reamer and insert the tip in it. Take the bead and the reamer with the large tip & dip it into water periodically during the procedure so that the water acts as a lubricant. Begin filing the inside of the bead hol...

How To: Make rabbit toys

There’s nothing a rabbit likes more than toys they can climb inside, shred, and drag around. With a good pair of scissors, you can make a steady supply of bunny-pleasers that won’t cost you a thing.

How To: Apply glimmery rhinestones to pink nails

In this video, we learn how to apply glimmery rhinestones to pink nails. First, you will want to have your nails done with long tips and painted any shade of pink that you would like. After this, you will need to take some rhinestones and a toothpick along with some nail glue. Pick up the rhinestones with glue on the toothpick, then place on the nails where you would like them. You can create a French tip design, or you can place them all over the nail. After this, paint a gloss over the nail...

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Identify the first occurrence of a value in a column 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.

How To: Keep your laptop battery safe and secure with four tips from CNET

Millions of laptop batteries have been recalled because of the risk of FIRE. Get some tips from CNET to learn how to keep your laptop battery safe and secure. First, make sure your battery hasn't already been recalled. Second, don't leave the laptop constantly charging because it heats it up. One way to save your battery is to remove it completely when you plug in directly. Third, treat the battery as fragile. And finally, four, avoid buying knockoff batteries.

How To: Make a portable lap-sized beading studio for beading on the go

You know those long drives home in the car after you've spent a weekend at a cousin's house, or back from visiting Las Vegas? With more than a few hours at your disposal, what do you do to fill up the time? If you're an avid crafter and enjoy making jewelry, that you can turn those usually idle hours into productive crafting time by making this portable beading studio.

How To: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Count with OR criteria in Microsoft Excel 2010

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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Create a defined name for a dynamic range 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Sum values after a deadline in Microsoft Excel 2010

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Add yearly totals from monthly data in MS Excel 2010

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.