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 662nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add or average while ignoring values in hidden rows. In addition you can ignore both Hidden Rows and Error Value.
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...
In this tutorial, we learn how to create flashcards with Keynote to use on an iPod touch. First, go into Keynote and choose the flashcard with the plain white background. To format this, click 'masters' on the toolbar. Now, choose "title-center" and make the first slide the question slide and the second slide the answer slide. Double click the text box to insert text into each different card. Next, to add a picture, click 'photos' and insert a picture you already had loaded on your computer. ...
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.
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...
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...
In this Computers & Programming video tutorial you will learn how to make a favicon for your site in Photoshop CS3. A favicon is a little symbol that shows up on url bars and also on browser tabs. Open a new project in Photoshop by pressing ctrl+N. Select height and width to 64 pixels and click OK. Now open the title tool and type in whatever you want. In the video, it is ‘F’. Open the background layer and do a color overlay of black. Now change the color of the title to white so that it ...
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.
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...
Replay AV is the newest software to come out for downloading steaming audio from the web. Replay AV allows you to download audio from different sources all over the web. You can even record radio broadcasts and set your account to record the station. This video will show you how to add a radio station to Replay AV.
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...
First log into your Facebook account and sign in. Then when you sign in click under your "profile". You will be redirected to another page. This will be your main page, with all of your information that you have put in and what not. Next click on 'Photos'. It will take you to another page. Once in your in there, you will click on 'create a photo album'. You need to name the new album and then create album. Next it will ask the location of the files. It will be located on your computer. Usuall...
To start off the process of publishing your access database online we first look at a sample MS ACCESS database with typical formats and a online searchable application where users can search by library name or city and get details of the library. There are 3 steps to publish the database. The first step is importing data which can be done through clicking on the file menu and then click on import data through a Microsoft Access Database. Now select the file you want to import through the bro...
This video tutorial demonstrates tips for how to organize your home office when you are visually impaired. Here a rehabilitation specialist is helping a visually impaired person. The person who is visually impaired should know what is visually important to him/her. Mostly these people obviously need to know where every thing is because they don’t have their eyes to depend anymore. Here visually impaired person is 66 year old Deanne Jackson. She has wet macular degeneration. In order to set up...
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...
