This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
The instructor in this video uses humor to teach people math, which is not a favorite subject for many. The video goes on to teach the students in the video different ways to cut the conic sections into different shapes. The teacher then focuses on parabolas and defines the formulas. The formula is y = x^2. The rest of the video dissects the equation breaking it down into much more meaningful statements so that the average human being who is not very good at math can understand the equation. ...
In this video tutorial ChowTime will show you how to grill caramel corn on the cob and Italian corn on the cob. These recipes are easy and fun. Remember to use the corn as soon as it is picked to ensure the quality of taste. Fun facts include that corn was first cultivated about ten thousand years ago in the highlands of central Mexico and that the average ear of corn has eight hundred kernels! after the corn has soaked for a minimum on thirty minutes, place it on the grill with the temperatu...
This video shows you how to photograph lightning in the daytime. Set the ISO to 100.The aperture set at f32 and set for half of a second. Meter should be showing averaged. Photograph in the manual mode so that the setting won't change between photographs. Manually focus lens to infinity so you won't have to wait for the focus to lock on. A remote shutter to just hit the button. Be safe and keep camera safe when taking lightning photographs. Don’t get under trees. When lightning starts strikin...
Follow this video to learn how to formulate calculations in Microsoft Excel. First type in a list of numbers in the cells. In order to calculate the median click on the cell where you want the answer to be shown. Then type equals, average, open bracket and insert the cell code where the first number is, colon, and then type in the cell where the last number in the list lies, and close brackets. In practice this is an example where the numbers are in a list from cell A1 to cell A11: =AVEARAGE(...
This video shows you how to use the accessory meter on a 2010 Toyota 4 Runner. The accessory meter display is located in the center of the dash board. The accessory meter center includes a clock, average fuel consumption, range, compass, and outside temperature display. On models equipped multi terrain select, it shows which mode is selected. To cycle between fuel consumption and range, press the mode button. Pressing the set button resets the fuel consumption back to zero. To set the clock h...
In this video Dionne from the Gadget show explains how to improve your digital photos easily using widely available free software. The first thing she instructs us to do is to download and install Google's free photo editing software Picasa. Next, once Picasa is installed you can use it's one click settings to easily remove red eyes from photographs or increase the brightness of a photo. The next thing we learn to do is to adjust the white balance of a photograph. This makes the photo appear ...
In the dead of winter, here are some tips to change your image to something more stylish and sexy in a few minutes. Using the proper accessories such as a scarf, hat, and the proper coat, you can completely change your look. Combinations of different accessories are just what you need to transform your look without having to change your clothes or your hairstyle. This video is a very interesting way for the average person to switch up their looks and look fashionable in the winter.
Are you an average guy who is madly in love with a girl, but is unsure of what to say to her because she is incredibly shy? You've never had a problem asking other girls out, but you find that she is becoming quite a stumbling block for you. Well, Dan and Jennifer know just how to help you. On this episode of Ask Dan and Jennifer, they will be explaining some useful ways on how you can even sweep a shy girl off her feet without making her feel scared or uncomfortable. Check it out.
How to draw a face in MS Paint. The video is obviously made by a professional, it shows a sped up replay of a man using MS Paint to draw a very well done face. He starts with the basic outlines, then moves into coloration and shading. Notice all of the shading is done in unison and correlates with a particular direction that remains the same with all shading properties. Also take note of the fact, that the colors and lines are blending together, that the detail isn't as sharp as a high resolu...
In this video the author shows how to play Wii ISO's without actually burning them do disks using the USB flash drive. A normal DVD disk's average capacity is 4.7 GB, but a normal Wii Play game takes about only .09 GB space. In a DVD we will be wasting a lot of space when you burn the games to it. Instead of DVD disks if you use a flash drive you can store huge number of games on a single drive and also use the USB drive as an other storage device. In this lengthy video the author shows how t...
In this tutorial video the author shows how to find the length of the median of a trapezoid. He starts to show that we first need to add the sum of the parallel sides of the trapezoid which are on the either side of the median. Now this obtained value is to be divided by two to get the length of the median. He explains that the length of the median of a trapezoid is nothing but the average of the lengths of the parallel sides of the trapezoid. If you want to learn how to find the length of th...
This is an educational video usually for college students or maybe even some high school students. This video explains to us how to calculate our cumulative grade point average. The main character in this video is Colleen who is a Registration Assistant. This video is mainly concerned with the students at the specific university that Colleen attends, however, all students who are graded can use this to help calculate their GPA. Although Colleen goes into a rather lengthy explanation of GPA, t...
Attention guys! Get out your pens & pencils to take notes... David Wygant, self-proclaimed king of getting girls, takes us on one of his many girl-getting adventures. In this video, learn how to pick up a celebrity if the chance ever presents itself. In this field study? Michelle Rodriguez, star of James Cameron's Avatar and the hit TV show, Lost. Watch as an average guy makes an attempt to hit on a girl way out of his league.
-Experts say celery is a negative calorie food, making it one of the best snacks you can eat. This means that chewing the celery burns more calories than the celery actually has in it.
Every day, the average American throws away about four pounds of trash. But a lot of your daily trash could actually be very useful in the garden, as composting. In this episode of Growing Wisdom, Dave Epstein shows you how to use a three-bin composting system.
A frozen pipe doesn’t have to mean major trouble. You can keep your water flowing all winter long. You Will Need
Hacking into computer systems to steal passwords could be a bit complicated for the average everyday joe, but for all of your tech illiterate folks out there, there's any easy way to get that password, and all it takes is a camera.
Forget what your mom told you about being yourself—there are definite things you can do to tip the odds in your favor! Check out this Howcast video tutorial on how to make yourself irresistible to guys.
Get the look of a pricey kitchen renovation—without the cost. All it takes is a few smart upgrades. Check out this Howcast video tutorial on how to remodel your kitchen without spending a fortune.
W.H. Auden wrote, “Thousands have lived without love, not one without water.” Indeed, the average American home uses 140 to 170 gallons of water every day. Cut that in half with some water-saving tips.
Snooze bar addiction is no joke. Learn how to wean yourself off this destructive, ugly habit. You Will Need:
Google SketchUp is a powerful 3 dimensional modeling tool that boasts comprehensiveness and versatility for the average, everyday user. Unlike some of its contemporaries, this program is very user friendly. Check out this tutorial and learn how to go about modeling a Tractor from start to finish in Google SketchUp 6. It is sped up so it takes only 8 minutes to watch, though the original model took about 65 minutes to complete! Feel free to pause at any juncture during the tutorial in case you...
In today's time of rampant information crimes, including identity theft, security is more important to the average computer user than ever. This tutorial from Linux Journal Online shows how you can use GnuPG to secure and verify data on your Linux box. (This video was created using only free and open source software tools: TightVNC, pyvnc2swf, ardour2, audacity, jackd, LAME, kolourpaint, cinelerra-cv, mjpegtools, and ffmpeg.)
This video tutorial will teach you how to solve the F2L (first two layers) of a Rubik's cube with a Fridrich F2L Method.
Say you want to bring two objects together so they automatically flow from one piece to the next in Autodesk Maya 8.5, well, then you're going to have to bridge them. Check out this video tutorial on how to do just that. Combine them, then bridge them. It's that simple. So, for easy 3D modeling, watch this Maya wizardry. You'll also see how to average vertices. One day, you'll make a very fine animated character, you'll see.
Get tips on how to make your home more eco-friendly, especially if you plan to renovate it.
According to a U.S. survey, the crud in our garages is taking up most available floor space. Hence the average North American chucks up to $6500 worth of mostly useless stuff on the floor of the garage, while the $20,000 vehicle sits outside in the cold, rusting. It's time to get our cars back into garages. We spent more than $688 million dollars last year on garage organization and it barely made a dent. If you don't believe me, walk down your street and count the number of houses with cars ...
Just because Developer Options is hidden by default doesn't mean you shouldn't unlock it. While for rooters its benefit are obvious, even for the average user it opens the door for tools which enhance your experience. From animation speed to improving gaming graphics, Developer Options has something for everyone.
Opioids, or narcotic painkillers, serve as our primary method for alleviating physical distress. They also happen to be a leading cause of death due to their addictive nature. AppliedVR hopes to introduce a safer alternative: virtual reality gaming. They utilize the existing Samsung Gear VR for the hardware, but provides specialized software that offers up a distracting experience that fosters greater pain ignorance.
We've all been there; waking up in the morning with a stiff, achy back. Maybe you overdid the yard work this weekend. Perhaps you were a bit too enthusiastic on the Nautilus circuit. Could be the long hours spent hunched over your computer are catching up with you. Perhaps your back pain is indicative of something more serious. Unfortunately, unless you've really injured your spine, your doctor isn't going to be much help; the best he can do is offer you pain medications and tell you to rest ...
Your average sit and go player will probably stick to the single, 9 or 10 person tables that are commonly found at all the popular online poker rooms. However, your more adventurous players aren’t afraid to try out the multi-table sit and go’s like the 180 man SNGs when they get a chance. But there are a few things players should keep in mind before starting out with the MTT SNG tournaments.
Introduction So today and yesterday I was playing with TNT (as we all do at one point or another) and I was curious about a few things. From this curiosity, I went on to discover some of the science behind some things you may or may not have known.
Introduction So, today and yesterday I was playing with TNT (as we all do at one point or another) and was curious about a few things. From this curiosity, I went onto discover some of the science behind some things you may or may not have known.
Learn how to do single leg cable curls. Presented by Real Jock Gay Fitness Health & Life. Benefits
Learn how to do hold a squat while doing a power single cable wide pull down. Presented by Real Jock Gay Fitness Health & Life.
Vocal breaks are a serious problem for singers just starting out. For those of you new to singing, Kevin Richards offers some advice on how to avoid vocal breaks.
Isometric exercises are strength training exercises that don't let the joint angle and muscle length contract during the movement. This means that the exercise is done in a static position with the muscular intensity coming from the weights and your own body.
In this video, Dina Prioste shows us how to do a yoga grasshopper and peacock pose. First, get into a grasshopper pose with your elbows close together. Place your chin on the floor and pick your knees up into the air. Remember to focus on breathing while you are doing this, because it will be challenging. This is a really deep shoulder opener, so it will be difficult if you have no tried it before. Make sure you stretch out well before you do this, or you run the risk of pulling a muscle. You...
Stretch marks are the bane of a woman's existence. Whether you went through a recent weight gain from eating a few too many ho hos or are recovering from post-pregnancy weight, stretch marks tend to pop up because your skin is stretching beyond that which its fibers can stay stable.