We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...
Learn how to quickly set up your brand new LG env3 with its Easy Set Up and Set Up Wizard features. Did you just get your hands on the new LG env3? Don't waste any time reading the manual - this video will walk you through the phone's Easy Set Up and Set Up Wizard to get you up and running in no time!
This video tutorial is an easy intro to making gradient text in GIMP… the free Photoshop alternative. It's easy to make your text a little more fancy with a gradient. It's so easy to use a gradient, that you have to learn it, or you'll never forgive yourself. This is GIMP 101. Learn it. Master it.
If you're trying to earn those unlocks quickly in Fifa 12, take a look at this guide featuring three easy ways to boost your virtual pro accomplishments in the game. Step 3 of the guide can be ignored, as there is an issue with Fifa 12 and the Creation Centre.
This simple how-to from Buildpedia shows every DIYer how to "sweat pipe", meaning, how to solder it together. This is a simple technique that's easy to get the hang of. You'll need a solder kit, the pipes want to solder, an aceteline torch and a few other things.
If you're looking for an easy spruce up to your house, try repacing the light fixture. This is an easy task you can do safely that will give your house or apartment and fresh new feel. Check out this DIY elctrical task today.
Glass normally doesn't conduct electricity, but there are all sorts of cosmetic and industrial applications for conductive glass. There are easy and hard ways to make it. This video will show you one so easy you can do it at home with only four ingredients: glass, Stannous Chloride, toothpaste, and alcohol.
Once you've unlocked Dead Ops Arcade in Call of Duty: Black Ops on the Xbox 360 (and PC), you can start earning some more achievements, and this video will show you how to get the "Easy Rhino" achievement. The key to earning this one is to NOT kill any of the zombies until they're in a large group, then point at them and press the Right Trigger (RT) to burst and that's it.
"This Love" is the song that ensured that Maroon 5 would stick around for a while. Their new albums don't stack up too favorably to good old Songs About Jane, and if you're feeling the nostalgia watch this video to learn how to play an easy version of "This Love" on piano.
Perhaps the two oldest and most-used computer pranks in the book are presented is clear, easy-to-understand language in this video: the printscreen frozen desktop trick and the fake shutdown virus icon trick. If you don't know how to do either of these easy and devestatingly effective pranks, watch on.
Don't worry ladies, you can make an easy costume that is both scary and sexy this Halloween, and this video will show you how to do it. It contains detailed instructions for doing the makeup and costume for a sexy female mad scientist. MUWAHAHA!
IF you don't mind carrying a small table-like protrusion around all night on Halloween, we've got the Halloween costume for you. In this video you'll learn how to make an easy DIY Head for Dinner Halloween costume that will shock and amaze.
There is something to be said for the idea that every person needs to know one really awesome magic trick. If you don't know one yourself, and need something to impress your friends and fellow bar patrons, you're in luck. This video will show you how to do an easy sleight-of-hand trick disappearing trick with a cork that will fill that hole in your skills lineup.
No one in their right mind would ever volunteer to be one of the Red Shirts, the security officers from Star Trek who so often died during the crew's away missions. Well, it is a pretty easy-to-make and easy to recognize costume, so it might be a good choice for your next nerdy Halloween party or other get-together. This video wills show you how to make a Red Shirt shirt of a long-sleeve shirt and paint.
iChat is gaining steam as a mainstream online chat program. Fortunately for you, you little prankster, it is exceptionally easy to change someone else's iChat away message to whatever hilarious thing you want from your computer! This video will show you exactly how to do it, with no software to download or anything. Aren't easy hacks great?
Wish finding Greasemonkey scripts were easier? With the Greasefire Firefox addon, it's super easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
In this clip, you'll learn how to synch bookmarks between two or more installations of Chrome. It's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
Interested in creating a map of all of your Facebook friends? With Microsoft's Bing, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over two minutes. For more information, including step-by-step instructions, take a look.
Want to put the extend the OS X menu bar to a second monitor? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Interested in viewing old, historical photos of the places you know on Google Maps? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Interested in adding a spell check function to any Windows application? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Need help figuring out how to remotely unauthorize a computer from accessing a file you've downloaded from iTunes? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Want to Google Earth-style bird's eye view of a given address? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Want to know how to find and play a Flash version of Pac-Man on Google? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Looking for a quick guide on how to use autoscrolling in Firefox? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Interested in making Firefox save your browser state more frequently to protect against crashes and outages? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Wish there were a way to unclose a Chrome tab you've accidentally clicked away? Well, there is, and this clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Looking for a way to keep up with your favorite YouTube channels via RSS? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Looking for an easy way to keep up with your Facebook comments and wall posts on an Apple computer? This clip will show you how it's done. With the official Facebook Desktop Notifications app, it's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Want to create Mac-style stacks in your Windows 7 taskbar? This clip will show you how it's done. With Piles, it's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Looking for an easy way to impress the math geeks in your life? This brief clip from the BBC will help you memorize pi to eight decimal places without breaking a sweat through use of a simple mnemonic device: "How I wish I could calculate pi easily today." (Hint: Count the number of letters in each word.) Easy as pi(e).
If you recently purchased Castlevania: Harmony of Despair on your Xbox 360, this next tutorial will help save your life. In this strategy how to tutorial, you'll find out how to defeat the game's most difficult enemies, the stage bosses. Each one has unique powers and attacks, but they also have some different weaknesses as well. They're easy to follow and should be easy to follow. Good luck and enjoy!
Turn your American Apparel Le Sac dress into a cute Gathered Mini. It's a fun look and really easy to accomplish. The Le Sac dress has at least TWELVE different configurations for you to enjoy, which means more closet space, and less laundry! It can be a totally new dress each day of the week. Follow along and get this easy, sexy style that's perfect for summertime.
Head massages are great releases after a long day. They are easy to learn and easy to give once you know how. When giving a head massage, it's important to remember that personal preference for the amount of pressure used varies greatly from person to person. Learn about giving a good head massage with help from Gretchen Rivas, a massage therapist from Relax Wilmington in Wilmington, NC. Learn these professional secrets from a masseuse in one of America's loveliest cities.
Don't know how to seed a pomegranate the easy way? Make a mess every time? It's okay, you're one of many—you're not alone. In this how-to from Food Wishes, learn a secret trick that's well known in the restaurant biz to get those seeds out easily.
This video tutorial details how to set up Canon 5D MK II footage on Final Cut Pro. After watching this, you'll be able to create an easy setup for your project. It covers using the Audio/Video Settings option and using the Sequence Preset Editor to maximize your project workflow. See how to create the Easy Setup!
Learn everything you could possibly want to know about the internet, multiplayer game Evony with tutorials from EvonyTutorials. Watch this video tutorial to learn how to play Evony - an easy way to get prestige. See exactly what the game Evony is!
Check out this informative video tutorial from Apple on how to get started using Keynote '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to organize your slides in Keynote '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in Pages. Numbers gives you simple ways to make sense of your data. You'll captivate your audience with new and sophisticated features in Keynote.
Check out this informative video tutorial from Apple on how to add audio and video to presentations in Keynote '09.