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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove duplicate records using the Remove Duplicate feature which was new in Excel 2007.
New to 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 Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP & data validation to make an invoice when the product list is on a different sheet or different workbook.
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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
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 and Mr. Excel, the 45th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract a number from a text string.
The Georgetown Army ROTC program first describes the benefits, and then demonstrates a proper army pushup to standard. Pushups are common in the army, they increase the strength and endurance of your chest, shoulders, and triceps muscle. The push up is also a part of the Army Physical Fitness Test (APFT). In order to be contracted and received scholarship benefits male cadets in the age range of 17 - 21 must perform 43 pushups while female cadets in the same age range must perform 19 pushups.
New to 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 Excel tutorial from ExcelIsFun, the 232nd installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally sum by array formula in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 185th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use Advanced Filter to extract records from a table with 1 criteria, then use a Macro to automate the process.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 483rd installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use both the sort and filter tools in Microsoft Excel.
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to prevent Excel from displaying a 13-digit number ID in scientific notation using the number formatting tool.
This is a tutorial video from Sessions Online Schools of Art & Design's "Photoshop Basics" course. This video is part of Sessions' Graphic, Web, Multimedia Arts, Digital Arts, and Marketing Design certificate programs. You are distorting layers using the transform tool. Use the line tool to check the work. GO Edit: Transform - Distort.
This video shows you how to remove the Digital Rights Management(DRM) protection from iTunes music. DRM is a way for Apple ITunes to control your music and where you save it. Hack the iTunes so that it does not interfere with you like this.
The best way to transfer contacts from a computer to an iPhone is to use Mobile Me, formerly known as Dot Mac, which automatically synchronizes Outlook or Entourage with the iPhone. Keep track of contact information, on both the computer and the iPhone, with tips from a digital technology specialist in this free video on the iPhone.
Do you have hundreds of assets in your Final Cut Pro project, but you are only using a percentage of them in your sequences? Want to find out how to get rid of the unused assets in your Final Cut Pro project quickly? Watch this Digital Media Dude podcast and learn how to search for unused assets in Final Cut Pro.
Tagging real walls can get you in a lot of trouble. So why not let out your creative urges in Photoshop? This Photoshop CS3 tutorial shows you how to make digital graffiti on a digitally made brick wall. Watch and learn how to use layer effects and lighting to create graffiti text in Photoshop.
Check out this instructional cinematography video that shows you how to build the Genesis Super 35 Digital Cinematography Camera System. Watch and learn as this instructor sets up the Panavision Genesis camera and prepares it for a shoot. This cinematography tutorial is perfect for professional filmmakers.
Watch this quick instructional cinematography video that shows how to balance a Canon XL2 professional HD digital camera on a GlideCam 4000 Pro. Learn how to secure the camera using this handheld camcorder stabilizer to prevent unwanted swaying, shoot fluid traveling shots, and produce professional works.
This video shows you how to upgrade your consumer camcorder sound capabilities using a camcorder XLR adapter, a simple device that mounts to the bottom of the camera. It then tests and compares the various types of microphones that can be attached, including the lavalier, sennheiser, handheld interview, and the wireless clip-on microphone. WAtch this helpful instructional video, and boost the sound on your camcorder for professional audio.
All you need is a basic digital camera and GIMP photo editing software to create your own version of the Pan's Labyrinth creatures. The Keyboard Shortcuts used, in case you can't hear it properly:
Ever wish you could see in the dark? Well, you can't but this how-to will show you a way to build a device to help you out. You will need light polarizors, a flashlight, and a digital camera. Make an infrared night vision device, just follow along with the steps in this video tutorial. Now you can see at night!
Want to challenge the filmmakers who spend millions of dollars on their films, yet, still have the nerve to call themselves indie? Pick up a 35mm adapter or build one yourself and you can give your movies that "film look" and start being taken more seriously!
Israel Hyman is a weekend videographer headquartered in Mesa, Arizona. In this video, he demonstrates how to use “Shutter Speed” to make your digital video look better. A rule of thumb is: Set the shutter speed at a rate of 1/60 of a second for normal shooting.
Little girls are always in a rush to look just like their mommies. Just think pint-sized fashionistas like Suri Cruz and Courtney Cox's daughter Coco, who was recently caught by the paps wearing the same ruby lipstick as her mommy on a stroll. While we don't think that wearing makeup is all that age appropriate for a five year old, beautiful, youthful hairstyles are.
Many survivalists believe that MRE's are the way to go for survival food supplies, but they are expensive for civilians and there are storebought options that work just as well. This video will teach you about a wide variety of storebought foods that will keep for ages and make great fuel for any survival kit.
If you've been interested in making a unique, smooth sculpted trestle table, look no further and watch this video. The trestle table is one of the oldest table forms known to man and its elegant yet sturdy form lives on to this day.
This is a fun craft for a child of any age, which teaches how to make an octopus out of yarn. All you need besides the yarn is a pair of googly eyes, glue and scissors. And a few decorations, like a pom pom or foam flower, if you want.
Dryers are big, noisy, and prone to breaking. If your clothes dryer is starting to show it's age, watch this video for tips on how to fix it up and make it work like new again. Basically, just clean the dang thing.
There are a lot of great pranks that are NOT appropriate for children to perform. Not only are they in the wrong environment, but their limited emotional development hamstrings their ability to handle serious pranks properly. This video will show you three pranks that are appropriate for all ages and use common household materials. The include the Ceiling Bowl Trick, the rubber-band-sink-sprayer, and the classic egg-in-the-doorframe prank.
This next tutorial isn't for anyone under the age of 18 and it should be noted that this video leads to the finding of naked women. With that said, the guys from Achievement Hunter will be showing you the location of all five hidden Playboy Playmates in the demo for Mafia II. These can be found in some pretty hard places and can be missed if not paying attention.
Summer is almost over and that means the end of summer vacation and the start of the new school year. During this transition, parents and students get ready for the new year by purchasing a variety of different materials. Pencils, paper, books, testing sheets, etc.
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to create a day and night cycle using the level editor that will make your games feel much more real. The creator included a download for a trigger library, but does not explain how to...
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to use Galaxy Editor to make Warcraft 3 style shops in your custom map where you heros can buy and sell items. If you want to make a Starcraft 2 RPG (you aren't alone) watch this.
Starcraft 2, like so many modern games in this age of modding, has a really robust level editor that's going to extend the lifespan of the game for years. You can edit almost anything about any of the game's many units buildings and maps, and make the game however you want it to be. This video will show you how to create a map, add custom abilities to a Terran unit, then blow up some Zerg with it. It's quick, fun, and a great place for beginners at Starcraft level editing to get started.
This one's good for all ages, and is pretty simple to execute, once you know the "tricks" to the trick. Watch this to see how the 'color changing four' card trick is performed. There's not a lot of practice involved and is perfect for a magic beginner, intermediate magicians and even the experts. Check it out. Try it. Love it.
In the confectionary world the way you ice or present a cupcake is just as important as how good a cupcake tastes. Thanks to cupcake bakeries like Magnolia Bakery in NYC and Sprinkles in L.A., the age of the yummy and chicly decorated cupcake has officially been ushered in. Make your own cupcakes that much more in line with the times by watching this cupcake decorating tutorial.
Eating healthy does not mean crunching on cardboard 24/7, even if that's what your kids think. While it's always easy to reach for a neat package of Cheetos and toss that into your kid's lunchbox for school, doing so means you're giving them a hefy serving of artificial coloring (some of which has been linked to cancer), artificial flavoring, and high fructose corn syrup.
Adobe Photoshop is the industry and personal standard for editing photos on a computer. If you have a digital camera, or ever want to have a digital camera, you need to know how to use it. This video series will show you everything you need to know about using Photoshop's many tools and options to do just about anything you want to a photo.
Not TOO many Western people want to see the United States nuked into the stone age. Some do, but not too many. Now you can simulate the effect on your computer! This video will show you how to use After Effects to simulate the effect of a nuclear blast or other major explosive catastrophe on a map of the US in 2D. This effect is used in many video games and movies, so master it yourself and we promise that you'll find cause to use it again at some point.
In this French lesson, you'll learn the basic French pronouns. In the French language, pronouns like "I" and "she" are already familiar around the world, but others like "us" or "them" are unknown. Learn all of the following words in French"
Using aspirin to treat acne is an age old remedy for skin blemishes. Learn more about treating acne from a dermatologist in this skin care video.
Sushi on your face?! Okay, not really. Rather, applying seaweed to your face will help restore moisture to skin, helping with anti-aging efforts.
