This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
Sarah East from Grocery School gives a lesson on how to buy fresh asparagus. Look for straight, firm stalks with dark green or purple tips. It is best to choose stalks the same size so they will cook uniformly, though the size does not affect the flavor.
If you want to create a Pareto Chart for categorical data in MS Excel you should first have your data input into Excel already. From your data, you should highlight the cells that you want to count the frequency for and in the frequency box you should type in =COUNTIF and highlight the data you want the frequency for and put in F4 and then press , click on cell to the left and click enter. Now this will work all the way down. If you have not sorted it, you can right click and then click sort....
Step1. Determine the type of job you want. Make sure that you have a detailed and complete profile on ‘linkedin’. You must also have a number of connections. Then decide which job you are looking for and the typical functions and titles. Also choose which type of industry you would like to work in and also choose what locations. You also need to write down specific names of organizations that you want to work for and who are they.
If you want to convert video files to DVD format using DVD flick you first want to go to www.dvdflick.net. Go here and download the program DVD flick. You will also want a program that allows your to burn DVDs. You should first open up DVD flick. So, go to open and choose the files you want and drag them onto the screen. They should then appear on DVD flick and they will be compressed. You should try to keep the files you add under 3 hours of video. This will keep the quality good. Now you sh...
This video shows how to make a real 3d text in Photoshop. First open up Photoshop. Create a new document File > new. Then select width then OK. Fill the background with black. Then go to the text tool and write whatever we want. Choose a font with fat letters. Right click on the text layer and go to "Blending options". Then edit the text in our way. We can create a Gradient Overlay, Contour, Stroke and Outer Glow. We can add any effect we want. Again right click on the text layer and click "R...
According to Gordon Ramsey there are only a few but very important steps to take when cooking a rib eye steak.The first thing to remember is that the tools and seasonings are almost as important as the main dish.You should pick out ingredients that are as fresh as possible such as rosemary,olive oil,salt,pepper,garlic and butter.You can let god quality tools like a knife and griddle do most of your work for you.And lastly you should choose a quality side dish like artichokes to make your rib ...
In this how to video, you will learn how to create a rainbow effect in your photos with Photoshop. First, open the image you want to edit in Photoshop. Next, edit the hue and saturation. Make sure to desaturate the drawing. Next, create a new layer. Select a brush and choose a blue color. Make sure in the new layer that color is selected. Color the top part of the image. Next, select a purple or pink color and color the middle part. Choose a yellow color and color the bottom of the middle par...
To start off making your bouquet, you must start by crossing the stems instead of going straight up and down. The crossing action will give you a round bouquet. Choose the size of the bouquet to match the bride and to match the dress. If it's a big dress with lots of action, you don't want to hide it with a big bouquet. Always hold your bouquet down. Use wax string to hold your bouquet together. This won't slip. Tie the not twice to ensure it stays together. Cut the stems off and then proceed...
This shows how to use live trace on Adobe Illustrator to make a vector image. First, you need to open up Adobe Illustrator. Then go to file and select New and adjust your size to letter. For orientation you can choose to have it landscape if you want. Once you have your blank work space you will want to get a saved image. Go to File and click on Place and locate your image. Adjust the size of the image if you need to. Click on the image and then go up to the tool bar to click on the live trac...
This is a handy tutorial about creating the favicon. A favicon is an icon which appears on the tab, in the address bar and in the favorite menu of browsers. To make a favicon:
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 tutorial is an on-screen demonstration on how to create a circle that looks like a glass orb using PhotoShop. First make the background black. Then using the elipse took, draw a circle, filled with light grey. Right click on the shape layer and click "Rasterize layer". Select the eliptical marquee tool and make a circle in the grey shape, a little ways in from the edge. Select the area and choose "Layer via cut", click on Layer 2 and delete. Click on Shape 1 and create a contour by choos...
In this how to video, you will learn how to work with standard materials in 3D Studio Max. The material editor is found by clicking the multicolored button to the right. You can see sample spheres where you can see examples of materials. Below, you can see surface properties such as shaders and ambient colors. You can select the type of material to be applied here. You can select the standard material to get familiar with it. First, decide the shaders. Blend is the default shader, although th...
1. First of all select 'filter' at the ‘top tool bar’. Now select the 'artistic' from the ‘drop down’. Then select 'fresco' and then click 'ok'.
In this how to video, you will learn how get VMWare Fusion on your Mac. This will allow you to install Windows and run them on the same computer. First, go to the mediafire page and download the files. Next, download and install Unarchiver to join the files together and extract the file. Mount this file on to your computer. Run the file and click install. Once that is finished, open it. You will see your Windows partition if you already have one installed. To install a new one, click new and ...
Spring Hill Nurseries shows viewers how to plant Chrysanthemums, or hardy mums, in this video. The mums should be planted in early spring. First, choose a place to plant. You should choose an area that has a lot of direct sunlight. You should also plant in an area that has good soil for growing plants. If this is impossible, mix some compost with the soil in the spot you wish to plant in. If you are planting more than one mum, make sure you have enough room to space them two feet apart.
This video explains how to use the Speech Recognition tool on the Mac, which allows you to speak most of the commands that you use on the computer. To enable speech recognition, go the Apple menu, select System Preferences and click on Speech. Then click on “On” next to Speakable Items, and click OK.
The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You can also choose to recognize the publisher as a trusted source. Click the office button and scroll down to Excel options. Click on the trust center option and go to trust center settings. Then, view the trusted locations...
This was a video on IMovie08 a movie editing program. Inside the IMovie08 program to get started you have to import a video. Once you have imported and opened the video you can begin to edit it. You can easily switch between your event library and the Project library. To play your video just click the spacebar. To create a project just click on new project and name it, once you have it named, pick your aspect ratio. Then click on create. Next you have to choose a video, by right clicking on t...
We learn how to throw a cast net. There are many different ways to do this since everyone develops their own personal technique. The way we're shown is this way: First choose your bait. Then get all the rope up in your hand. Lay your hand on the top. Come down about halfway. Lay it back on top again, Hold net up. Grab the lead line. Although many people dislike doing it this way we see him put it in his mouth. Then he grabs the led line and throws it, releasing the lead line at the right moment.
This video tutorial from Britec09 presents how to backup and restore Window 7 registry.First, press Start button and enter regedit command into Start Search area.Registry editor window will open, click File-Export.This option works on all Windows operating systems.Type file name - registrybackup and click Save. You can save it wherever you want, but in this video it was saved to Desktop.Next step is to reboot to Windows DVD. Insert you Windows DVD and reboot computer.Press any key to boot fro...
In this Computers & Programming video tutorial you will learn how to upgrade from Windows XP to Windows 7 with CNET. You need to do these 3 things. 1st - run the Windows 7 upgrade advisor to know if your computer can handle any version of Windows 7. 2nd – check the Windows 7 compatibility center to know if you need to upgrade your drivers or apps. 3rd – make a copy of your hard drive. Down load and run the ‘windows easy transfer’ wizard. This will back up all your files and settings to an ext...
In this video, Brian from Trutricks shows us how to create a new Twitter account. First, go to Twitter and click on the "sign up now" button. You will now be brought to a new page where you can choose your user name and enter your email, password and full name into the information boxes. Once finished, click "create account". After this, you will be able to follow people you want as well as have other people follow you. Once you are ready to tweet you can type whatever is on your mind in 140 ...
First of all go to the website source forge and download the file 'DVD Flick'. Once you get it you now need to install this in your computer. Accept the ‘user agreement’ and then choose the folder where you wish to put in this file. You may also choose to store this in your programs directory. Then click on the ‘next’ and then ‘install’ to continue. This shall take some time. Now open this application. Take any YouTube videos. First of all click on the 'add title' from the left side top menu ...
This video describes how to create intricate nail painting designs. The first step is to choose a background color. You can either choose a lighter background color so the darker designs you paint over it will stand out, or a darker background color so the lighter-colored designs will stand out. For this specific design consisting of 3 flowers and a few dots, the former will be used. Next, take globbing paper and glob it with some white polish. Use a nail dotter to apply the polish from the p...
This video demonstrates how to shell, devein, and butterfly shrimp. For this, you will need a paring knife or a pair of kitchen shears and large shrimp.
The perfect way to avoid boredom at work or in the classroom is with a good old-fashioned prank, and this one is for tech-minded. In the video below, you'll see how to change your coworker's (or classmate's) computer screen to be display upside-down, which will totally freak them out when they return from lunch or the restroom. The best part is watching them try to revert it back to normal!
In this video tutorial, viewers learn how to perform an amazing card trick. The magician begins by going through the deck and lets the spectator pick a card. The entire deck has a red back. Then the magician put the card at the top of deck and a cut. The magician then snaps his finger and lays out the entire deck face down. The cards are now a blue back and the only red back card is the spectator's chosen card. Then the magician snaps his finger again and the card changes into a blue back. Th...
Learn how to delete the game history on your Xbox 360 from Ryan Treit in simple steps. You can get rid of the nasty unused game history from your Xbox 360 by following the steps below: 1. First go to your profile, press the guide button and then slide to the left one tab to Games and choose 'Achievements'. 2. Now a list of all the games you used will be displayed in order. 3. Select the game you wish to delete and press the X button and select 'Yes' to delete the game history. 4. Delete all t...
Get to design your own watermark for your documents. Here's a video showing these easy steps to watermarking your documents. 1. Go to the "Page Layout" tab in Word 2007 and look for the "Page Background" section of the toolbar and select the "Watermark" button. 2. Click on the "Custom Watermark". 3. Click on either picture or text watermark, whichever you prefer. 4. If you select the Picture Watermark, you need to insert a picture by clicking the select picture. You can also customize the sca...
Andy Field performs the top shot card trick in this video. To begin this card trick, first a spectator is needed to name a card, not pick a card (this instruction is repeated several times throughout the video to emphasize importance). The card chosen is the five of clubs. He asks if the viewer would like it done fast or very fast, and opts to do it "very fast but in slow motion." Next the deck is shuffled, and held in one hand. He snaps his fingers with the available hand, and the correct ca...
This video presents how to connect to your iPod Touch or iPhone using SSH (Secure Shell) without using Wi-Fi connection.
This video shows the viewer how to do a ‘Jumping Gemini’ card trick. In this trick three different cards of your choice appear to continuously find their way back to the top of the pack. This seems impossible as the cards are both placed on the table as well as being placed at the back of the pack. The trick uses a series of breaks and lifts to work. Essentially it involves continuously appearing to place the chose card at the back of the pack or on the table whilst actually keeping the card ...
Bob Doyle shows how to make a layered latte at home. You need an espresso machine, any brand, and milk. Skim milk foams better but whole milk tastes better, so choose which you prefer. First, steam about 3 ounces of milk until your glass is about full. Set it aside. Start the espresso. Plan for about 6 ounces of espresso. Use a container with a lip to control how you pour because the key to a layered espresso is how fast you pour your espresso into your milk. Pour slowly, alternating with a f...
In this Magic & Parlor Tricks video you will see the ‘impossible’ card trick. This card trick is performed by Andy field. First he removes all the 4 aces from the pack and puts them face up on the table. Then he chooses a card from the rest of the pack shows it to the camera without seeing it himself. It is the king of hearts. He then puts the card back into the deck somewhere in the middle. Now he takes the 4 aces in his hand all facing up, gives a little jig and out of the 4 one ace turns f...
First of all open any image and create a new ‘layer’ and add it to your image. Click on the transparency and then click ‘ok’. Now from the right menu bar choose the ‘elliptical’ icon to make a round balloon. Now select the 'free select tool' and select ‘mode’ to 'add to current selection' and then draw a triangle with the base inside the previous balloon and the pointed end outside the balloon. Now select the 'bucket fill' tool and make sure your ‘background’ color is selected as white and th...
First of all open adobe Firework CS3/CS4. Open the 'file', then 'new' and set a banner with 'width' as 900, 'height' as 100 and ‘resolution’ set as 72. It shall open a banner for you on the screen. Now from the side bar underneath the vector, select the 'ellipse tool' and then drag the ellipse to fill in the whole banner as shown in the video. Now from the right side bar you have to expand the 'pages and layers'. Now select 'optimize and align' and select 'animated website 1. 2a’. Now minimiz...
In this video tutorial, viewers learn how to perform the double undercut using a deck of cards. This shuffle controls the bottom card. The trick begins with the magician asking the spectator to choose a card. Return the card on top of the deck. Then it will be shuffle and end up at the bottom. To do this trick, create a break between the card and the deck. Now cut the deck in half. The right hand packet is placed under the left hand packet. The card is now transferred to the right hand. The l...
The video tutorial is about creating an 8 or 16 bit Nintendo Character necklace. The first step is to select or search an 8 or 16 bit game character, the person in this video tutorial recommends choosing a sprite (which is a 2D character. Doing online search will help a lot in finding a Sprite character. The second step is to gather the supplies such as Perler Beads and Peg Boards. The peg board will be used in assembling the Nintendo Character necklace. Other supplies includes ring, chain an...
