Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
Managing your busy schedule just got easier in Entourage 2008 for Mac. Using the powerful Entourage Calendar feature lets you organize your time wisely. The Microsoft Office for Mac team shows you just how to organize your schedule with the calendar in this how-to video.
Not everything that Facebook does is in the best interest of its users. Just look at past examples such as social ads, facial recognition, and instant personalization. Users were perfectly fine without these, and they still are. And now there's another annoying problem that Facebook users have to deal with—the ticker.
The Zone AF option on the Canon EOD 7D is a brand new feature, and it lets you select a cluster of AF points, which could be in center or off-center. In this video, see how to actually use the Zone AF selection on your digital SLR camera.
On November 18, 1928, a star was born. His name: Mickey Mouse. Walt Disney's most famous character appeared before that date, but November 18 is known as Mickey Mouse Day because that's when he appeared in "Steamboat Willie," the first cartoon to feature synchronized sound. That short animated film is now in the public domain as of January 1, 2024.
Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to use the iPod and Genius on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.
The Google+ Sparks feature is a kind of social search that allows you to find and read different articles and websites that have been selected by the people you follow and other Google+ users. It can help you find interesting posts and information on a specific topic.
After beating chapter 2 in Disagaea 4, the Cabinet feature for multiplayer unlocks. This allows you to interact with other Disgaea 4 Playstation Network players within the game. This guide overviews the functionality of the Cabinet, as well as how to use the Red Cell Phones in game to call upon other player's characters.
Mirror Mode is a feature provided with the Motorola Droid Bionic that allows you to connect the Android smartphone to an HD TV or computer monitor via an optional HDMI cable. Then, you can watch HD videos and look at pictures you've taken with your Bionic on your TV or computer. This guide will walk you through the process of hooking up the phone to an HD device.
Similar to the Wii, Nintendo frequently updates the apps and software on the Nintendo 3DS. These upgrades are always available using System Update under the system settings on the gaming handheld. Take a look at this guide on how to access the System Update feature, download, and install the updated software. Now you can always access the latest version of the Nintendo 3DS software and apps, such as the eShop and internet browser.
The Motorola Droid 3 smartphone is capable of recording 1080p video, and while the screen on the Verizon Android phone is large, wouldn't it be nice to look at all the pictures, games, and videos on a bigger screen? If you have the right kind of HDMI cable nearby, you can connect your Droid to an HD device using the Mirror Mode feature.
Did you know that Google Chrome has a feature called Incognito Mode that allows you to browse the web without having your history recorded or any cookies downloaded? It's perfect for shared computers, but by default you have to turn it on every time you open the browser. Watch this video to learn how to make Google Chrome default to Incognito Mode, removing one step between you and anonymous browsing.
Most good rap songs, or at least those modeled on the 1990's model, feature a thumping sub bass track designed to max out whatever size subs you've got. If you want to produce classic hip-hop beats yourself, watch this video to learn how to create epic sub bass synth tracks in Reason 4.
The Motorola Droid was one of the first and is still the most popular Android phone. It's hardware keyboard, a unique feature among it's competitors, will keep it there for a long time, but it's performance is starting to lag behind. Why not overclock it's processor, giving it some much-needed speed? This video will show you how to overclock a rooted Droid the easy way, and help you make your phone work faster.
The slide effect is a popular feature of many websites that allows information to cascade out from an item on a page and the rest of the page to adjust accordingly. This effect is created using the SlideToggle() function in jQuery, the popular Javascript library. This video will teach you how to use it to make your website much easier for your users to access.
Flash and Actionscript can be used together to create damn near any sort of animation or website feature that you could want. This video will teach you how to do just one thing: generate a random frame using Flash CS4 and Actionscript 3. This is handy if you want to create a button that will link to several different objects randomly. Fun if you want to add the zest of unpredictability to your user's website experience.
In this tutorial, learn all about how to use a Barnes and Noble Nook e-reader from top to bottom. This helpful clip will walk you through every single feature so that you will be reading wirelessly in no time. Not only is the Nook easy to use and carry around, it is also inexpensive (as of June 2010), why not give it a try?
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 230th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel List Table feature to make a dynamic stock price line chart.
We don't know about you, but making selections around oddly shaped areas of an image is one of the most frustrating single tasks in Photoshop. Odd shapes are really hard to navigate around by hand and often you can't get a perfect cut. Luckily, this Photoshop tutorial will guide you through how to make complex selections easily in Adobe Photoshop CS5.
Want to pitch correct vocals on your Mac without dropping $120 on Antares Auto-Tune? If you've got GarageBand 2, you can — and easily at that with GarageBand's own, built-in pitch correct feature. Get that pop radio sound with this how-to.
Aperture's web gallery feature allows you to use your MobileMe account to quickly and easily publish sophisticated webpages that are synced directly to your Aperture library.
3D modeling tool Mayafrom Autodesk is a monster of a program, able to do SO many things. One of the things you'll need to learn is how to use the CV Curve tool. This will allow you to create objects with curves of any shape or dimension you desire. Let's be honest, most of your models will require curves, so check out this tutorial and find out how to do it. Maya is used in everything from small animation to feature films like Spiderman. If you want to be in the biz, expand your skill set wit...
In this tutorial, we learn how to file a player complaint with Microsoft (Xbox 101). There is no tolerance for file complaints, cheating, rude remarks, and anything of that nature. The file complaint feature should only be used if someone really violated the code of conduct. When you feel someone has crossed the line, you will tap the guide button, then select friends. From here, choose the person from the group and identify the complaint. View the profile of that person, then you will be fin...
Searching your phone just got easier with Google's Android operating system for your cell phone. With the Android Quick Search box feature, you can easily search your phone or the web, right from the home screen. It even provides you with search suggestions while you type. Watch this video tip to see how to easily search both your phone and the web with Quick Search box.
One of the greatest things about Google's Android operating system is the ability to "long press" on your cell phone. The android platform is full of many surprises and features, and this is just one of them. Long press (or 'touch and hold') is a nifty feature that reveals additional functionality on your Android-powered phone, like long pressing a picture to edit or share it, and download pictures from webpages, and get more options on your email.
You have a ton of options and extensive possibilities on the Canon EOS 7D to configure different buttons and controls. You can change just about anything on this digital SLR camera. Watch this video for info on customizing operations.
You can easily share and transport your photo and videos on the Canon EOS 7D by using the wireless file transmission option. See exactly how sharing and downloading your files to computers and other devices works in this video. When the digital SLR camera is combined with the WFT-E5A Wireless File Transmitter, transmitting is easy.
There's a new LCD viewfinder on the Canon EOS 7D, and in this video, you get to see all about it. See how you can change your viewfinder options on this digital SLR camera with ease. You can display almost any information you want.
The EOS 7D has an accurate level display, which you can activate on either the read LCD monitor or in the viewfinder. See how to work the electronic display on the Canon digital SLR camera. This is great for getting a steady shot wherever you need it.
The Canon EOS 7D can be fine-tuned to adjust its auto focus to suit nearly any subject. See how you can customize your AF functions to get the best focusing options needed for your desired result. This video breaks down everything.
See the workings of memorizing AF points on the Canon EOS 7D digital SLR camera. It's easy to memorize points and come back to them whenever you want, by just pressing a button. See how to use the memorization option in the video.
You can gain even greater precision on the Canon EOS 7D digital SLR camera by using Spot AF or AF Point Expansion. When you manually choose one AF point, you also have the option of changing its size. You focus point will be exactly what you want. Very specific.
Let your Canon EOS 7D do all the hard work. With the AF Point Selection option, the digital SLR camera will do all the focusing for you. It's easy to compose and shoot in just one step.
Sure, you've probably seen a million YouTube videos that feature the impressive schemes of 2,000-sided modular origami balls that seem to defy gravity as well as patience. But sometimes the simplist origami craft is the most striking.
We all make mistakes and in this tutorial, learn what to do if you decide to go back and change a word after you've already typed it. Fixing a word with Swype - the fastest way of text messaging - is super easy and won't slow you down at all. So, if you've typed that rambling, soul baring text message at 3 am and want to go back and change a few choice words save yourself with this feature.
Sending e-mail on the go is a must these days. People seem to be working 24/7, don't they? If you've recently bought a new HTC Magic cell phone, this tutorial will show you exactly how send an e-mail from your phone to anyone, just like you would on a computer. This is a very handy feature and is easy to access.
Spaces is a very cool feature that is included with all newer versions of Mac's OS X. With Spaces, you can organize your programs and keep your desktop clutter free. This program is similar to Expose, but instead of having your windows open on the desktop, Spaces minimizes them but keeps them ready for a quick reload. You can choose a number of spaces and decide which shortcuts you want to use to access them.
If you have a iPhone then you can assign a photo or a ring tone to any of your contacts. With this feature you can know who is calling just by the sound of the ring tone or by seeing their picture if the phone is in silent mode. To do this open the contact and tap on the edit button at the top right corner. Now tap add photo. This allows you to take a new photo with the integrated camera or choose a new photo from your library. To assign a ring tone tap assign ring tone and choose the tone fr...
Live View wit the EOS 7D camera from Canon, lets you compose and view your subjects with the LCD monitor as your viewfinder. This is great for a multiple of reasons. See how to use live view on this digital SLR camera.
You can use the Canon EOS 7D to shoot digital video at a variety of frame rates and resolutions up to full HD. In this video, see the basics of movie mode and how to use it. This is the best digital SLR camera to film video with.
