Software: Page 90

This video helps you to Pin Recent Documents in Excel to the Start Menu or Office Button Menu in Excel 2007. When you click the office button on the left corner, your recent documents will appear by default. If you open a new document, it will push the other documents down and it will appear on the top. So, if you want a particular document to open whenever you open the excel, you have to click that particular document by clicking the pin that appears in the right side of it. This will turn the...

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF...

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.

Want to change the DPI resolution in an Adobe Photoshop project? If so, this concise, free video tutorial is precisely what you need. In it, you'll find a detailed, step-by-step overview of the entire process. Take a look.

In this video tutorial, viewers learn how to edit in storyboard mode in Corel Video Studio. The storyboard mode is an alternative view for the time line. To switch to storyboard mode, click on the film strip icon above the time line. Storyboard arranges your project by element. To add a new element or transition in storyboard mode, click on the Edit tab and select the element or transition that you want by dragging it to the storyboard. This video will benefit those viewers who use Corel Video...

Show your love and appreciation (or you distaste and hatred) to your fellow podcasters and review their work in iTunes. Giving reviews in the iTunes Store for podcasts and other things is a great way to help others decide the worth of such items. One way in which podcasters get 'seen' more by the iTunes logarithms is by having people leave reviews to podcasts.

Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of...

Autotune your voice using MixCraft 5MixCraft 5 is the latest version of the program. The program is an instrumental, video and voice editor. We will be using the audio track. Use your best mike and record a short voice recording. Add a songy tune to it to get the full effect. Go to effect, autotune bst. Use the preset. Input auto is soprano voice, auto correct, left select pitch reference, vibrato on 0 or .1. Format amplitude at 130. Set pitch to 0. Natural vibrato needs to be at a 90 degree...

This video tutorial from Foreclosureresearch presents how to burn video files to a playable DVD using DVD Flick application.First you need to download and install free software called DVD Flick.You can find it at DVD Flick.Once it's installed, run the program. First thing to do is to set your Project Settings. Click Project Settings from top menu. From Project Settings window you can name the project, select Target size (size of your DVD), Encoder, Thread count, DVD format, bitrate, playback...

JdudeTutorials shows how to Photoshop the rims of a photo of a car, either for previewing different options for your vehicle or just for fun. Open the photo of the car (preferably shot from the side) in Adobe Photoshop. Open the desired rim photo. On the rim, use the lasso or magnetic lasso tool to select the rim from the background. Then copy the selected area and paste it into the car photo. Select the layer with the rim, select "free transform" and resize the image to fit the car's rim size....

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8"...

This video tutorial from pirateskool presents how to enable screen share function in iChat application in Leopard operating system.Firstly, you need to ensure Screen Sharing function is enabled. From menu dock on your desktop, choose System Preferences option.In the opened window select Sharing. Make sure Screen Sharing is checked.Now you can close system preferences window.To establish screen sharing you need another user, who has Leopard operating system and iChat communication...

Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created using...

First, after recording the movie open it in IMovie. Make the "rough edits" (removing parts of videos you don't need, and making quick changes). Next, go to Share>Export Final Cut XML. Now an XML file should be on your desktop. Then open up Final Cut pro and edit the audio. If you are adding music, you can open soundtrack and find the music you want, then click and drag it into Final Cut, or send it to Final Cut. Then, make the edits you want to your video until you have it polished into a final...

First of all you have to go to 'logic pro' and select any instrument you want to play. Here you can choose a synthesizer. Now click on the record button at the bottom and it shall start playing and produce a loop. Now from the side bar you can select the 'low pass filter' and change the 'frequency'. From the new pop out, you can change the volume or the note. You can click in 'command 'L' to open the keyboard 'assignments settings' and click where you want to add it. In this case you have to...

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

Audacity is a very effective program when it comes to audio and top of that it is free. Download Audacity from its home page, get the newest version because only that one will work with what we need to do. Install it when done with the downloading. Now the first step to installing auto-tune is getting the Audacity VST enabler, you need to need place this right or it will not work, it needs to go into the plug-ins folder in the Audacity installation folder. Now you need to get auto-tune evo from...

This video is about how you can change someone's eye color. The first thing to do is to load up a picture in which you want the eye color to change. The next step is to zoom in the eye that you're interested in working on. Just simply press "D" button on the keyboard and draw a rectangular shape on the eye. Now that you've zoomed in, make a selection of the iris, the part that we want to change the color on. The first thing is, you need to set up colors found on the lower left of the window....

HandBrake is an application that lets you to burn any DVD into any other format for any of your devices like music and gaming devices. Open the HandBrake application. Initially it displays a menu that can be used to rip a DVD. First select the source. You can browse your computer for the source. Insert a video DVD that you want to rip and select it from the source menu. Now you set the destination. Browse to any of the folder on your computer where you want to put the output video. HandBrake...

This video provides tips to make great photo slideshows. Many people have found photo slideshows are a great way of celebrating memorable occasions, commemorate milestones or reminisce. First, choose your photo images carefully. Filter out irrelevant or blurry photos. Try using a photo editing program to improve your photos. Next, choose a theme for your slideshow. Then select transitions, being cautious to limit your use of transitions. Consider your use of intervals in the slideshow. Also,...