Software: Page 40

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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS 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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.

Learn how to use and work with render layers in your Maya 2011 projects. 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 more information, and to get started using render layers in your own Maya 2011 projects, watch this free video guide.

Learn how to create global illumination effects in Maya 2011. 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 more information, and to get started creating GI effects in your own Maya 2011 projects, watch this free video guide.

Learn how to create depth map shadows when working within Maya 2011. 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 more information, and to get started making depth map shadows in your own Maya projects, watch this free video guide.

Learn how to preview lighting and shadows when working in Maya 2011. 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 more information, and to get started previewing lighting and shadows in your own Maya projects, watch this free video guide.

By now, everyone is familiar with the Annoying Orange, but how do they do their effects? This video will reveal the secret and show you how to put a face on an inanimate object like the Annoying Orange. See how to put any face on any object to make something that once was inanimate alive! This should work on all Adobe CS versions of After Effects. This example in this video is a beach ball.

There are two sorts of bits out there: The sort used by computers (zeros and ones) and the sort you come across when interacting with the physical world (grains of sand, clods of dirt, droplets of water). The clip below demonstrates a new physics engine that takes the first type of bits and ends up with the second. No small feat.

Attention all amateur filmmakers… if you want a cheap way to blow things up, After Effects is your man. This tutorial will show you specifically how to obliterate a flying helicopter in the sky, but this easy effect could be applied to anything you choose. It simulates the object exploding with flames and disappearing out of sight. Super easy. Great for After Effects beginners.

One of the best (for Apple) and most dangerous (for you) features of the iTunes media distribution system is that it allows you to buy things with a click of the mouse that are delivered to you instantly. The potential for making rushed buying decisions that you'll regret later is massive. Fortunately, and not many people know this, you can actually return content that you've purchased from Apple to them for a refund! This video will show you the process for returning and getting refunds for...

Want to tweak built-in table-of-content styles in Microsoft Word 2007? This guide will show you precisely how it's done. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started edding ToC styles yourself, take a look.

Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started formatting your own MS Word 2007 documents, take a look.

Want to know how to make custom styles within Word 2007? This clip will teach you everything you need to know. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, take a look.

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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and...

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.SUBTOTAL...

In this 3DS Max video tutorial, you'll learn how to create and apply lens shaders. Whether you're new to Autodesk's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!

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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL 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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.

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 568th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the five largest values for each a data set using the new AGGREGATE 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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how toe AGGREGATE function cannot handle 3-D cell references.

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...

In this tutorial, you'll learn how to create a realistic canvas texture within Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

In this tutorial, you'll learn to adjust color behavior when using the mixer brush tool in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.

In this tutorial, we learn how to enhance the color of your lips and eyes with GIMP. To change the eyes, use the ellipse tool to highlight each individual eye, then change the contrast of the eye as well as the color and highlights. Do this for both eyes, then save. To change the lips, use the lasso tool to highlight the outside and inside of the lips, then go to "select", "from path", and then change the color balance as you did on the eyes. Change it until it's the desired color you want,...

In this tutorial, we learn how to make a movie in Windows Movie Maker from PowerPoint. First, open up PowerPoint, then open your finished project and save it as a JPEG, saving all the different slides. Now, open up Windows Movie Maker and import all of your slides from where you saved them. Next, drag them into the time line and save it as a movie file. This will take a few seconds to finish saving, then click finish. When this is done, you will be able to play your slides as a movie and you...

In this tutorial, we learn how to create Apple's aqua wallpaper in Photoshop. First, create a new canvas in the dimensions you choose. Now, go to the paint pallet and choose a color. Click on ok, then start to paint your background. Select the pen tool, then draw a line from left the right on the canvas. Now, change the color of this shape to white. Now, change the fill of the layer to 10-30%. Now, double click on the layer and make the stroke white and add a drop shadow to 40 pixels and 20%...

In this video tutorial, viewers learn how to add location shortcuts to KDE open file dialog. This task is very easy, fast and simple to do. Begin by opening the program. Then click on File and select Open. In the Open File window, right-click on the left side panel and select Add Entry. In the Edit Quick Access Entry window, type in the description, URL and select an icon. Finish by clicking OK. This video will benefit those viewers who use the KDE program, and would like to learn how to add...

This video tutorial belongs to the software category which is going to show you how to use color options in Photoshop Elements 4. This version of Photoshop includes color settings that help you to control the way in which the colors in your photos are managed from capture to editing to printing. To use the options menu, click on edit > color settings. Now you get a dialog box with 4 options. Check the option that you want and click OK. Let's say you select the 'allow me to choose' option....

In this video, we learn how to transfer your iTunes library between two computers. Now, open up your computer drive and go to the backup menu and find your music. Clear all the music you have in there currently, then add your current music library to your backup file. After you copy this to a backup CD, install iTunes on the other computer you will be using. After you do this, close iTunes and then insert the backup CD into the computer. Once this loads, you will be able to transfer the music...

In this tutorial, we learn how to convert a word file into a PDF file. First, open up your file and then minimize this screen. After this, open up Google and type in "Cutepdf". When you find this, go to the website and download then install this software. This will convert your files into a PDF like you are sending it to a printer. Now, open your word file back up and go down to the print option. Press print, and choose the CutePDF writer, then click "ok". Now, you will save your PDF file, then...

In this tutorial, we learn how to set up your AIM/AOL e-mail accounts in Outlook. First, go to Outlook and open up e-mail accounts through the tools menu. Now, add a IMAP serve, then add in your user information. After this, enter in your server information, and click the settings button. Change the name of your folder if you are using multiple accounts, so you don't confuse them. In the next tab, check the outgoing server mark, then on the advanced tab, change the last number to 587. Press ok...

In this tutorial, we learn how to use the HLSW game server organizer program. First, go to the HLSW website and download their product. After this, save it to your computer and then install it. Next, register an account with them, then fill out your information. Now, when you are in the program you will be able to find servers that don't require key checks for games. Then, you will be able to add the servers to your computer. To download the server list, you will have to login, then you will be...

In this tutorial, we learn how to create flashcards with Keynote to use on an iPod touch. First, go into Keynote and choose the flashcard with the plain white background. To format this, click 'masters' on the toolbar. Now, choose "title-center" and make the first slide the question slide and the second slide the answer slide. Double click the text box to insert text into each different card. Next, to add a picture, click 'photos' and insert a picture you already had loaded on your computer....

In this tutorial, we learn how to rip a DVD to a computer using Handbrake. First, go online and download Handbrake, then install it. Once you've done this, open up the program and then go online and download/install http://www.dvd43.com/. Now, place your DVD into your computer. After this, go to Handbrake, and open up the DVD into the software. Wait for this to load, then change your presets if you prefer. When you are ready, rip this onto your computer and wait a couple of hours for it to...

In this tutorial, we learn how to do UVmapping with 3D Studio Max. Open up your image in the software, then go to "unwrap UV". Scroll down to edit and you will be able to see the basic scale. Grab the mass and scale it down, then use your element turn on to select the different pieces. The UV mapping will now turn a different color and show you where you have edited it. Continue to do this throughout the entire program. Make sure you have all other programs closed while you are doing this, and...