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.
Score higher on Bejeweled Blitz without cheating! No cheats or tricks here, just a few tips on how to get a higher score honestly. Get your multipliers up, use bonuses strategically and become a Bejewled Blitz master!
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.
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.
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...
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.
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.
In this tutorial, we learn how to make Indian dahi puri. You will first grab your yogurt, and mix it together with salt. After you do this, poke a small hole in your mini puri shell and sprinkle spices on the bottom of the plate. Next, place different spices and vegetables into the middle of the shell. Follow this with adding the liquid mixture into the shells, then top off with chopped onions and tomatoes. Add spices to the top and curd if you like. To finish, sprinkle the yogurt on top and ...
If you need to break up soil for a garden or a new lawn, a rototiller is the tool that will make the job a lot easier. This video from Lowe's will provide you with some key tips to using a rototiller successfully. Mike Kraft shows the best way to use your tiller. Learn what settings you should use for tilling, how you should prepare for tilling soil and garden safety tips.
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.
In this video, we learn how to create a knotted tank top. First, you will need to take a shirt that is too large, the cut off the sides of the two sleeves down to the bottom. Next, cut the shirt from the collar and make strips out of the excess fabric. Tie the strips on the back of the shirt going to the front of the shirt and tie it. You can also make a chain shape to make this look more unique. When you are finished with this, you will wear a tank top underneath it, then you can wear this c...
In this video, we learn how to make a ninja mask out of a t-shirt. First, grab your t-shirt and then roll it up until you get to the head opening. Now, stick your head through the hole and take your sleeves out. Now, take the back of the shirt and roll it over the top of the head and bring the top of the shirt up to the top of your nose. Now, tie the sleeves behind your head and tuck the rest of the shirt underneath the top of the shirt you're wearing. When you are done, you will have a ninja...
In this video, we learn how to tie a plafond knot. First, make a loop with your string, then make a smaller one directly underneath it. Make a larger loop underneath this, followed by another small one. After this, grab the bottom and lift it to the middle of the one on top of it. Next, bring the top down and push it into the middle of the bottom loop. Bring the left hand side of string through the top of the loop, followed by the right hand side through the right hand side middle. Now, pull ...
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.
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....
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.
If you own an old refrigerator, chances are that you have an energy zapper in your home. With some of the more newer models, they zap less energy, but can still waste a good amount.
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...
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 ...
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...
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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
T-shirts are practical and unfailingly comfortable, but not particularly known for looking either sexy or fashionable (they're more, shall we say, frumpy, than anything else). But did you know that within the ugly duckling that is your blank gray T-shirt is a beautiful swan of a tank top just waiting to get out?
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.
Are you a huge fan of Top Chef? Who isn't? Wish you could make the delicious recipes they whip out every week? Well, here's you chance! In this video, go along with Mark Kaye as he makes a meatloaf recipe devised by Top Chef's Tom Colicchio.
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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
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 and Mr. Excel, the 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions 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 and Mr. Excel, the 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS 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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT 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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
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 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the consolidation feature in Excel. Summarize data from a number of different tables quickly using consolidation.
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 525th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records using advanced filter and wild-card criteria. See, for example, how to extract records that start with the letters W or J.
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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.
Nathan demonstrates how to easily make a button using the Badge A Minit hand press button maker. First, load the button back into the blue ring. Place the artwork, face side up on top of the button back. Add the clear plastic circle on top of the artwork and put the yellow ring on top. Next, flip the apparatus over and put the purple ring on top of it. Then, put the green ring on top of the purple ring. Place one hand on top of the other on top of the green ring and press down firmly until it...
In this video, our author, ofenjen, shows us how to slice and plant a pineapple. First, find a pineapple: please don't get one too green or too yellow as they aren't ripe properly. Twist off the top of the pineapple with your dominant hand.
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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
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 373rd installment in their series of digital spreadsheet magic tricks, you'll learn how to select 3 numbers from 50 with no repeats. Also see how to select 3 names from a list of 10 with no repeats.
