How To: Find a P-Value with Excel
So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis.
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 a dissolving text transition in After Effects
In this episode of Red Giant TV, Aharon Rabinowitz shows you how to create the effect of text (or a logo) dissolving to sand and blowing away. You'll also learn how to reverse the transition, so that sand forms into text.
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: Flip a Clip in Final Cut Pro X 10.1.2
This is a great how to for all users in Final Cut Pro X 10.1.2 Video: .
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: Compare two lists and extract the new values in Excel
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
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: Get auto tune (t-pain effect) in Audacity using gsnap
In this video tutorial, learn how to get auto tune, or the t-pain vocal effect, in Audacity using gsnap. To get the GSNAP (GSnap/Grymmjack skin), go here.
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: Make perky nipples with Photoshop
This tutorials shows how to use the Bevel and Emboss Layer style with the Fill slider to create fashions with "perky nipples" used in games like Second Life and IMVU.
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: Increase the volume on "too quiet" exported songs in GarageBand
If you've just exported your masterpiece from GarageBand and found that your volume on the song is too low, then you're going to have to fix it. And increasing the levels on your "too quiet" song, you just need to get back into GarageBand and make some adjustments.
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: Fade out in FL Studio (Fruity Loops)
This video shows a simple way to fade out your song using an automation clip in FL Studio.
How To: Save a snapshop of any video frame in Sony Vegas
See how to quickly grab a snapshot or photo of any video frame in Sony Vegas or Sony Movie Studio with just one mouse click - Bill Myers shows you how.
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: Automatically insert symbols 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 391st installment in their series of digital spreadsheet magic tricks, you'll learn how to use custom number formatting to insert symbols automatically.
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: Achieve a smoother model in Zbrush
This Zbrush tutorial shows how a smooth look when modeling can be achieved just by removing some higher Sub-Division levels and re-working the details back in.
How To: Rotoscope in Sony Vegas Pro
This tutorial explains what rotoscoping is, and how to do it, despite him not doing it, in Sony Vegas Pro.
How To: Clone your head, face or anything, then print in 3D, with Anim8or & Pepakura
What could you do with two of you? Or, two cats, or two cars, or two of anything? Cloning, it's the way of the future and this tutorial shows you how to clone and print a 3D model of virtually anything. Using Anim8or and Pepakura Designer you can model your face and print it up to create a 3D mask. Two for the road I say! (Or would that be four?)
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.
Next Page
Prev Page