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: 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: Set up pagination in Adobe InDesign
Get your numbering straight with Adobe's InDesign and this helpful tutorial, showing you what you need to know. It's essential when creating a project for yourself or a client, to get your numbering right the first time. There is no second chance. So, check out the steps and see how to turn this sometimes tricky task into a much easier one. InDesign offers a lot of options, and if you're going to master all it's tricks, watch this how-to to learn one of the most simple and essential tricks.
How To: Make Any Song Instrumental Using the Audacity Program
This will work for nearly any song. Upload your chosen piece (simpler pieces work better), and then follow along with the procedure so you can remove the entire vocal track and end up with a song that's purely and completely instrumental.
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: 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 music mixes on your computer for free
There are many music programs beyond Audacity which you can download for free, and which will allow you to mix and edit your own music. This tutorial shows you where to get these programs, like ROC, Myna, FreeSound and FlashKit, and how to use them for your own projects.
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: Model an object using the CV Curve tool in Maya
3D modeling tool Mayafrom Autodesk is a monster of a program, able to do SO many things. One of the things you'll need to learn is how to use the CV Curve tool. This will allow you to create objects with curves of any shape or dimension you desire. Let's be honest, most of your models will require curves, so check out this tutorial and find out how to do it. Maya is used in everything from small animation to feature films like Spiderman. If you want to be in the biz, expand your skill set wit...
How To: Tune a kick drum in FL Studio 9
In this clip, learn how to tune your kick drum using FL Studio 9 on your computer. You will learn how to tune your kicks and make them sound better when played melodically. So, check out this tutorial and try it out on your own version of Studio to start making beautiful music. Rock on!
How To: Use Excel data analysis functions (max, min, average)
Create a table with sales data with this video.
How To: Create a multicolor text effect in Photoshop
This Adobe Photoshop tutorial teaches you how to perform a multicolor text effect for use of logos and graphics. In this example, the graphic artist types each number in 2012 on separate layers. Then he turns down the opacity and overlaps the numbers. He takes the first number on its own layer and creates a red to pink gradient. Then he pastes the layer style on the rest of the numbers and changes the gradient colors so they are all different.
How To: Use OR, ISNUMBER and ISTEXT in Excel
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.
How To: Create interlocking patterns in Photoshop
In this Photoshop tutorial you'll learn how to make interlocking patterns with perfect symmetry, for example holes cut into metal or reptile skin. Of course, the key to this is the interaction with light.
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: 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: 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: 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: 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: 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: 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: Make breasts appear larger in Photoshop
In this tutorial, we learn how to make breasts appear larger using Photoshop. First, open up the image you want to change inside of Photoshop. Next, go to "filter", then choose "liquefy". Choose the float tool and then set the brush size to a size you want the breasts to be. Stay in the same spot while you boost the breasts, making small movements, so you don't create an unrealistic image. If you are using a close up, use the dodge tool to give the breasts color, then use the burn tool to add...
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: Extract part of a table from a larger table 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. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to extract part of a table from a larger table. You'll accomplish this with an array formula that uses Excel's INDIRECT, IF, ROWS, COUNTIF, INDEX, SMALL, and ROW functions. The formula will extract records that meet one con...
How To: Create an Excel spreadsheet to calculate your GPA
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
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: Create a PDF Portfolio or Magazine with InDesign and Share It Online
Why a PDF Portfolio? If you've been wanting to create a PDF (portable document format) portfolio for your photos, art or design work, or wanted to create a PDF magazine that can be read by anyone on the net, then this article will show you how to go about it.
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: Create a lens flare in Illustrator
Ever wondered about the flare hitting your eyes from reflective surfaces (vehicle mirrors)? Let's create one. Open Adobe Illustrator with an image and embed it. Take the flare tool from tool palette. Draw the first shape and then second shape. To change settings, go to flare options. You can change the brightness, opacity and diameter of the flare which will add life to the image(open sky). This will help bring out some cool effects as well as realism to the image.
How To: Create an ISO image with Ashampoo Burning Studio 6
In this video tutorial, viewers learn how to create an ISO image. Users will need to download the program, Ashampoo Burning Studio 6. Begin by going to the Google search engine and search for the program. Select the result from download.com. Click on Download Now and save the file. Double-click on the file and follow the instructions to install it. Then open the program and select Create/Burn Disc Images. Select the type of disc image that you would like. Then click on Add and select the file...
How To: Save still images and screenshots from your iMovie clips
For this tutorial to work, you will need to be running iMovie on a Mac. Take any frame from your footage and turn it into a still shot that will function like a photograph. Use it as a screenshot or promotional tool for your movie!
How To: Reveal nipples with the Photoshop x-ray effect
Well, here it is. Hornballs unite!
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 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: Create a skewed checkerboard pattern in Illustrator
Check out this simple Adobe Illustrator CS4 tutorial to learn how to create a skewed checkerboard pattern. This technique will save you the trouble of having to use the Option and Drag method multiple times. Veerle Pieters expertly takes you through this easy pattern technique. For more Adobe Illustrator tutorials, search for Illustrator on WonderHowTo.
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: 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: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!
How To: Compress Mp4 videos in Sony Vegas Pro
If you are facing any problem to compress videos in Sony Vegas like not in very good quality or big in size etc. then you have to take these steps to get rid of it.
Next Page
Prev Page