How To: Pack your cosmetics when you travel
Heres a quick video on tips for packing your makeup products when flying to a gig, specially if you're a makeup artist, or just plain Janes (and Joes) traveling with loads of makeup.
Simple Tips Search Results
How To: Tie standard hackle tip wings for fly fishing
Using hackle tips to create standard Adams style dry fly wings, you can fish like no other. Don't believe me? Try it out for yourself.
How To: Clock your wedge shots for a better golf swing
Do you have the perfect timing? Timing your swing is important, but sometimes a clock can do a whole lot more to help your golf swing. By imagining the face of a clock, you can effectively train your body to calculate the proper swing length for shots from various distances. Sound intriguing? Let Doug Hammer, PGA, show you the way. Watch this video golf tutorial and learn how to clock wedge shots.
How To: Use an orange guard non-toxic bug killer
Lars shares some tips about using an orange guard non-toxic bug killer. These helpful and easy-to-understand tips will help to keep pests out of your garden. Watch video for best results.
How To: Reduce heating costs
Tim Carter shows us a few tips on how to reduce your heating costs. These quick tips and quick solutions are a definite factor in saving money and fuel.
How To: Zone out your opponent in League of Legends using these zone control tips
This League of Legends guide from CLG showcases how to use zone control against your opponent by forcing them to stay out of range of minions and preventing them from damaging you. This will allow you to win your lane so that you can move into the late game.
How To: Earn the secret achievement 'Balls' in Deus Ex: Human Revolution
Once you have access to the Detroit City Hub in Deus Ex: Human Revolution, it's possible to unlock a secret achievement dubbed 'Balls' on the Xbox 360 version of the game. This Giant Bomb walkthrough will help you locate the basketball hoop you'll need to earn the achievement with, and give you a little tip on how to easily get the ball through the hoop.
How To: Earn the 'Ship of Fools' achievement in Alice: Madness Returns on the Xbox 360
Alice: Madness Returns features a segement of the game where the player controls a ship and enters into a side scroller arcade style mode. Achievement Hunter gives some tips on how to complete this section without taking damage, unlocking the 'Ship of Fools' achievement.
How To: Tone your body and have glowing skin for a wedding
Whether it's your friend's wedding or your own, it's so important to look drop dead gorgeous on the wedding day. If you're a bride or bridesmaid who's looking to firm up and look like a ravishing, glowing princess, then check out this video for great tips on how to work out with limited time and get your skin smooth and bright.
How To: Defeat the Ape King in Ninja Saga on Facebook
If you didn't know already, December 5th, which is today, is the Day of the Ninja. It's an unofficial holiday where people across the world dress like a ninja, engage in ninja-related activities and spread information about ninjutsu online. But for web-gamers, the Day of the Ninja is the best time of year to get some Ninja Saga action in.
How To: Clear your drain with eco-friendly white vinegar
A clogged drain makes an unhappy cook. But unfortunately drains get clogged far too easily and often. And while pouring down a drain de-clogger can work, the very toxic chemicals in the de-clogger are damaging to your health and to the environment.
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: Clean gutters and downspouts with tips from Lowe's
Gutter maintenance is not the funnest household chore, but it is essential in preserving your home. Lowe's has a few tips for you to start clearing out your gutters. You'll need a ladder, a bucket to clear out the debris, a trowel of some kind for scooping out the gutter gunk, a garden hose to wash out the gutter and a pair of gloves to protect your hands.
How To: Winterize your lawn mower with basic fall maintenance and repairs from Lowe's
Winter's coming, and when it's over you'll be back to mowing your lawn in no time. To make sure your lawn mower is up for the job, Lowe's has some great maintenance tips for you to perform to completely winterize your mower.
How To: Make DIY prosthetic horns, tentacles, and nose tips
Most girls dress up only one way during Halloween: With a suitably colored bra (green for a leprechaun, pink for a bunny, for instance) and teeny mini skirt in a matching shade, plus some sort of headpiece so people don't just think they're hookers.
How To: Ask a boy to the Sadie Hawkins Day dance in November
Before the feminist movement gained prominence in America, there was a man named Al Capp. Capp was creator of the hillbilly comic strip Li'l Abner (1934-1977), and in 1937, his Sadie Hawkins Day spilled out into reality as the pseudo-holiday practiced throughout schools and colleges, where girls asked boys to the dance.
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: Create realistic looking drawings and paintings
Merrill offers up some of this best tips for making your works of art more realistic. There's three very important strategies for improving your the lifelike quality of your drawings and paintings, and in this video, he demonstrates them for you.
How To: Sharpen a chef's knife or kitchen knife using a whetstone
You know how writing with your trusty No. 2 pencil gets to be a pain if you haven't sharpened the tip in a while? A sharp pencil produces crisp, pretty marks that enhance your writing, while a dull pencil tip causes smeared and sometimes illegible writing that looks slopping.
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.
How To: Add a scenario button to a ribbon or toolbar 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 680th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a scenario button to a tToolbar or Ribbon in Excel 2010.
How To: Ignore hidden rows with MS Excel's AGGREGATE function
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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
How To: Ignore nested subtotals with AGGREGATE 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
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: Use the AGGREGATE function 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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...
How To: Extract records with 1 criterion via Excel's AGGREGATE
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
How To: Extract records with 2 criteria with Excel's AGGREGATE
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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...
How To: Extract the rows in a data set to 1 column 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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.
How To: Use Boolean logic for AND & OR formulas 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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...
How To: Create a frequency polygon line chart 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 655th installment in their series of digital spreadsheet magic tricks, you'll learn see how to create a statistical frequency polygon using a line chart. Also see how Excel mistakenly interprets number category label data as Number Series data.