Software: Page 87

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 276th installment in their series of digital spreadsheet magic tricks, you'll learn how to download and install the MoreFunc supplementary function add-in.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 279th installment in their series of digital spreadsheet magic tricks, you'll learn how use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA, AB, ZZ with a formula.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 275th installment in their series of digital spreadsheet magic tricks, you'll learn how to reduce a column of numbers by a set percentage (in this case, 35%) quickly!

To create glossy or reflective vector image, you will need to know how to use the offset options in Adobe Illustrator and the basics for pathfinder. You will be creating a vector image that can be resized without hurting its quality. To start select you text style, which be glossy for this. You will have first a white layer, a shadow, a radiant layer, a white outline and a shadow going underneath. In this video the Oh Gizmo Logo! is being used as the template. Right click create outlines. You...

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 186.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an advanced filter to extract records from a table with 2 criteria.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 223rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count individual letters in a word. See how to count the occurrence of a given character in a text string.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.

To do fading in flash, first drag an image onto your main window. Shrink it down so it fits on the window, then right click your image and hit copy frames, then come out to frame 15 and hit paste frames. Right click in the middle of the set of frames and hit "Create motion Tween" Go to the first frame and click on what you want to fade. Go to the color tab and then select alpha. If its not on 0, drag it down to 0. Now go to frame 15 and make sure its on 100. Now if you drag from left to right...

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 207th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up and solve a business math word problem in Excel.

This tutorial teaches one on how to sort a given number of contacts in the Excel spreadsheet so that identical values in the sort appear after one another.

In this Software video tutorial you will learn how to animate symbols with a bone tool in Adobe Flash CS4. Open up a stage in Adobe Flash and put say five oval symbols vertically like links in a chain. All the symbols are in one layer. Grab the bone tool from the right side, click the mouse on the top of the 1st link and drag and leave it at the bottom or the top of the 2nd link. Now repeat this process for the top four links. Take the ‘selection tool’ from the right side to manipulate the...

This video tutorial from gogeeks shows how to install mIRC application on Mac OS X operating system.

In this how to video, you will learn how to swap faces using Photoshop. First, find two images that you want to swap. Select the lasso tool and trace around the face in the first image. Copy and paste it into the second image. From here, line up the eyes to the face. Next, you will have to match the face to the head by going to the hue and saturation window. Check the clipping mask before changing the settings. Next, adjust the settings until the face matches the skin color. Next, go to...

This Dreamweaver CS4 tutorial takes you on a step by step process for installing an automated comment box system for your website. The system is a great way for communicating and interacting with your website users. It has a great feature that automatically sends you an email everytime someone comments in your website. Also it will allow you to post a reply by email.

Here the New Boston shows you some tips about using the Spry Validation Text Field. To begin you will go to the Spry Validation Text Field, on Dreamweaver CS4. Looking at the bottom of the page notice the various options that are available for Properties. You find drop-down boxes for Type, Pattern, Minimum or Maximum values, Required, Enforce pattern, Format, Validate on, Blur or Change and Preview States. You can see the types of text available for validating by left mouse clicking the Type...

In this how to video, you will learn how to use Google Earth. First, download the program. Type in a city and state in the form. In the lower left, check street view to turn it on. Click the magnifying glass to zoom in. Some cities have 3d buildings. When you get really close, you will see cameras indicating street view images. If you get even closer, you will see spheres of the actual street view images. Click on it and the photo to get into the photo. In the upper right, you see...

Tool is selected, followed by email accounts and a selection is made at the "add new email account" option , the "next" button is clicked. Pop3 is selected and the next button. The required information is filled in such as name, amail address, incoming and outgoing mail server, username; which is the same as the email address and the password is entered. The "remember password" option is selected, along with the "more settings" button. Within the more settings window, the company name and a...

In order to make a brushed metal effects in Photoshop you should first go to your gradient tool and select a dark grey or a black and click okay. Shift and drag your mouse to create the gradient. Next, go to filter, Noise, and then add noise and change the percent to 40% and click okay. Now, go to blur and ocean blur and change the angle to 0 and distance to 100 pixels. Now, for the sides to look like brushed metal, crop those sides out. Now you have a metal effect. To make a screw, click on...

This video shows you how to keep your itunes library, music information, and song ratings intact after reinstalling your computer's operating system. Before you begin the reinstallation process, you must make sure your music is in the same location and will be in this location after the reinstallation process. After reinstalling, open itunes while holding down the shift key. In the window that pops up, click on the "choose library" button. Locate your itunes library file. This should be an...

This how to video shows you how to create a nebula star scene in Photoshop. First, create a new image in Photoshop. Fill the background with black. Next, create a new layer and call it stars. Go to filter and select noise. Choose Gaussian and click monochromatic. Click okay to add the noise. Once that is done, go to adjustments and levels. Change the settings so that you have less clutter. Next, make a selection in the middle. Copy and paste it as a new layer. Go to edit and select...

James from DreamWeaverTutorial.co.uk shows you how to use collapsible panels with the spry module in Dreamweaver CS4. The spry collapsible panel works similarly to an accordion widget, except it only has one section which features a tab panel and a content panel. When you click on the tab panel the content panel either appears or disappears (toggles on and off). You can add background colors, text colors, images, rollover effects and more, and James shows you exactly how to do all that in this...

Tut Teacher shows that if you're going to edit alot of pictures, learning to change your eye color in Photoshop is helpful.Go to Photoshop and open "human eye", zoom in and it gives more room to work with. First, go to your lasso tool, hold down and click. You can click and drag or click along the outside edge. Set to 6 pixels, more or less depending on the image. Make sure you don't click on scanner..it'll make the image go crazy. Keep clicking along the edge there'll be a symbol on the...

In this video tutorial, viewers learn how to make a digital sunburn using Adobe Photoshop. Begin by importing the image into the program. Then use the masking tool and select the areas of the skin that you want to sunburn. Now select a reddish color and use the brush tool to paint the select areas. Then click on the masking tool to create a selection use the marquee tool to invert the selection. Now right-click on the selection and select Inverse Selects. Then go to Image, click on Regulations...

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create sequential numbers in formulas using the ROWS function.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 215th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a named formula with OFFSET & COUNTIF functions that defines a print area, and then insert the formula name into the print area name.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 213th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a non-array formula to extract data dynamically using two different methods.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a mean value as a scatter diagram data series to a box plot or box & whisker that is set up as a bar chart.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 206th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate commissions with the VLOOKUP function when the lookup value is an account type instead of a number.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 210th installment in their series of digital spreadsheet magic tricks, you'll learn what to do if your formula does not calculate and is showing the equal sign and the rest of the formula without calculating.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 200th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel 2007 Table Nomenclature in formulas. See 9 examples of how to create formulas with table nomenclature in this free Excel video tutorial.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.

New to Microsoft 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 MS Excel tutorial from ExcelIsFun, the 195th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, MIN and VLOOKUP functions to create a grade book based on given total score that drops the lowest score and calculates grades automatically.