If you're looking for Easter Eggs in the Xbox 360 hit, Fallout 3, this next tutorial will show you one that is quite shocking. In this video you'll be going after the electric toilet that can only be found at Hubris Comics. It's a regular toilet but is wired to 35 microfusion cells. Try to drink from it and you'll lose some health thanks to a little shock. Now if you're repair skill is high enough, you can actually disarm the toilet and take the cells with you. But first, you need to find it ...
In this tutorial, we learn how to erase cell phone information on a Blackberry 7290. First, go to the home page of your screen the scroll to "options" and hit okay. Now, go to "security options" and click okay again. Now, click on "general settings" and click okay, then click on okay once more, and click on "wipe handheld". You will now see a warning, and click "continue" and type in the word to confirm you want to wipe your information. It will now take a couple of minutes to wipe the inform...
Sam Fisher is back and boy is he mad! The man, as well as the iconic goggles, are back in Splinter Cell: Conviction for the PS3 and Xbox 360. Aside from the original story mode, the game also offers a bunch of great P.E.C. challenges that are sure to keep gamers busy. Some of these challenges are easy to complete, while others are extremely difficult and require great skill to complete. So in this helpful tutorial from the people at IGN, you'll find out how to rule the challenges using some h...
The Motorola DROID is the hottest new mobile device on the market, and playing all of your favorite music on it is a cinch. The new Android platform makes it easy to navigate through your music files. Want to know how? Best Buy has answers. The Best Buy Mobile team explains how simple it is to access the music on your Motorola DROID cell phone.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
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 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.
Want to know the quickest and easiest way to access your Gmail email account from your Motorola DROID mobile device? Getting immediate access to your Gmail account from the DROID is as easy as three steps and only two buttons. Best Buy has answers. The Best Buy Mobile team explains how simple it is to easily access Gmail from the Motorola DROID cell phone.
In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, click conditional formatting and select new rule. From here, type in =column(A1)-row(A1)=$H$1. For the format, choose a contrasting look, such as a purple background and bold numbers. Click okay. If you type -1 or -2 in this...
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 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...
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...
Having a dropped call can be incredibly frustrating, especially when you look down and see that your iPhone has full reception. While there's any number of issues that can cause this, one common and often overlooked issue is your iPhone failing to switch cell towers as appropriately needed.
How can a drug used to treat cancer be effective against viruses, too? The answer lies in the drug's shared target — specifically, cellular components that control the activity of genes. A new research study showed that one such type of drug, histone methyltransferase inhibitors used in cancer clinical trials, has activity against herpes simplex virus, too.
As if the swollen, painful joints of rheumatoid arthritis weren't enough, the disease is the result of our immune system turning against cells of our own body. Ever since this realization, scientists have worked to find the trigger that sets the immune system off. Scientists believe that gut bacteria may have a role in initiating the abnormal immune response. Now, a team of researchers from Boston has figured out how that might occur.
Even though the Ebola virus was discovered as recently as 1976, over 30,000 people have been infected since, and half have died a horrible death. Since there's no way to cure the infection, the world desperately needs a way to prevent it — and the five similar viruses in its family, the ebolaviruses.
This video is about finding duplicate entries in excel sheet. The example excel sheet contains different names. There are around 1000 different names in the sample excel sheet. CountIf(range,criteria) formula has been used to do the comparison and return of results in True or False mode. Type =CountIf( now move your left arrow key, this will generate the formula like =CountIf(A2. Now press Ctrl+Shift+Down arrow, this will select all the available values in the column. Now press F4 to lock it ...
In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...
ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure u...
Today's Tech shows you how to fix a cell phone or computer that has gotten wet or jammed. With a wet cell phone, you must act quickly or it may be permanently damaged. The first thing you should do after pulling it out of the water is to take the battery and SIM card out. Dry both of them off. If you drop it in a liquid that is not water, rinse them off quickly. If you have a vacuum cleaner handy, you can use it to suck the water off. You can also place the phone on top of your cable box. Wai...
Steer clear from empty flattery and malicious social engineering with these tips on how to avoid a player.
Thanks to modern "smart phones" and the internet, media by the people, for the people is finally a reality. Here's how to use your phone to be a mobile journalist.
Creating a digital spreadsheet by hand can certainly be tedious, especially if you're copying a printed paper table word for word, number for number. Instead of typing information that's already there, however, use Microsoft Excel on Android or iOS to snap a photo of that printed chart and import it directly into your digital one.
Not all bacteria in the eyes cause infection. A group of researchers from the National Eye Institue has shown that not only is there a population of bacteria on the eyes that reside there but they perform an important function. They help activate the immune system to get rid of bad, potentially infection-causing — pathogenic — bacteria there.
About a third of the methane released into the environment comes from the production and transport of natural gas. The gas leaks as it moves along the transport chain from gas wellheads to market.
As you already know, Hong Hong has been rocked in recent weeks by protests against their Beijing overlords. Promised free and fair elections, Beijing has reneged on this promise and is now telling Hong Kongians (that's what they're called, aren't they?) that they will only be able to vote on Beijing-selected candidates. All that is interesting from a political perspective, but from a technological perspective, the more intriguing story is how the protesters are communicating. Faced with their...
Leaving your Wi-Fi radio "on" allows your smartphone to auto-connect to trusted wireless networks in lieu of using cellular data, but it also consumes battery power while it's constantly network hunting.
