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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
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 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
In this video Mike Callahan walks you through using Skype on the iPhone. To start, download it from the Apple App Store. Next, launch the application on your iPhone. It will immediately prompt you to enter your name and password. If you don't have one you can use this screen to create one. Once you've logged into your account you'll see your list of contacts. Touch one of your contacts to place a call to them. There is a call option at the bottom of the screen that will launch your dial pad. ...
Rita Heikenfeld from AboutEating discusses some of the flowers that are not only beautiful but also edible. It is important not to eat flowers that have been sprayed with chemicals. Some of the more common edible flowers are the zinnia, petunia, and the marigold, which has a delicious citrus flavor and is used in bath oils. Impatiens are edible (just the flowers, not the leaves) and come in a variety of colors.
Danny with Top Ten Reviews will show you how to monitor social network activity with the Net Natty program. This will be helpful for monitoring social networking accounts on websites such as Facebook and MySpace. First, open Net Nanny. Go to the dashboard and select Additional Settings under Filtering. With this section, social networking sites that have been used on the computer will be listed. You can check whichever account you want to monitor. Under the dashboard, go to Reports and select...
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
This is a "Southwest Yard and Garden" episode that details the proper selection of gardening tools for fighting seasonal weeds. Horticulturist and host Curtis Smith takes us to meet with Ron Jobe, an Albuquerque Master Gardener, to discuss the options available for such a task. Ron covers the various conditions a gardener is faced with, including the soil and the weeds themselves. Some suggested tools are: the Wing Hoe, Skimming Hoe, Raker, Pointed Hoe, and Stirrup Hoe. The use of each is off...
In this video tutorial, viewers learn how to uninstall the program on an Android phone. Begin by clicking on Settings and select Applications. Click on Manage applications. Now users will be revealed a list of all the applications that are installed on the phone. Simply scroll through the applications and select the unwanted application(s). Users will now see the information about the application, click on Uninstall. Now click OK and click OK again when the application is finished uninstallin...
In this video tutorial, viewers learn how to control which games can be played with Net Nanny. Begin by opening the program and select Manage Games under Games. Users will have 3 options on how to block or allowing the games. Users can block by the ratings, games or descriptions. For the ratings, simply drag the slider to which ESRB you want to be allowed. For the games, simply go through the list and click on the game that you want to block. For the description, by checking the content that ...
HO TouchSmart is a all-in-one PC with many essential features. You can video chat using your HP TouchSmart PC. Note that you will need a internet connection to use the video chat feature. There are lots of messengers available on the net like Windows Live messenger, Yahoo messenger, AOL and others. You will need to have a messenger to chat with an other person using the same messenger. So first go to the respective websites and download the required messenger. Install the messenger as shown i...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
Have an opinion and want the whole world to know it? You're not alone! There are many online outlets for you to type up your review, whether it be for a restaurant, play, movie, book or anything else you have recently experienced. Check out this video for tips on how and where to post your exciting review.
Quitting smoking is incredibly difficult. It's hard enough to break the habit, but the withdrawals are even worse. In this tutorial, learn how to make the transition a little more bearable.
You've boxed up and shipped all your other possessions for the big move and all you're left with is the little issue of how your getting your car there. There are companies out there that will ship your car to you, just make sure your car is prepped for the journey.
Ken Appleby demonstrates how to mask a domain with GoDaddy. Masking a domain enables the domain owner to customize what appears in the viewer's address bar. First, log in to your GoDaddy account. Then, click on the domain manager function located on the left hand side of the page. Next, choose the domain that you would like to work with in the domain name list. Click the forwarding option. In the next window, click on the masking tab. Tick the enable masking function. Choose a masking title. ...
In this video tutorial, viewers learn how to locate and remove spam accounts from a WordPress blog. Begin by logging on your blog and select the User tab. Search through the user list and look for suspicious email accounts. Some keys that reveal spam accounts are: emails that have .ru, poker, Viagra, pharmacy and accounts with more then one dot. Use your common sense to find spam accounts. Select the account you want to delete. Select Delete and click on Apply. This video tutorial will benefi...
Learn how to operate the latest Blackberry 8330 in simple steps. Follow the steps below to overview the Blackberry 8330: 1. First switch on your Blackberry by pressing the power button on its top. 2. Use the 'Trackball' to navigate around the menu options and press it to select an option. 3. The 'Send' can be used to call a contact, the 'Menu' key opens a list of options, then the 'Escape' key is used to end an application and the 'End' key is used to end a call. 4. You can find on the left s...
In this video you will learn how to remove your friends and acquaintances from Facebook. To do that just follow these simple and quick steps and instructions: The first thing that you need to do is to open your browser and go to Facebook. After you login to your account click the Friend List tab and select All Friends. To remove a friend in Facebook, click the X button located on the right of his/her name. A warning will pop-up and to complete the process just click the Yes button. Now you ar...
Trevor4Ever595 shows us how to hack Hell Tour on Kongregate tours. First start the game by clicking 'New Game'. Complete the first level. Once you're on level two complete it as usual, and at level three you can start doing stuff. Open the cheat engine, click the process list, and click on your browser. Multiply your souls by 8 and put it into first scan. Go back to the game use some of your soul and then open cheat engine and multiply it by 8 again. Go down and click the frozen box on your c...
As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...
Go to the Menu and click the Start button. Now select Control Panel. In the Control Panel, you can see the Option Programs. Now you can see Uninstall Programs in small letters below the Programs option. Click on Uninstall Programs. Here you can see the list of programs installed, when they were installed, what is the size of the program, and which version of program is installed. To uninstall a program, simply click on the program you wish to uninstall. Some options get displayed above the ta...
Trevor4Ever595 teaches you how to hack the game Space Attack using Cheat Engine. You start the game, select a level and pause it using P. Open up Cheat Engine, open the process list, select Firefox or whatever internet browser you are using. Then you will want to use the search box to search for the amount of money you have in the game. A lot of values will come up to the left of the search box. Go back to the game, earn more money and then search for that new amount. Cheat Engine will only r...
This video shows you how to change the background color and watermark in your Word 2007 document. Both settings are found on the Page Layout tab. The background color can be chosen from a wide palette. The most frequently used colors are immediately applied to the current page as a preview. You can also choose to add a fill effect, like a color gradient, by clicking the Fill Effects item in the Page Color list. The watermark feature allows you to add either a predefined notice, an image or a ...
Have you ever wanted to make Filipino dishes? Watch this video and teach yourself how to make a Filipino grilled isaw. You will need isaw (intestines of pork or chicken), dry bay leaves, full peppercorns and salt. The dish is very easy to cook and you will have a mouthwatering grilled isaw in no time. The isaw is boiled in water with the listed ingredients and when it is done, a skewer is inserted and it is grilled. Try this dish which cooks in no time for your evening party.
In this video, the author shows how one can make one's own playlists on YouTube, and also get the code which can be embedded on one's website or blog. All one has to do' according to the author, is to first load all the videos which one wants in a playlist and pause them. Then one has to click the 'Playlists' option under the video pane. In the drop-down list which opens, one can choose one of the existing playlists or create a new one, and then, simply click the 'add' button. This action has...
Ways Linn brings you this acoustic guitar lesson, teaching you how to play Green Day's song "21 Guns." As always, she provides an easy to follow lesson that any level of guitarist can appreciate. She lists the chords, and the fingerings that you will need to learn to play the song, as well as demonstrates the strum pattern to keep you on the right track. In just a few short minutes you can be rocking Green Day like a pro.
In this video tutorial, viewers learn how to weave a pouch for an MP3 player. The video lists all the materials required to make the pouch. The required materials include: cardboard, a ruler, scissors, yarn needle or bodkin, scraps of yarn or 10 crochet yarn and a marker or pencil. This video provides voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit those viewers who enjoy homemade accessories. This is for those who enjoy we...
This video will show you how you can easily find out what your IP address is for a computer which is running the Windows XP operating system. You will first need to go to the start bar and click on the button which says "Run". Choose to run a program called "cmd" by typing this into the bar that appears. This will then open up a black box, where you should type in "ipconfig/all". Typing this in will offer you a list of information about the internet service you are currently using and one of ...
Mixologist Miguel Aranda wants to share his very simple recipe for Rose Water Champagne Cocktail in this video. He goes through each stage of the recipe including adding real rose petals to add more flavor and color to the Champagne Cocktail. You can use sparkling wine in place of the champagne if that is your preference and all of the ingredients are listed at the end of the video. By following these easy instructions you will have a great Rose Water Champagne Cocktail any time you need to a...
Dawn from "Stampin' Up" shows how to make an adorable Christmas card. She uses cardstock and several shapes to create this cute Christmas tree. A scallop circle hole-punch makes this craft a breeze - you could easily make enough of these cards for everyone on your list. A triangular base and six or seven scallop punches cut into quarters are all that is needed for the body of the tree. A star punch and some small circle punches bring this little tree to life. Your friends and family will want...
Looking for a pumpkin pie recipe with exact directions for making it? Here's the video you have been looking for! Exact steps are given, begin with precise ingredients. Next you will get a list of utensils needed. A nice feature of this video is not only to watch the steps in the video, but the directions are also written on the screen, making it easy to write the steps and ingredients down for future reference. This is a made from scratch recipe, so fresh pumpkin is used. Holiday traditions ...
In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...
This is an educational video from The Free Math Tutor which explains how and why should we expand fractions. This video is basically for kids who have just been introduced to fractions in mathematics.
In this video, Jewellia describes how to create a 3 dimensional origami teddy bear. First, she lists the materials needed and the quantities necessary. She then begins the actual process of building the teddy bear, which is broken into steps. Step 1 is "creating the base". You will create 18 "pairs" out of origami paper which you then put small blue origami triangles on top. It looks circular. She then demonstrates how to repeat this circular pattern of triangles upward until you have a cylin...
The great people at Food Wishes show you how to prepare a delicious and simple to prepare creamed spinach recipe. They take you through each of the steps needed to cook it with detail. Don't just read a list of instructions, watch as a chef cooks the food, so you can see the steps plainly. You will see how each ingredient is added, stirred, and cooked in detail, and you can stop or go back if you need. Watching this video will teach you how to prepare what is sure to be a favorite to whoever ...
Facebook is one of the most popular social networking sites out there, so make sure you are being safe! Susan Kline shows you in her Facebook Essential Training series how to Restrict certain aspects of your profile. Login to Facebook and view your Privacy Settings. From there you can pick your About Me, Personal information, Wall Post, Photos and more and restrict showing it to people. You can pick everyone, certain friend lists, Networks, and even individualize it down to one person.
This video is a demonstration by A-BnC parties on the making DIY poker theme centerpiece. This is a rather simple do-it yourself video. The start of video lists a couple of materials needed to make the centerpiece like over sized playing cards, play paper money, power chips, card stock, shish kabob sticks, optional sun glasses and a just add sand centerpiece. The optional things required are glue and scissors to make changes to the materials and to stick them together. Following this video on...
Want to change your YouTube Channel type? YouTube user webduncetv shows you how. After signing into your YouTube account hover your mouse over user name and click on the word "Account" from the drop down list.
In this four-part video, learn how to create a CMS with PHP and MYSQL. The basics of a simple CMS are split up in the following four parts:
Permanent access to the internet might not always be possible for you and your Linux system, and this computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to offline package install and update on Ubuntu Linux.
