How To: Keep your herbs fresh with tips
We can't get enough of fresh herbs in our cooking, but that's just the problem: About 2 days after we purchase our sprigs of thyme and sage they look sadder than Ashton Kutcher's last romantic comedy.
Personalize Tips Search Results
How To: Make a buttercream rose with a rose tip
One of the quickest ways to dress up a cupcake or a cake is by adding a pretty rose on top. The rose acts kind of like the bow on top of a present - the present looks okay without it, but adding one turns it from drab to fabulous.
How To: Apply latex ear tips to make yourself look like an elf, alien or faerie
Ear tips are a versatile part of any science fiction or fantasy costume - make yourself look like a Vulcan, elf, fae or any other creature with pointed ears. Not only are you shown how to attach the ears, you can make blend in with the skin of the wearer to look as natural as possible.
How To: Run effectively with tips for beginners and advanced runners
If you're a habitual runner - or you want to become one - then it's super important that you run correctly. Even if you don't notice it at first, running with the wrong alignment can cause leg and back issues later on that are extremely painful and difficult to deal with.
How To: Use the SUMIF function with approximate criteria 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
How To: Use the SERIES chart 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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart function.
How To: Get started using a Verizon Droid 2 Google Android smartphone
In this clip, entitled "Tips for Droid 2 Dummies," you'll learn the basic ins and outs of using a Google Android phone. Whether you're the proud owner of a Verizon Droid 2 Google Android smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, and to get started using these tips and tricks yourself, take a look.
How To: Rank values based on a single 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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
How To: Extract all the letters from a text string 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 699th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract all the letters from a text string with a VLOOKUP function in Excel 2010.
How To: Tip your delivery person the right amount
Knowing how much money is appropriate for tipping the delivery person bringing you flowers, pizza, food or something else can be a tricky etiquette question. Always make sure you're giving the proper amount for what was delivered!
How To: Create makeshift laundry detergent from a bar of soap and boiling water
If you need to save your money for bills, then this laundry tip will help keep the costs of laundry to a minimum. It's a really simple and cheap tip if you happen to be out of laundry detergent during a load. Simply grab a bar of soap and cut a third of it off. Then place it in a pot of boiling water and let dissolve for about ten minutes. When it's done, transfer it to a large bowl and stir for about thirty seconds. Then it's ready! Makeshift laundry detergent!
How To: Extract month and year records from transactional data 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 extract month and year data from transactional records by filtering, array formula and non-array formula.
How To: Count with Boolean 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 683rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count with Boolean criteria in Excel 2010.
How To: Apply formatting to alternate rows 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 685th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD and ROW functions for applying formating to every other row in your chart.
How To: Find the smallest number greater than zero 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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.
How To: Average times entered as text 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.
How To: Add & average while ignoring #N/A errors 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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
How To: Use AGGREGATE instead of SMALL 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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
How To: Avoid Ctrl+Shift+Enter for array 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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.
How To: Extract unique lists from Excel data sets by filtering
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 660th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a data set using Advanced Filter.
How To: Create a data set with ROWS, COLUMNS & CAR 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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
How To: Increment a number pattern by formula 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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.
How To: Use comparative operators in logical formulas 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
How To: Create line and X-Y scatter charts 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 654th installment in their series of digital spreadsheet magic tricks, you'll learn see when to use line charts and when to use an X-Y scatter diagrams.
How To: Use the Speak Cells on Enter tool 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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter function.
How To: Calculate interest with the CUMIPMT function 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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
How To: Base a PivotChart on a PivotTable 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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
How To: Create a chart with two horizontal axes 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 638th installment in their series of digital spreadsheet magic tricks, you'll learn how to add two horizontal axes to a chart.
How To: Use lighting to your advantage in photography
In photography, good lighting can mean the difference between an amateur shot and a professional quality portrait. Whether you're taking photographs outdoors or in, using lighting to your advantage creates an artistic, flattering effect.
How To: Create a simple studio backdrop in Blender 2.5
This quick Blender 2.5 video tip shows how to make a simple drop-cloth effect like those you see photographers often use. The tip also demonstrates how to make the drop cloth follow the camera's rotation. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more informa...
How To: Create rounded-off square forms in Blender 2.5
In this quick Blender 2.5 video tip, you'll see how to easily model a rounded-off square form by using snapping/retopology tools. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
How To: Remove spaces from a Microsoft Excel formula
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
How To: Find the hidden secrets in Fallout 3's "Point Lookout"
Check out this tutorial from IGN and learn how to find the hidden secrets in Fallout 3's "Point Lookout". You will learn tons of tips and tricks for this level so that you will always come out on top. These tips come straight from the expert gamers at IGN, so you know they're good.
How To: Use mixed cell references in 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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
How To: Match lists with lookup functions 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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND function.
How To: Use MS Excel 2010's NORM.DIST & NORM.S.DIST functions
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel 2010 video tutorials, you'll learn how to use the new NORM.DIST and NORM.S.DIST normal distribution functions. They have new screen tips to help you select the correct argument.
How To: Round only the total column with SUM & ROUND 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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
How To: Convert hours to days & days to hours with Excel's MOD
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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT functions.
How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
How To: Allow only Monday dates in a cell 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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.