Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 34th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a formula that will calculate the taxable earnings for a payroll period when there are ceilings (hurdles maximum) for taxable earnings (above which ...
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 41st installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate deductions from paychecks when there is a ceiling or max taxable amount or hurdle.
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 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
It's mid-January and some of you happy tax-paying citizens have already started receiving your W-4s and 1099s in the mail. But before you start filling out your 2010 Federal Tax Return, make sure you're hip to all the tax tricks in 2011. You could end up saving some money!
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 363rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the ADDRESS, MIN, IF, COLUMN & ROW functions that will return the address of the first non-blank cell in your Excel spreadsheet.
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 364th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula using the INDEX, MATCH & NOT functions that will return cell content from the first non-blank cell in a row.
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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.
You may remember the recipe for a basic non-Newtonian fluid from grade school science experiments (one part water to one and one third part corn flour or cornstarch), but those trials probably stopped at squeezing the mixture in your hands. While a regular fluid's viscosity wouldn't allow you to walk on it, a little bit of technique and the magic of physics will have you walking on a non-Newtonian fluid as well as Jesus. This video science experiment shows how to use 50kg of corn flour/cornst...
Non-traditional Pilates strengthens the core by using body weight and avoiding use of the floor, weights or beds. Learn alternative Pilates exercises in this free workout video series from a fitness trainer.
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 or 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 solve non-linear systems of equations in algebra.
In this video tutorial, we learn how to use non-Apple, non-iPod MP3 players in conjunction with iTunes. It's easy. So easy, in fact, that this home-computing how-to from the folks at CNET can present a complete overview of the process in just over two minutes. For more information, including a complete demonstration detailed, step-by-step instructions, take a look.
If you are unlucky enough to have a bike whose setup does not features a self-extracting crank, then this video is for you! It shoes you how to remove a non-self extracting crank properly as part of you normal bike maintenance. Never envy the self extracting crank kids again after you learn how to take off you non-self extracting crank yourself easily.
Check out this instructional fishing video that demonstrates how to tie the Non Slip Mono Loop knot. Just follow the simple instructions outlined in this fishing tutorial and learn how to tie a Non Slip Mono Loop fishing knot. Knot tying is a breeze with this video. Start practicing and reel in the big fish!
Making a tutu can be hard, but making a non-sew tutu is nothing but easy. Watch this video tutorial to learn the ins and outs of the non-sew tutu for young children. You can change it up all you want once you get the basics down, but for starting off, use the following supplies:
Like it or not, there's a very set idea of how a woman should do her hair on her wedding day. Usually we don't see permutations beyond either down and curly or up and curly.
This clip offers instructions on how to do non-character rigging for animation in C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, and to get started creating and rendering your own Space Octopus, watch this 3D modeler's guide.
No coffeehouse or cappuccino maker in sight? Whip up a tasty instant version with a little ingenuity and some common ingredients. You will need:
Can you recharge non-rechargeable alkaline batteries? Yes you can! Gary Cutlack from techdigest.tv risks chemical burns to demonstrate.
Yanik Chauvin demonstrates how to do Non Destructive Dodging (lighten) and burning (darken) of images using the tools in Photoshop. He shows the image of a man lying on earth with his camera. To start the work he wants to make a new layer which can be done in two ways either by clicking on the ‘layer’ button on top of menu or by pressing down the alt key and clicking on the new layer at button of the layer palette. It will bring up the dialogue box. He named it “dodge and burn” and from the l...
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 375th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy non-contiguous columns of data and then paste all the columns at once.
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 213th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a non-array formula to extract data dynamically using two different methods.
Educational Specialist, Jennifer Taggard shows her viewers a very easy and accurate process to making non-toxic flea killer. This flea killer will not harm children in a household or any dog being treated. To make the flea killer, 1/2 of a cup of baking soda and half of a teaspoon of orange essential oil was used. The two ingredients were mixed together and simply applied and rubbed into the dog.
This music production software tutorial is a demonstration and explanation of the usage of Dr. Rex as a melodic instrument or otherwise in FL Studio. See how to use the drum pattern maker Dr. Rex for non-pattern sounds in FL Studio.
This how-to video will show you how to zap charge a non-rechargeable battery with only two wires and a car. Sounds cool, and fun, unless of course you zap yourself. Watch this video circuitry tutorial for more information on this simple, money-saving hack.
Non-stick cookware is a great way to cook and not have to deal with foods that stick to regular pans or deal with the cleaning up after cooking. A few rules to keep in mind are to not preheat a non-stick pan and do not use a heat level above medium. If you break or damage the surface of the pan, it could cause more damage than you think. There have been reports where you could develop flu-like symptoms just from cooking with a bad pan.
A Facebook page formatted specifically for non-profits can be created in a matter of minutes with this video tutorial from John Haydon. The first step you need to take is to search for any page. In this tutorial, Haydon searches for the page "Facebook Pages/Public Profiles" to use as the example. On the bottom left (of any Facebook page), you will notice that there is a link for "Create a Page for My Business." Click on that link, which allows you to begin the page creation process. Non-profi...
Need a new prank or trick to play on your friends? Well this video is your solution. All you need a non-transitive dice and to follow this video and you will be cheating your friend in no time. The idea behind this video is to use dice that are non standard, which means instead of having from 1 to 6 on the sides, they have other numbers. By playing with what numbers go on the faces, the viewers can skew with the probabilities of what number comes up. With this idea, the viewers can make dice ...
A non-CPU lens is one which does not have contacts on the rear mount, meaning it communicates with the rest of the camera solely through the aperture. This tutorial shows you how to set up the lens data for your camera, so you can get the most out of your non-CPU lens.
For beginners, one of the biggest questions is how you can wire your stick to a non-common ground PCB. In this great video, you'll learn how to rewire a Sanwa JLF joystick to work with a non-common gruond PCB and even disperse some myths on methods that others talk about.
Sir Robin Knox-Johnston is the first man to sail solo, non-stop around the world.In April 2009 he celebrated the 40th anniversary of his return to Falmouth in Suhaili, 312 days after setting sail on a voyage no one else had ever accomplished. In 2007 he completed his second solo circumnavigation as a competitor in the VELUX 5 OCEANS race. Sir Robin is the founder and Chairman of the Clipper Round the World Yacht Race and is an inspirational figurehead to those who undertake this challenge of ...
Non-woven wallpaper is easy to install and it's reusable. Tim Carter of AsktheBuilder.com explains how this cool wallpaper is different because it doesn't expand when the adhesive contacts the paper backing. These new non-woven wallpapers are huge time savers because there is no need to pre-paste a sheet of paper and book it while you work on another piece.
Today we show you how to do a non surgical facelift with the Secret Lift. Doing a non surgical facelift is So Easy a Guy Could Do It!
This tutorial shows you how you can set up a non-premium server for playing Minecraft with your friends, without having to use Hamachi. Your users will all need a Minecraft account and a Google account to be able to login.
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?).
This free video science lesson from YouTube's Mindpaint demonstrates a simple technique for creating a non-Newtonian fluid with a presure-variable viscosity. For all of the relevant details and detailed, step-by-step instructions, as well as to get started trying this experiment yourself, watch this home-science how-to.
In this video, Mike shows us how to dish a rear bicycle wheel. First, you need to measure the distance from the wheel to the hub and axle. Do this on both the non-drive and drive side. Set the dish on both sides, then find the gap from each of the side. Now you will know if the rim needs to be pulled more to one side. Loosen the non-dry spokes and tighten on the dry side spokes. Do this by loosening the non-dry a quarter turn each all the way around, then tighten the dry side a quarter turn e...
Want to know the secret to running Snow Leopard on a non-Apple Intel PC? Let this video be your guide. It's a simple process and this home-computing how-to will teach you everything you'll need to know. For specifics, including detailed, step-by-step instructions, and to get started creating your own hackintosh computer, watch this helpful video guide.
Nicole Young demonstrates how to use non-destructive dodging and burning using layers in Photoshop. Your first move is to create a new layer and then hit shift + delete to select the level of opacity. You want the layer to be fifty percent grey. Now select overlay from the menu which will make anything that is fifty percent grey will be transparent. You will be dodging and burning with white and black brushstrokes. To switch from black and white background colors just hit x. Other keyboard sh...
On this episode of Scientific Tuesdays, Dylan shows you how to create a non-Newtonian fluid using corn starch and a little water. A non-Newtonian fluid is any fluid that does not follow the laws of physics.
Tired of slipping on hard wood floors, but too cold to go barefoot? Make some of your favorite socks slip-proof. This how-to video project is an easy way to revamp your socks into a safer non-skid style. Your injury-free joints will thank you.
