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: 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: 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: Resize images and video in Sony Vegas
In this video tutorial, viewers learn how to re-size an image or video in Sony Vegas. Begin by opening the image or video that you want to re-size in Sony Vegas and drag it into the time line. Then click on Event/Pan Crop on the right side of the clip in the time line. Now re-size/rotate the video/image by dragging in and out. Finish by simply closing the window. This video will benefit those viewers who create videos using Sony Vegas and would like to learn how to make their video image smal...
How To: Create a percentage frequency table 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 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).
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: Reveal nipples with the Photoshop x-ray effect
Well, here it is. Hornballs unite!
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: 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: 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: See through clothes with Photoshop CS5
This video shows how to make it look like you can see through clothes with Photoshop. This also works with Gimp, so don't feel you have to go buy a big software package. Try it now and watch the clothing vanish!
How To: Link two (multiple) workbooks & cells in Excel
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
How To: Create a multiuser login system in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.
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: Calculate vacation days with TODAY, YEAR & IF 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF functions.
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: Group quantitative data into classes in MS 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 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...
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: Remove a bra strap using Adobe Photoshop
Bras are such wonderful inventions. Without them, our twins would stray and wander right out of our clothing, and cold weather would prove rather uncomfortable - not to mention awkward - anytime we take our sweater off (if you catch our drift).
How To: Use volume envelopes in Sony Vegas Movie Studio
In this video tutorial, viewers learn how to use volume envelopes in Sony Vegas Movie Studio. Begin by importing the audio track into the time line. Then right-click on the audio control panel, go to Insert/Remove Envelope and select Volume. This will place a purple line through the audio track. Users are able to control the volume by moving the line up or down to increase or decrease the volume. Users are also able to select certain points by creating starting and ending points in the audio ...
How To: Change/convert a pivot animation into an AVI video
In this video tutorial, viewers learn how to change/convert a pivot animation into an AVI video format. Begin by loading the animation in the Pivot program. Now click on File and select the Save as type to Animated gif. Nam the file and click on Save. Then open Windows Movie Maker and add the pivot animation into the time line. click on Publish Movie and select This Computer. Name the file and select the save location. Click on More Settings and select DV-AVI (PAL) and click on Publish. This ...
How To: Create an animated butterfly in Adobe After Effects
In this two-part tutorial, J. Schuh demonstrates how to animate a layered image of a butterfly using After Effects CS4.
How To: Create a sudoku puzzle in Excel with array formulas
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a sudoku puzzle using array formulas, the INDEX function with criteria and data validation.
How To: Use Raw Therapee with GIMP
In this video, we learn how to use Raw Therapee with Gimp. First, you need to go online to Raw Therapee, then download and install Raw Therapee. Once you have this, open it up and familiarize yourself with the layout of the software and where the different tools are at. Next, change your preferences and pick your settings throughout the different folders. Next, find GIMP through the program folders as your installation directory. Now, it will export your images to GIMP automatically. This way...
How To: Calculate invoices and trade discounts in MS Excel
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 43rd installment in his "Excel Business Math" series of free video lessons, you'll learn how to complete an invoice and calculate trade discounts.
How To: Mount an ISO with Daemon Tools in Ubuntu
Askabouttech shows how to mount an ISO with Daemon tools using Ubuntu. Right click on Daemon Tools in the tool bar and select "virtual CD rom". This will bring up a side window in which you will click "device". This will open another side window where you will click "mount image". This will open a new window. Make sure you're looking in desktop and open the Ubuntu ISO file. This should open up a new window where you have the option of running it or viewing the files. When you're finished, fol...
How To: Use the Sony Vegas Movie Studio audio equalizer
Watch this tutorial with Bill Myers and learn how to use the audio equalizer to sweeten the audio in Sony Vegas Movie Studio.
How To: "Grab" flash files from websites
In this video tutorial, viewers learn how to grab flash files (.swf) from websites. Begin by going to the website and locates the flash file that you want. Right-click on the page and select "View Page Source". Go to the Media tab and copy the URL that ends with .swf. Paste it into your address bar and go to the site. Click on File and select Save Page As. Choose the location, name the file and select Save. The file will download and you will be able to access it whenever you want. This video...
How To: Obscure or blur sensitive information in Camtasia
Watch Bill Myers show you an easy way to quickly hide sensitive screen capture text or images using Camtasia Studio.
How To: Look younger with the help of Photoshop
We all know the magazines do it for celebrities, so why not try de-aging for yourself or your friends? Watch this tutorial and learn how to use Photoshop to make someone look younger.
How To: Use 9-slice scaling options in Adobe Illustrator CS5
Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of Adobe Illustrator CS5's most vital new features, you're sure to be well served by this from the folks at Lynda, which presents a detailed, step-by-step overview of how to use Illustrator's 9-slice scaling options.
How To: Use drag & drop in MS Word 2007
In this video the instructor shows how to use the drag-and-drop feature in Microsoft Word 2007. You can use drag-and-drop to copy and move information within the Word document. This is particularly useful when you want to move and copy information within one page. However, if you want to move information between different pages, use the normal copy-paste feature. If you want to move any information, first highlight and select the data. Now click and hold down the mouse button in the middle of...
How To: Create a reverse delay effect in FL Studio
This effect is used to spookify a sound and make it sound like it's coming from the underworld. Follow along as NFX shows you how to create a reverse delay effect in Fruity Loops (FL Studio). This can be done with vocals or instruments.
How To: Create a page curl effect in Adobe Photoshop
Bring your Adobe Photoshop images to life with this wonderful effect, the page curl. Create a sense of movement and tell a story by adding the page curl, also known as page peel, effect. This is a simple procedure that you can master once you've watched this video.
How To: Download iTunes 9 for Windows
iTunes is one of the best music programs out there. You will need this program to use an iPod or download anything from the iTunes Music Store.
How To: Pixelize an image in PhotoFiltre (GMask)
Got something to hide? Learn how to censor or "GMask" an image simply by using the Mosaic option in PhotoFiltre to pixelize the entire thing or just a small (Naughty!) area. It's not that difficult to protect the identities of the not-so-innocent, especially after following the instructions in this video.
How To: Correct pin cushion & barrel distortions in Photoshop
Pin cushion and barrel distortions? It may sound funny but many cheap cameras take pictures with these distortions - basically concave and convex stretching. This tutorial shows you how to fix both of these problems using Photoshop and right your camera's wrongs.
How To: Use the Safe Color Limiter Effect in Avid
When creating video for broadcast or distribution it is important to make sure that the color values meet requirements. Learn how to use the Color Limiter Effect to insure that your color limits fall within the required range. Use the Safe Color Limiter Effect in Avid.
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: 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.
Next Page
Prev Page