In excel a left click is made on box A1 and the X title is typed in as year. In A2 the year 2001 is typed and in A3 the year 2002. Both A2 and 3 boxes are highlighted and the bottom right hand corner is used to drag the work into a copied sequence down to A12. In B1 "population in billions" is typed. From the web site the data is copied and typed in as it appeared and the numbers are rounded off. A click is made on the "insert" tab and line is selected from the menu which appears. The upper l...
This video in the Software category will show you how to remove pimples and wrinkles in Photoshop. Yanik from Yanik’s photo school presents this video. Select the photo you want to work on. First you duplicate the layer by ctrl+J or select from the dropdown menu. You start off with removing those pimples that you want to remove completely. Select the spot healing or the regular healing brush. Yanik prefers the regular healing brush. Also choose a small brush size. To select a source point, ho...
This video takes us through a process of speeding up our internet connection using OpenDNS.com. Open the webpage and go to solutions and click on the icon open the DNS page and it lists computer or router, she selects computer and list of operating system is listed, she selects vista. She goes to start and selects control panel, click on view network status and connection, in that select view status and then click on properties and on the networking page, go to internet protocol version 4 and...
Learn how to make an animated GIF from a video clip using Adobe Photoshop CS4. You'll need to use an external editing program (like Sony Vegas) to create a small clip from your larger video beforehand. From Photoshop, go to "File" and select "Import" and then "Video Frames to Layers" from the pop-up menu and select your video clip. Choose "From Beginning to End" when prompted about range to import. The duration of the video clip will now be displayed in frames. By default, each frame is set t...
This video is from HelpVids and describes how to change the axis titles on charts in Microsoft Word 2007. To access the chart tools, select the chart and the tools will appear above the ribbon. There are many different design options that you can preview on the screen to make your final selection. To change the chart title, click on the Chart Title button which is located on the Layout ribbon. You can then select where you would like the title to appear. Once you select the location you can t...
Tasktutorial teaches you how to create a sound on/off button using Flash. Name the first layer Actionscript. Go to frame 1, then window - actions. Add stop(); Go to frame 2, then window - actions. Add stopallsounds(); Create a new layer and select the text tool. Write off on. Change the color to black. Select the text and hit CTRL + B to break apart the letters. Select off, hit F8 and select convert to button. Name it off. Do the same for on, but name it on. Double click to open the off butto...
This video will walk you through the process of creating your very own icon to use for your email by using Adobe Photoshop. Photoshop is a great tool to use for a variety of purposes and in this instance can make the perfect icon in just minutes.
This video will help you learn how to create an Explosive rainbow color swath in Photoshop. First open a new file, keep the width 845, height 475, RGB color mode and white background.
It is a tutorial that how to make an ice text effect on Photoshop. First create a new layer select paint bucket tool switch black color and paint the layer now create an other layer, choose type tool then switch the white color and create a text "ice text" after go to layer pallet merge the layers after that again create another layer select paint bucket tool and select black color now select ice text layer then go to image menu rotate canvas click clock wise then go to filter choose crystall...
Earlier this month, AT&T quietly introduced a new "Mobility Administrative Fee" which levies a $0.61 monthly charge to all postpaid contracts. While it's a seemingly small amount on an individual basis adding up to $7.32 per year, with its huge customer base, AT&T stands to make around half a billion from the tight-lipped move. AT&T has stated that the fee will "help cover certain expenses, such as interconnection and cell site rents and maintenance" that's consistent with other phone carrier...
Wait, a query within a query? This function is possible within the framework of MySQL. Learn how to correctly implement a subquery or sub select in your next database project and avoid a couple perils that will make your program unstable.
Want to know how to make clean hair selections when working in Adobe Photoshop CS5? It's easy. And this clip will show you precisely how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
This video tutorial is in the Computers & Programming category where you will learn how to use caret browsing. Caret browsing is a method of selecting text on any web page. You can activate caret browsing by pressing the f7 button on your computer. It is available in Internet Explorer and Firefox browsers. Normally, for selecting text on a web page, you highlight the text by clicking and dragging the cursor and then you can copy and paste it in to a text editor. While doing this, if there are...
In this video tutorial, viewers learn how to save and swap icons on a Mac OS X computer. Begin by selecting the application that you want to get the icon from, and copy it. Then open preview, go to the File menu and click on "Create new clipboard". Users are also able to apply the icons on other applications or drives. After you have copied the desired icon, select the application with the icon that you want to replace, press the Command and I buttons, select the icon and paste the copied ico...
This video tutorial is in the Software category which will show you how to map multi-sub objects in 3D Studio Max. What this means is you can apply two textures to a single 3D object. First you select the 3D object, say a box and go to editor > standard > multi sub-object > OK. Now change the number of materials from 10 to 2 and follow through the next steps to select the two textures. Then go to modify panel > edit mash. Select polygons, and apply the texture to the front of the box, move ar...
Want to know how to do proportional modeling when working in Maya 2011? This clip will you how to do just that using the program's Soft Select tool. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the Maya 2011 workflow, you're sure to be well served by this video tutorial. For specifics, watch this free video guide.
In this video you will learn how to setup a Bluetooth mobile phone in OS X. To do this go at system preferences select Bluetooth click on Discoverable, Open Bluetooth Setup Assistance and Show Bluetooth Status in the menu. Then click Sharing and mark all the options. Now go at devices, select set up new device, mark mobile phone, click continue, wait until the device will find your mobile device, click continue and you will get a pass key. Enter that passkey. A window will pop-up where you ca...
To program your DirecTV remote for your XBox you will need to find your programming codes. Press menu on your remote and scroll down to parental fav's and setups, then system setup, select remote control, and program remote. You can use either AV1 or AV2 both should work. Then you will choose DVD, and then select the brand for your 360 and your program codes will come up. Put your TV in AVI mode and press your menu and select button at the same time. The lights at the top of the remote should...
This instructional video Nehal Kazim from Site shows you how to make a complete Facebook fan page. Before creating a fan page evaluate the reasons of making a fan page. A fan page lets you connect with your future clients and fans and keeps them updated and gives them a platform to talk about your organization. To create a fan page go to the bottom of any page and click 'Advertising', select pages and click create a page. Select a suitable category and a suitable name make sure to select it c...
Photoshopuniverse will show you how to change a person's hair color in PhotoShop. You can achieve this by using hue and saturation adjustment layers and set to colorize. Set the saturation to about 50%. Go back to the background layer and select the color range select parts of the hair color, select the parts of the hair you want to change and with the eye dropper click it. Once the selection is made invert the selection the color will change. You can now change the hue to make it what you want.
This video demonstrates the split tone effect in Photoshop. A split tone effect makes a picture look more rustic by changing the tones. First, add an adjustment layer to the picture by opening the channel mixer window. Select Monochrome and adjust the RGB values to create a black and white image to your own personal preference. Next, add another layer by opening the color balance window. Here you can change the colors of the light areas by selecting Highlights and changing the color sliders, ...
Tutorial on how to create realistic reflections on Photoshop with the objects. Take a base ball image then open layer pallet and duplicate the base ball layer its shortcut is Ctrl j. Go to image menu adjust the canvas size change height to 200 and anchor to the top then click OK then go to edit select transform change to flip vertical, select move tool then move the base ball vertically down change opacity to four percent. Finally go to filter select blur then motion blur with an angle 90 deg...
The video is basically about how to modify the focal point of the image. When the image has some stuff on the background and when you want the viewers to focus more on one particular area and making the rest of the image darker, you need to modify the light values of the image, which will be taught in this video. This can be done by just selecting the area, which you need to highlight on the image by giving some border and then add curves. In the curves the area is made darker than the rest b...
Open the picture you wish to place a rainbow within. A good scene has clouds that are receding into the distance and the light angle coming in from the front of the scene. A rainbow effect appears when by the sun is shining from behind you into the mist-filled air where it is refracted by raindrops.
This is a video tutorial in the Software category where you are going to learn how to revert to the Fixedsys font using mIRC. Click on the channel icon and select font. Here you can select the font and the size and then click OK. If you have Windows XP or older version of Windows, you can type in fixedsys in the font window, select the size, click OK and the fixedsys font will be selected. But if you have Vista or Windows 7, this will not happen. So you bring up the Windows explorer and in th...
In this tutorial, we learn how to make a cool neon text effect using Photoshop. First, type your text using a big and simple font. After this, right click on the text layer and click on "rasterize type". Now, press the control button while you click the thumbnail of the text layer. After this, grab the lasso tool and click "select inverse". Then, set it on 12 pixels in the toolbar. Now, use the magic wand too and select each of the letters by holding shift. Next, create a new layer and click ...
This video tutorial belongs to the Computers & Programming category which is going to show you how to reformat a computer. For doing this you will need your computer and the operating system CD. Turn on the computer and load the CD. Then keep tapping f8. Your computer will now load from the CD. When the set up options page comes up, select the 'set up windows' option. Thereafter select the number of partitions that you want to create in your hard drive. The hard drive is now reformatted and t...
In this video tutorial, viewers learn how to make free custom ring tones for an iPhone. Begin by clicking on the Start menu and select Control Panel. Then click on the Folder Options and deselect "Hide extensions for known file types". Now open iTunes and select the desired song. Right-click on it and select Get Info. Click on the Options tab and make the song lasts only 29 seconds. Then right-click on the song and select Create AAC version and wait for it to finish converting. Now open the c...
In this video tutorial, viewers learn how to data clear and erase an LG CU720 Shine mobile phone. This task is very fast, easy and simple to do. Begin by clicking on the Menu button and select Settings. Then scroll down the list or press the # sign to select Reset Settings. Now select Master Clear and select Handset. If there is data in the memory card, clear it as well. Click on Yes to confirm the resetting and type in your security code. This video will benefit those viewers who have a LG S...
In this Software video tutorial you will learn how to make a basic bar graph in Microsoft Excel. You will also learn how to give your chart a title and how to label the axes. First you put in all your data in to an Excel spreadsheet. Then you highlight the data you want to put in your graph, select the 'insert' tab, then' column' and choose the basic column chart. Next you select the title tab, go to option and choose new title. Now you add the title to the graph. To label the axes, go on top...
In this video tutorial, viewers learn how to fix the Wi-Fi problem on an iPod Touch or iPhone. Begin by clicking on Settings and select General. Then scroll down to click on General and select Reset Network Settings. When a confirmation window pops up, click on "Reset Network Settings". The iPod device will then reboot. Now click on Settings and select Wi-Fi. Then select a network to connect to. This video will benefit those viewers who have an iPhone or iPod Touch, and would like to learn ho...
In this video tutorial, viewers learn how to use the zoom tool in Adobe Photoshop. To select the zoom tool, click on the magnifying tool in the toolbar. Users are also able to press the "Z" key to select the zoom tool. Once selected, users are able to zoom into the image by left-clicking on the image. Users are then able to select the hand tool to move around the image. To zoom out, right-click on the image. This video will benefit those viewers who use Photoshop to edit images, and would lik...
In this video tutorial, viewers learn how to make a shiny glass ball in Adobe Photo-shop. Begin by creating a new document with the default size and a transparent background. Then paint the entire background in black. Now select the marquee tool and create a circle anywhere in the background. Now go to filter, click on Render and select Len Flare. Make the lens flare 105 mm prime with 141% brightness. Then go to Filter, click on Distort and select Spherize. Use normal mode and set the amount ...
In this video, viewers observe the auto reversal magic trick. The magician begins by telling the spectator to select the card. Once selected, the magician places the card back into the middle of the deck. The magician then reveals that he/she has no card markings. Now the magician tells the spectator that he will find the card behind his own back. The magician starts shuffling the cards behind his back. The first card that shows up is not the selected card, so the magician goes through the de...
In this video tutorial, viewers learn how to create a carbon fiber desktop wallpaper using Adobe Photo-shop. Begin by creating a 20x20 pattern with the rectangle marquee and gradient tool. Then go to Edit, select Define Pattern and name the image. Now create a document with the dimensions of your monitor screen. Then go to Edit, select Fill and select the pattern that you have created. Then go to Filter, select Render, click on lighting effects and configure the image's lighting. This video w...
In this video tutorial, viewers learn how to change the color of lips in Adobe Photoshop. Begin by importing the image into the program. Select the quick mask tool and then select the brush tool. Now color the part that you want to retouch. This will allow the mask to create a selection. No click on the masking tool to create a selection. Then select the marquee tool. Right-click the selection and click on Select Inverse. Right-click the selection again and select Feather. Make it 1 pixel and...
In this how to video, you will learn how create glowing eyes in the darkness using Photoshop. First, open your image in Photoshop. Next, duplicate the background layer. Go to hue and saturation and make the image really dark by turning down the lightness and saturation. Next, select a paintbrush for the eraser and start erasing around the eyes. Once this is done, make a selection around the pupils. Create a new layer and paint the selection red. Next, lower the flow of the paint brush and cho...
In this Software video tutorial you will learn how to create shock style text in Photoshop. Go to the text tool and select it. Then select the font and a large size. Select white color and type in your text. Now create two copies of this text and select the original text. Then click on image > rotate canvas > 90 degrees clockwise. The text will turn by 90 degrees. Now go to filter > stylize > wind. Make sure under ‘method’, ‘wind’ is selected and under ‘direction’, select ‘from ...
In this Software video tutorial you will learn how to make a winking animated GIF in Adobe Photoshop. Select a photograph of two eyes and duplicate the layer. Now copy the top eyelashes and paste them on top of the bottom eyelashes. Go to the eye drop tool and select a dark color. Then go to paint brush, choose a brush with size 1 and select darken in the ‘mode’ dropdown menu. Reduce opacity to 50%. Now darken the lower eyelashes as shown in the video. Then go to healing brush tool and se...
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
