Showcased Tips Search Results

How To: Tag contacts on your Apple iPhone

There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.

How to Do the M1R/M1L: Make One Right/Left knitting technique

Watch this instructional video to accomplish the knitting technique: M1R / M1L: Make One Right / Left. A make one, abbreviated M1 in knitting patterns, is an increase stitch. In some instances the slant of the increase does not matter, but, when it does, it's helpful to know how to make one left-slanting and how to make one right-slanting. A make one right slanting is abbreviated M1R:

How To: Use tables in documents on Microsoft Word: Mac 2008

Creating tables inside Microsoft Word has always been a chore— but not anymore! With Word 2008 for Mac, you can easily create tables of all your information. And if you're not sure of the best way to select, resize, and move those tables, you'll know soon enough. The Microsoft Office for Mac team shows you just how to work with tables with these Word table tips in this how-to video.

How To: Use worksheets in Microsoft Excel: Mac 2008

Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.

How To: Make & decorate a pastel flower cake

In this video we learn how to make & decorate a pastel flower cake. You can make a lot of things with just one icing tip. First take a round white cake with white icing. Then, use a start tip to draw three flowers onto the cake. Create a green vine to connect all of these flowers together and a cookie cutter to draw the outline around the flowers to keep it in place. You can use different colors of icing for each of the flowers and draw smaller flowers around the side of the cake as well. Get...

How To: Make a speedy paper airplane

In this video we learn how to make a speedy paper airplane. First, fold the paper in half and make a crease in the middle. Next, fold the corners down on the top. After this, fold these into another triangle going half way down the paper. Then, fold the tip all the way down so it rests on the opposite side of where it started. Do one more fold like the ones you did in the second and third steps. Make sure you are making crisp creases in the folds that you make. After this, fold the tip to the...

How To: Retrieve the cell address of the minimum 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How To: Extract inconsistent name & e-mail data from a one-column list 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Return every other cell in a row 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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.

How To: Look up and return two values to one 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.

How To: Mix face paints with water

In this video, we learn how to mix face paints with water. First, you will dip your brush into water and then dip it into the paint color you want. Now, paint on your body where you want that color to do. When finished, place the brush into the water and swish it around until clean, then dip the brush into a new color and continue painting on your body with new brushes, cleaning them as you go. To use a sponge, dip the tip of the sponge into the water, then rub it into the paint color you des...

How To: Write heavy metal music with songwriting tips

System of a Down. Motley Crue. No matter who you are, a heavy metal song is almost instantaneously recognizable, with bands as diverse as System of a Down and Motley Crue banging out deep, distorted guitar riffs and emphatic beats. The muscal genre of heavy metal is a headache for adults and a form of rebellion for kids, which is why you'll always seen teens rebelling by blaring this music on full volume.

How To: Make a rosette and a swirl using the star tip

Cake decorating when we were little kids was pretty uncomplicated. Once the cupcakes were out of the oven, we'd scramble over to the counter, maybe secretly take a bite or two, and then whip out a spatula and begin slathering on icing. We would then finish off with a nice handful of rainbow sprinkles because sprinkles were pretty.

How To: Make sugar cookie dough with a good consistency

When we're baking sugar cookies, we all tend to do the same thing: Rush through the boring mixing and baking part, and then spend three times as long on putting on the icing and forming pretty motifs. But to create truly spectacular sugar cookies, there is more to crafting dough then simply throwing in the ingredients and blending.

How To: Do look-up addition with VLOOKUP & HLOOKUP 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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.

How To: Ice a small cake for beginners

The video covers how to ice a cake. According to the video it is best to start by refrigerating the cake. You will need a 16" pastry bag with an icing tip on it. The tip should have a cerated edge on one side and a smooth edge on the other. Set the cake on a rotating plate. Rotate it and put a layer of icing all the way around the cake and then fill in the center. Once the cake is covered use a spatula and smooth out the icing. Then set the second cake on top of the first and put the icing on...

How To: Use Boolean math formulas in Microsoft Office 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 to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.

How To: Create a dynamic frequency table & 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 636th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic frequency table and histogram chart using defined name formulas for dynamic ranges that use the INDEX function. See other formulas that use the COUNTIF, IF and ROWS functions that help to make it fully dynamic....

How To: Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.

How To: Carve a 3D pumpkin into a jack-o'-lantern in Blender

This spooky-themed tutorial presents a look at some of the techniques needed to create a jack-o-lantern from a pumpkin. Some of the techniques include using retopo, extrude and some manual modeling. The tutorial also provides a series of tips for easily managing your camera angle and spot lights. 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 w...

How To: Perform 5 exercises to firm stomach and thighs

This video demonstrates various different tips which will help you to strengthen the stomach and thighs. First of all, you should make sure that you are eating properly by eating more vegetables, whole grains, and cut down on junk food. Next, make sure to do cardio exercises, at least 3 hours a week. This increased oxygen consumption will be able to increase fat burning to get rid of fat around the stomach area. Another tip to help with burning fat and toning muscles is to focus on different ...

How To: Break up hours worked by shift 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 624th installment in their series of digital spreadsheet magic tricks, you'll learn how to break apart the hours worked in a given day into one part for the day shift and a second part for the night shift using the MEDIAN function instead of the IF function. The MEDAIN function can be used when there are different ca...

How To: Sum year over year sales using MS Excel's SUMPRODUCT

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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.