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 use the left handed column options in Gmail. First, log into your Gmail account, then click on your different emails. Open an e-mail by clicking on it, then click reply to respond to it. You can also save this, and it will save to your account. If you want to delete a message, simply select it and click on the delete button. It will now be moved to your trash, where you can keep it, or you can delete that, which will remove it forever. If you want to write an...
Want to rename a group of files on your Mac computer without going through them one at a time? Rename them en masse with a free application! This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just under two minutes. For more information, including complete, step-by-step instructions, take a look.
If you use iBooks on your iPad or iPhone, you can only read books in EPUB format. If you have books in text or PDF format you may want to convert them to EPUB so you can read them in iBooks. You can do this with Calibre, a free open-source e-book library application. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the process in about five minutes. For more information, including detailed, step-by-step instructions, watch this Apple lov...
Learn how to use Automator to convert selected text, or text from a file, to audio. You can listen to the result on your Mac, iPod or iPhone while on-the-go. It's easy! So easy, in fact, that this home-computing how-to from MacMost can present a full overview of the feature in exactly four minutes. For more information, including detailed, step-by-step instructions, watch this Apple lover's guide.
We all have our reasons for erasing personal data from a phone. Whether you just ended a bad relationship whose face you never want to see again (lots of text messages) or just want to restore your privacy on the cell phone, erasing may be your only option.
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.
You can hack you XBox 360 as perfectly as you please, but if you don't burn the games that you want to play on it properly than it will all be for naught. This video will teach you an important part of the process, using AGBX360 and S360X to stealth patch your .iso game files and make sure that they are SSv2. Taking these steps will ensure that the games you are burning are ready to be played on XBox 360's and ensure greater enjoyment of you XBox hacking experience.
In this video tutorial, viewers learn how to save and swap icons on a Mac OS X computer. Begin by selecting the application that you want to get the icon from, and copy it. Then open preview, go to the File menu and click on "Create new clipboard". Users are also able to apply the icons on other applications or drives. After you have copied the desired icon, select the application with the icon that you want to replace, press the Command and I buttons, select the icon and paste the copied ico...
Mobile Me will allow you to access your home Mac computer from another computer, using Back To My Mac. In order to use this, you will have to sign up for a Mobile Me account. You will have to sign up, using both computers or all of the computers that you hope to connect. Sign up under System Preferences. Turn on Sharing: both screen and file sharing.
Layer comps let you assemble multiple image variations or even independent pieces of artwork inside a single Adobe Photoshop file. The Layer Comps palette gives you the freedom to explore. Whether you're new to Adobe's popular raster 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 instr...
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:
This clip explains how the Adobe Premiere Pro CS4 Media Browser panel can save you time and keep your projects tidy. Also learn about Equalize Volume within Soundbooth to make volume matching files easy. Whether you're new to Adobe's popular non-linear editor (NLE) software or a seasoned video 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 detaile...
Shine effects are one of the cooler and more popular effects that you can add to a title in After Effects. Many people use Trapcode's Shine plugin to accomplish this quickly and easily. But that costs extra money! This two-part video will show you how to create shine effects in After Effects without having to download any additional plugins. If you already shelled out the dough for After Effects, we know you don't want to spend any more, so watch this video!
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.
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!
RayFire is a really powerful (and expensive) plugin for 3DS MAX that is designed to facilitate destroying, shooting, and otherwise causing harm to your 3D models. No, it won't destroy the files, just the images, which is very important for video games or film work. This two-part procedural video follow one artist as he creates a demolition video using Rayfire inside 3DS MAX.
In this video tutorial, viewers learn how to add the "Show Desktop" button in Windows 7. This task is very fast, easy and simple to do. Users will need to download the freeware from this site: German freeware. Once downloaded, users will then need to extract the file and pin it into the task-bar. Users may also use the keyboard shortcut by pressing the Windows button and M. This video will benefit those viewers who use a Windows 7 computer, and would like to learn how to have a Show Desktop b...
With this quick Blender 2.5 video tip, you'll see how to stave off frustration in the case of a crash or lost work by using Blender's autosave feature to recover your work. 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 from the folks at CG Cookie. For more information, including step-by-step ins...
In this quick Blender 2.5 video tip, you'll see how to use the new external drag and drop functionality recently added to Blender. This feature enables you to drag and drop images and videos from your operating systems file browser into Blender. 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 from...
L4D2, or Left 4 Dead 2 for those unfamiliar with the game, is a great PC shooter with a really robust level editor. This video will teach you how to create a survival mode map in the editor, allowing you to bring your creativity to bear on improving your L4D2 experience.
One of the coolest parts about modern PC shooters is that most of them include level editors, allowing you to create the map of your dreams. This video will teach you how to make a scavenge game mode map in Left 4 Dead 2, Valve's zombie shooting fest from last year.
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!
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.
If you've spent a ton of money on your newest smartphone, you will want to make sure it's secure. In this tutorial from the experts at PCWorld, learn exactly how to activate safety mechanisms on your Android. With these options you can set a complicated passcode (so that anyone who does find your phone won't be able to access your files) and you can also set up a locator. By using the location app, you can text your phone from anywhere else and set off a search alarm so you will be able to fi...
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.
Ever wish there were a way to get a peak at what's inside a zip archive without having to unpack it? Well, with Mac OS X and Quick Look, there is. And it's easy! So easy, in fact, that this home-computing how-to from Tekzilla can present a complete overview of the process in just over two minutes. For specifics, and to get started previewing the contents of zip archives without expanding them, give this guide a look.
In this video tutorial, viewers learn how to import, manage and export 16:9 footage in Adobe Final Cut Pro. Begin by opening the Log and Capture.Then configure the Logging, Clip Settings and Control Settings. For the Control Settings, set the Device Control as Fire Wire NTSC and the Capture/Input as DV NTSC 48 kHz Anamorphic. Then scroll through the sequence setting of the footage and check Anamorphic. To export, click on File and select Export. Click in Options set the the size to Compressor...
Hulu is a great video site, but unfortunately the TV shows and clips they show have a time limit and won't always be there for you to watch.
If you have recently changed computers, or lost your music files, or even if you are just looking to share amongst multiple PCs; check out this tutorial and learn how to import songs into iTunes off of your iPod. This is a sort of backwards import, because normally you would be exporting your music ONTO your iPod.
In this tutorial, Luke shows you how to change your default PDF reader on your Mac computer. There are various programs that can be used to read PDFs and you don't have to decide on only one. Your Mac is probably pre-programmed to open up the "Preview" application when you click on a PDF file, but if you'd prefer to use something else, such as Adobe Acrobat Reader, there is an easy way to change your default. Check out this tutorial, and set it up in just a few minutes.
By default, iPhoto will open as soon as your Mac detects a digital camera or iPhone. In this tutorial, learn how to change your iPhoto settings so that it does not automatically open. The auto open is a good feature, but can be annoying, especially if you are just using your computer to charge your device and do not need to import any files. iPhoto's auto-open can disrupt other activities you may be involved in on your computer. In this video, Luke will take you step by step through the proce...
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...
Whether you're new to Adobe Photoshop or a seasoned digital photographer after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. New Photoshop CS5 helps you achieve the visual and emotional effects you’re after with re-engineered features for reducing and adding grain, performing post-crop vignetting, and sharpening. CS5 reinvents HDR imaging with Exposure Merge, which makes it easy to preserve the fu...
This video instructs you how to use the "Finder" Button if you own a Mac on OS X. The "Finder" window shows the Mac user the contents of the hard drive. It describes functions of the Finder folder: i.e., adding an untitled new folder in the Finder file. It also discusses how you can view the "Finder" in a variety of layouts: grids, lists, etc. The video shows you how to use the buttons on the upper left hand corner of the "Finder" screen to maximize, minimize, or close the window. It also dis...
Is your digital SLR camera creating an unintentional "Jello effect"? Well, this is caused by a rolling shutter, which can be fixed in Adobe After Effects. This tutorial serves to help you eliminate your problems on your D-SLR caused by the CMOS's "rolling shutter".
Have you ever hated the latest version of an app? Wish you could go back to the version you had before? This video will show you how you can revert to the previous version of an application that you have recently updated.
This video speaks about removing sensitive information in Adobe Acrobat 9. The viewer might get a very obvious idea of removing sensitive information by redaction. Redaction is the process of permanently removing sensitive information from a PDF file. This is done by opening the Advanced menu, clicking "Redaction" and then clicking "Show redaction tools", which can be in any format, images or text. The viewers will definitely get a clear idea of removing such sensitive information by redactio...
This video instructs the viewer about the basics of cloud computing, using more than one computer and managing your computing needs online. The instructor explains, "Cloud computing is a metaphor for using the Internet for your computing needs." A program called cloudo, allows the user to store information online through an interface that looks like a regular computer desktop; then the information can be accessed via password from any computer with an internet connection. Other programs also ...
