Numerous Tips Search Results

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Give your cat medication with a few fool proof tips

In this video, we learn how to give your cat medication with a few fool proof tips. The first method to do this at home is to wrap the cat inside of a towel, then drop the medication into the cat's ears or mouth. This will help your cat feel comfortable and it will prevent you from getting scratched. Next, you will use treats and place the pill into the pocket of it, then give it to the cat. The animal won't even know the pill is inside of it. After this, you can use a pill popper, which is a...

How To: Enter a mail-in sweepstakes using tips & tricks

In this video, learn how to enter mail-in sweepstakes, what supplies you need, tricks and tips for filling out entries, how to organize your entries, and how to not get disqualified. This clip will walk you through the entire process so that you can increase your chances of winning and getting one of those oversized checks delivered to your door. So, follow along and enter those contests the right way to maximize your opportunities to win.

How To: Magnify to edit text on an iPhone

In this Electronics video tutorial you are going to learn how to magnify to edit text on an iPhone. This video is a part of a series of tips on iPhone finger tips. This is very simple and easy to do and takes practically no time to complete. If you wish to add something to a list or change an email, go to the springboard and click on the ‘mail’ icon. Then scroll and find the text you want to edit. Now simply touch and hold your finger on the text. This will bring up the magnifying glass. Now ...

How To: Generate random numbers not divisible by 3 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 261st installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random numbers within a certain range and with certain supplementary criteria (e.g., values that are not divisible by three) via the use of large array formulas.

Hack Like a Pro: How to Use Maltego to Do Network Reconnaissance

Welcome back, my greenhorn hackers! Before we attempt to exploit any target, it is wise to do proper reconnaissance. Without doing reconnaissance, you will likely be wasting your time and energy as well as risking your freedom. In previous guides, I have demonstrated multiple ways to perform reconnaissance including passive recon with Netcraft, active recon with Nmap or hping3, recon by exploiting DNS or SNMP, and many others.

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

In this how to video, you will learn how to draw Broly. First, start out with an oval shape for the face. Next, add another for the ear. From here, you can add the neck, shoulders, and chest. Next, draw numerous spikes for the hair. The basic outline is complete. Go into the drawing with more detail by adding lines inside the spikes to simulate hair strands. Add the eyebrows, eyes, nose, and mouth. Next, draw in the muscles of the shoulders and chest. Add the outline of the necklace. Now you ...

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

Are you bored with ordinary meals? Why not tap into your adventurous side and try Starfish? Yes, that's right, those cute little fish that you see on the sand - you can eat them! So, if you are interested, check out this video and master the techniques needed to eat these spiny sea creatures.

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.