How To: Add "if" function in Excel
The 'if' function in Microsoft Excel is perfect for projects such as doing grades for a pass/fail course. Find out how to add it to your spreadsheet.
The 'if' function in Microsoft Excel is perfect for projects such as doing grades for a pass/fail course. Find out how to add it to your spreadsheet.
Don't be just another red shirt! Here's a detailed tutorial showing you how to engage in ground combat when exploring a planet. Make sure you've equipped the right weapons and know how to use their expose and exploit functions!
This video tutorial shows how to cheat at FarmVille (11/01/09).
Ipad is a revolutionary device from Apple with some amazing features. One of the major functions of Ipad is to serve as a E-book reader. Apple provides an application called Ibooks using which you can read ebooks on your device. You can also browse and purchase new ebooks using this applications. Launch Ibooks from your applications menu and it will take you to the collection of books that you already have on your device. Click the store button to visit the books store. From the store you can...
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
In this Computers & Programming video tutorial you will learn how to create a new account, add and edit in Blogger. First go to Blogger. On the home page click on ‘create a blog’. You will be taken to the account setting up page. Feed in all the details including our email. Then open your email and click on the confirmation link. You will then be taken to your dashboard or your home page. On this page you can click on ‘new post’ button and start writing your blog. When you do this a word proc...
Awakening the sixth chakra – known as the third eye – also awakens your sixth sense, and unlocks psychic potential. In this tutorial, learn how to harness your spirituality and get in touch with your third eye.
This tutorial video will show you what the purpose of compression is and how compression works through its parameters. Your instructor illustrates a drum beat and a plucked guitar line. Beginning with how to compress the drum beat, take (download) a drum sound pack without compression and to add compression using the software right click on the drum machine, choose create, and then choose combo on compressor. The virtual compressor has all the dials and adjusters found on any basic compressor...
Polish up your prediction card tricks. Easy and amazing prediction card trick revealed in this tutorial.
Looking to fix your iPhone home button? Do you have a broken HOME button on your iPhone? In this video, learn how to get around it with an application called "mquickdo", formerly known as iHome for jailbroken iPhones. This also works for iPhone 1G or 2G and iPod 1G or 2G. Mquickdo allows you to use a series of finger swipes to function as the home button. This includes putting your iPod to sleep, going back to the home page, the double tap music menu, exiting an application, and more.
New to Windows? No problem... here's a beginner's video tutorial that will teach you how to prevent cut, paste, copy, and delete on Windows files.
Before you attempt this firmware install, if you have already installed custom firmware on your PSP this measure might brick it. Don't double install if you have already hacked your PSP.
K'NEX is one of the most popular construction toys on the market, right next to Lincoln Logs and LEGOs, but what makes K'NEX stand out is the fact that children can build mechanically derived toys. Instead of blocks or little logs, kids use interconnecting plastic rods and connectors, which give them tons of contraptions to build and play with. Today, K NEX has even more possibilities with wheels, pulleys, panels and flexi-rods to make amusement park roller coasters, airplanes, animals, bikes...
End constipation
Here's a complete tutorial on all the controls, tools, functions and processes at your disposal when you edit photos or images in Adobe Photoshop. Starting with the basic toolbox, this tutorial series takes you on a tour of the program and demonstrates all the nifty things you can do to get started editing your own images!
The "pinch and scroll" function on your iPhone is a great feature. Pinching allows you to zoom into specific areas on your phone, and scrolling, obviously, let's you scroll. So how's it go? Best Buy has answers. The Best Buy Mobile team explains how simple it is to pinch and scroll on your Apple iPhone.
You don't have to browse your entire contacts to find the one you're looking for anymore. There's a shorter way to find the contact of your choice on the iPhone. It's a nice little shortcut you can use when you know exactly who you're calling. So how? With the Search function. Best Buy has answers. The Best Buy Mobile team explains how simple it is to find contacts via a shortcut on your Apple iPhone.
Zooming is a great function on the iPhone, if you like that sort of thing. If you don't like the ease of zoom, or maybe you're zooming when you really don't intend to, there's a way to stop it. You don't need the zoom. So how to you get rid of the zoom feature? With 3 little fingers! Best Buy has answers. The Best Buy Mobile team explains how simple it is to disable the zoom feature on your Apple iPhone.
Today we are going to learn how to sort data in a Microsoft Excel 2003 spread sheet. We will go over single column and multiple column sorting. In a single column sort you may high light the data or just click on any cell in the column. Once the data is selected look for the sort icons just under the menu bars. There is a sort ascending and sort descending icon. Click on the icon and Excel will sort the list. When sorting multiple columns the data must be in columns next to each other. If the...
This video describes how to create a custom toolbar in excel. First we have to go to tools menu in the excel. Next take the option of customize there and then choose the toolbars there. Next there will be the option “new” tab in that box. You have to select it first and then give a name the toolbar, which you are going to create. Then will be get the tool bar. Next if you want to add the buttons to the toolbar that you have created now, you have to go to commands tab. Then you will get ca...
In Part 8 on the series about Selecting a Tripod, ClickHerePhotography talks about main questions to ask when buying a tripod. First is to ask the dealer what tripod is recommended for the specific brand of camera that you will be using. Then probe further as to why the particular tripod is recommended. Details about the cost of the tripod should be inquired in relation to type of pictures that will be taken. Clarification should be sought on the functions of the tripod - how to adjust it, or...
This video describes basics about using Wubi installer for Ubuntu in Windows operating system.Wubi installer is usually used for Ubuntu family distribution installations.You can download Wubi installer from the Internet and then it will install all desired distribution automatically or you can run installer from CD or DVD.In this example Wubi is installed from Kubuntu live DVD.After inserting DVD into your computer's disk drive autoplay function offers to run Kubuntu installer. If you don't h...
In this video, Britec09 shows, "How to Fix and Troubleshoot Internet Explorer Browser Problems". First ensure that your computer is connected to the internet and your system is not infected by a computer virus, or any other type of infection, that will cause your computer to function incorrectly. First you should download Firefox to validate if the problem is with the internet explorer or the website itself. Second, you must check the version of your internet explorer. If it is old, update th...
This is a javascript trick that will work on any website. Just go to the webpage you would like to view go bananas, erase the url from the address bar, insert this code into the empty address bar, hit enter, and enjoy:
Do you love a good mystery? Were you a huge fan of "The X Files" or any other freaky movie or TV show? If you are daring and not afraid of the unexplained, Paranormal Investigator may be the job for you. Check out this video to see if you qualify and exactly how you can get into this spooky field.
It seems like its hard to get as much sleep as we need, doesn't it? Sleep is important and effects how you function throughout the entire day. Follow these tips and you will be on your way to a good night's rest.
TM Lewin shows us his technique to perfectly iron a man's shirt. You should have what he calls an ironing kit. An iron with a good steaming function, a spray bottle, and a can of starch for a more formal look, and an ironing board. To start lightly spray the shirt with the water bottle. Start with the sleeve, to avoid and crease press firmly with the base of the iron not the tip. Make sure the shirt is flat so you will only have to press on side of the shirt. The collar of the shirt will be t...
The verb "stop" in the English language can be used with a gerund and an infinitive. The word "stop" has different meanings depending on how it's used. Look at the sentence, "I stopped eating fast food." Stopped is used in the past tense and eating is a gerund, or a word that describes an activity and functions as a noun. Look at the sentence, "I stopped to eat some fast food." In that sentence, there is an infinitive. The first sentence means I no longer eat fast food. The second sentence me...
George Maestri from Lynda shows how to add interactivity in Google SketchUp Pro using a variety of tools in the program. Adding interactivity allows for added dimension and interaction with an object. The example used in the tutorial was that of a fridge, which after adding interactivity, allowed for the doors and drawers of the fridge to be opened. To utilize this technique, the object's file (without interactivity) should be opened. By selecting the fridge and then going to component attrib...
This video shows us how to fix an iPod that is displaying a folder icon and exclamation mark warning and does not function. The first thing you will need is obviously the iPod, typically the 1st Generation to 5th generation iPod. The second thing you will need is your sync cable, and also a wall charger. The first thing you have to do with the iPod is to reset the iPod by holding down the center button and at the same time hold down the menu button. After a few seconds without letting go the ...
Use the "Magic Wand" tool to select the color you wish to change. The next step is to open the replace color box. Go to Image > Adjustments > Replace Color. After the Replace Color box is open, you may have to select the color that you want to change in the image. Sometimes, it will automatically select the color you're changing, but sometimes you will have to use the Eyedropper Tool and click a hue of the color you wish to change. After the color is selected in the "Replace Color" box, you c...
Make simple snowflakes from paper. You can tape these snowflakes to a window for a nice winter decoration or paste them onto a piece of folded construction paper for a great winter card.
In this video, Gary from MacMost demonstrates how to select items on a Mac computer. He explains that there are different ways of selecting items, both with the mouse and with the keyboard. Click to select a single item, and click an empty space to clear the selection. Hold Command or Shift to add to a selection or remove items from the selected group. Drag around an area to select multiple items, and use Command and drag to add more areas. To select items in a list, click to select a single ...
Interested in chakras? Boost the seven energy centers from the base of your spine to the top of your head for optimum health and vitality. Learn how to awaken chakras with help from this video.
Feeling like you need to rid your body of a few toxins? A nice, hot cup of tea isn't just soothing; some varieties have health and diet benefits. See which brew might be right for you. Learn how to tea-tox with help from this video.
This technical video will show you all about the Rohos Mini Drive. See how you may work with an encrypted partition on a PC without admin rights using this free portable encryption solution. It securely protects your portable data on any USB device. Portable utility Rohos Disk Browser gives you opportunity to work with your sensitive data on a USB drive in the usual way on any PC (even at an internet cafe, where you don’t have admin rights).
Have something you want no one else to find? The best hiding places are in plain sight. Follow these steps to create a shockingly sly storage space.
Fear someone you love might be showing signs of Parkinson's disease? Parkinson's disease is a chronic condition caused by a lack of dopamine in the brain. Diagnosis can sometimes take years; knowing symptoms can speed up the process.
Worried about your or someone you love's relationship with alcohol? Not all alcoholics fit the stereotype of the down-and-out drunk. Learn to recognize the warning signs in yourself or a loved one.
Looking to move the right way? Owning a piece of property is an important goal for many people. Here’s how to obtain a copy of proof of ownership.