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?).
You don't need a big name hairstylist who claims he's done Jessica Simpson's hair in order to get luscious, enviable locks. In fact, all you need are cheapo, basic velcro hair rollers.
People respond so much better to requests when you add the word "please" in front of them. So if you're stuck in a foreign, Spanish-speaking country, it's vital that you add "please" when necessary to establish good manners, so that people will help you out.
When we think of holiday songs, usually "White Christmas," Bing Crosby, and lots of fake snow falling on Bing Crosby while he sings "White Christmas" come to mind. Thanksgiving songs are often neglected or get lost in the shuffle during the very Christmas-centered holiday season.
Want to find the value of a t-statistic confidence interval for a small sample? This clip's your ticket. 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. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.
Need a quick primer on how to solve type-1 error problem in stats? Let this video be your guide. 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. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.
Can't make heads or tails of one- and two-tailed tests? Never fear. This stats lesson will teach you everything you'll need to know. 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. For all of the details, watch this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials.
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to calculate a confidence interval in basic statistics.
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 installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to find a 95% confidence interval in statistics.
In this video, we learn how to sit cross-legged for meditation. Meditation in this pose will cause you to be far more relaxed and calm then if you were in an uncomfortable position. If your rear end hurts while you are sitting down, try putting padding underneath you so you are completely comfortable. Make sure your feet are tucked into your body and your back is aligned with your head straight in the air. Once you are comfortable, you can put your hands at your sides on each of the legs. The...
In this tutorial, we learn how to say basic phrases in Polish: "may I use...". Listen to the video and read the text as you practice saying each of these phrases. It's important to get the accent down right, or you can be saying a totally different word or phrase than you mean to. If you use these everyday, you will become more familiar with the answers you get to the questions as well! Just make sure you practice and go slow with these, no rush. Once you learn these, you will open your mind ...
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 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
In this tutorial, we learn how to knife someone in the face with film effects & tricks. This effect is mostly done in the camera and not in computer software. First, get two identical knives and a hat you don't mind ruining. Then, remove the blade from one of the knives and fix it to the hat. Once you have the knife set up, put your actors in place. When you do this part, use caution to make sure you don't throw the knife at anyone. Throw this into the air, then take the shot to the person wi...
In this tutorial, we learn how to learn to live in the moment and be more attractive. When you want to land a girl and appear more attractive to her, you need to live in the moment. When you stop worrying about yourself and being absorbed in your own mind, the girls will come. Forget about yourself and focus on exactly what is going on in the situation that you are in. Life is full of ups and downs, so don't let outside things effect you when you are trying to find a girl. Live in the moment ...
In this tutorial we learn how to use the Facebook status tagging feature. This will let you update your Facebook status and add your friends in with it. This will appear on their wall as well, for all their friends, mutual friends, and your friends to see. To do this, you will begin typing in the status update, then type in "@ and then that person's name" Their name will show up underneath where you are typing. Keep in mind you cannot tag someone you aren't friends with. Click on their name w...
Want to draw a quick scene in Photoshop that contains mountains, clouds and water. Just watch this video.
In this video, we learn how to cut side bangs. Fist, you will need to grab some shearing scissors, a comb, a trash can, and water. Now, get your bangs wet in the area that you want it, then part your hair where you usually part it. Once you do this, separate your bangs from the rest of your hair and clip the rest back. Next, use your scissors and cut at an uphill angle from the bottom of your bangs to the top. When finished, continue to cut until you have the desired length. Keep in mind your...
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH 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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.
In this tutorial, we learn how to make movie rain without getting wet. First, you will need to get a garden hose that has a spout on it and few pieces of PVC pipe. Connect the pieces of PVC pipe together, then stick the head of the hose to the pipe. Keep in mind that you will want to cut the pipe a bit shorter so it's easier to hold. Now, have someone hold up the pipe while you are taping and make sure to stay opposite of the way the wind is blowing. After this, you will have taped rain in a ...
In this tutorial, we learn how to change fractions to decimals. First, you will need to divide the numerator by the denominator. The numerator is the top number and the denominator is the bottom number. Once you get this number, you will end up with a decimal instead of a fractions. When finished, you will end with the number that will be your answer! Practice doing this with simple numbers, then move onto more difficult to test your mind and get better and better at math! This is an easy con...
We're all into modern hairstyles, but sometimes a retro 'do helps take us from blah to positively glamorous in just a few minutes, which, well, we don't mind. Check out this hairstyling video to learn how to create a rockability hairstyle inspired by pin ups and women of the 1950s.
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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
