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 208th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the keyboard ctrl-enter keyboard shortcuts to speed up common tasks in Microsoft Excel.
Whether you're new to Adobe Photoshop or a seasoned graphic artist 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. In it, you'll learn how make fast work of common design and production tasks like image re-touching with magical content aware fill in Photoshop Extended, creating complex shapes with Shape Builder tool in Illustrator, and intuitive object-selection features in InDesign and more.
Alley-oop! Surfline's Timmy Curran gives an explanation of how to perform a good alley-oop by providing professional tips. Remember: performing an alley-toop requires good timing.
One of the coolest feature of the 3G iPhone is the high speed, always on, Internet connection. Having a constant connection to the Internet is pretty much a must have for any dot com mogul. The main problem with the iPhone is the screen is too small to do any serious Web surfing. Yes, it’s great for Twitter or checking up on emails but blogging from it is an exercise in frustration. Fortunately, there is a way to extend that 3G connection onto your laptop by turning your iPhone into a wireles...
The trick is to pop the cork with style and flair—and without creating a dangerous projectile. You will need a cold bottle of champagne, a towel, a bucket of ice water, and salt (table or rock). Tip: To speed up the chilling process, ass cold water and a little salt. Watch this video to learn how to open a bottle of champagne.
This software tutorial shows you how to use Magic Bullet Frames plug-in. The plug-in is available for After Effects, Final Cut Pro,k Premiere Pro and Motion. Magic Bullet Frames allows you to take interlaced video and get the 24p look of film, right from within your editor — at high speed and high quality. Get started with Magic Bullet Frames in this After Effects tutorial.
This music production software tutorial shows you how to create Glitch-type effects for use with your drum patterns in Reason 3.0. It is an advanced tutorial only because of the speed at which he has to cover the material. In this example Ace Pincter will be adding glitch effects to drum patterns using Dr. Rex, but you can use any Reason drum pattern. Included: RV7000 Gating, Automation, Matrix offsetting, Filtering by gate, and Distortion.
Learn to fold T-shirts the Japanese way with English instructions. This is a speed trick for great shirt origami folding.
Have a million 3-inch reel-to-reel tapes piling up in your garage? Keepsake audio tapes?
By customizing your keyboard shortcuts, you can speed up your image editing work flow significantly.
One of the best ways to spice up your movie is to apply a visual effect to it, such as speeding up your clip, reversing the direction, or adjusting the color.
Learn how to perform a midline episiotomy in order to prevent tearing and lacerations and speed delivery.
This Microsoft Word tutorial discusses some tips and tricks for speeding up your work and adding extra function to Microsoft Word.
Learn how to improve your speed, muscle stretch and agility for football with the help of these box jumps.
Have you ever found your video images over-exposed? Or under-exposed?
Learn how to drive a golf ball with PGA professional Darrell Kestner. He begins by discussing the driver itself and how it affects the shot. He shows where to start the shot from on the tee box, the speed in which the club is swung, the arc of the shot, and proper body positioning. Tips appear through the video in the form of pop ups.
Tired of worrying about where you can get your next charge? Watch this video to learn how to save your Android phone's battery life. Don't let your phone charger become a ball and chain, use the techniques shown here to conserve your Android device's battery life.
It's important to know what version of Android your phone has in case you ever need to call for support. And, if you are thinking about upgrading your Android phone's firmware knowing which version you are currently on is a great place to start.
Shake it like a Polaroid picture is out. Shake it for a screenshot on an Android phone is in. Watch this video to learn how to download and install the screenshot app for your Android phone that takes a screenshot when you shake the phone.
Can't get enough Facebook? Take your "friends" status updates with you wherever you go by syncing your Facebook account with your Android smart phone. Having access to Facebook on your cell phone will keep you in touch, and come in handy when you need to look up a phone number or email address.
Want to transfer all of your data from an old phone to your new HTC Desire HD? Learn how with this quick, official guide from HTC.
Learn everything you need to know about using a Samsung Focus Windows Phone 7 (WP7) smartphone. This video guide presents a general overview of the phone's hardware and software. For all of the details, and to get started using your own Focus, watch this video guide.
Learn everything you need to know to set up and use a Verizon Optimus 7 Windows Phone 7 (WP7) smartphone. This video guide presents a general overview of the phone's hardware and software. For all of the details, and to get started using your own Optimus 7, watch this video guide.
Learn everything you need to know about using a T-Mobile HTC HD7 high-definition Windows Phone 7 (WP7) smartphone. This video guide presents a general overview of the phone's hardware and software. For all of the details, and to get started using your own HTC HD7, watch this video guide.
New owner of a Samsung Galaxy? Thinking of picking one up? In this Galaxy owner's guide, you'll learn how to get around this Google Android phone's user interface (UI for short) to do things like send and read messages, make and receive calls and surf the web using the phone's web browser.
In this video tutorial, we learn how to navigate and use the basic functions and features of the Verizon LG Octane VN530 cell phone's built-in camera. Whether you own a LG Octane phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
In this tutorial, we learn how to cheat on any test by wearing a fake bandage. You will need: a phone, ear buds for your phone, bandages, and transparent tape. First you will need to use your phone to record yourself saying the information you need to hear. Read this off your book or notes so all the information is perfectly correct. Now, plug the ear phone into your phone and then slip it through your sleeve before school. Now place it in your hand and wrap the bandage around it. When you ne...
In this clip, we learn how to send and receive text messages on a Windows Phone 7. Whether you're the proud owner of a Microsoft Windows Phone 7 smartphone or are merely considering picking one up, you're sure to be well served by this video tutorial. For more information, including detailed instructions, and to get started using the messaging app on the Windows Phone 7 yourself, take a look!
Flash is now supported by the Android family of phones! You need to run two updates to Froyo and then install Adobe Flash onto your phone. Once you've done that, you can get the Flash player directly to your phone and browse Flash-based content on the web!
Rooting (also called jailbreaking) a phone grants you superuser access, which allows you to download third party applications and otherwise alter your phone. This tutorial shows you how to give yourself root access on a T-Mobile G1 cell phone. Be careful, because rooting will often void your warranty!
Jailbreaking isn't just for Apple devices anymore! You can jailbreak your G1 phone as well, which will give you access to third party apps outside the regular market store. After you've connected your phone to your computer, download the software, and you'll have a freshly jailbroken G1 phone! Make sure you have everything backed up before doing the jailbreak.
Tired of always having to charge your phone? Don't want to pay for an expensive upgrade? This tutorial shows you how to get the most out of your phone's battery life. Make sure your data and Internet features are under control, those will suck the most juice.
This clip demonstrates a pair of handy shortcuts for discovering the PIN and phone number of a BlackBerry phone. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this official video guide from the folks at Blackberry. For detailed information, including step-by-step instructions, take a look.
In this video, we learn how to do a free reverse cell phone look up for call records. This will work for some cell phones, but not all of them. First, go to the website Your Spying Eyes. This is a great search tool where you can look through records of cell phones to find out who someone is and more information about them. There is a small fee you will have to pay to get this information, but it's worth it. You can also look up phone numbers on Google, by simply searching for the phone number...
In this video, we learn how to sync your HTC Windows phone to your PC via Bluetooth. First, connect your USB from the phone to the laptop. After this, a window will show up on the computer screen, click on that. After this, your computer will go through the steps to install the drivers. Now, go to your phone and you will see a menu that says your laptop. Click on the button that says "sync", and your computer will start to sync with your phone through a Windows Mobile window. When finished, y...
In this video, we learn how to set up your Motorola Devour a555. First, remove the plastic from the phone and unwrap the battery from its package. Now, press the tab on your phone to unlock the back of it and insert the battery into the slot it goes in. Next, close the tab that you took out to insert the battery, then turn your phone on. Go to the menu and then change all the settings on your phone that you want to immediately change. Search around the phone to see your contacts and other inf...
In this video tutorial, viewers learn how to upload pictures from their cell phone to their computer. Begin by connecting the DCU60 USB cable to the cell phone and connect it to your computer/laptop. Then insert the software CD into the computer. Install the software, depending on the type of phone that you have. When the phone is ready to be used by the computer, select media transfer to upload the pictures from the phone. This video will benefit those viewers who have a cell phone, and woul...
In this Electronics video tutorial you are going to learn how to hook your phone up to your computer using Bluetooth. Keep only one phone around the computer while doing this. On the phone go to options, discovery mode and ensure discovery mode is ON. Then go to ‘horizon’ > menu > settings and tools > Bluetooth menu > add new device. Now on your computer go to Bluetooth and ensure discovery mode is ON. Then click on ‘set up Bluetooth device’. Now select ‘mobile phone’ and click ‘continue’. Pu...
In this video, we learn how to fix a wet phone using rice! Before you begin, you will need to turn your phone off and take the back off and battery out. After you do this, take a bag of Basmati rice and place the phone inside of it. If there is a reseal on the top of the rice bag, seal it, if not, place tape on the top to seal it. Next, stick the bag on the radiator or heater overnight. The rice will soak up the moisture from the phone and the heat will extract the water. In the morning, your...
To freeze motion in photography, you need three things. First, you need a good camera, triPod, and a subject to photograph. One thing to keep in mind is your shutter speed. For example, if the subject is moving towards you, you want the shutter speed between 1/100th to 1/250th. If you are capturing the subject going from side to side, you want it set at 1/250th or more. Keep in mind that the more you increase the shutter speed the less light you will have in your picture. Next, move the camer...
