jQuery is a very powerful Javascript framework that makes making cool website interfaces much easier. This video will introduce you to the basics of using jQuery from installing it on your computer to creating your first simple element. You'll also learn the function methods that jQuery uses and how to inset jQuery into an HTML document.
Flash Actionscript 3 is a wonderfully powerful, but somewhat obtuse, tool for creating websites. This video will teach you how to use one particular function in the language, creating a class that has multiple key detection enabled. This will allow you to create a website where users can key in multiple inputs and the website will respond appropriately.
If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.
Multi-touch input has been spreading throughout a huge variety of devices, from phones to all-in-one PCs. However, most multitouch (table) displays that can function with your computer tend to be fairly expensive, so with this project we're going to make our own display, that can run on any operating system, and reuses some useless everyday materials.
Check out this video tutorial to show you how to use a Fuji FinePix digital still camera. This video was made by the equipment room at CUNY Journalism School in New York.
You may or may not know that Facebook has several keyboard shortcuts you can use to quickly navigate around the site without using a mouse.
Are you an iMovie user looking to double down on yourself? Well, if so, watch this video and see how to clone yourself, quickly and easily. I mean, who wouldn't want to make two of themselves? It could be so helpful for so many situations! Though cloning may be far in the future, we can still clone ourselves in Videos. Apple's new iMovies, have changed from being small easy video processors to a more complex higher quality Video editing software. This video will use the Green Screen Function ...
If you want an electrical circuit to send power to an object, like a light, you're going to need resistors. This video, part of an excellent series on basic electronics by Scotty, will teach you how to make a circuit with resistors and an LED light, a real function piece of electronics.
Electronics are the most important new thing people have created in the last hundred years, and learning how to use them will make you much more able to function in modern society. If you want to learn about electronics without going to a class or anything so formal, this excellent video series will teach you everything you need to know to get started. This video, the first in the series, will teach you about the basic tools and components you'll need to work on electronics projects, includin...
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 693rd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate how long it will take to double your money using the NPER function and the rule of 72.
Create links and change elements with AS3 in Flash CS3 Use buttons to change the appearance of a button, navigate to a different place in a time line and link to a website. Use action script 3.0. Publish settings. Need to apply actions. Create an event listener. Attach to a button that you want it to listen for something to happen. When it hears a mouse click, it will execute the function. Give the buttons instance names R_btn, G_btn, and B_btn.
This video shows you how to do a mathematical representation on computing the nCr function using a TI-89 calculator. You can write the nCr notation in different forms. It can be simplified from nCr to C(n,r). The symbol can either be read "n choose r" or "n taken r at a time" which are from it's probability applications. On the example to find "26 choose 17", go to the Home screen of the TI-89 calculator and then go 2nd 5 which is Math. Go choose probability and then to nCr to type in (26,17)...
Learn how to edit audio files using Audacity of the MAC. 1 Create an audio file by using the built in recording function in Audacity. Save the file prior to starting your editing. 2 Open the file that you created earlier and test the file by playing it. 3 You can copy, cut and paste different parts of the file by highlighting the section in your file and then right clicking (or option clicking) and choosing what you want to do from the pop up file. 4 You can also add effects by highlighting a...
If you're looking for a creative place to stash your cash or small valuables, this how-to video walks you through the process of turning a DVD drive into stash box. Armed with a screwdriver and some time, this video gives detailed step-by-step instruction on talking apart your DVD drive and reassembling it. The video includes helpful hints to make this stash box look and function in an authentic manner. This DVD stash box video will not only help keep your stuff safe, but you may even feel a ...
The personal computer is a strange and powerful entity, capable of bringing great joy. Just as often, you probably want to chuck the damn thing at the wall because it doesn't work right. If you want to pull a prank on a friend that will really upset them, messing with their computer is one of the best ways to do it. This hilarious video will show you how to do three great PC pranks quickly and easily, including changing the contrast on the monitor and pretending to edit websites using Javascr...
This video demonstrates the installation of memory in a 13” Macbook Pro (mid 2009 model). It’s easy to perform and takes about 10min time. You’ll require a #00 Philips screwdriver (available in the Newer Technology 11- piece tool kit). Take care to work in an anti-static work space. Close the Macbook Pro and flip it over with the hinge side up. You can note 10 screws along the border. Start unscrewing the 3 screws on the right on the top edge, these are longer than the rest. Now unscrew the r...
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to use color correction in Photoshop.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...
The factorial of a number n can be defined as the product of all positive integers that are greater than 0 but less than or equal to n.
After performing a Vital Signs examination on a patient, usually, the next step for a doctor is performing the HEENT.
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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.
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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.
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 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.
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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...
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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...
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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.
This video is a tutorial for a music producing software program called Ableton Live 8. In this tutorial he shows you how to apply effects to effects to audio using the audio effect rack function. The way this function works is by being dragged into the bottom of the program and being applied as a place to hold various effects. Using the effect rack you can modulate and manipulate the sound waves in the effect. This is a very convenient tool to have in Ableton because it allows you to have mor...
Now that we're feeling the full force of Jack Frost's chill, scarves are the perfect fashion accessory, balancing that fine line between function (keeping our necks warm and toasty) and form (since they're oh so cute). Check out this fashion styling video by Michelle Phan to learn seven different ways to work your neck wrap.
Wait, a query within a query? This function is possible within the framework of MySQL. Learn how to correctly implement a subquery or sub select in your next database project and avoid a couple perils that will make your program unstable.
Learn the fundamentals of position tracking in After Effects in this informative 5 minute tutorial from Patrick Carter. This video lesson involves attaching a text object to a moving cowboy on screen to demonstrate the basic transform tracking function.
It took all the way until firmware version 4.2 for Apple to add a function to the iPhone that's been present on other phones for years: the ability to set custom ringtones / sounds for text messages from different contacts. This video will show you how quick and easy it is to set this up on the new firmware.
A remote control for a camera? Why not! You won't have to worry about racing the timer function any more! Build a remote control for your digital camera that will take the picture whenever you want. The range is as far as two miles!
Using an animated movie strip as an example, this tutorial for Blender shows you how to properly animate textures. You can achieve this effect by making use of the offset parameter function within Blender, and this tutorial demonstrates how.
Turn a photograph of a regular person into an image of everyone's favorite muscular green psychopath! Using the hue slider, saturation tool and the Iwarp function, you can distort your picture in GIMP to make it look like a picture of Hulk instead.
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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT 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 699th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract all the letters from a text string with a VLOOKUP function in Excel 2010.
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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an array formula.
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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal 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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter function.
