Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
Are you a major networker with a cell phone full of digits? Are you horrible at remembering names and often times look at incoming calls with a look of confusion? There's a way to remember them from this day forward. Once you get a number, snap a picture of them and set it up as their caller ID. When calling, their photo will appear giving you a hint who it is! In this video courtesy of Best Buy Mobile, learn how to set a photo as caller ID.
Want your HTC Droid Incredible to alert you whenver you have a new email? It's easy. So easy, in fact, that this video smartphone guide can present a complete and thorough overview of the process in just under two and one half minutes' time. For more information on how to set up and receive email notifications on your own HTC Incredible cell phone, watch this free video tutorial.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.
In this video tutorial, viewers learn how to create fog using Adobe Photoshop. Begin by importing the image into the program and duplicate the image. Now go to Filter, select Blur and select Radial Blur. Set the amount to 100, Blur Method to Zoom and Quality to Best. Now select the rectangular marking tool and select the sky. Then open the Hue/Saturation menu and set the Saturation to -100. Use the eraser tool to remove the gray from the edges. Now use the paint tool and paint white streaks o...
lakercoolman shows us how to set up our gmail account with this quick tutorial. Basically outlook express is a program that helps us to organize our email with added features such as contacts, to do lists and calender entries. Its an offline email client that allows us to work offline and also lets us set up exchange servers aswell. Ohter email servers such as hotmail and yahoo charge for thios service but the advantage of gmail is that IMAP or POP access is free. in ofer to set up, navigate ...
Wireless networks are really the only way to go these days. With WiFi you can access the world wide web from almost anywhere, at anytime, and not have to worry about annoying wires or cords. In this tutorial, learn how to set up a wireless connection in a Windows Vista based machine.
Carole Gallesie from Creative Media Web shows viewers how to set up a new account in Microsoft Outlook Express. Express is preferred because it is a scaled-down version of the popular email client and it is easier to navigate. From your Windows desktop, go to the start menu, all programs, and click on outlook express. When the program opens, look at the top of the page for the "tools" menu, select accounts, add, and mail. The new account wizard will then appear and will walk you through setup...
This video demonstrates how to set up a password for Microsoft Outlook. Begin by opening up Microsoft Outlook. Next, go to "GO" and scroll down the "Folder List." Click on this. Then right click on "Personal Folder" and then on "Properties." Next, you will need to click "Advanced" then "Change Password." You will then type your old password. This is your default password for your email. Next type in your new password. You will need type it in twice, so make sure you type it in correctly in bo...
This video tutorial from ChaminadeENN shows how to set your Facebook account to private mode. First what you need to do is to sign in to your Facebook account.
In this how to video, you will learn how to set up Outlook 2007 in Windows 7, XP, or Vista. First, open the program. Click next and and check manual configuration. Select the top option in the next window. Now you must fill in your name, email address, and server information. Lastly, fill in your user name and password. Click more settings and select the outgoing server tab. Here you will authenticate your email address. Once this is done, click okay and next. Click finish and the program can...
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
This video shows how to make a Google Custom Search Engine. A Custom Search Engine safely searches only the sites you want, and gives you relevant results. To set it up go to the Google home page and sign in. If you don’t have a Google account, you can easily set one up by following the directions. Sign in, then enter in your browser “www.google.com.coop/cse”.
Spaces is a very cool feature that is included with all newer versions of Mac's OS X. With Spaces, you can organize your programs and keep your desktop clutter free. This program is similar to Expose, but instead of having your windows open on the desktop, Spaces minimizes them but keeps them ready for a quick reload. You can choose a number of spaces and decide which shortcuts you want to use to access them.
This is a video tutorial that is showing its audience how to set up your own VPN client on your Mac computer. The first step in setting up a VPN client is to go to your system preferences on your computer. Next select network and then select the plus button and type in that you will be making a VPN network. Next you should select the type PPTP and enter your server name. Then you can click on create and it will create a new network for you. Next you should enter your service address and your ...
Clicks are made on "Image",then "Adjustments", followed by "Brightness/Contrast" ; contrast is set to 30 and brightness is set to 60 to add more light to the picture. "Adjustment", "Variations" are clicked in that order and both yellow and red are increased. "Filter", "Render", "Lightening Effects" are chosen in that order and a new window appears; within which the style is set to "Soft Omni". The brightness is decreased ;similar to the way it was increased, and contrast is increased to 60. T...
In this video, we learn how to make tropical fried rice with shrimp and sweet plantains. You will need: 1/2 c mushrooms, 1/2 purple onion, 1/2 c carrots, 1 clove garlic (minced), 4 scallions (thinly sliced), 1 tsp ginger (minced), 2 tbsp soy sauce, 2 tsp toasted sesame oil, 3 tbsp peanut oil, 2 beaten eggs, 1 ripe and sweetened plantain, 4 c cooked long grain rice and 1/2 lb of seafood or chicken. Peel and slice your plantains, then fry them inside oil until they are dark brown and set on a p...
This video is a tutorial on how to set a table in a restaurant. The table should first be wiped thoroughly with a product called Thieves, a mixture of organic oils that contains no chemicals. Be sure it is dry before people are seated.
In this video tutorial, viewers learn how to announce alerts on a Mac OS X computer. To do this, open the Speech preferences and click on the Text of Speech tab. There, users are able to set up the computer to announce when alerts are displayed and announce when an application required your attention. Users are able to set additional options by clicking on Set Alert Options. Users are able to select a different voice, phrase and delay time. To preview the option, click on Play. This video wil...
Placemats are an important piece when it comes to setting the table. Not only can it add a certain sense of style to the table, but it can help keep your table top nice and clean! Usually placemats have only one particluar side where it is going to be used the most. In this video tutorial, you'll find out how to make reversible placemats so you have another option to choose from. Enjoy!
Now when it comes to setting the table you just need three things: fork, plate, and a napkin. But for some, things are more complicated than that. Sometimes they feature the soup spoon , salad fork, and so on and so forth. Although this video doesn't cover every single utensil, it does cover some of the basics. Find out how to make placemats for kids as well as teach them how to set the table. Enjoy!
You can make your own canopy for your boat and save hundreds of dollars from the store bought ones. You’ll need 1 inch pvc pipe, some nuts and bolts and you‘re set. You’ll set you’re canopy off of some swivel brackets that secure on the pvc pipe with 2 inch screws. This video will show you how to rig everything and you’ll be sitting in the shade in no time.
This video tutorial from pctechbytes presents how to quickly set up Homegroups in Microsoft Windows 7.This feature allows to easily share files between computers with Windows 7 operating system.Press Start button, select My Computer option. In the newly opened window select Homegroup from the list to the left. Select View Homegroup Settings link.In this window you can choose what types of documents you want to share with other Windows 7 operating system users.You can share pictures, documents...
This video gives tips on how to count calories in order to take responsibility for the food that you eat and your weight. Pick a daily calorie count for each day. Set a goal. That goal can be anywhere. You can set it at 1200 or 1800. It doesn’t matter. Weigh yourself regularly.
To solve a proportion for a variable you should employ cross multiplication. The basis of cross multiplication is the property which states that the product of the numerator of one fraction and the denominator of what it is set equal to is equal to the product of the remaining denominator and numerator. For example if you have x/15=21/45 you simply need to multiply x by 45 and 15 by 21 then set them equal to each other. The result of this is 45x=315. To solve this new problem for x, divide bo...
If you are a user of the system uTorrent then you know sometimes your downloads can take longer then they should or maybe longer then you want to wait. So, to fix this problem watch this video and find out how to get those downloads to go quicker in a few very fast and very easy steps. First, you want to right click on your download and then highlight "Bandwidth allowance" and from there click on "High". Now, in that same box go to "Set upload speed" and put it at 10 kb/s. Again, in that same...
Setting up a chroma key backdrop contains various steps/ the support system and muslin consists of various parts like the support stands, shrink lamps and the muslin. Place the two stands 12 feet apart and attach 4 clamps to vertical section of each stand. Snap the crossbars together in a proper way and insert the muslin into the respective end of the crossbar and put the crossbar on the stands with the green end of the muslin facing out. The muslin should be attached using the clamp. And ens...
These are the steps required to set your D80's pop-up flash. First, go to the "Custom Shooting Menu." Then you choose #22 on the screen: "Built in Flash." Choose the "Commander Mode" option. The modes that are available for the pop-up flash include TTL, AA (Auto Aperture) M (Manual) and Off (no flash). If you are using an external flash unit, you use either group A or B. The light frequencies and proper settings are related to how much light compensation is needed. +3. 0 is high power, 1. 1 i...
Mike Wallace is going to show you how to set up a softbox in order for a photo shoot. First, you are going to need an 1200 watt generation and with the Profoto one it comes with a pocket wizard built into it so it allows the photographer to meter and trigger with a pocket wizard TT1 on the mini camera. Also, you want to use a Manfrotto Megaboom softbox, and this is much easier then using a ladder because on the ladder you'd need to climb it whenever you wanted to reposition it. With the Megab...
Frustrated that your Mac can't play your favorite Windows video & web games? In this tutorial, learn how to solve this problem by setting up Cider, which will allow you to play these Windows games on a Mac. To complete this tutorial, you will need the following download:
This video is to show how to install a glass tile backsplash. Because installing glass is a little different then installing ceramic, knowing what to do is important. Use painter's tape to protect your surroundings wherever you are installing your glass and use only a white thin set mortar recommended from the glass manufacturer to adhere your tiles. Since the glass is see through, unlike ceramic tiles, you need to make sure there is no discoloration and smooth out the ridges on the mortar fo...
To repair damaged hair. Cut off the dead ends. When shopping, remember that you get what you pay for in hair care products. Use a shampoo and conditioner that says "Strengthening" or "Repair" to rebuild the bonds in your hair. Use a leave-in conditioner that protects your hair from the heat, and protects from sun and wind. To keep it healthy, do not blow dry your hair. It causes too much damage. When you use a heat iron, use a heat protectant. Don't wash your hair every day. If your hair is f...
This is a great instructional video on how to set up a fishing pole for bass fishing. If you want to set up a fishing pole for bass fishing, you have to use a 6 1/2-foot, medium-action spinning rod with a medium-sized reel. You can discover why it's important not to overpower a bass fishing setup with help from a commercial fisherman in this video on fishing equipment. First you need to insert the thread into the spool and grab it with your little finger. You have to pull it out now. Tie the ...
In this instructional video we can easily learn how to apply a mysterious bird lady makeup look for Halloween.
Trails demonstrates how to set up a spin cast pole when fishing for trout. In a traditional spin cast pole, look for an ultra light set up of 4. 5 to 5 feet long. Find a pole that has ultra light action with a 4 pound power pro and a 4 pound carbon leader. Don't go overboard with the pound test on the line with the leader material because it will make the trout shy and you will get less strikes. You can even go down to a two pound test on the leader. For trout, use small gold spoons and small...
Mich Baker of Bogies to Birdies demonstrates how to draw and fade your ball in golf. To draw the ball, first set yourself up in the fairway. You want to close yourself down by aiming right down the fairway when drawing the ball. Set yourself up for a fade by deliberately using a driver. Instead of coming in to draw the ball, come out and across for the fade. When fading your ball, set yourself up so that you are really open. Aim down the left side of the fairway. To fade the ball, keep the ba...
Our instructor will choose set 2, 6 and 8 to show you what the company offers. On the wrappers are pictures of the types of beads possible with each set. She will create from set 2 today, which makes oval beads. Inside of the packages, such as this package which holds set 2 are several items. First is the thin metal pins or rods that can go into the baking oven with the polymer clay molded around them. Next, two pieces for the mold, a bottom and top that fit together with grooves. There are a...
This is another video in the helpvids series of technology videos. The video describes how to set power options in Microsoft Windows XP. These options control when the monitor is turned off, when the computer goes to sleep, and when the computer will go into a hibernation state. Laptops will have more options than desktop computers since there are battery options on a laptop. Click on the Start Menu and then Control Panel, then Power Options. The first screen offers the option to turn off you...
This video is about how to construct a DJ set together. Ellaskins states in this video that he doesn't feel you should follow his tutorial step by step. Instead, use it to soak up all of the information and to help finalize your own product. In this video he describes what he calls the "Tree Chaos Theory". He states that in your room you can set up any play list and it will work. However, in a club you need to watch the crowd and make sure you know when they want their playlist to go in anoth...
Tile RIGHT demonstrates how to tile a diagonally cut tile. First set the Measure Right Pro to the appropriate setting, extending it from corner to corner along your tile. Account for your grout line and the space up against the wall. Then, lock the tool. Next, place the tiles you're going to use on top of your set tiles. Slide the Measure Right Pro along the wall and mark the tiles. Place the sections in the appropriate place. Then, cut your tiles. Lay the tiles where you've previously marked...
