How To: Create a Basic Attendance Sheet in Excel

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.

How To: Adjust luminance with the Levels command in Adobe Photoshop CS5

In this clip, you'll learn how to adjust luminance with the Levels command in Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.

How To: Change Skin Tone in Photoshop

With Adobe Photoshop on your computer, it's super easy to change or adjust the skin tone of somebody in a digital photo. The process uses some basic selection and color adjustment tools, and it's a fun way to make a friend's face nauseously green or lessen the effects of overly strong, sometimes even orange, makeup.

How To: Convert an mp3 to wav format in iTunes

This video tutorial belongs to the software category which is going to show you how to convert an mp3 to WAV format in iTunes. Go to file menu and click 'add file to library'. Grab your mp3 file that you want to convert by double clicking on it. This will automatically add to the iTunes library. In the library click on 'music' and find the file that you just added. Now click on edit > preferences > general > import settings. Now in the 'import settings' dialog box, select 'WAV encoder' under ...

How To: Resize images and video in Sony Vegas

In this video tutorial, viewers learn how to re-size an image or video in Sony Vegas. Begin by opening the image or video that you want to re-size in Sony Vegas and drag it into the time line. Then click on Event/Pan Crop on the right side of the clip in the time line. Now re-size/rotate the video/image by dragging in and out. Finish by simply closing the window. This video will benefit those viewers who create videos using Sony Vegas and would like to learn how to make their video image smal...

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Reverse video and audio in Sony Vegas

In this video tutorial, viewers learn how to reverse video direction in Sony Vegas Movie Studio. This task is very easy, fast and simple to do. Begin by importing the video clip(s) and/or audio into the time line. Then right-click on the clip and select Reverse. To reverse the audio, right-click on the track and select Reverse. To undo the video or track, right-click it and select Reverse once again. This video will benefit those viewers who enjoy editing and creating videos, and would like t...

How To: Cross-check two lists for discrepancies in MS Excel

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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.

How To: Extract part of a table from a larger table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...

How To: Calculate proportions and percentages in Excel

This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...

How To: Display trend arrows in a Microsoft Excel spreadsheet

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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.

How To: Generate a dynamic list from a table in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 146th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from table, putting one record on each sheet with records in rows. This is accomplished with Excel's VLOOKUP, COLUMN, FIND, REPLACE and CELL functions. See also how to create a formula for a sheet name (sheet tab name, works...

How To: Make boobs bigger in Photoshop

One of the most suggested topics on youtube for Photoshop is enhancing breast size. Sending an image to someone & need to alter it? Want your boobs to look bigger? Or do you just want to have some fun giving girls bigger boobs on Photoshop? This tutorial demonstrates how to increase breast size using Photoshop.

How To: Remove date and time stamps from your photos

There are various ways to remove the timestamp on your photos using Photoshop. You can use the crop too and crop out the photo, but then you'll lose parts of the photo as well. You can use the patch tool, and draw a border around the date, then drag the date to another area, let go and press ctrl+D. The time will disappear and the area will be patched up with surrounding colors. Another method is to use the spot helium brush tool, and simply just brush over the text, and the spot helium brush...

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Change lip color & shade in Photoshop

Forget to put on lipstick before a photo? Or perhaps you want to spice up an old photo of someone you love. Well their is a way, as 4YouTutorial demonstrates step by step using Photoshop CS4. First upload a photo or image into Photoshop. Next access your Photoshop layers and delete the default locked layer. After, activate the zoom tool and zoom in on the photo where the lips are located. Next choose the quick selection tool (make sure it's on plus) and drag it over her lips. This process can...

How To: Create an interest-only loan schedule in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an interest-only loan schedule in Excel.

How To: Use the noise removal tool in Camtasia Studio

In this video tutorial, viewers learn how to use the noise removal tool in Camtasia Studio. Begin by uploading the audio track into the time line. Then select and highlight the region that contains the noise. Now click on Edit and select Audio Enhancements. Under Background noise removal, users are able to select to automatically or manually remove the noise. Once selected, simply click on the Remove Noise button. Users also have the option to adjust the sensitivity. This video will benefit t...

How To: Remove stains, dirt and discoloration in Photoshop

Want to touch up an old printed photograph? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from the folks at Britec Computer Systems. This video offers a step-by-step guide on how to get rid of unwanted stains, dirt and discoloration using Adobe Photoshop.

How To: Turn off AutoCorrect symbols in Excel

In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...

How To: Increment a number pattern by formula in MS Excel

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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.

How To: Use the TV simulation effect in Sony Vegas Pro

Want to make a video clip appear as though it's being displayed by an old CRT television set? With Sony Vegas Movie Studio or Sony Vegas Pro, it's an easy thing to do. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Make HD videos in Windows Movie Maker

Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...

Prev Page