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 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework). With this three-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to sum rational expressions in algebra.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this two-part installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to graph a rational function in college-level algebra.
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 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
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 329th installment in their series of digital spreadsheet video tutorials, you'll learn how to create a frequency table. Then see how to calculate the midpoint of each category and make a frequency polygon with two or more lines (two or more data sets).
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 234th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between degrees and radians in Excel with trigonometric functions and formulas. Rad!
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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.
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 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
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 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.
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 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.
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 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
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 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.
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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Rafael and Zappos How To demonstrates how to pack your luggage efficiently. First, make a packing list to determine what you will need to bring on your trip. Go through your day in your mind and add things to the list accordingly. Don't forget your toiletries. Ideally bring one pair of shoes and coordinate your wardrobe accordingly. Lay out everything you will be packing and group them by like items. Don't put piles in your suitcase. Instead, roll your garment to prevent wrinkles and save spa...
Make sure your neighbors don't mind before you learn to play the drums with Mr.G. In this new four part series, he is going to teach you how to play the drums. You'll start with extreme basics, including your grip, to learning a simple 16th note full measure. Watch this, if your sick of just "banging", whether it be pots and pans or a proper drum set.
Daniel Zondervan of Diva Dan's Kitchen shows us an incredibly simple way to make Roast Beef with Caramelized Veggies. you can make for the chilly fall months or anytime you just want a delicious meal. This dish just happens to feature roast beef, acorn squash, carrots and turnips. Keep in mind that you can change up the vegetables to fit your taste. Also shown is how to make a homemade gravy with cornstarch and water that you can use to marinate your vegetables in. A dish that is sure to please!
Blood and sand doesn't necessarily sound that delicious as a drink but I'd be lying if I said it didn't intrigue me a bit. This classic Dutch cocktail has body, taste, and will get you where you need to be (well maybe a couple will do the trick). In this video you will learn exactly how to make a Dutch blood and sand cocktail in less than 15 seconds. Mind you the scotch is replaced with a very bodied gin. Enjoy!
This video starts off with a neat optical illusion that he uses to demonstrate the effectiveness of force card tricks. He shows a piece of paper with "Paris in the the spring" written on it, most people's mind will skip over the second "the" and will read it, "Paris in the spring." He then goes on to demonstrate a shuffling trick that allows you keep a hold of a given card while shuffling. Finally the presenter explains the difference between asking someone to "Pick a card" and asking someone...
In this video PCMECH give a walkthrough the installation of a bootable Linux on a USB thumb drive from Windows. For this it's recommended to use a USB stick with a capacity of at least 1GB. First the UNetBootin application should be downloaded from the site mentioned and run the program keeping in mind to plug in the USB stick prior to the running of the program. Next the desired Linux distro and version should be selected and run as shown in the video. If you already have a distro you can us...
Check out Houdini's new pyro effects! Watch this video tutorial to learn how to use Pyro FX n Houdini 10.
Transforming your school uniform to express your individuality can be done very easily with a creative mind. One thing you can do to dress up a pair of pants and a plain tee is to wear different scarfs and belts. Feel free to mix and match. You can even try them with a cute vest or a jacket. Another way that you can mix things up is to change your shoes; you can get a variety of interesting colors or patterns. Also, changing your totes to something cute and different can make you stand out.
Tired of those bulky alarm clocks in your bedroom? Get rid of the darn thing and use your computer. There's an online alarm clock at onlineclock.net that saves space in your bedroom and keeps simplicity in mind, with simple red number digits and a black background.
This video illustrates tapping on the '3' or the upbeat (halfway through the beat). Count '1-2-3-4' for each beat. ('1' being the downbeat, '3' being the upbeat or exact middle, and '2' and '4' being the places inbetween or the quarter beats). It is not a synchopated embellishment, as it happens on an even division of the beat.
Have you become a Jedi in your Star Wars delusional mind? If so, break out of the the asylum with a Jedi lightsaber. Oh, but you don't have a lightsaber yet, okay. Well, this video tutorial will show you how to make a very inexpensive LED light saber with the most basic parts you could find. Novastar will shares his Jedi wisdom on LED light sabers, so pay attention, or you could never get out of that loony bin.
Learn the important steps necessary for the best printing experience when printing to the HP Photosmart Pro 9180. Keep in mind that many of the steps that are detailed in this tutorial can apply to many of the other fine HP printers. Here is a detailed explanation of the changes that were made to the 10.0.1 update to Adobe Photoshop CS3. Remember, having all the current versions of Adobe Photoshop, and the Epson drivers is critical to success when printing.
Here is a very in-depth description on how to make a silencer, but really a sound suppressor for your paintball gun. If you want to try to make a suppressor for a real firearm, the principles are basically the same. So, for ninja-like paintball action, watch this video tutorial to see how to make a silencer for a paintball gun, or sound suppressor, whichever you would like to call it.
Now that summer is swiftly approaching, it's time to start wrapping your mind around that most enjoyable of summertime treats: Ice cream. While you can certainly go to the store and purchase bulk packages of rocky road, store-bought ice cream is full of gnarly-sounding ingredients that sound more like a chemical found in a mad scientist's lab than actual food (xanthan gum, anyone?).
If you were to read the achievements list for Infinity Blade II, you'd come across a rather peculiar one called 'Mind Over Matter'. To get this one, you have to defeat an enemy without attacking him. Say what?
Four years ago Mind Candy was a pretty small game company. They were best known for their revolutionary but short lived ARG Perplex City, and had no other successful franchises to fall back on when that ended. Their plan to save it? Start a free online social game for children ages 7-12 called Moshi Monsters, where kids can create monster pets, raise them, and socialize with one another in a controlled, safe environment.
Although in recent years street art has reached a high point of public appeal many of the great artists are over shadowed by the likes of banksy and shepard fairey (who are amazing artists for sure, just not the only amazing artists out there). Some of the best urban artists have never had a gallery show or exihbit, and most have only been out of their own country once or twice. But of course, thanks to the internet and movies, i )along with many others) have been lucky enough to see the work...
It takes a special kind of mind to look at an M.C. Escher drawing and see a blueprint. And yet, looking at this working 3D model of Escher's Waterfall, one gets the impression that YouTube's mcwolles may have done just that! One thing's clear: like Escher's famous lithograph, the video employs some manner of trickery. But what kind? Good, old-fashioned forced perspective? CGI? Do the shadows provide a clue? Let's hear it in the comments.
The crochet decrease may be similar or the same as a cluster of stitches. Keep in mind that you can decrease by skipping stitches as well, but with this tip we are addressing the stitches joined at the top. The purpose of the stitch is what will make them different, while the anatomy and structure of the stitch may be identical. It is something to keep in mind and to help prevent confusion. I am providing two video examples. The first is the Double Crochet Decrease. The second is the crochet ...
Dutch designers Marcia Nolte, Stijn van der Vleuten, and Bob Waardenburg are the masters of illusion behind We Make Carpets. Look, then look again. What you initially see isn't what it appears to be...
Can a well-directed thought be as good as a mouse click? With an Emotiv EPOC headset, the answer is yes. And then some. Though Emotiv describe their device as a "high-resolution, neuro-signal acquisition and processing wireless neuroheadset," we're quite content to call it a thinking cap.
Whether you need very temporary skin art for a costume or simply want to test-run a potential tattoo design before it gets permanent, making your own temporary tattoo only requires wax paper, a printout or drawing of your desired design, black eyeliner, rubbing alcohol, baby powder, liquid bandage, and a lot of patience.
Ayurvedic medicine is a 5,000-year-old system of Hindu traditional medicine of Vedic tradition and is now a widespread form of alternative medicine and natural holistic healing.
