How To: Create an advanced Cherry 7-Up animation in Cinema 4D
In this advanced three-part tutorial, learn how to create a beautiful, sweeping animation for Cherry 7-Up. This animation is made using Cinema 4D and will take a bunch of cherries, have them swim together and form the logo for 7-Up. This animation is gorgeous and looks so professional that you'd think it was an official ad for the brand.
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: Create a spinning glass block animation in Cinema 4D
In this two-part tutorial series, you'll see how to make a spinning glass block animation with Cinema 4D, Mograph and refraction. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.
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: Register & activate PreSonus Studio One online or offline
In this video tutorial, we learn how to register and activate Studio One either over the Internet or offline. Whether you're new to PreSonus' DAW or new to digital recording more generally, you're sure to find much to take away from this free video software tutorial. Take a look.
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 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: 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: 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: 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: Archive data 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 using an append and delete query sequentially using a macro. For more on archiving data in Microsoft office, take a look.
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: Work with title text in Final Cut Pro 7
Learn how to create a professional-looking title sequence in Final Cut Pro or Express with this video guide. Whether you're new to Apple's Final Cut Pro non-linear video editor or just want to better acquaint yourself with the popular video editing program, you're sure to benefit from this video tutorial. For more information, including detailed, step-by-step instructions, watch this tutorial.
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: 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: Change an object's color in Photoshop using magic wand
Use the "Magic Wand" tool to select the color you wish to change. The next step is to open the replace color box. Go to Image > Adjustments > Replace Color. After the Replace Color box is open, you may have to select the color that you want to change in the image. Sometimes, it will automatically select the color you're changing, but sometimes you will have to use the Eyedropper Tool and click a hue of the color you wish to change. After the color is selected in the "Replace Color" box, you c...
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: Make a simple but effective bassline in FL Studio
Making an effective bassline is probably easier than you think. Check out this tutorial and see how easy it is to make a simple and good bassline for your music in Fruity Loops (FL Studio).
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: Create an array from a rasterized object in Photoshop
This image editing software tutorial shows you how to create an array from a rasterized object in Photoshop CS3. An array (in design terms, not programming terms) is an object that duplicates itself around a pivot point. So learn how to work with arrays to create designs in this Photoshop video.
How To: Insert joints in a joint chain in Maya
If you are working on characters or rigs, you are definitely working with joints. This video shows you how to insert a join in a joint chain if you need more or happened to miss one.
How To: Get the CD Product Key or Serial Off of Any CD
This will allow you to find the CD product key or serial if you have lost it so you dont have to buy another CD.
How To: Create a rough sketch effect in Adobe Photoshop
Have a photo that's not sketchy enough for your taste? Are you maybe just a big fan of Norwegian new wave band, A-ha? Whatever the case, this free Photoshop video tutorial will walk you through how to apply the effect to your own images in Adobe's popular image editing program. Take a look.
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: Create realistic water flowing in Photoshop
This tutorial shows you how to make realistic looking water flow out of a tap or faucet using Photoshop. This is a still image and not an animation.
How To: Use the IPO Curve Editor in the Blender 2.49 sequencer
Here's a quick tip on using the IPO Curve Editor in the Sequencer in Blender 2.49b or 2.5. Whether you're new to the Blender Foundation'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: Create an animated comedy title sequence in Cinema 4D
This Cinema 4D tutorial offers a lesson in creating a very fast and easy comedy title sequence using MoGraph, MoGraph Spline Effector and a bit of compositing in After Effects. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, watch this 3D modeler's guide.
How To: Build a city in 5 minutes Bryce
Here's a tip for building a city in Bryce - start with a mountain and then edit it.
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: 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: Mount ISO, BIN, or CUE files using Daemon Tools
In this video tutorial, you will learn how to mount and unmount an .ISO, .bin and .cue image with daemon tools. This is useful because when you download a game, movie or an application, you usually get an .ISO, .bin or .cue file.
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: 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: Use the Excel Vlookup function in Microsoft Excel 2007
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
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: 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: Draw vector art using the path tool in GIMP
This video will introduce you to the basics of creating vector art in GIMP by teaching you to draw using the path tool.
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...