Software: Page 86

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 2nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create charts via keyboard shortcut as well as how to create dynamic charts with cell references.

In this how to video, you will learn how to create an animation with pictures using Photoshop. First, open an image in Photoshop. Double click the layer to unlock it. Next, open another picture in the program. Select and copy the first image, then paste it into the second image as a new layer. Close the original picture. Next, open another picture and copy it. Paste it into the other picture and close the latest picture. Open yet another image and copy and paste it into the previous...

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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...

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 21st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the BINOMDIST function to calculate probabilities for a binomial experiment - binomial distribution!

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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.

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 17th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the RANDBETWEEN function to randomly generate whole numbers as well as how to randomly assign numbers to employees.

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 331st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract individual characters without extracting the leading zeroes through use of the MID, VALUE and COLUMNS 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 327th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart that will include highlight the workdays one color and weekends and holidays another color.

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 214th installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with a circular reference warning in 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 324th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic list of dates for a data validation drop-down list.

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 326th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a hyperlink from one sheet to another in the same workbook.

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 320th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT & SUMIF functions together to look up multiple items and add them in one cell.

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 317th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data (specifically, a substring from string) using the MID 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 318th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract data with the MID function and use VLOOKUP to retrieve a date.

In this how to video, you will learn how to turn a photo into a line drawing in Photoshop. First, open your image in Photoshop. Create three layers of the same photo. The top two layers will be worked with. The bottom layer will remain the same. Take the top layer and change it to color dodge. Select control and I on the keyboard to invert it. Go to filter and blur to choose Gaussian blur. If you have dark lines, use a small amount of blur. You can use a lot of blur to get a unique...

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 322nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an advanced filter to extract with AND and NOT 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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as 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 311th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for determing whether a Produt ID prefix matches a second specified prefix.

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 309th installment in their series of digital spreadsheet magic tricks, you'll learn how to check to see if an item in first list is second another list, even if there is text before or after the item using the LOOKUP, SEARCH and ISNUMBER 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

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 302nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX & MRAND functions to randomly select names without repeats.

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 304th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a secondary axis to a chart so that you have axes on the left and 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 297th installment in their series of digital spreadsheet magic tricks, you'll learn how to select varying columns for summing (adding).

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 296th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a row, a column and the intersection of the two with three different colors.

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 298th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and MOD function to add up all hours in one cell worked by employees when time in and time out data are entered as time values.

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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.

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 301st installment in their series of digital spreadsheet magic tricks, you'll learn how to change Regional Settings to force Excel to accept 20th century (1900) dates.

This video describes how to use Adobe Photoshop CS4 software to create and manipulate text in animated .GIFs. GIF stands for Graphic Interchange Format, a type of image file which allows short animated sequences to be displayed. A preselected scene from a television show is opened as a GIF in Photoshop CS4. Animation window is opened by selecting window then animation. The text tool is selected and a textbox is drawn by clicking and dragging. Photoshop CS4 then applies the text to the frames...

If you have recently changed computers, or lost your music files, or even if you are just looking to share amongst multiple PCs; check out this tutorial and learn how to import songs into iTunes off of your iPod. This is a sort of backwards import, because normally you would be exporting your music ONTO your iPod.This video will show you all the steps you need to know in order to rip songs from an iPod and put them back onto a computer. This is a great idea for backing up your music, just in...

In this how-to video, you will learn how to remove tattoos using Photoshop. First, open the image in Photoshop. The patch tool is the easiest for removing these type of tattoos. If the tattoo is very ornate and complicated, it will take longer to remove. First, select the patch tool, which looks like a band-aid. Hold it down and select patch tool. Zoom in on the tattoo and draw a selection around it. Once it is selected, click the left mouse and hold it down. Drag the selection to an...

It's unfortunate, but the fact of the matter is computers crash and you can lose a lot of important files when this happens. Your music doesn't have to be part of that. If something goes wrong with your iTunes, you can take the music on your iPod and transfer it to another iTunes. This video will show you how.

Sharing iTunes with your friends is easy to do and makes living together a lot more fun. Forget about burning CDs and wasting all that time and money. You can hookup your computers and listen to each others' music all the time. This video will show you how to share iTunes with your friends.

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 247th installment in their series of digital spreadsheet magic tricks, you'll learn how to add leading zeros to a text string with an array 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 286th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked for a night shift where workers start at 9 PM and end at 5 AM.

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 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.

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 290th installment in their series of digital spreadsheet magic tricks, you'll learn how to count codes from a column of text strings that have multiple codes.

In this tutorial, user CollegeTut shows you how to customize the shapes of various fonts and text, essentially creating your own custom fonts, by converting the text of any font to outlines and then editing those outlines (bezier paths/strokes). You can modify the points on the path to create different shapes for the letters in your text, or you can manipulate the strokes of the text. You'll create some cool text effects such as text that looks like it's made of bricks, by converting the...

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 289th installment in their series of digital spreadsheet magic tricks, you'll learn how to count words separated by commas using the LEN & SUBSTITUTE functions in a formula.