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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
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. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.
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 274th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate various probabilities for a binomial distribution when there are additional complicating factors. This is accomplished with recourse to Excel's BINOMDIST, NORMSDIST, SUMIF, SUM, INDEX and MATCH functions. See also how to create th...
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 248th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the PERCENTILE and QUARTILE functions to calculate percentiles, quartiles and deciles in basic statistics.
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 124th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a box plot or box-&-whisker chart using a stacked bar chart and a open-high-low-close stock chart. You'll also learn how to use the QUARTILE function.
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 180th installment in their series of digital spreadsheet magic tricks, you'll learn how to count specific words, specific numbers, numbers greater than a hurdle, numbers between two values, values that are NOT equal to an amount, words that end in es, all words, all numbers, all content, all blanks, all things which aren't words ...
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 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
In this video, Sbirdboi will explain how you can get rid of a gnat infestation. First, you must identify what kind of gnats they are, as this determines the best ways in dealing with them. He will explain three common types of gnats, their habits and where they tend to lay their eggs. After teaching you about the kinds of gnats, you will learn what steps to take to kill the gnats, and prevent them from coming back. You will also learn tips of ways you can attract gnats and subsequently kill t...
In this video Eric Joneckis gives you a few tips on acting like a true skateboarder. If you want other people to take you seriously as a skateboarder, you need to look the part. Here are a few tips: Always wear a shoelace belt, skateboarding shoes that shouldn't be untied to take them off, long hair and a cap to keep it all in place. Next to style, attitude is the most important thing you can have. Learn how to fool the people around you into thinking you are a good skateboarder. If you can't...
Soldering properly is a skill every electronics and computer hobbyist needs. Proper soldering appears deceptively simple, but it requires practice. One has to do the steps below to solder the wires which is as follows, First Clean the area you wish to solder and scrape the wire down to the metal and then wiping it clean with alcohol or acetone. Then you want to use a rosin-core solder for electronic applications, which comes normally with coils. Tin the tip of the first Wrap one or two inches...
In this video Neil Young provides his viewers with some tips on how to correctly apply foundation on the face of a girl. Moreover, he gives advice to the girls out there on how to pick the correct shade of foundation that will be perfect for her; a foundation that will unify the tone of their face and body. Neil also gives tips on which kinds of foundation should be used during different seasons of the year and what one should do on the few months in between.
Lowe's presents a video that can give you a few tips on removing wallpaper from a room. First off you do not want anything to be in the way so clearing the room out is a must. This video shows you a abundance of products that can help you with the task. Also it shows some safety precautions to take before you take on this task. This video will show you a few different methods that can help you when giving a room a new look.
This video will show you how to make a birch holiday wreath step by step. The best part is that there are two options for this project. One for inside and another for outside. The projects focus on using items that you can find your backyard making finding supplies easy and accessible. By following these easy and simple tips you can create a wonderful wreath display for your home during the holidays. All these tips are shown by Terrain staff.
Get a sexy rock 'n' roll look that would be seen on the likes of such stylish celebs as Katy Perry and Gwen Stefani. In this makeup tutorial hosted by the experts at Smashbox Cosmetics, get tips, tricks and secrets to achieving this look without paying for a stylist. With dark, deep lips and a black pussy cat eye applied to your lids, you'll be ready to take center stage!
Looking to emulate the vixens of the 20's and 30's? In this makeup tutorial hosted by Smashbox Cosmetics, embrace your inner vixen with these tips and tricks on how to steal this look with your makeup. With a clean face, a natural matted eye with nude shades, and a dark winged out liner, you'll be channeling Betty Page in no time!
Upgrade your look this spring with these makeup tips inspired by the sexy style featured on the television show, Gossip Girl. Bronze your skin, add golds to your eyes and contours, and apply a high shine peachy gloss to your lips to achieve this sexy look for your next big outing.
IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to clean up an IMVU avatar in Photoshop.
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Wizard101 chessboard bug (09/23/09).
Get the inside scoop on Wizard101 hacks, cheats, tricks, tips, and walkthroughs! Watch this video tutorial to learn how to find the Yardbirds in Wizard101.
Check out this cooking tip from the Milen Show. Cooking doesn't have to be tough or stressful. Find out how to make it quick and easy! Watch this video tip for how to make perfect rice in the microwave!
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.
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:
Use GPS navigation on your road trip with tips from this how-to video. Liesel Hlista shows you how to use GPS as a backup on your roadtrip.
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.
The low price of speakers and MP3 players today make them ideal for adding a bit of sound to different items, and this tip from CNET reveals a few ideas. Add an MP3 player and a pair of speakers to a decoration, for example.
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.
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.
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.
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.
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.
Fiction books are often cited as being more entertaining than non-fiction books as you get to travel to exotic, sometimes alien worlds and the characters can sometimes be supernatural, with cool powers like flying or being able to heal instantly (vampires, anyone?).
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...
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...
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.
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.
Dragon Age: Origins is one of the most intense role-playing games on the PC, and if you want to continue that role-playing into real life this video has some tips for you. It will show you how to do a makeup look inspired by Morrigan, one of the game's main female characters.
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!
