Software: Page 25

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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the 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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart 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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

In this tutorial, we learn how to make an image strip using FastStone Image Viewer. First, open up the images that you want to have inside the strip. Then, open up Fastone Image viewer and find the location of the images. From here, go to "create", then "image strip builder". This will bring up the builder window where you can add in the images you want to see on the strip. When finished, click on the "create" button. Now, the strip will come up on your computer in a new image and you will be...

In this video, we learn how to repaint your car in Photoshop CS4. First, open up Photoshop and open up the car you want to change. Now go to image, adjustments, then hue/saturation. After this, choose a yellow hue and click on different areas to change the colors that you are seeing. You can choose a different color if your vehicle is blue, brown, black, etc. After this, move the bar on the hue lever and you can change the entire color of the car. You can change it from purple to pink to neon,...

This is a video tutorial in the Software category where you are going to learn how to revert to the Fixedsys font using mIRC. Click on the channel icon and select font. Here you can select the font and the size and then click OK. If you have Windows XP or older version of Windows, you can type in fixedsys in the font window, select the size, click OK and the fixedsys font will be selected. But if you have Vista or Windows 7, this will not happen. So you bring up the Windows explorer and in the...

In this video, we learn how to use the Ribbon and Backstage view in MS OneNote 2010. First, open up MS OneNote 2010 on your desktop. You will now see a new user interface where the ribbon appears underneath the tabs. Click the home tab to see the ribbon and then you will see the options to change font, colors, headings, and more. These help you find the features you want to change much faster and is completely customizable. The options can be located on the backstage view, which is underneath...

In this tutorial, we learn how to reduce noise in RAW Therapee. First, open up your photo in the software that you want to reduce the noise on. Then, open up the detailed view of the photo and click on then click on the detail button. Through here, you can sharpen the image or you can change the noise reduction for the color and luminance. Click on the drop down menu for the luminance and then enable to checked section. Then, move the edge tolerance to its maximum to see the full effect on the...

In this video, we learn how to enhance the audio in your Camtasia Studio 5 videos. First, set your video to 640x480 and then choose the option to zoom yourself. Now, click the zoom in button to zoom in on the time line with your audio. Then, right click the audio and go to "audio enhancement". Once here, click the first option under background noise removal, then click the remove background noise button. Now, when you play back your audio, you will hear a huge difference in what you just played...

In this tutorial, we learn how to capture HV30/HV20 HD video in Sony Vegas with Bill Meyers. First, go to "file" then "capture video" if nothing is happening, you can fix this. Go to "options" then "preferences". Now, click on the video tab and if you are uploading in high definition, you will need to un-click the box that says "use external video capture application". When finished, click on "apply" and you should be able to capture live video. Instead of seeing the blank screen when you click...

In this video, we learn how to edit quick shapes in Xara Xtreme. First, open up Xara Xtreme and select the quick shape option. From here, you will create the shape on your screen. Then, alter the number of spokes you see. You can hold down or select any nodes that you see. Pull these into the center and then it will create a thin star. Undo this and then hold down the control key while pulling in the center to create a twisting effect in the middle. All of these will look different and you can...

In this tutorial, we learn how to extract .RAR files. First, right click on the file, then click on "extract files". Once you are in a new window, you will be able to choose where you are opening the file from. Once you do this, the file will show up on your desktop in different icons. This is handy if you want to extract a file but don't have time to waste waiting forever. You can also open up the file by right clicking on it and opening it up in notes, where you will see the file waiting to...

A video that demonstrates the use of Adobe Flash for creating sprites for use in animation in games. In this video, a game character is shown doing various actions which range from simple stance's to complex combo's The video explains the use of sprites and keyframes to be used in various actions. It also explains the use of pauses while executing the sprites so as to add fluidity to the action performed. This also reduces the number of frames required to perform an animation. Lastly,...

A simple tutorial video that demonstrates the procedure for creating a brochure quickly and easily using the Microsoft Publisher program, which is shipped as a part of the Microsoft Office Suite. The entire process of creating a brochure is greatly simplified in this program as predefined templates for common documents like brochures, invitations, circulars etc are available within the program. As shown in the video, the steps for creating a brochure simply consist of picking a template...

Microsoft has finally released Windows Live Essentials 2011, their suite of consumer applications designed to compliment Windows and compete against Apple's iLife software.  Windows Live Essentials 2011 is only available for Windows Vista and Windows 7 and can be downloaded from the Windows Live website.

Whether you own a business or work for a company, you probably send out millions of emails every day corresponding with clients, PR, and whoever else you have to deal with. It's hard enough making sure you get around to all of them, but what's more is that even after you've finished composing the message you have to add your name, company name, phone, etc.

Internet whores (which would be all of us by now) are quite familiar with gifs. Just like popular internet memes like LOLCats, viral gifs are short videos or slide shows sequenced together for a comical - or at least unexpected - effect.

In this tutorial, we learn how to use Eraser to permanently erase data. First, open up Internet Explorer and search for "eraser". Once you do this, click on the first link that you see. Then, go to the download section of the website and download the first version that you see, it will be the newer version. Choose the bit processor that you have, then wait for it to download on your computer. Now install it and go to your Start menu to find the application. After this, open up the Eraser, then...

In this clip, you'll learn how to create movies with Windows Movie Maker on a desktop or laptop computer running the MS Windows Vista operating system. For more information, including a complete demonstration of the process and detailed, step-by-step instructions, watch this home-computing how-to.

Want to add a clickable button to your website, but want something a little more exciting than just the ordinary picture or text button? If you have Adobe Flash and After Effects CS4, then you can design yourself a really cool, electrified button with your logo on it. Click here for the source files.

In this clip, you'll learn how to use Nik Color Efex Pro filters when working in Adobe Photoshop or Photoshop Elements (PSE) with your Wacom tablet. It's easy. So easy, in fact, that this video tutorial can present a complete, step-by-step overview of the process in just over eight minutes. For more information, including detailed, step-by-step instructions, take a look.

Art nerds rejoice. With the aid of Photoshop, the folks at Artcyclopedia have doctored Van Gogh's paintings  to give the effect of a three dimensional model (the same effect used in tilt-shift photography).

2 Methods to Burn Vuze Movie to DVD

For graphic artists all sorts of projects come into play at some point or another in the time that you're working, and if you're in need of a marble texture but not sure how to create it, check out this quick video. You will learn how to set up and then break down a picture into a great looking marble texture!

Remove unnecessary content and orient your images in the proper direction using the crop and rotate tools in Adobe Photoshop Elements. This very basic tutorial shows you how do some easy and quick fixes to draw out what you want from your PSE projects.

Add a little extra touch of realism to your project or image in Adobe Photoshop CS5. If you're building a digital scrapbook or photo album, you can Photoshop in a few pieces of tape at the edges, and this short tutorial demonstrates a few separate techniques to achieve this effect.

Create a custom brush which you can use to stamp your own signature onto projects you've worked with in Adobe Photoshop. You'll be able to change the size or color of your signature, and put it anywhere on the image you want.

One of the perils of making photos larger or smaller (especially in only one direction) is losing content or ending up with a distorted image. This tutorial shows you how to use the content-aware scaling feature in Adobe Photoshop CS5 to resize your images and retain all your content.

Bring out the colors in your clouds and sky images - or any other picture you want to retouch. This short tutorial shows you how to use the gradient tool in Adobe Photoshop and s-curves to adjust the color and contrast in your image.

The Chroma Key tool is a useful function in Adobe Photoshop which can let you select, group and otherwise work with colors when retourching a Photoshop image. This tutorial also shows you how to work with hair while trying to key out your background.

Showcase your work on a portfolio-style website. This tutorial shows you the simple and easy process for you to create a clean, modern look in Adobe Photoshop CS5, which you can use online to display a portfolio of any kind of creative work.

Photoshop has the capability to handle many different file formats, though many of these files are now obsolete. The five most common formats currently in use are .psd, .tif, .jpg, .png and .exr. This tutorial explains the pros and cons for using each format in Adobe Photoshop projects.

Replicate the old arcade games like Pac Man or Galaga by downloading the free software Gamemaker 7.0. After you've downloaded the program, create your own sprites in an image editor, use the sounds already provided in the software and finally load your background. Then set up your game script, and you have your own arcade-style video game!

Use a CAD plan as a reference for your Google SketchUp project. This tutorial shows you how to use the rectangle tool to create building walls and outline your building for SketchUp. Use the eraser tool afterwards so you can erase unneeded lines.

After you've already modeled your dragon (or any other winged creature) in the 3-D modeling and animation software Blender, you can then set it to fly! This tutorial shows you how to apply a flight animation to your new Blender projects.

Have multiple animations going at the same time in your Flash project! This tutorial shows you how to use the scene editor, timeline and other functions in Adobe Flash CS4 and Swift 3D to make multiple animations run concurrently in a single project.

The Unreal 3 Engine is one of the most common and prevalent engines used to create and mod video games. This tutorial shows you how to integrate UDK and Papervision 3D to increase your productivity when creating a game, 3-D animation or other similar content.

The Unreal Development Kit lets you create terrains and add textures. This tutorial shows you a few tips to making a terrain, and then demonstrates how you can take this textured terrain and port it into Papervision 3D for your own projects.

Skydomes are effects you can use when mapping an outdoor level or map area to simulate the open sky. This tutorial shows you how to create a sky dome using the Unreal Development Kit and then incorporate that sky dome into your Papervision 3D project.

Take an .flv video clip and embed it as a Flash movie, complete with stop, play and pause buttons to control the video. This tutorial shows you how you can use the Adobe Flash software to set up your own embedded videos.