Software: Page 105

In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For this...

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...

Today we learn about creating a header appearance in animation w/sound in Flash. First your import image. Create a new layer and then create our new shape. Then delete the stroke. Next select the shape and change its size to frame 20 and then press F6. Move your image as shown in the video. You will be asked to create a new layer three times. Just repeat the process of layer until you have a total of 35 layers. Now onto getting you animation to move. Mass layer is also acceptable in creating...

This video demonstrates how to make carbon fibers in Adobe Photoshop. It starts off with a picture of a car and then slowly teaches you how to add carbon fibers to them. There are instructions on the screen to help you out with this. It should be noted that a basic knowledge of Adobe Photoshop is required in order to understand the terminology in the video. If you follow the steps in this video, you'll be able to do this simple task in Photoshop.

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 to...

This video shows you how to make a brochure using Microsoft Publisher. To create a brochure first you will need to choose the brochure template in Publisher, in this case the presenter chooses the event brochure. You can then customize the template by changing the default text, which the video shows you how to do by highlighting and deleting. It also shows you how to move to page 2 and change the text there. You can also change the default pictures by choosing the picture to replace and...

The Windows uninstallers work okay, but they do not remove all the files associated with a program. Over time, this will leave excess of unneeded files on the computer which will occupy valuable hard drive space that you could be using for something else. Luckily, the program called Revo Uninstaller can uninstall the entire program without leaving anything behind. This how-to instructional video will show you how to get Revo Uninstaller and most importantly, how to use it correctly when...

In this video tutorial by photoshopuniverse, from Free Photoshop Video Tutorials, shows you how to automate the process of resizing images using Photoshop, primarily for sending over the internet. The guide takes you through the step by step process of creating a new action to record the process of resizing an image. Using this recorded action, you will learn how to go about applying that action to an entire folder, which will resize all the images contained in that folder.

You can draw almost anything in Photoshop. Check out this video for information on how to draw an envelope that you can use as an icon for other programs. This step by step tutorial takes you through the entire process of creating a realistic looking envelope on your computer. This icon can be used to identify programs on your desktop or simply as a drawing. All you need is a mouse and a copy of Photoshop and you will be on your way.

This video tutorial by tasktutorial shows you how to create stylish text in Photoshop. Launch Photoshop and select the type tool and choose myriad-pro font light. Create a text field and type in the text as indicated. Increase the font size and location as desired. Thereafter open the layer options, choose a gradient and create a new gradient by selecting the color as required. Apply a white color outer glow change the size, range and opacity. If you want to add more text create a new layer and...

This video teaches about adding any of your photos to a billboard. Now copy into the computer memory back into the original billboard image to create another layer this is the layer place in our image. We can do this correctly, respective into this filter which is called vanishing point. Clicking at the four edges make this little bit bigger in image area. Now we can paste in that image control and change the promotional image. It fits sign of the billboard area and resize after the slight...

Photoshopuniverse shows you how to quickly add rounded corners to photos using Photoshop. He talks about vector masks which he is going to use to give the photo in the video a rounded corner. He uses layers inside of Photoshop to complete this task and also use the Crop tool. He also adds a border around the image then makes it green. IF you watch this video, you will learn how to add rounded corners to photos and how to add boarders and color them.

Xara Xtreme makes it easy to learn how to extract part of photo.

This how-to video is about how to use the Ribbon and Backstage view in Microsoft Office Excel 2010.

In this flash tutorial the instructor shows how to make a black and white mask animation. To do this, first start by importing your image into the flash tool and bring it on to the scene. The image should be wider than the scene. Now select and distribute the layers. Now convert those images into movie clips. Now go to frame 80 and add all frames. Get back to the first layer and create a shape that is the your mask. Now go to frame 40, select key layer and add free transform tool. Now, mask the...

Learn to create a fashion editorial style color in Photoshop! 1. From CHANNELS button select color of the Model. It will show different colors select as per your choice. 2. Click on Levels it will show the image selected. 3. Right click and select Black&White it will open ADJUSTMENTS button adjust the color. 4. Go back to CHANNELS button they all images will look same. Copy channel Blue and Select Blue copy3 and color model's body and hair with black. 3. Click on ADJUSTMENT button and adjust...

This video is a step-by-step tutorial about Photoshop, in which the creator shows you how to create the text "Twilight" the way it is done in the movie-title. It offers a perfect image of the capabilities of this program and the way it can be used. Even if you're completely new to Photoshopping this video is likely to teach you how to use it by just showing you the basic elements, which makes it ideal for people who are capable of picking up things quickly. It's also handy if you're already a...

Cleartechinfo.org presents a how to video on downloading and installing Firefox v3.5. First you would open your Firefox browser, go to the help tab. Under the health tab, you would click Check for Updates. A screen announcing a Software Update should pop up. When that screen pops up, you can click on the button "Get the new version." After it is downloaded, double-click the set-up file and follow the instructions on the screen to complete the installation.

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...

Correct the midtones (the coloring) of your photos with this easy to follow guide on using the Photoshop program. Make the true colors shine through and brighten those washed out photos with just a few simple steps. He shows you how to make the improper colors show themselves with just a few clicks of the mouse and then how to fix them with ease. Don't waste precious money having a professional retouch your photos when you can do it from the comfort of your own home by calibrating the color on...

In this Photoshop tutorial the instructor shows how to create a dollar sign button in Photoshop. Open Photoshop and select the ellipse tool and make a around shape. Now open the layer select the layer tool. Now open the gradient editor and make a gradient as shown in the video. Now change the gradient angle to around 124 degrees. Now tweak your colors a little bit as shown in the video. Now make an other layer with low opacity as shown in the video. Now you have two inter leaving layers and cut...

In this video tutorial by photoshopuniverse you learn how to create a wood photo frame in Photoshop for your photos. Take the photo that you want to add a frame to, open it in Photoshop. Open the layers palette and double click to convert to a regular layer and increase the canvas size of the image to the required thickness of the frame. Create a new layer and fill in with the wooden pattern. Apply a mask and reveal the photo as shown. Apply the desired effects bevel and emboss to get the...

This video is about using a luminosity mask in Photoshop. The luminosity mask is used to enhance the color and contrast in photos that lack each of these. The color is enhanced or punched up. Choose the manipulation tool: channel and RGB. To choose RGB, touch control and then select RGB. Select the 100 % white or light parts of the photo, it will not select the darker or black images. Copy the light parts of the image by using control J. Choose to copy the lightest parts by selecting...

This is an excellent kids tutorial to draw a koi fish easy and simply using a Adobe Photoshop. The artist shows you how to hand draw the body, add the fins and other features of the fish. Then you create guidelines to make a perfect pattern of scales on the fish. Next he starts texturizing the fins as well as creating a realistic flip of the tail. He then takes the outline of the fish and puts it on one layer then traces it over on the next layer. On subsequent layers, the artist paints the...

This episode of TUTCAST shows you how to get rid of blemishes in your photos using Photoshop. For this demonstration the patch tool in Photoshop is used to clean the blemish. Use the elliptical marquee tool to select the area including the blemish as shown and then feather the selection using the selection modify feather command. Use the patch tool to patch the area with the blemish and use the clone stamp tool to clean up the unevenness as demonstrated.

In this Photoshop tutorial the instructor shows how to change the dark hair color to blond. To get this accomplished you need to use a couple of very special techniques. First use the selective adjustment layer and select the outline of the hair. Now use the selective color option and change cyan and magenta settings to about minus forty. Now changing the other yellow color to achieve saturation and black colors to achieve the effect with shadows. Now next change the colors of black so that the...

Computer forensics expert Steve Burgess gives a highly informative tutorial on how to recover deleted emails in Outlook and Eudora. The most critical factor affecting the recoverability of deleted web-based emails, according to Steve, is whether the PST file, which stores all the emails, has been compressed after the mail was deleted. If this hasn't been done it is possible to hack into this file and recover the deleted email. Text-based emails, like those one creates on programs like Eudora,...

To manipulate photos and turn someone in a photo into a ghost, there are several filters that can be used in Photoshop. This video takes us through the steps of how to take an ordinary picture and turn the subject into a supernatural being using the motion blur technique and the diffuse glow filters among others to alter an image. The best types of pictures to use are ones where the background is relatively dark. By following these simple steps in Photoshop, you can turn anyone in an ordinary...

If you've ever wondered how you could possibly create hairy balls in Cinema 4D, wonder no more. This video tutorial shows you how you can use the software and a picture of chicken legs to reproduce the texture of human balls and a scrotum. Follow along with smearballs as he shows you how to copy and clone the texture of chicken legs, create the balls themselves, and the scrotum. Check it out yourself!

This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.

To add drama to a photo and create some additional pop, this video tutorial shows how to create a photo cutout using Photoshop software. What you need to do is determine what subject in a photo you would like to cut out. Using a cutout and multiple layers, the final impact is an effect that makes the cutout appear as though it is extending beyond the photo's boundaries and into white space. By following these steps, you can create additional interest or emphasize a certain part of a photo using...

MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. MotionTraining will show how to make text stand out with bold and italics, adding colors to your data, and how to make a grid appear during the printing process. Creating various charts of the data in the spreadsheet is also...

A tutorial video that demonstrates how to install Skype on Puppy Lynux 4. It is a very simple and short video at roughly just over 2 minutes. The narrator does a good job illustrating how to install Skype. In just a few easy steps, the video shows how fast and easy Skype can be installed.

This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the...

In this video tutorial from Get Connected TV, hosts AJ Vickery and Mike Agerbo will show you how to safely move your iPod files to your home pc, for back up purposes, just in case something were to happen to your iTunes account or your iPod is damaged, or music directory accidentally deleted. The program they introduce in this video is called iPod-Rip, and they lead you through the steps necessary to back up your iPod files safely and easily, without damaging or deleting your files.

In this Photoshop tutorial the instructor shows how to fix colors. It looks bad to have dull colors in your images. Now open the image in the Photoshop and go to image adjustments. Go to curves and start playing around with the curves in the RGB mode. When you change the curve you can see the change in the original images. Now adjusting the colors in the curves tool play around with the colors and this will get the colors brightened up. There are no stead fast rules but you need to play around...

In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get...

In this Excel basic video the instructor show how to setup a page in Microsoft Excel. Now you before go to a page setup, first you have to make sure that all the cells are visible in a spreadsheet by extending or contracting the size of different columns. You can also select all columns and make their column width a constant. Now go to the orb and select a print preview to get a preview of how the print out is going to be. Now after checking it out you can make necessary changes in the original...

Learn how to touch up images in Photoshop and bring out the true potential of your art. Using subtle strokes of image enhancement you can redefine the effect that shadows have on your images and use them to bring out the aspects of the photos that you want to highlight. Similarly you can hide those nasty imperfections with ease as shown in this tutorial. Never again let your images befall an embarrassing fate. You too can produce professional quality work with minimal effort and time on your...

In this video the author shows how to sign PDF files and create digital appearances. To do this open any document where there is a place provided to digitally sign it. Now double click that area and you will be shown a pop up menu that helps you to sign the document. Now if you already have a digital sign prepared you can go ahead and sign the document. If not there is an option to create a new sign and this video shows the procedure of how to get it done. Using this feature now you can...