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: Generate random numbers (with decimals) in Excel

This video shows you how to generate random numbers with decimals in Microsoft Excel.When generating random numbers you must have a lower and upper limit, so that your number will be generated between the two limits. For a number without decimals, you only have to use the "=randbetween" function. If you want to use decimals, you will have to use a different but similar function. Start by typing "=rand()". Next, you multiply this by the difference between the limits and add the lower limit. Fo...

How To: Change Excel options directly in the Registry

This video shows us the method to block the formula bar, scroll bars and the status bars in Excel. Click on 'Start' and type 'regedit'. Click on 'regedit' and go to 'HKEY_CURRENT_USER'. Open it and go to 'Software' and 'Microsoft'. Expand it and go to 'Office' and open the version of Office on your computer. Expand it and go to Excel. Choose the options folder. Go to the 'Options' item and right click on it. Go to 'Modify' and type 150 in the text box. Click on 'OK'. Now restart the Excel and...

How To: Use x-ray techniques in Photoshop to show naked skin through clothing (NSFW)

Do those new naked body scanners have you freaked out at the airports? As far as the TSA is concerned, those x-ray machines are here to stay, but you might as well take comfort in knowing that airport security guards aren't the only ones looking at your private parts. Practically anyone with a computer can manage to see through your clothes, and it's all thanks to a little program called Photoshop. Thanks, Adobe.

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: Make your own passport size photo

This video instructs the watcher on how to create a passport-sized photo in Photoshop. First, open Photoshop and choose the image that you want using the "Browse" option. Then go to "image", from there "select image size" and select the image size you want (e.g. 35 mm by 43 mm). Next, under "File", go to "select new" and select the size of the paper you use in your printer. Select image and move it to the new file. Copy it as many times as you want in that file. Save, then print. Watch this v...

How To: Create a Motion Trail in Maya 2011

Motion trails in Autodesk Maya can be very handy at times when animating your scene. Keying a bone/joint or other object every so many frames can take up quite a bit of time and can sometimes be a big hassle, too. I have found many times when I could have really used one. I also don't like to search the Internet with a question and not find an answer (at least, without paying for it). So in this how-to article, I will demonstrate going about creating a simple (or complex) motion trail to make...

How To: Use Style Builder in Google SketchUp

Style Builder is a companion application to Google SketchUp 6 Pro that allows you to create, mix, and modify your own unique style that you can use and share in SketchUp. Take a look at this instructional video and learn how to use this new software. This tutorial covers loading and mixing strokes, creating custom strokes, and how to finish the style in Google SketchUp.

How To: Create nice image transitions in Flash

For anyone interested in creating a slideshow with stationary photos, follow the steps in this video tutorial. The video shows how to take multiple images to create an animated slideshow in Flash, with fluid transitions between each image change. Using this technique can add motion to pictures and added interest. By following these steps, you can learn how to take your photos to the next level with a professional touch in a matter of minutes.

How To: Duplicate elements in After Effects

In this video tutorial, Creative Cow Contributing Editor Eran Stern shows you how to duplicate elements in After Effects using the Shape Tool's Repeater function. Part two shows you a neat way to duplicate elements in After Effects using the Puppet Tool. Part three shows you how to duplicate elements in After Effects using the CC RepeTile Effect. Part four shows you how to duplicate elements in After Effects using the Clone Stamp Tool. Part five shows you how to duplicate elements in After Ef...

How To: See Through Clothes with Gimp 2.6

If you can't seem to find any photos of naked people on the internet, don't fret, this how to will show you how to "see through" clothing using some simple techniques with Gimp 2.6 photo editor. Gimp is like Adobe Photoshop without the heavy price tag. Tight, white clothing works best for this trick, so keep that in mind. Watch the video and get one step closer to seeing someone naked. Right on your own computer! See through clothes with Gimp 2.6.

How To: Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Resize an image in MS Paint without losing resolution

In this video, we learn how to resize an image in MS Paint without losing resolution. First, you will go to the file menu and then open. From here, open up the photo you want to resize. After this, go the 'image' section on the toolbar and then click 'stretch and skew'. From here, change the vertical and horizontal stretches until you have the size of picture that you want! Continue to play with it until it's right and then save this over again. This should only take a few minutes and will ke...

How To: Make a freeze frame in Sony Vegas

How to Make Anything demonstrates how to make a freeze frame in Sony Vegas. You can go to the preview window and click on save snapshot to file. The program will then create a jpeg which you can lay into your video to create a freeze frame. You can also use Vegas' velocity envelopes to create a freeze frame. First, zoom into your video in the timeline so that you see each individual frame. Make sure that quantize to frames is toggled in the options menu. Then, hit S to split the video. Right ...

How To: Create glass material in 3ds Max

Dave shows you how to produce a glass three different ways in 3ds Max in the video tutorial. Put two panels away, then concentrating on sensor one press m on the keyboard to bring up the materials editor. On the material editor go to the first sphere, choosing a slight blue color, bring up the specter level, bring up the glossy level, click on two sided and bring down the last two to about four. Look to see it is fairly transparent, in a test window. This is glass one, put on hide. Go to glas...

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: 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: Change a person's sex in an image editing program

Want to change someone's sex in Adobe Photoshop—making a boy look like a girl or a girl a boy? This clip will get you started. 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: Do matrix multiplication and inverse in MS Excel

This is a video about the multiplication, determination, and inverse of matrix using excel. First we have to take two matrix in excel. If you take two 3x3 matrices and multiply it then you will get a 3x3 matrix as a result. First we have to select 3x3 cells in the excel and give then a formula of =mmult(and then select the first matrix it will automatically takes the row and cell numbers, next select the second matrix). Then it will give the answer. Next if you want to find the determinant of...

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: 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: 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: Create a simple typewriter effect in Sony Vegas Pro

In this quick Vegas-user's guide, you'll learn how to create a typewriter effect. 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: Calculate incentive rates by formula in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 39th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate (piecework/comission) incentive rates by Excel formula.

How To: Summarize survey results with a pivot table in 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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.

How To: Measure the spread of a data set with Excel's AVEDEV

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 97th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVEDEV function to measure the spread (variation) in a data set. Also see the STDEV function and learn how to measure whether a mean represents its data points fairly.

How To: Count words separated by commas in Microsoft 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 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.

Prev Page