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...
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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
This is a presentation of different types of immune responses in human body. There are two types of immune systems i.e., non specific and specific or adaptive immune system. Again, non specific immune system is sub- divided into barriers. It is the first line of defense. The second line of defense is the inflammatory response. They are phagocytes. These are all products of white blood cells. It is also called as leukocytes. Lymphocytes are another type of white blood cells which are carriers ...
Ever wanted to know how to make a fire with your cell phone? All you need is a cell phone, a brillo pad, and material for tinder. First take the battery out of your phone and find the positive and negative contacts on the bottom of it. Next tear off a chunk of the brillo pad, roll it up until you have a twisted piece about an inch long. Bend the steel wool over and touch an end to the positive and the other end to the negative contacts on the battery. That causes the steel wool to smolder--no...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that.
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
The video asks the question "What would you do to gain respect?" This is the bad example. It says that you should turn the sound off on your cell phone before you enter the interview. The video suggests that talking on your cell phone during an interview will lower your chances of getting the job. The video also suggests that keeping your potential employer waiting while you take a phone call can also keep you from getting the job for which you are interviewing.
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
Sick of paying for pricey text messaging plans? Down because your parents cut off or limited your texting? Let Hawks12thman offer his excellent, money-saving advice on how to send your texts for FREE from your computer. Especially helpful for those who cannot afford to keep a cell phone but don't want to miss out on a minute of conversation with friends. Also handy for when you are working on the web and don't happen to have your cell phone handy!
With all of the technology literally at our fingertips, there's no excuse for things not to be easy, right? Don't get frustrated about not being able to send pictures with the simple click of a mouse. Educate yourself with this video so you can send pictures to your cell phone. That way you can have that awesome photo from last weekend available no matter where you are. This video will show you how to send pictures from your computer to your phone.
This user-friendly video shows you how to transfer media files via bluetooth to and from your Mac and cell phone. First you must pair your Mac to your phone. This video tells you exactly how to do this, even if you don't have bluetooth on. You must put both devices in discovery mode. To pair it, you have to put a set of numbers your Mac gives you for ur phone. Click continue. Now browse devices and pick your phone. Pick what you would like to transfer over to your Mac. Save it on Mac. Open th...
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
This video takes you through the details of creating a website using Nvu without paying any amount of money to anyone. This program will take you through the basic steps in creating and setting your own website. You will learn how to format a page, give the page the color and background you prefer, placement of cells, insert the needed icons and setting instructions and links to the needed cell. All you have to do is follow these easy steps and get started with your own website.
Electrolytes are solutions containing ions usually found in sports drinks that help maintain proper hydration during extreme physical activity. A balance of electrolytes is important for the normal functioning of the cells and organs of our body. The most popular electrolytes are sodium, potassium, chloride and bicarbonate. Try these tips for buying foods rich in electrolytes in this nutrition how-to video.
Storing information, such as a full address, in one column can limit what you can do with that information. For example, you can't easily filter or sort by part of the address, such as country/region or city. However, if you break up the address into its parts — street address, city, state/province, postal code, country/region — one for each column, you can remove those limits. Watch this instructional video to see how to use the Convert Text to Columns Wizard to automatically break up a sing...
Check out this Greener Business Show video tutorial on how to make a portable solar powered USB charger with an LED flashlight inside an Altoids tin can. You will see in this episode how to modify a solar path light into the Altoids tin so that you can have a nifty LED flashlight and so you can charge your iPod or cell phone in the gleaming sunlight.
Craft a mobile phone holder for your car by bending and cutting an old CD. It doesn't actually hook up to your car but maybe with a little modding...
Beating Jaron Namir can be a somewhat difficult if you do not have the right weapons. This guide will help you learn how to defeat the Deus Ex: Human Revolution boss so that you can earn 'The Snake' achievement on the Xbox 360 and trophy on the PS3.
To earn The Shuffler achievement in Ilomilo, you will have to play the Shuffle minigame and score at least 500 points. This tutorial shows you how to unlock the game, and then the right strategy to use when playing to get this achievement.
Natural remedies used through the ages abound, especially in Asian medicine. The willow-leaved justicia plant, found throughout Southeast Asia, has traditionally been used to treat arthritis, but scientists have just discovered it contains an anti-HIVcompound more potent than AZT. AZT was the first drug approved to treat HIV, and is still used in HIV combination therapy today.
New research reveals how E. coli bacteria construct elaborate and effective tunnels to pump unwanted molecules like antibiotics and other toxins out of cells. The discovery could help us better understand how antibiotic resistance occurs and give us a leg-up to beat them at their own game.
Drug-resistant bacteria have made curing some infections challenging, if not nearly impossible. By 2050, it's estimated that 10 million people will be dying annually from infections with antibiotic-resistant organisms.
Usually, the mucus lining of the female genital tract presents a barrier that helps prevent infections. But, somehow, the bacteria that causes gonorrhea gets around and through that barrier to invade the female genital tract.
Usually, we think of vaccines as preventative, a shot we get to prevent the flu or some childhood disease like measles or mumps. But there are vaccines for other purposes, such as the ones studied by researchers from the Netherlands.
If you're ever lost or hurt out in the middle of nowhere with a dead cell phone, you might be able to "flag" down help as long as you're near some railroad tracks.
Watch this science video tutorial from Nurd Rage on how to make a lithium thionyl chloride battery, which is capable of generating 2.8v with enough current to power a LED.
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. Just looking at the numbers, it is hard to compare the different sales easily, but a more visual approach may work better. Next to one of the cells, type in "=REPT(" which is the repeat function. A popup should say "=REPT(text, numbertimes)". For "text", type in *** or anything, really. For "numb...
Working on filling your PS3 trophy collection with L.A. Noire achievements? This video is your guide to earning the Bulletproof Windshield trophy from the Nicholson Electroplating DLC for L.A. Noire. Watch and learn how a detective gets the job done.
Look in the air, it's a bird, it's a plane, it's- who cares? Blow it up. Shoot the blimp out of the sky and earn the Sunday, Black Sunday achievement in Duke Nukem Forever for Xbox 360. Take a break from fighting the Cycloid to blow up that blimp.
Ego is an important feature in Duke Nukem Forever. Watch this video to learn how to collect every single Ego Boost in the game. Collecting all of the Ego Boosts in Duke Nukem Forever earns the I Am All That Is Man achievement.
Got your eye on the Back to the Bayou trophy in Infamous 2? Watch this video and learn how to get it. This video will show you exactly what you need to do to earn the Infamous 2 Back to the Bayou trophy.
Trying to score all of the achievements in Duke Nukem Forever? Here's a DNF walkthrough that will show you how to earn the I Need a Date achievement. This achievement is in the Shrunk Machine chapter of Duke Nukem Forever for Xbox 360.
Are you playing a Duke Nukem Forever single player campaign? Are you racking up trophies? You should be. Watch this Duke Nukem Forever walkthrough to learn where you can find the helmets to earn the Bucket Head trophy in DNF for PS3.
The trick to getting this achievement is killing the Crawlers (the baby necromorphs) without them exploding. It can be a bit tricky to shoot them in just the right way, and you have to do it thirty times in order to earn this achievement.
This video shows you several tips and strategies for earning large amounts of gold in the game World of Warcraft. Everything here is perfectly legal - it's all about strategy and making good decisions about crafting and in the auction house.
Even if you're just a new player, or a casual player, you can still earn this achievement. It's one of the first achievements in the Shadowfang Keep heroic on World of Warcraft. The key is in having a spare tank in your party.
To earn this achievement, you will have to complete the Bomb Them Again quest in World of Warcraft alone and in under two minutes and fifteen seconds. It can be tricky, but is still doable - and this video shows you how.
This walkthrough is from a Warlock point of view, but players of any class will no doubt find valuable information in here. The tutorial shows you how to earn the Headed South achievement when you're playing World of Warcraft and facing down Siamat.
The Vigorous VanCleef Vindicator achievement is currently one of the most difficult to earn when you're playing World of Warcraft: Cataclysm. But this video has figured out a relatively painless way to earn it! The trick is making sure there's a shaman in your party.
