Software: Page 84

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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF function.

iTunes is one of the best music programs out there. You will need this program to use an iPod or download anything from the iTunes Music Store. If you have a Windows based PC, you can still use Mac's iTunes program - and best of all it is a free download!In this tutorial, provided by Apple, learn how to download and install iTunes on a Windows PC and start using it for your media library. iTunes can download and play music, audiobooks, movies, TV shows and more, so check out this 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 467th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting every nth value using the SUMPRODUCT, MOD and ROW functions.

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 469th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a VLOOKUP query to lookup values for horsepower calculation.

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 13th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF and COUNTIF functions to add and count given certain 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 93rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting to create a Gantt cell chart.

In this video tutorial, viewers learn how to create a photo-montage using Adobe Photoshop. Begin by inserting the images into the program. Then double-click on the montage image to unlock it and select the eraser tool to remove the background. Once the background is removed, select the move tool and move the montage image to the background. To modify the dimensions, go to Edit and select Free Transformation. Hold the Shift key to maintain the proportions. This video will benefit those viewers...

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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.

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 392nd installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly generate 1, 0 and blank values with the CHOOSE, RAND, RANDBETWEEN and INT functions.

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 384th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an easy go-to/enter keyboard shortcut trip that will allow you to highlight 1000 (100x100) cells.

This is a video about creating a logo using adobe illustrator. First go to adobe illustrator and open the new document. Next if you want to make a logo in rectangular shape take the rectangular and drag it over in the new document. Next choose a color and fill it in the rectangular. Next go for new layer and click the button. Next insert the text what you want in that rectangular. Next increase the text size how much you want. Next if you want to change the color in between the text select the...

In this video, we learn how to lose weight using the liquify filter on PhotoShop. Before beginning, open up PhotoShop and the image you want to adjust. First, click on "filter" then "liquify". Next, use the forward warp tool and adjust the size of the brush to the body part you want to change. click on the body parts to make them smaller. Push in the body parts you want to be smaller, pushing in small parts one at a time. If you do too much, the picture will become blurry and it will not look...

In this video, our author, Windows7User, shows us how to burn an iso file as a bootable image onto a dvd. First, please open your internet browser going to google. Next, please enter “empower iso” into the search bar.

In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a...

In this video, we learn how to created a chilled look on a photo using PhotoShop. First open up PhotoShop and open up the picture you want to change. First, duplicate the layer on the photo. Then press "control" then "u" and make the picture blue. Now, click "filter" then "blur" and add a small amount of blur to the photo. Now you can click on "overlay" and you can see the photo change. If you want to make it look more blue, duplicate the layer again and you will see more of a chill factor on...

Clicks are made on "Image",then "Adjustments", followed by "Brightness/Contrast" ; contrast is set to 30 and brightness is set to 60 to add more light to the picture. "Adjustment", "Variations" are clicked in that order and both yellow and red are increased. "Filter", "Render", "Lightening Effects" are chosen in that order and a new window appears; within which the style is set to "Soft Omni". The brightness is decreased ;similar to the way it was increased, and contrast is increased to 60. The...

Make your video look like a Hollywood film in 3 simple steps

In this how to video, you will learn how to work with standard materials in 3D Studio Max. The material editor is found by clicking the multicolored button to the right. You can see sample spheres where you can see examples of materials. Below, you can see surface properties such as shaders and ambient colors. You can select the type of material to be applied here. You can select the standard material to get familiar with it. First, decide the shaders. Blend is the default shader,...

In this video tutorial, viewers learn how to change/convert a pivot animation into an AVI video format. Begin by loading the animation in the Pivot program. Now click on File and select the Save as type to Animated gif. Nam the file and click on Save. Then open Windows Movie Maker and add the pivot animation into the time line. click on Publish Movie and select This Computer. Name the file and select the save location. Click on More Settings and select DV-AVI (PAL) and click on Publish. This...

This photoshop tutorial demonstrated by Howard from tutcast.com, teaches you how to do amazing glow effects for your work and projects. Everything you need to know from the background you choose to use to editing out the leftovers. You can use any image that you choose to. Start out with the pen tool located on the toolbar on the most left of the screen. Create the initial layer for the glow by clicking now on the new layer icon located on the bottom right. Next, define brush by pressing the...

This video tutorial teaches you the basics of Keyframing using Final Cut Pro. A picture is used in this tutorial. You can also use video or picture for this example. The video shows the keyframe button and the different keyframing tools. The video then teaches a basic keyframing concept of how to add a motion to the clip using keyframing. You can also add rotation effect in the keyframe. When you add a keyframe and move the clip from one place to another, it adds a path along which the clip or...

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

In this video tutorial, viewers learn how to import music from i-Tunes into a Adobe Final Cut Pro project. Begin by right-clicking the song and select Show in Finder. Then drag the song from the Finder into the Final Cut Pro program. Users will not be able to drag songs directly from i-Tunes to Final Cut Pro. If the song is not compatible with Final Cut Pro, right-click and select Show in Finder. Then right0click the song and select Open with Quick time player. Now click on File and select...

First create a new 800x600 document and fill it with black color. Then create a new Layer and add a white circle with the hard edge Brushtool Select the 'Eraser tool' and use the same brush (a bit smaller) to erase the inside of that circle. Rightclick an layer 1 and go to the blending options. Add a contour. Now you should have a simple ring. Create a new layer again, and drag a dark red/brown circle inside the ring. Open up the Apple Logo (download in discription). Resize/replace it....

Description Of Excel Magic Trick 444->

This video describes how to illistrate simple reflection and shadow tutorial using Adobe. The first thing you want to do is to get the image you are going to be working with, touch up the colors. Make sure the logo is cleaned up, and ready to use. Make it more useable by making it 140x25 cm. Make a copy of your imag, flip it upside down, make sure it is pretty close to the base of the other one. This will look like the first one has a reflection right under it. Next make a 142x 27 box, put it...

This how to video shows you how to setup a meeting using Microsoft Outlook. First, open the program. From here, click on calendar. Next, go to the upper left corner and select new. On the subject line, type in the subject of the meeting. In the body, type in what the meeting is about. Go to scheduling and go to the left and select invite attendees. From here, select the address book and search for people by their last names. Select who is optional and who is required. Click okay. 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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.

Whether you want to create a custom icon for an iPhone app or simply ape the glossy style, with Adobe Photoshop, the process is a snap. And this free graphic design tutorial will walk you through the entire process. For more information, including step-by-step instructions, watch this handy designer's how-to.

Want to create neon-tube style text in Photoshop? It's easier than you might think. Watch this graphic designer's guide, which presents a full, step-by-step guide to accomplishing just that. For more information on how to create your own custom neon-style logos and headers, watch this free video software tutorial.

In this how-to video, you will learn how to straighten crooked photos in Photoshop. First, open the photo you want to straighten in Photoshop. Next, use the ruler tool under the eye dropper tool. Select it and zoom in to an area. Find a crooked line to straighten, such as a building rooftop or ground line of some sort. Click, hold, and drag. Next, zoom out. Go to image, image rotation, and arbitrary. Click okay and your image will be adjusted. Go to the crop tool and crop out the...

ShowMeAcademy.com shows how to sort data in Excel 2007. Excel has many options for sorting data according to any given column. To sort your data, right click on a cell in the column that you want to sort by. A menu comes up where you will see the “Sort” option. Hold your mouse over “Sort” and another menu comes up showing the different ways to sort. For example, if you select “Sort Smallest to Largest” it will take all the data and sort it from the row that has the lowest figure up...

In this how to video, you will learn how to clean up scanned drawings using Gimp. You will need a scanner, drawing, and Gimp installed to do this. First, open the scanned drawing in Gimp. Next, select Select by Color. Click on an area that should be white and hit ctrl + x. Next, go to filters and select soft glow under the artistic sub menu. Play around with the settings to lighten the image and darken the important lines. Click okay once you are finished. Next, go to the artistic sub...

Perfect skin is a big part of beauty. In this tutorial, learn how to enhance the natural texture and tone of your subject's skin in Photoshop CS. By enhancing your model's skin, you will give them a more luminescent appearance and make an overall better picture.So, follow along with this tutorial for information and advice on the steps you will need to take to improve skin texture and tone in Photoshop.

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 385th installment in their series of digital spreadsheet magic tricks, you'll learn how to generate random letters without RANDBETWEEN function using the formula =CHAR(65+INT(RAND()*26)).

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 386th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting for letters less than the letter M. Yes! Comparative operators like less than (<) work on letters!

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 378th installment in their series of digital spreadsheet magic tricks, you'll learn how to format field names. If field names have formatting, Excel understands that they are field names and should not be used as data.

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 379th installment in their series of digital spreadsheet magic tricks, you'll learn how to round hours worked to the 1/10th of an hour using ROUND and MROUND functions.

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 372nd installment in their series of digital spreadsheet magic tricks, you'll learn how to find the end date for a specified event with the WORKDAY function given a start date, number of workdays and non-included days.

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 373rd installment in their series of digital spreadsheet magic tricks, you'll learn how to select 3 numbers from 50 with no repeats. Also see how to select 3 names from a list of 10 with no repeats.