We've all heard our fair share of roommate horror stories, or have some of our own, because we never truly know who someone is until we've lived with them. Cohabitation issues generally revolve around things like bills, chores, cleaning, and groceries. Approaching a roommate, especially an adult one, to remind them to do their chores can be an anxiety-ridden and daunting task. After all, we're roommates, not parents!
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.
Need a primer on how to discount outliers when calculating a statistical average within Google Spreadsheets? It's easier than you might think. And this free video tutorial presents an easy-to-follow, step-by-step guide of the entire process. For detailed instructions, and to get started lopping off outliers in Spreadsheets yourself, take a look!
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.
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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
One of the best ways to monitor your diet is by measuring your body fat content. In this three part tutorial, learn how to measure body fat using a caliper. A caliper is a device used to pinch and measure the fat on your body. A caliper is cheap, fast and accurate and makes an excellent alternative to electronic devices. Check out this video and stay on top of your new workout regime - mind the scale and use the caliper to know what's muscle and what's excess.
This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, watch this how-to.
Left 4 Dead 2 has a new add-on campaign, and it's called "The Sacrifice". This DLC for the Xbox 360 is a prequel to "The Passing", which features a meeting with three of the survivors from the original Left 4 Dead video game, where they learn that Bill, the fourth original survivor, sacrificed himself for his fellow comrades.
Looking for a way to save on your energy bills at home? How about line drying your clothes? According to the Energy Information Agency, clothes dryers account for 5.8 percent of home electricity usage. Line-dry your washed clothes and linens to keep them from wearing out, and save money on your energy bill at the same time.
Many ways to help the environment are costly, but using less electricity is one measure that will save you money. Learn how to lower your electric bill with this how to video.
In this bar trick, you'll ask someone to remove a dollar bill from underneath an upside down beer bottle without knocking the bottle over. Follow this little video and see how it's done. Next thing you know, you'll be drinking free beer!
If you're concerned that your computer has been infected by spyware and other malicious programs, watch this informational video and find out how to clean and restore your computer back to a normal bill of health. This informative tutorial shows various methods that can be used to disinfect your computer and rid it of those nasty viruses once and for all!
Are you under a backbreaking amount of debt? In this economy, we don't blame you. If credit card bills, mortgages, and bank loans are making you want to crawl into bed and pull the covers over your face, then check out this video to learn how to consolidate debt.
Gmail has been the best free email client for a while, but now it's even better. It has added a Skype-like service by which you can call any number in the US or Canada from the US or Canada for free. This video will show you how fast and easy it is to use this new feature to cut down on your phone bill and stay connected.
TextNow is a great App for the iPhone that allows you to, for a $1 initial fee, send unlimited text messages to any other TextNow user without using any of the precious limited texts on your AT&T plan. The App is very easy to use, requires only a modest amount of additional money to keep using it forever, and will probably wind up saving you money in the long run by cutting down your monthly billed texts.
You've probably seen millions of caricatures, or drawings that exaggerate reality by either over or under emphasizing a person's traits (so former president Bill Clinton would have a really big chin and Christina Ricci would have a really prominent forehead).
Gophers are one of the most common and annoying pests that plague gardeners across the country. This video features a gardening expert explaining how to use cinch traps to kill the gophers in your yard and allow your garden to flourish once again. Do what Bill Murray could not do in Caddyshack after watching this video.
Is your love of money and butterflies only surpassed by your love of craft projects? Boy, are you in luck. With this guide, you'll learn how to make a dollar-bill butterfly using origami, the traditional art of Japanese paper folding. For more information, including a step-by-step overview of the folding process, as well as to get started making your own money butterflies, watch this free origami lesson.
Learn how to get free electricity from your home telephone line just by watching this video. Save money on your power bill, and hack into the electricity coming out of the phone jack. The phone company doesn't monitor electricity usage, so you can probably get away with this con. Check out this video tutorial and learn how to tap into the electrical energy source in your phone line.
When you're on a limited data plan, bumping up against your monthly cap is a major concern. Overage fees are incredibly high these days, and being throttled down to 2G coverage almost renders a smartphone completely useless.
In this video, Bill Corso teaches us how to apply injury makeup. This can make it look like you are hurt, but it's really just makeup you are using to create the look! Using red and brown together can give a more realistic look of blood, blending it out through the entire cut. Using different colors on the injury can add a more realistic look to where the injury is. Work with the different features on the face to create the best look you can. Pay attention to the sweat on the body as well, be...
This is the ultimate guide to drawing correct human proportions. If you've always had trouble with it in high school art class or in art school, this video condenses all the information into a tight package that's fun and easy to understand. This will uncover all the tricks to human proportions for figure drawings.
Are you sitting in class the last day before holiday break, simply dying over how long each minute is before that last bell rings and you get to head to Big Bear? Pass the time (though obviously do so discretely) by crafting these simple origami t-shirts. Each t-shirt is folded from a monetary bill, which we're pretty sure you have in your pocket.
During the summer, lace shawls become uniform for many fashionable women who want to cover up slightly during those nippy summer nights or jaunts out by the chilly ocean but don't want to compromise their style. Lace shawls, which are composed of many delicate patterns with holes interspersed for breathability, fit the bill just right.
Grow your paper menagerie with this crafty how-to. This video tutorial presents a complete, step-by-step overview of how to make a paper money frog from a bank note using origami, the traditional Japanese folk art of paper folding. For more information, and to get started making your own dollar-bill frogs, watch this arts-and-crafts guide.
If you are looking to win an easy bar bet, check out this video. In it, you will learn how to link two paperclips together using magic and without ever touching the clips!
Mike Kraft of Lowe's shows you how easy it is to install a ceiling fan. Not only will it keep your home cooler in the summer and warmer in the winter, but also it can dramatically lower your utility bills. Using common household tools, even an inexperienced electrician can install a ceiling fan within minutes. Working with electricity can be scary, but this video will show you step-by-step how to mount your ceiling fan safely and securely.
Did you just find an iPhone 3G or 3GS on the floor but don't want to pay for the expensive AT&T plan?? This instructional video takes you step by step on how to easily jailbreak the phone with a couple of simple of steps that will allow you to use your phone in a matter of minutes without having to pay outrageous monthly phone bills. All you need to do is have iTunes installed on your computer and then just follow the simple steps stated in the video.
What's the best way to bribe a bouncer at a club? It takes tact and strategy. Fold a bill up with the denomination showing into a tiny square. You must need a good attitude to get past the bouncer or the best table at a new restaurant.
Wanna know how to get a shot at any bar for just a dollar. Mr. Magicpants gives a wealth of barroom strategy. You gotta botch the first bet. Wager a $1 on a drink. Then lose the bet. The mark gets to drink it. Walk away and he's left paying the bill!
Easy way to test for fake currency. This is a quick way to find out if a dollar bill or paper currency is fake or counterfeit. Counterfeiting is rampant. Don't get scammed.
Want to record guitar? Learn from the professionals at PreSonus while host Bill Gibson shares his techniques for recording guitar with this instructional recording video. Discover the typical mic choice for recording an acoustic guitar and how to mic the speaker with this recording tutorial video. Record professional sounding audio quality of your music for your guitar by learning the various types of microphones to use.
Use this freeware program from Bill Myers to prevent bandwidth theft of your videos - any format and stored on any site - including Camtasia videos stored on Amazon S3.
Your store bought iPhone stand isn't fancy enough? Make an origami stand with a dollar bill. This says you need a c-note, but we tried the $1 version and it works just fine.
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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 41st installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate deviations, variance and standard deviation for a sample and a population using Excel tables and the VAR, S...
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.
Augmented reality headsets with depth sensors, like the HoloLens, offer a much more immersive experience than the average smartphone at present, and one app demonstrates that in a uniquely entertaining fashion.
