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: Create a Tangent Line with Excel
Given a function, you can easily find the slope of a tangent line using Microsoft Excel to do the dirty work. That is to say, you can input your x-value, create a couple of formulas, and have Excel calculate the secant value of the tangent slope. This is a fantastic tool for Stewart Calculus sections 2.1 and 2.2.
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: Remove makeup in Photoshop
This video tutorial is about removing makeup in a photo using Photoshop. To do this, first of all, open the photo. Then zoom in on the area where you want to remove the makeup. The tool that is to be used to remove makeup is the brush tool. It can be selected from the left pane. After that, on top there will be an option which says mode. Click on the option just near to that and a drop down menu appears. From that list, select the hue option or color option. Both the options serve the same pu...
How To: Convert a Photo into a Line Art Drawing in Photoshop
If you're not much of a drawer, you can still get the look of a detailed drawing simply by taking a picture and using Photoshop's tools and filters to transform it into something that looks drawn by hand.
How To: Download Videos with One Click in Freemake Video Downloader
Looking for the fastest and easiest way to download videos from YouTube, Facebook, MTV, Vevo, and other sites? If so, read this guide. Freemake Video Downloader 2.1 offers a brand new mode to get web videos offline in a single click!
How To: Use Blender 2.5.7 to create the time vortex fx from the Doctor Who titles
How cool is the time vortex effect in the opening titles of the BBC's Doctor Who? If you would like to know how to recreate that FX for your own video, watch this Blender 2.5.7 tutorial. The technique covered in this video can also be used to model a roller coaster track.
How To: Count unique items with multiple criteria 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. With this video tutorial from ExcelIsFun, the 368th installment in their series of digital spreadsheet video tutorials, you'll learn how to create and use an array formula that will permit you to count unique items within a column while specifying more than one criterion. This guide uses the SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER functions (in a somewhat unusual combi...
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: Conditionally format at every change in value in 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 tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
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: Clear data & cell contents in Excel using a macro
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
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: Create a bond discount or premium amortization table in 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 52nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a bond discount or premium amortization table.
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: Convert an mp3 file to wav format with Audacity
Want to convert an MP3 to a WAV? With Audacity, it's easy! And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.
How To: Hide scroll bars, sheet tabs & charts in Excel
This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, where you will see some check boxes. Uncheck the boxes for horizontal scroll bar, vertical scroll bar and sheet tabs. This will remove them from the current workbook. This feature only works with the current workbook.
How To: Install additional fonts in Photoscape
Photoscape is a piece of free, photo editing software to use instead of more costly programs such as Photoshop. The program is pretty cool but you may want to install more fonts than what it comes with. If so, check out this video and you'll find out how to get it done. You'll need a zip program like winzip or winrar and you'll of course need Photoscape which you can get here.
How To: Unclothe People in Photoshop
Have you ever wanted to prank your friends by showing pictures of them naked? By learning these easy graphics editing techniques in Photoshop, you can quickly make people shirtless or nude in fake photos.
How To: Turn a male voice to female voice with Audacity
If you're a user of digital editing software Audacity, you already know you can do a ton of cool things. One of the cooler things you can do is changing a guy's voice to sound like a woman's. This is done with pitch control, or autotune, and will like you modify the voice by a number of octaves. I this video, rock band 30 seconds to Mars is made to sound like Avril Lavigne. Check it out! Of course, this can also be done with your own voice too!
How To: Use the Photoshop CS4 patch tool
As each new version of the award winning Adobe Photoshop is released certain functions remain the same from prior versions while other functions are changed. In the latest version of Photoshop, Adobe Photoshop CS4, the patch tool works significantly differently than prior versions. In this video we are shown how the patch tool originally worked in Adobe Photoshop CS2 compared to how it now functions in Photoshop CS4. Finally the author gives us step by step instructions on how to operate the ...
How To: Use the extract tool in Photoshop CS3
The extract tool in Photoshop is one of the most frequently used - and useful - tools you'll ever learn to use. Extracting allows you to remove a picture from its background or even filter away flyaway hair.
How To: Multiply column times row with Transpose in MS Excel
Description Of Excel Magic Trick 444-> to understand this you can also download it from EMT 440-451.
How To: Create a Helix-Shaped NURBS Curve in Maya
There are several ways you can go about creating your NURBS helix curve in Maya; I will demonstrate the two easiest ones.
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: Save Your Word Document as PDF with One Click (Using a Macro)
In this article, we're going to create an additional button in our Word toolbar which creates a PDF file of our loaded file with one simple click. We are going to use the function to create Macros, which are little 'programs' in
How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
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: 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: Model a Leaf in Maya
Start with a Polygon Plane Start by creating a Polygon Plane with 4 width and 5 height sections.
How To: Change the tempo in GarageBand (speed up or slow down songs)
Anyone with a Mac knows the power of GarageBand, but not all iLife users know the ways to slow or speed up their songs in GarageBand. This video will show you exactly how to change the tempo of your song creations, which is actually a really simple thing to do.
How To: Pull data from one Excel worksheet to another via DGET
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
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: Create a favicon in Dreamweaver
This is a handy tutorial about creating the favicon. A favicon is an icon which appears on the tab, in the address bar and in the favorite menu of browsers. To make a favicon:
How To: Score a Full Version of Microsoft Office for Only $10
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, and dinner. Something that I wish I would've known about during college is Microsoft's HUP (Home Use Program). With HUP, any employee or student of an organization that has a Microsoft volume license is eligible to purc...
How To: Create a Simple Procedural Brick Texture in Maya
This is a guide to making a very simple procedural texture for Maya. As with all procedural textures, the basic texture can be refined and added to.
How To: Make someone look fat with Photoshop
Well, usually people are looking to go from fat to thin, but sometimes it's fun to see what a person would look like if they were on a full Twinkie diet. Well, this tutorial shows how to use the liquify tool in Adobe Photoshop to add weight to someone to make them look pudgey, overyweight, fat or even downright obese. The tool is easy to use and the video shows clearly how to turn that beach babe into a Jenny Craig "before" photo! Check it out and YOU can make people look fat in photos.
How To: Create a twinkling star effect in Adobe After Effects
This is a great background for Christmas plays, holiday pageants or any other video you want to add a little twinkle! You can add a twinkling star quite easily in Adobe After Effects, and this tutorial shows you exactly how!
How To: Remove body fat or stretch marks in GIMP
In this video, we learn how to remove body fat or stretch marks in GIMP. First, go to filters, then distort, then warp. When you are in this window, you will be able to see all the different distortions that you can do. To help you remove the fat, use the "move" tool and a proper sized brush. Now, press on the stomach and slowly press down on it until you see the part of the body start to become smaller. Don't do it too quickly, or the picture will look fake. When finished, save your new pict...
How To: Use After Effects to recreate the "Annoying Orange"
By now, everyone is familiar with the Annoying Orange, but how do they do their effects? This video will reveal the secret and show you how to put a face on an inanimate object like the Annoying Orange. See how to put any face on any object to make something that once was inanimate alive! This should work on all Adobe CS versions of After Effects. This example in this video is a beach ball.