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 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.
This video shows you how to use flacs inside of iTunes. FLACS are higher quality audio files than your average mp3.FLAC stands for Free Lossless Audio Codec. It is designed for people who want to hear their music in a great high quality. For Mac users, download fluke. If you have iTunes up already, select open applications and open with. Select fluke and import it into iTunes. Once it has finished doing its thing, your music will open and you can play it. Essentially the system is tricking it...
This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...
The average American consumes 27 pounds of bananas every year. If you're not getting your fair share, try this classic drink—you'll catch up in no time. Chill the cocktail glass by filling it with ice and water, and set it aside. Crush the ice in the blender. Peel the banana and break it into small chunks. Place the small chunks of banana into the blender. Pour in the light rum, banana liqueur, lime juice, and simple syrup. Blend the ingredients for about 15 seconds, or until smooth and cream...
Illustrator/Character designer Joe Bluhm talks about his process and philosophy as he paints a caricature of Bill Murray (as Steve Zissou from the Wes Anderson film "The Life Aquatic...") as part of an illustration for a Canadian Pop Culture Magazine called the Naked Eye (available in USA, as well). Using Adobe Photoshop, Joe renders the face in very little time to demonstrate his approach to an entirely digital painting, with a cartoony and loose feel to the art.
With this video, we learn how to deal with a girlfriend who tends to tell white lies. First, don't set an ultimatum with the girl, this will end up in a verbal fight and can ruin the relationship. You need to start to create a new relationship with your girlfriend so she feels more comfortable with you. You need to tell her that if she keeps lying to you then it can cause you guys to end your relationship. The average person tells 26 lies a day, even if they are just white lies. Try working w...
This is a video tutorial in the Education category where you are going to learn how to compare 2 distributions with the Z-Score formula. In this example Doug's class has X bar as 71 and a standard deviation of 4. Corey's class has X bar as 68 and a standard deviation of 11. If both Doug and Corey beat the class average and have the same standard score, will Doug have a lower grade than Corey? If both of them have a standard score of 1.5, then Doug will get 77 marks and Corey will get 84.5 mar...
The "Run" command in Windows XP was a super handy tool for those above-average PC users, those who know all the shortcuts to navigating the system. But Windows Vista automatically removed the "Run" option from the start menu, and replace by "Search" instead. But don't worry, it's not gone forever. You can restore the "Run…" command with a little tweak to your Vista preferences. See how.
As little girls, we always read stories about beautiful princesses with neverending long hair, some with hair so long they could turn it into a rope to aid their prince to rescue them.
When it comes to anything artistic, from interior design to makeup application, color theory plays an immense role in determining what colors go together and what colors clash. Of course, you won't find the average woman at the cosmetics counter asking the saleslady for a cool toned though slightly neutral foundation shade for her, but this is what we should all be doing if we're to find the right shade.
Orange plum tomatoes are sweeter than your average red tomato, which make them a sweet treat to put into salsa. Summer's coming to an end soon so celebrate the last waning days of warm weather and ripe, succulent food by making this pluout, or plum tomato, salsa with Me Gusta.
It doesn't matter how great a photographer if you don't have the right tools. Even Annie Liebvitz would get only average shots with a lower grade digital camera because it's very limited in terms of settings that you can control.
Walk into L.A. hotspot Kitson any day of the week and you're sure to find a teeming collection of celebrity endorsed jewelry, at least half of which are bohemian and breezy, made out of skilled wire wrapping and exotically colored gemstones. They're pretty, yes, but unless you have a celebrity's budget they're also hard to attain for the average person.
In this tutorial, we learn how to apply for unemployment in New York. You can do this either by phone or by going online. You will need personal information to file, including: social security number, drivers license number, mailing address, phone number, and W-2 form. Even if you don't have every item on the list, you can still file a claim. You will get a four digit pin number, then have an agent gather all of your information. If you do call to file, there are people who work there that sp...
In this video tutorial, viewers learn how to develop an elevator speech. An elevator speech is a short prepared speech in which you "sell" yourself to others. The average elevator ride is no longer than 20 seconds, so your speech should be no longer than that. Your speech should describe who you are. Your name, if your meeting a new contact. It should explain what you have to offer, the skills that are relevant to the job you are seeking. What benefit will you provide. This video will benefit...
Need to find the mean (that is, the regular average) of a set of numbers? It's easy! So easy, in fact, that this clip can present an overview in just under 45 seconds' time. Learn how with this free video lesson. 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 te...
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 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...
"Mean" is really the average on a set of numbers. The video uses the temperatures on a weather report as an example of a data set. Start by adding the temperature numbers of the week up. After you have the total, divide that number by 7, because you used 7 numbers in your data set. The answer that you get after dividing will have a few decimal places at the end of it. You can round the answer to the nearest whole number because all the numbers from your original data set do not have any decim...
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all the cells and click the sum button. Press and hold down the control key for another shortcut to work in accordance with the auto sum button. You can also select the average for the area. You can also select the area and...
This is a great instructional video on how to measure a quilt for binding. This video teaches you about binding. First you have to get your quilt and tape measure. You need to know the size of your quilt. You have to be careful while measuring a quilt. You can measure the breadth with your measuring tape first. Then you can measure the breath as well accurately. You can take measurements down the center of the quilt. In some cases you can measure from one side, the center and the other side. ...
Computers malfunction all the time in the form of freezing, crashing or by just not responding. This can happen due to various software reasons behind the comprehension of an average PC user. But by following some simple steps you can restore your computer some times. Your computer might not responding if there are lot of programs running simultaneously. This causes the available memory to be used up and there by causing your computer to not respond. In such case you can use you computer effe...
The way to convert 0.300 Moles of water into Grams is to start by writing what you have. Then put grams on top and moles on the bottom, then put one by the mole, the omler mass goes by grams. Now you figure out the moler mass of water which has 2 H and 1 O, its 2 times 1 which is the atomic mass for hydrogen plus 16.0 for oxygen which gives a total of 18.0 g/mol. So then you insert the 18 up by the grams, now you can cancel out the moles and multiply 0.300 times 18.0g and it gives you 5.40 g,...
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.
