ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.
How do you know if you should lose weight is a question people often ask. For the most part the need for weight loss should be determined by how you feel in your own body. There are some calculations that doctors use to determine if you need to lose weight. One of those calculations is BMI or Body Mass Index. BMI is based upon a fairly difficult equation. BMI is figured by multiplying your weight by 703 then dividing by your height squared. A body mass index over 25 is considered overweight. ...
Learn how to develop your intuition by dowsing with a pendulum. In this video hosted by Andrea Hess of Soul Realignment, Hess is teaching dowsing with a pendulum to determine "yes" or "no" (or "undetermined") answers to specific questions. As told here, the pendulum is controlled by your subconscious mind, but the information is determined by one's higher self. One is not to ask questions that start with "Should I..." or "Am I supposed to..." as there is no "Should" or divine plan we need to ...
Turn your possessions into cash and become an online selling machine. You will need: Something to sell, a computer with internet access, an eBay account, a digital camera, shipping supplies, something to sell,a computer with internet access, an eBay account, a digital camera, & shipping supplies.
There are three main line types in fishing, but how do you know what you should be using? In this video tutorial, a fisherman will give you some tips so you can decide for yourself. Take action: determine bait type, determine type of fish to catch, and look at line weight and strength. Ron, the instructor in this how-to video from Live Strong, is a professional bass fisher and has qualified for the Bass Master Classic and has won two B.A.S.S. Western Divisionals. He has also recorded multiple...
This experiment uses a ballistic pendulum to determine the launch velocity of a metal ball. This is compared to a measurement of the launch velocity found using projectile motion. You may wish to emphasize why energy is not conserved in the initial impact of the ball into the ballistic pendulum, but momentum is, and conversely why energy is conserved as the pendulum rises but momentum is not conserved.
In this video tutorial, Chris Pels will show how to determine what capabilities a user’s browser has when viewing pages in an ASP.NET web site. First, learn how to access an instance of the HttpBrowserCapabilities object from the ASP.NET Request object associated with the web page request. Next, see the different information available in the HttpBrowserCapabilities object such as the type of browser and whether the user’s browser supports JavaScript and Cookies. Then see an example of how to ...
So you've been invited to a poker game, but you don't know the difference between a straight and a flush. Well, this how to video is here to make sure you don't lose all your money, or your shirt. This Texas Hod'em lesson teaches you how to determine the ranking for various hands. It runs through all possible winning hands in Texas Hold'em and explains their rank. At the end of the video you will be tested on your newly acquired knowledge of Texas Hold'em hands. Are you holding the nuts or ar...
Use red cabbage to determine the pH of different common household items. Great experiment for kids. Begin by cutting up a red cabbage. Put in a blender and blend it. Put in a coffee maker and turn it on. After all has come through, turn off the coffee maker and let it cool. Now test it and determine the pH of different household items.
This video shows us how to build a garden bench out of cinder blocks. Before you get started, you need to refer to the How To sheet #320 for all your materials and make sure you have everything you need.
Installing shelves in a closet turns dead space into useful storage. You Will Need:
Azimuth is simply the angle of an object in the sky along the horizon. Yes, it's spherical trigonometry but it's not difficult! Check out this video and in just a few minutes you will be able to solve azimuth problems on your own.
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 work with and solve rate problems in algebra using the distance formula.
Need some help figuring out a simple rate problem (involving the rate of a train for example? See how it's done with this free video math lesson. Need help finding the 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 peda...
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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.
One formula that you will run into in Calculus is calculating the percentage growth rate using a logarithmic derivative, elasticity of demand, relation among elasticity of demand and also revenue. In this video you will learn the different formulas that are used, methods of solving each formula, and also the full solutions.
Babysitting is the prime teenage job for young women to start learning responsibility and earning a wage, but it isn't all fun and games… you are dealing with an infant, which is far from fun, but it's money in your pocket. Earning a little extra money babysitting infants can be more fun — and a lot easier — than schlepping food at your local diner.
Want to calculate percentage growth rates (also known as the relative rates of change)? Learn how with this free video calculus lesson, which covers calculating the percentage growth rate using a logarithmic derivative, elasticity of demand and the relation between elasticity of demand and revenue. 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 t...
In this editon of Tip Tuesday from Pursebuzz we are shown how to determine your skin tone. This tip is a pretty simple way to determine if you're a warm or a cold tone, and if you are pink-based or yellow-based. That's the first question you're asked if you go to a counter and you're trying to figure out your foundation colors or your blush colors or shadows, or what will work for you. The first test is the fabric test. You don't even have to buy this fabric. You could just go to a fabric sto...
In this video the teacher shows us how to use a TI-84 plus graphing calculator to graph a function, adjust the view window, and determine the values of several types of critical points on the graph such as x-intercept, y-intercept, local maximums, and local minimums. After entering the function in the Y= editor she presses the ZOOM button and selects Z-Standard this adjusts the view window to a range of -10 to 10 on both axis. To find each of the critical points requested the teacher uses the...
Just because fixed rate mortgage rates have dropped to historic lows doesn't mean that you should automatically refinance. With the economic climate you might not be able to refinance because many banks have tightened the rules for refinancing. As for who is eligible, you will need a 700-720 on your credit score to get the best rates. To refinance at all you need at least a 600. Generally it is worthwhile to refinance if you can save at least a half point off of your current rate. But you do ...
Learn how to determine the equation of a line with this tutorial: The equation of a line can be determined by two given conditions.
Want to win the prize? Knowing a little math is the key to winning this popular contest. In this video, learn how to estimate correctly.
Don't just use a belt for keeping your pants up, use it to give you some style! As important an accessory as a handbag, a belt doesn’t just hold up your pants or pull in your tummy. Change your look by creatively matching your belt with your outfit.
Waking up your Apple Watch to see "your heart has shown signs of an irregular rhythm suggestive of atrial fibrillation" might come as a shock. While your watch can send you warnings if it detects a fast or low heart rate, those messages are pretty vague, while the abnormal arrhythmia alert can downright scary. So what should you do if you receive one of these AFib notifications?
What Is a Rate? A rate is a comparison of two quantities that have different units. An example is 90 miles/3 hours, which is read as 90 miles per 3 hours.
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 48th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the RATE, EFFECT, NOMINAL and NPER Excel functions to solve the following problems:
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 29th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for rate, amount of change and rate of change.
This tutorial will help you learn to read the defense while playing Madden NFL 12. You'll need to pay special attention to the alignment if you want to figure out what your opponent is up to. Using the technique described in this guide, you'll be able to determine if it's zone or man.
This video will show you how to subnet using CIDR notation. If you're curious about how to determine networks, subnet masks, broadcast addresses and what makes a host range valid. A great video for anyone currently studying computer networking technology.
Interested to know how to start a new cable television ad campaign with Google AdWords TV Ads? This official video from Google will teach you how to use the new interface to determine just that. For all of the relevant details, and to get started creating your own televised advertising campaigns, watch this clip.
Interested to know how many TV impressions you'll receive over the next seven days? This official video from Google will teach you how to use the new interface to determine just that. For all of the relevant details, and to get started estimating the impressions of your Google AdWords TV Ads campaigns, watch this clip.
Want to see how a Google TV Ads national cable television advertising campaign is doing? This official video from Google will teach you how to use the new interface to determine just that. For all of the relevant details, and to get started gauging the effectiveness of your own Google AdWords TV Ads campaigns, watch this clip.
Determining exactly what of the thousands of parts on a modern car is broken is as difficult as doing the repairs many times. IN this video you'll learn how to diagnose and fix error codes P0171 and P0174 on a 2001 Ford Escape, which indicate vacuum problems.
If your car doesn't run very well and sometimes belches black smoke from the tailpipe, you may well have a problem with your air flow sensor. In this video you'll learn how to determine what's wrong with the sensor and then clean or replace it accordingly.
Cylinder heads are tough pieces of metal, and determining whether one is bad if it isn't snapped in half isn't as easy as it sounds. Watch this video to learn a fast and accurate way of assessing whether a cylinder head is bad.
Creating extremely impactful pictures can all be up to Depth of Field. You can either put more or less focus on your subject with various techniques. In this video you will learn how to determine distance with aperture, focal length, and distance from subject techniques.
The Salmonella eggs outbreak sweeping the nation is mammoth in scope, and if you want to keep yourself and your family safe you need to know what Salmonella is and how you can prevent it. This video will explain all of that to you, including the connection between Salmonella and dysentery and how you can prepare eggs to avoid contamination.
If you've been working on a project and need to know how to put up a door using a butt hinge, this video should help. In the tutorial, The Wood Whisperer, will let you know what tools you'll need to determine how to properly install a butt hinge mortise. Installing it incorrectly can result in an off balance door and can be tedious to try and fix. So check out the video for more information, take notes, and good luck!
In flight school, at some point or another you will be asked to determine your density altitude. In this professionally taught tutorial, lean how to calculate density altitude on a flight computer. This lesson is taught by an instructor from the Golden State Flying Club at Gillespie Field in El Cajon, California. So, if you are just beginning to fly, check out this clip and make sure you know all there is to know.
