If you want to manage what sort of data is entered into your Excel spreadsheet, data validation will help you to accomplish just that. In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to use data validation to full effect in your Microsoft Office projects.
In order to bring Xara3D animations into flash you have to first go to the Xara3d screen and select export animation from the 'File' drop-down list. Now save the file so that it replaces a flashexport.swf file. That is all you need to do to export the animation to flash but this creates some problems. When you view the same animation you'll see that certain parts of the animation get lost. To fix this, just open a flash page and give it one frame. In that frame, type loadMovieNum("!flashexpor...
The Epson video describes how to print two-sided on one piece of paper. When document is ready, go to "File" and then "Print". Click the "Properties" button and select Page Layout tab and turn on the two-sided printing option. Click "OK" in print window. Wait for Epson printer to complete the first page. Take paper, flip over and put it back upside down in the paper feeder. There are instructions that will pop out on screen for this. Click resume and the second page will be printed on the bac...
This video goes step by step in teaching you how to download songs from iTunes to your iPod or iPhone. The video is for a true beginner, even explaining where to plug the USB into the computer. The tutorial is easy to understand and shows how to select your audio files and import them onto your iPod. The video also shows you how to navigate the iTunes store and point and click your way to filling your iPod. This tutorial is a must for anyone new to iTunes.
We all know how frustrating it can be to replace ink cartridges in a printer. With the Epson Artisan printer, the task is simple and easy. The hardest part about replacing the cartridge is selecting the correct one. Even this job is made easy by the numbers on the cartridge casings. Simply pull off the tab before replacing, pop in the new one until it clicks, and you're ready to start printing whatever your heart desires. Exceed your vision!
Phil from droidboards.com shows you how to set a specific MP3 that you have as a ringtone on your Motorola Droid. As long as you have this new phone and MP3's in your play list. The MP3 that you select from your phone can be used as a ringer for a specific contact and can still be used as a traditional MP3. This video will teach you step-by-step how to do it showing you on the phone while talking you through it so you can set a ringtone for any individual you want.
This video shows you how to modify and organize windows desktop icons in Windows 7. The first instruction is to right click in an open desktop space and select personalize. From there you hit change desktop icons. on this screen you can add or delete any of your available program icons on this screen. After completing this task you hit accept or apply to finish the process. This video contains vocal and text instructions to help you accomplish the task at hand.
This video tutorial shows you how to block any website on a Windows xp operating system by simply using notepad. First the URL to the site that needs to be blocked should be located by visiting the website form your browser and copying the URL from the address bar. Next close the browser and locate the "hosts" file and open it with notepad as indicated. Make the necessary changes to the "hosts" file and save it. Now the selected website is blocked on your computer.
Obtain finely powdered iron oxide (rust), aluminum, and a thin strip of magnesium. Mix them together in a 8:3 ratio (iron oxide: aluminum) in a ratio by weight. [Note that the since aluminum is so light, it will appear that it is about a 50-50 mix by volume].
This video shows you how to easily turn JavaScript on in Firefox. The first thing you have to do is open Firefox, click the Tools tab in the upper menu and then choose Options. After this, you have to select the Content tab. Then, simply check the "Enable JavaScript" box. Remember to click the OK button in the window. Next, you only have to restart Firefox by closing and re-opening it. You can now enjoy the benefits of JavaScript! Good Luck!
This video shows you how to disable the automated spell checker in Mozilla Firefox. The spell checker is supposed to be a great feature in Firefox, but lot of people find it annoying. The spell checker helps you correct your writing mistakes by underlining the misspelled word with red. You can easily disable it by opening the Tools tab in Firefox and selecting Options. Then, go to the Advanced tab in the popped-up window and uncheck "Check my spelling as I type". That's it! Good Luck!
Are you bored with the similar font styles? Open Adobe Illustrator, click the text tool. Select Arial font, bold & italic and a size of 48. Type some text and give its fill color-white and stroke color-black. Duplicate the layer text by going into layers. Then change the duplicated path's color to black. Then create a new background with some different color and keep it below all layers. You can change the opacity of the text for a shadow effect. This will help in bringing innovative presenta...
In this Adobe Photoshop tutorial the instructor shows how to turn on headlights of cars realistically. To do this open the image of a car in your Photoshop software. Now select the dodge tool and choose a brush size that you want to apply. Now click on the head lights of the car a few times using the dodge tool to make it appear as if the lights are turned on. Now after doing this it appears as if the original lights were turned on and never looks like it was edited. This video explains how t...
Did you know that you could make an ISO or CSO image of your PSP UMD and then run it off your memory stick. This solves space issues and the games even run faster! What you need to do is first go to the root of your memory stick and make a folder called 'ISO". Put the ISO that you've made from your UMD into this folder and then startup your PSP. In the PSP menu go to 'GAME' and then launch the custom firmware enabler. Inside go into the settings menu and into configuration and change the UMD ...
This video is about burning a DVD using Nero. On menu bar choose create/edit. Select audit, edit and capture video in dialog box. Nero vision 5 appears. Go to DVD dialog box. Choose where you will import video from. Drag video into open screen. For best quality keep video size to 1 GB. You can add titles, edit or create chapters. Click next. Choose a category which are choices of how the video will appear. You can customize text and audio in this screen. Click next and view the final product....
Learn how to combine images with a mask in Adobe Photoshop by opening the same raw file twice and applying separate exposures. This technique is used to perhaps mask out the sky or the windows. Using the negative exposure making the initially over exposed sky black and the dark parts white which is what the mask feature operates on. Then the designer selects cuts out the sky in the mask layer and makes it invisible so that the second layer or underlying picture shows through.
Formatting the hard drive on Windows Vista is easy. First click Start, then Control Panel, Administrative Tools, Computer Management. When that opens up, click Storage Disk Management. This will open a window showing all the computer's partitions. It isn't possible to format C: because that is where the operating system is installed. We will format disk 2. Right click on that, and select New Simple Volume. This will open the wizard. Follow the prompts through the wizard to Finish. The compute...
Now in PDF document interactivity can be added. By using Hyperlink or bookmark one can start interactivity in PDF document. In Microsoft word there will be a acrobat ribbon. In preference setting there is option for creating link. There is also ANoption for bookmark. By this we can create our PDF. When we select bookmark automatically a related topic will come up. All the interactive options are editable. After following the steps in the video you can easily create bookmarks and hyperlinks wh...
MySQL is a database for serving data on the web. This video teaches viewers how to connect to a database and add data in PHP & MySQL. PHPMyAdmin is an interface that allows you to interact with MySQL more easily. Use the form in the program to create a database; choose the name for your database and select 'create'. Next you can create tables within your database, also using the forms provided. Within the tables you can set your variables; PHPMyAdmin has fields that allow you to choose the ty...
This video shows you how to easily copy data to and from your Motorola Droid. The first step is to connect your Motorola Droid to PC, using the data cable. Now, simply drag down the bar in the upper side of the screen and select USB Connected. Then, click on Mount in the popped up window. This will allow your PC to see the SD Card in your Motorola Droid and browse through it. Now, open My Computer, in your PC and open the Removable Disk that appeared. Easily click and drag or copy-paste the f...
Gary Rosenzweig of MacMost is describing how we can use sound input and output controls on one's Mac computer. He mentions of the availability of multiple input and output devices like built-in mic; line-in etc and speakers , USB headset and provides a detailed information of using each of it; by selecting the one the user requires. He shows how the user can use popular communicating tool the Skype with the Mac laptop. One must go through this video to understand the selection of the output o...
This video is about understanding and deleting cookies in Internet Explorer. Cookies store bits and pieces of personal information concerning your web browsing habits. In essence, you can be spied on by others through cookies. Cookies should be deleted often - daily, weekly or twice weekly. Go to the Internet toolbar and select "Tools", "Internet Option". In this screen, you will see "Temporary Files". Choose delete cookies. Delete all cookies. Press "ok". All the cookies will be deleted. Rem...
This video shows how to use a special tool to redact or remove sensitive information from Adobe Acrobat 9. This includes hidden metadata, file attachments, comments, hidden text and layer elements within a PDF file. You can also set it up when you're emailing. The Examine Document function highlights information that you may want to remove. You can then select the different types of data and choose which things you want to remove.
Sims 2 fan? Let's be a vampire. You must have Sims 2 night life. First create a downtown in your town. One can meet vampires only after 19.00. They have red eyes and red clothes. Once you meet, create good relations with the vampire by complimenting, telling jokes, etc. As you become friends, have a pillow fight in the Sims University. Create good relations and ask whether he/she likes you. If yes, then ask vampire to move to your house. To become a vampire select bite neck. It will help you ...
In this ClearTechInfo tutorial the author shows how to backup and restore the bookmarks in Firefox 3 browser. He points to the organize bookmarks option under the Bookmarks link in the menu tab. Now he shows how to take the back up of the bookmarks by using the backup option and selecting a location on the hard disk to save the backup. Now the back up is easily taken which can be carried anywhere because of its small size. Now to restore the same bookmarks if they are deleted, you have to go ...
In this tutorial video Phil from DroidBoards will show you how to organize your Verizon Wireless Droid cell phone (smart phone) with folders on the home screen. This is good for keeping similar apps or frequently used apps in a quick and easy to access place. This video shows step by step how to create a folder on the home screen, select, and rename the folder. The video then shows you two different ways you can drag an icon into your newly created and renamed folder.
NUME2004 sees the transition from relaxed to natural hair as a practical and emotional journey. The video presents few tips and suggestions to all the ladies seeking for such transition to eliminate the appearance of baldness or thinning hair. Learn from the tips which talks about the journey starting from scratch, suggesting you to fire your stylist without doing a big chop, to treat all your hair like its natural. You should experiment with various products available and select the right on...
Consider two pairs of parallel lines, one pair horizontally and another is inclined from vertical position. If one of the four angles is given, then the other three angles can be easily identified. First select the angle which is down to the known angle, it will be same as first one. Then according to the law, that a straight lines consists of 180 degrees. For example if the known angle is 114 degrees, the unknown angle will be 180-114= 56 degrees.
* This video explains how to write an awesome poem easily. * You can write the poem in three easy steps.
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
Gary Rosenzweig of MacMost teaches us how to best utilize Mac's Safari web browser, and how to, when it's not necessarily immediately intuitive, search through your Safari internet browsing history. Selecting first the History option in your browser, and then Show All, you'll find that, oftentimes, there will be quite a large volume of information presented. Months and months of browsing history is unwieldy and too intricate. The solution, of course, is to use the search bar there will be ava...
In this Adobe Acrobat series of video the instructor shows how to add headers and footers to your PDF documents. Headers and footers help give your integrated document a unified look and feel. You can use the combine feature in the Acrobat to combine information obtained from various sources and integrate it in a single PDF. In the Acrobat software go to the document menu option and from the drop down box select the Header and Footer sub-menu, from which you can add a new or delete or modify ...
This video will show you exactly how to download and install Firefox extensions or add-ons. First open Firefox and click on tools, then add-ons. You can either search or browse for add-ons. After selecting an add-on that you would like to add, click the Restart Firefox button and it will be installed. Just watch the video for step-by-step instructions. Follow along it's easy. This tutorial uses AdBlock Plus as an example.
Phil from droidboards.com demonstrates how to send a video file by email using a Motorola Droid. Before capturing the video make sure to change the settings on the Droid to optimize the quality of the video for distribution by email or MMS as shown in the video. This is essential to keep the video file to a smaller size as possible. Next after shooting the video select the video file using a file manager and send it via email as indicated. This allows you to instantly share videos shot on you...
Photoshop is the perfect program to use when you want to make adjustments to photos you have taken. You can really make a sky pop in any of your pictures by using Photoshop to manipulate the color by following this tutorial.
This instructional video by ToyotaUSA guides you on how to use the rear cargo area of a 2010 Toyota 4Runner. The 2010 Toyota 4Runner is extremely spacious and the 5 passenger model has a sliding rear cargo deck which can be pulled out as demonstrated by moving the lever and pulling it to one of the two positions (halfway out or fully extended). There is also a concealed storage area between the second row seat and the cargo deck. It also has rear tide outs to secure cargo. The rear hatch has ...
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
In this video the author shows how to burn a movie file to a DVD using free software. He explains the requirements are the movie to be burned, the DVD burning drive and a software called DVD Flick which is used to burn the movie to the DVD. He shows how to download the DVD Flick software from the internet and how to install it. He opens the installed software and shows the various settings of how to select the movie and explains about the supported video formats, how to set the title of the m...
This video shows the viewer how to create a stylish centerpiece for a wedding reception using commonly available items. This is done by first placing a square mirror on top of a larger piece of light pink tulle. Then an artificial plant was selected and a number of glass beads were secured around the piece using another piece of tulle and a ribbon; this is to stop the plant floating. The plant is then placed in a tall square vase that is filled with water. A single drop of food dye is then ad...
To create a web photo gallery on Photoshop, first go to file show all menu items if you have then automate go to Web photo gallery then to changes the styles click on the style to see them the description on thee right then set up email address after Source images on (use) choose a folder, click all sub folders if you do not have any sub folders in Your folder. Go to options select one that you choose then click OK then in Photoshop it resizes all photos quickly after open up a web browser an...
