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: Use the delete mesh modifier in 3ds Max
This 3D software tutorial shows you how to use the delete mesh modifier when modeling in 3ds Max. Delete Mesh provides parametric deletion based on the current sub-object selection level in the stack. The possible choices are faces, vertices, edges, and objects. Apply the Delete Mesh modifier to delete the geometry specified at that sub-object level. The Delete Mesh modifier in 3D Studio Max works well for removing geometry without having to delete. You can use it in conjunction with the Edit...
How To: Remove red eye from flash photography in Fireworks 8
In this Fireworks 8 video tutorial you will learn how to remove red eye using a simple tool. The Red-eye Removal tool works by removing all the shades of red within a certain range that are within the selected area. These shades of red will be replaced by a neutral color range of gray and black. Make sure to hit "play tutorial" in the top left corner of the video to start the video. There is no sound, so you'll need to watch the pop-up directions. Remove red eye from flash photography in Fire...
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: 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: 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: 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: Calculate stock value based on the value of future dividend cash flow 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 61st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock based on the present value of a future dividend cash flow.
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: 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: 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: Force text formulas to wrap with Excel's CHAR function
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.
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: Fix missing grids in elevation in Revit Architecture
Have you ever had the problem where your grid lines will NOT show up in elevations?!?!?! This is of course after you have checked your VG settings and maximized 3D extents, still NOTHING! Chances are the elevation view is not perpendicular to the grid lines. In most cases this makes sense, how is Revit going to know where you want to intersect the infinite planes of the grid lines. In this Revit tutorial David Fano establishes the point of intersection as the point where the site boundary and...
How To: Auto-tune your vocals in Audacity for free
T-Pain, Cher, heck, most of the new artists these days use auto-tune, some over use it. With technology it isn't so much of a question of, "do we need to do it?" and more of "why aren't we doing it!?" Well, if you're looking for an easy way to add auto-tune to your vocal tracks, or your voice in recordings, and are looking to spend the fantastic price of FREE then check out this video! You will learn what programs you will need to download (Audacity, Audacity VST, ect.) and then how to set yo...
How To: Create a 3D extruded world map in MAXON Cinema 4D
This tutorial presents a lesson on how to create a 3D extruded world in MAXON C4D. 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: Create techno backgrounds with Photoshop & Illustrator
This tutorial experiments with a current design trend of creating cyber punk backgrounds using Adobe Photoshop and Illustrator in tandem. For more information, including detailed, step-by-step instructions, watch this free video software tutorial.
How To: Solve markup & markdown math problems 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 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.
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: Use fractal noise in After Effects
In this tutorial, Aharon Rabinowitz introduces you to the Fractal Noise Effect, and shows you how to create the animated backgrounds seen in the opening of the Creative Cow After Effects tutorials. Fractal noise is a powerful way to add variation and randomness to surfaces or scenes and this tutorial only covers the VERY basic basics of the tool. Use fractal noise in After Effects.
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: 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: 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: 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: 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 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: Copy and move worksheets in Microsoft Excel 2007
Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.
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: Calculate probability in an Excel pivot table
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 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.
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: 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: Edit videos in Audacity
Audacity is a great (free) audio editor for recording, slicing, and mixing audio. Learn how to use this software with this detailed step-by-step guide on how to edit videos in Audacity. Be sure to check out other Audacity tutorials on WonderHowTo to find the answers to all your questions!
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: Open, close & save documents in MS Word 2007
In this beginners video, the instructor shows how to use Word 2007 by opening, closing, and saving documents. When you open the Microsoft Word software with out any documents, the window looks gray indicating the same. There is an office button present in the top left corner of the window through which you can access various options. Click on it, and select the open button which brings up the open dialog box. Now, you can browse through your computer and select any Word document to be opened....
How To: Make a harsh lead synth track with dissonance for hard techno in Reason 4
Nowadays digital and analog synthesizers can produce a nearly infinite number of sounds, and many of them sound terrible to most people. If you find yourself more in the Trent Reznor music camp though and love making dystopian, harsh sounds in your music, watch this video. It will teach you how to make a really harsh, dissonance filled lead synth track in Reason 4. Great for glitch, industrial, and other abrasive electronic styles.
How To: Create a new custom brush in Adobe Illustrator CS4 or CS5
Looking for a quick guide on how to create and use custom brushes within Adobe Illustrator CS4 or CS5? This clip will teach you what you need to know. Whether you're new to Adobe's popular vector 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: 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: Create and use Xrefs when working in MAXON Cinema 4D
This tutorial looks at streamlining your C4D workflow, organizing your assets and working with groups. Xrefs can be incredibly useful and as well as helping you to stay organized can also hugely reduce hard drive space used. 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, and to get started using this tr...
How To: Create a realistic 3D model of a human head in Blender
In this four-part tutorial, you'll learn how to create a full human head with Blender's 3D modeling tools. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, and to get started modeling your own 3D heads in Blender, take a look!