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.
In this tutorial, we learn how to watch TV on your iPhone with Joost. First, you will need to download this application to your phone. After you do this, click the icon that is on your phone. Once you are on this, you will be directed to a page with different options. Click on popular to see what the most watched shows are, then click browse to find different shows to your liking. You can also click on search if you are looking for something in particular. There are thousands of different sho...
In this tutorial, we learn how to upgrade a 32-bit Windows to 64-bit. Chances are, it should be able to run as a 64-bit, depending on the processor. If you change the settings in BIOS, you can change it up so you can upgrade the computer. If your computer is still not working, use the backup CD to reinstall the previous software back onto the computer. If you do not have a backup CD, you can try to download the original CD back onto the computer. You will lose all your personal information th...
This simple After Effects tutorial from Laurence Grayson will show you how to use CC Ball Action effect in AE to create a realistic scrolling LED signboard effect, like the ones you see at conference centers and football stadiums. Then end result can be altered to suit your project, and corner-pinned into a scene. There are no plug-ins required, and this method uses the standard toolset in CS3, CS4, and CS5.
ios249 is a sweet little hack for the Wii that allows you to play backup burned copies of games on your console. Pirated games will work too, although we DO NOT condone piracy. This video will walk you through the whole rather elaborate process of installing it on a hacked Wii with the Homebrew channel. You will need to download a whole mess of free software:
HDDhackr is a really cool little software utility that allows you to make any hard drive work as an XBox 360 hard drive. No need to pay a ridiculous premium to buy a cheap hard drive from Microsoft! This video will teach you how to use HDDhackr to set up a hard drive for use on your XBox 360. Now you can backup your game library, download as many movies as you want, and do all sorts of other fun things that the tiny hard drive you had before would not permit.
In the Twilight Saga by Stephenie Meyer, vampires don't melt away in the sunlight. Instead, they sparkle like a beautiful piece of crystal. In this clip, learn how to take a photo of anyone at all and turn them into a sparkling daytime vegetarian vampire like the Cullen family. If you are dying to know what you would look like as a vamp, check out this clip and celebrate the release of Eclipse with a sparkling photo of yourself.
In this video, we learn how to find your Windows product key. Start off by going to Magical Jellybean Keyfinder. This website has a download that will find your product key for your Windows program. This is a great and necessary tool if you happened to loose the product key that came with your computer. This is also great for computers that already had Windows installed, and you never had the product key in the first place. Once you install this on your computer, you just open it up on your d...
The XBox 360 Connectivity Kit is a powerful tool that you can buy for connecting your hard drive to a PC and sharing or manipulating saved game files. They can be a little tricky to figure out though. This two-part video will show you how to use CK3 (Connectivity Kit 3) to connect your XBox 360 hard drive to your computer and how to use software to resign other peoples saves to your profile or vice versa.
Fallout 3 is one of the most popular and biggest (content-wise) games on the XBox 360, and has thus become a popular target for hackers to mod. This video will show you how to mod your Fallout 3 saved game from the XBox 360 version using some FREE software. This does not include Modio, the popular for-money save game editor that many hackers use. Here are the files:
The Canon EOS 7D digital SLR is the first Canon EOS camera that can trigger off-camera Speedlites with the cameras build in flash. The integrated Speedlite transmitter is fully compatible with the Wireless E-TTL Flash System. See exactly how all this works and how to use your flash functions.
You want the best quality photos you can get, and the Canon EOS 7D digital SLR camera makes perfecting your pictures easy. There is a range of technologies to enhance image quality. This video shows you the many options you can use.
There seems to be a growing number of people who decide to try out blender but when you download Blender and start it the first time, it doesn't look very inviting, does it? Well, here's a little tutorial for those who are annoyed by Blender's default setup. 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 ...
If you've seen the 2005 film Sin City, you most likely remember how most of the film was black and white, but some objects were rendered in livid color. This video will teach you how to create the same effect yourself using After Effects! The creator of this two-part video works with a photo of a fetching young woman and her red blouse, which retains it's color as he turns the rest of the image black and white.
Love your new Nook but don't want to spend a ton of money just to read? No problem! Lucky for us, the Nook is now the most inexpensive, fully featured e-reader and to top it all off you can download nearly 100,000 free books for it!
The scrolling, synopsis-giving titles of the sci-fi epic Star Wars might be the most famous set of titles in the history of cinema. All most people need to see is deep space and yellow letters to immediately think of Star Wars. This video will teach you how to make similar titles for your own films using Adobe Premiere Pro. This is MUCH easier than what the Star Wars staff did to make the original titles, so fire up your computer and make your own!
In this super cool tutorial, learn how to create your very own episode of South Park using Flash CS4 and a couple of images you can download on the web. This tutorial is for any super fans who wish to spend some extra quality time with their characters, or for anyone interested in animation. These famous, foul mouthed, 2D characters are fun to move around and will do anything you need them to do once you get started! Get your fan fiction minds turning with this video!
In this video tutorial, viewers learn how to upload large files online for free. The website recommended in this video is Load2All It does not host any files, but it provides a interface to upload the file to several other sites at once. If the file exceeds the limit for any given site, Load2All will automatically split the file into RAR files, upload it into several mirrors and provides one download link. This video will benefit those viewers who have a large file...
Hacking the PSP is a complicated process, and there has been some demand for a software tool that would make the process easier. This video has that solution. It explains how to use a program called PSPtool to create the magic memory stick and Pandora's battery much more easily than you could otherwise. Follow these instructions and play those homebrews!
In this clip, learn how to root your Motorola Droid phone. By rooting your device, you will be able to access new files and apps as well as create your own ROMS and enable WiFi tethering. This process is super easy and should take no more than 5 minutes to do.
In this clip, learn how to tether your rooted Droid to a WiFi network and use it as a modem for your other Wireless devices. This process is pretty easy and only requires a network and that your phone be rooted.
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.
This survival cache is made for adventurers who, if lost, may stumble upon this handy little tube and immediately get some food and knowledge of their geographic location.
Mac or PC? PC or Mac? The debate rages on? Unfortunately, this can mean a lot of headaches for you when dealing with different file formats. If you work on both types, you might very well have to open the same file type on different computers. This can be a problem if you are using .rar files. But this video can help you. This tutorial will show you how a simple download can enable you to open .rar files on a Mac.
This video demonstrates how to fix the batter length problem on a jailbroken iPod. First, make sure that you have a Wi-Fi connection so you could download the necessary files. Turn your iPod Touch on and locate the Installer icon. Wait until the installer program loads. Then, on the bottom portion of the screen, select the icon Install. In the Packages section, scroll all the way down to letter S and look for Services. Select it and install it. After the installation completes, go back to hom...
This video is about how to fix an iPod Touch that will not open applications. You fix it by pressing and holding the power or home button which will restart your iPod that will only take a few minutes. If this does not work, fix it by uninstalling or deleting all the applications and re-installing it from the Appstore for it to work again. If both these two methods will not work, then you can restore your iPod through iTunes by clicking the button "restore". The whole process takes for just a...
This video teaches the secrets of properly burning an ISO file to a CD-R or DVD-R on a Mac. First download the CD burning software from internet and open it. Now click 'Copy' and browse for the disk image. Find the required file and click 'Open' to open it. To see the data on the file click 'Mount' and check them. Click 'Burn' finally, wait for it to complete and start using your CD.
This tutorial from LoadedNewsletter's Jonathan Jelkin gives a simple process on how to prepare H.264 video footage for quick editing. H.264 video footage is shot by popular cameras such as the Canon 5d/7d, Flip cam, GoProHD. This is a great format for straight upload to YouTube, but if you want to edit you need to transcode it to something else. The first step is to download and install a free program called MPEGSTREAMCLIP. Once it is installed you can process all of your files by loading the...
In this video, Gary from MacMost gives some tips on how to set up a new printer with your Mac. Some printers don't work for Macs, so make sure it's compatible before purchasing it, by checking the internet. Check if a USB cable comes with a cable and buy one if necessary. Ignore the CD that comes with the printer, because it probably doesn't have the correct Mac drivers. Leopard or Snow Leopard systems will find the correct drivers for you automatically most of the time. You might need to dow...
Hands are a tricky thing to draw. Not everybody can get them right. It takes times and practice to draw hands realistically. This particular tutorial will show you how to draw a hand making a "peace sign". Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.
The Wedge ROP is a render output driver, which can be used to change variables on the fly while rendering. This can be very useful when simulating, in that you can test out different parameters to see the different results. It's a relatively new feature in Houdini 9.5.
Make your router run on VTEC by injecting it with Tomato Firmware. Tomato Firmware gives you excellent tools such as being able to monitor bandwidth consumption, boost WiFi signal, track results with graphics and much more.
IMVU is a 3D avatar chat, instant messenger, and dress up game. Get help with all of your IMVU avatar needs with these IMVU tips and tricks! Watch this video tutorial to learn how to clean up an IMVU avatar in Photoshop.
There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.
There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.
There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.
Kick back with John Park as he demonstrates how to upcycle a no-longer-usable shopping cart into an easy chair. This Make: magazine-based project offers an introductory look at how to cut, bend, and shape metal using metal cutters, saws, vice grips, and other tools common to home workshops. John also attempts a “deluxe” version of this project that employs motors and switches to transform it into a “go-kart chair.” View the clip to see his mixed results, and download the PDF.
This video will show you how to fake a RAM, Flash, or entire memory clear. Lots of teachers and test administrators go around and clear your calculator so students don't cheat. This is any easy way to subvert the teacher's security measure. This is a good thing to know if you want to cheat on your GED, SAT or ACT test / exam.
This homemade cake mix can turn your least kitchen-savvy friend into a star baker. And you’ve done 90 percent of the work, which is the greatest gift of all.
How to Use Your Mac as a Server: Turn your Mac Mini into a server! Yes, that's right, with a little know-how and a little spunk, you can turn an inexpensive Mac Mini computer into a server to provide services over you network. You won't even need the Mac OS X Server, just the Mac OS X Client, so there is no extra software to buy, just the Mac Mini and it's operating system.
