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: 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 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: Create blendshapes to animate faces in Zbrush

THis video from accredited 3D art instructor Andrew Klein covers how to create symmetrical and asymmetrical blendshapes using the 3D sculpting program Zbrush. This is a fairly complex process, utilizing transpose masking features, move brush, smart resym, and morph target tools to accomplish its goal of creating a really cool animated 3D mask.

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: 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: Build a 15-minute schedule in Microsoft Excel

Want to make a time schedule in Microsoft Excel partitioned into perfectly regimented 15-minute intervals? It's easy, provided you know how to go about it. And in this Excel tutorial from ExcelIsFun, the 543rd installment in their series of Excel magic tricks, you'll learn how to do just that using the Fill Handle. For a complete walkthrough, watch this Microsoft Office how-to.

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: Use the bubbles effect in Photoshop to make it look like your model is nude

Start with a photograph of a woman in a bikini. Open the picture in Adobe Photoshop. Now, learn how to use the Bubbles effect to make it look as though your model is not wearning anything! All you need is a little familiarity with Photoshop, since you will be working with layers and a few more advanced tools in the program. And make sure not to use your photograph to any nefarious purposes - this tutorial is just for fun, only!

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: Repeat each successive date in an Excel date column

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 579th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD function and date math to create a column of dates where each successive date is repeated twice.

How To: Work with skew and histograms in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Retrieve the name of a lowest-bidding vendor 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 283rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, MATCH and MIN functions to retrieve vendors name when they have made the low bid.

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 wh...

How To: Record streaming audio from the Internet with Audacity

In this video from PCRescueRepair we learn how to record streaming audio from any website using audacity. To get audacity just go to google, type in audacity, click on the link for audacity, and download audacity to install this on your computer. Also you need the LAME mp3 encoder which is on the audacity website. Now he takes you through the steps to do this task. Go into audacity and from the drop down change to stereo mix from microphone. On output adjust to max. and on input adjust the vo...

How To: Create a 3D sphere & reflection in Illustrator

In this video tutorial, viewers learn how to create a 3D sphere and reflection in Adobe Illustrator. Begin by using the ellipse tool and create a circle. Select the black and white gradient, and drag the colors that you want into the gradient panel. Now hold the Alt key and draw a smaller circle inside. Fill it with white/transparent gradient. Select the sphere and go to Object/Group. Now go to Effect/Distort and Transform/Transform. Tick the Preview and Reflect Y, insert 1 copies box and sel...

How To: Calculate interest on a loan payment in MS Excel 2007

Learn how to calculate interest on loan payments with Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started making your own loan payment calculations, watch this free video guide.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use auto color correction in Avid Media Composer 5

Need a primer on how to set up automatic color correction within Avid Media Composer 5? Watch this helpful video guide. Whether you're new to Avid's popular non-linear editor (also known as "The Avid") or are a seasoned digital video professional just looking to better acquaint yourself with Media Composer 5, you're sure to enjoy this free software tutorial. For detailed instructions, and to get started using Avid 5 yourself, take a look.

How To: Compare text with text & numbers with numbers 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 634th installment in their series of digital spreadsheet magic tricks, you'll learn how to build logical formulas for counting with criteria or conditional formatting so that the comparison is between text and text or numbers and numbers. Text-to-number comparisons (e.g., 2003 to "2003") do not yield matches. Learn h...

How To: Find the sample size for confidence intervals in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.

How To: Use Radium Glow plugin in After Effects

This software tutorial shows you how to use the Radium Glow plug-in for After Effects. Radium Glow is also available for Final Cut Pro, Premiere Pro and more. Don't settle for glow effects that are just a blur. Radium Glow simulates the way real light behaves, giving you ultra-realistic glimmers and glows. If you've never used Radium Glow, get started with this tutorial.

How To: Embed a video in a slide in Microsoft PowerPoint Mac 2011

Want to know how to add a video to a slide in a PowerPoint for Mac 2011 document? This video will show you how it's done. Whether you're new to Microsoft's popular word digital slideshow application, new to MS PowerPoint 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For detailed, step-by-step instructions, watch the video.

How To: Use the Pathfinder tool in Adobe Illustrator CS5

Learn how to use the Pathfinder tool in Illustrator CS5. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, watch this video guide.

How To: Calculate skew in a distribution in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 44th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the SKEW function to calculate the skew in a distribution of data.

Prev Page