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 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: 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: 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: Use VLOOKUP across worksheets in MS Excel 2007
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using VLOOKUP in one worksheet to look up values located in a second worksheet. For more on using VLOOKUP across Excel worksheets, watch this MS 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: Create Scarface-style poster art effect in Photoshop
In this video tutorial, you'll learn how to use Photoshop to generate Scarface-style poster art. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
How To: Create lightning effects in GIMP
If Photoshop is too complex for your tastes - or just takes a little too long - then GIMP may be the solution. GIMP is a photo manipulation software with super easy controls and tools. Generally it's used for photo retouching, but like Photoshop, the program allows you to add in special effects.
How To: Create glowing line effects in Photoshop
This is really cool, you can make these awesome neon glowing lines using your Adobe Photoshop. This is a fun way to make creative and colorful designs and it looks really neat without spending time working on detailed shapes.
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: Create an old faded newspaper effect in Photoshop
The video is about how an old stalled photographic image with faded backgrounds to a normal image. A nice clean digital image is taken and is mixed with a texture of a paper and produces a final composite image of all effects combined. The procedure is not that difficult but it needs to be followed in a proper order. First the paper texture is taken as a base and then the clean digital image is dragged onto this texture. The blending mode is adjusted from normal to multiplied blending mode, w...
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: 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: 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: 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: 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: Simulate dust in volume lighting in 3ds Max 2010
Whether you're new to Autodesk's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look.
How To: Count whole and half workdays 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 535th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, ROW, INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.
How To: Make a realistic ribbon in Adobe Photoshop
This is a pretty basic tutorial that will help you learn most of the core features of Adobe Photoshop, like shapes, pen tools and layers. Start with a blank file and create your own realistic piece of soft, wavy ribbon.
How To: Create A Nice Curtain In GIMP
Hello everyone, This is my first tutorial posted on WonderHowTo and as a starter I wanted to show you how to make a nice curtain in GIMP, the free Photoshop alternative. Even though GIMP does not have all the features of his expensive brother, you can still do some cool designs or photo manipulation.
How To: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.
How To: Model cloth with Reactor in Autodesk 3ds Max 2010
In this tips tutorial, you'll see how you can use Reactor's dynamic features to simulate a simple cloth using constraints and
How To: Use Assemblies and Groups in 3D Studio Max 2010
See how to use 3ds Max 2010's built-in grouping features to work on multiple meshes the same way you might work on a single object. Whether you're new to Autodesk's popular modeling software or a seasoned 3D artist just looking to better acquaint yourself with the application, you're sure to be well served by this video tutorial. For more information, and to get started taking advantage of the 3ds Max Assembly and Group tools yourself, take a look! Use Assemblies and Groups in 3D Studio Max 2...
How To: Link to a URL in Flash
1. The following Steps shows how to open a URL in a Web Browser, using a Button Click from a Flash Application. 2. Open a new Flash Application and place a Rectangle Shape from Tools and inside place a Text Box and Enter a Text named "URL". 3. Then convert it to Symbol by Right Click->Convert to Symbol and selecting type as Button. 4. Goto Button Properties and Name the button instance as "btnurl" 5. Then in the Action Screen Create a OnRelease() Event function for Button "btnurl" 6. use a me...
How To: Create picture-in-picture effects in iMovie '09
Check out this informative video tutorial from Apple on how to create picture-in-picture effects in iMovie '09.
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 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: 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: Remove Vocals from a Song in Pro Tools
If you need to remove vocals from a song in Pro Tools first you need to open Pro Tools and load the song. First, you need to split this track so go to Track and click split to mono. Now, mute this first track. Next, you want to remove the stereo by panning each the bottom to 0. Now, flip the phase by going to the bottom clicking EQ plugin. Now the vocal is pretty much gone.
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: Give someone a shave in GIMP
In this Software video you will see how to give someone a shave in GIMP. Learn spot removal, skin smoothening and a makeover or removing a 1 day beard. This is done using the Clone and the Healing tool. To use the Clone tool, select the tool from the right hand panel. Then to select the source skin color, you have to hold ctrl key down and click. Now when you apply it to the area you will get the same shade of the source color. So, you will need to select an area very close to the spot you ar...
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: Open & edit Dolby Digital AC3 audio with Audacity
A great number of audio editors don't support importing/exporting AC3 files, luckily the awesome—and, of course, free–Audacity does. 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 free video software tutorial, which presents a complete overview of how to open and edit Dolby Digital AC3 audio when working in Audacity.
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: Create 8-bit style pixel art using Adobe Illustrator
Copy the popular, retro-style 8-bit pixel art. You can use Adobe Illustrator to create this simple sort of art. This tutorial shows you how to set up your document and how to begin illustrating your project to get that old school feel for your artwork.
How To: Soften skin, control color & tones in Photoshop CS4
Learn about skin softening techniques and the controlling of color and tones when working in Adobe Photoshop! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started managing skin tones in Photoshop yourself, watch this designer's guide!
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: 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: Use Photoshop to create six pack abs
Who has time to go to the gym any more? Not to mention the money. And then there's all that heavy lifting if you do get there. Why not just fire up Photoshop and turn that 96 lb weakling into a gym monkey beefcake? This Photoshop editing technique for giving a similar look dodging and burning only a lot quicker. This is a technique was developed by Photoshop Guru Calvin Hollywood. This tutorial will show you how it's done. In no time at all you'll be faking out people with your touched up pho...
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