Learn how to use the VBA environment within MS Excel 2007 to create custom macros. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started working within Excel 2007's VBA environment yourself, watch this free video guide.
Looking for instructions on how to animate a series of images within Adobe Photoshop CS4? This is that! Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial, which offers a thorough, step-by-step overview of how to generate custom animated GIFs within Photoshop CS4.
Create stunning montages the easy way. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from Pro Photo Life. For more information, including step-by-step instructions on how to create your own custom photo montages, watch this graphic designer's guide.
Looking for a guide on how to set a custom default ringtone on your Android smartphone? One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular, discusses how to tell your Android mobile phone to use a specified audio file as its default ringtone.
Root your Sprint (CDMA) HTC Hero Android smartphone and run custom ROMs! This hacker's how-to presents a thorough, step-by-step overview on unlocking and rooting a Google Nexus One Android smartphone. For detailed instructions, and to get started rooting your own Nexus One smartphone, watch this free video tutorial.
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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.
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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.
Now that you've installed Microsoft Windows 7 on your computer or bought a new Windows PC, it's time that you made yourself at home. With this official Windows 7 video tutorial from the folks at Microsoft, you'll learn how to apply custom settings as well as how to keep your Windows 7 PC running smoothly.
Put PS1 games or PSX games on your PSP for free with help from this video tutorial. You must make sure you have custom firware on your PSP in order to complete this.
Want to personalize your MySpace page with a custom-made layout? In this two-part tutorial, learn how to create your very own MySpace layout in Photoshop.
Looking to elongate those lashes in Photoshop? Create false eyelashes quickly and simply with some fancy custom brushes that you can download for free. In this two-part tutorial learn everything you need to know about how to make that pair of lashes in your photo pop.
Update your Ford Mustang to a more appropriate custom look! With dome lights! If you're looking for a new feel for your Mustang, then US Muscle Mods can help. 'Stang LED lights are the way to go for dome lights. See how to install Mustang LED dome lights.
Thread Banger and their friends at Ruffeo Hearts Lil Snotty show us how to transform our old backpack into a now hip (yes, they're hip again) fanny pack in just under two hours. With a disposable backpack, pattern weights, marking chalk, a zipper, seam ripper, scissors, a buckle, some pins, a sewing machine, and a downloadable pattern courtesy of RHLS, you can make your own custom-made fanny pack in time to show off at school the next day! A definite must-try.
This is a video tutorial that shows you how to use the Tiger Stripe Vinyl Paint Mask found in the store at My Custom Xbox. Apply these white tiger stripe stickers is easy. Everyone should know how to paint an Xbox 360 controller!
This step by step video will show you how to reassemble an Xbox 360 Controller after completing a custom paint job or mod. This is integral and the final step of any great mod, paint or customization job.
Accidents will happen. This brief how-to will guide you through the process of disassembling a Microsoft Xbox 360 console controller quickly and efficiently without damaging any of the components, the first necessary step of any successful repair (or custom paint job, for that matter). This tutorial will also be of use to those who wish to learn more about the guts of their Xbox controllers without actually disassembling their units.
Cooking instructions at John's Cuisines, the all-time Filipino favorite dishes are now unveiled to the whole world.
How to make that cardboard hood to assist you in making your own custom bokeh when shooting images.
Project 4 of the Popular Science 5 Minute Projects with Craftsmen Tools is a Nut-and-Bolt Keychain. Downsize your pocket cargo with a custom-fit keychain. Editor Sean Captain ditches the ring and uses more tool than necessary to trim a small bolt to just the right size for his set of keys. (For a slightly different take on the project, see the site that inspired us: carlitoscontraptions.blogspot.com).
This web development software tutorial shows you how to create a custom left panel for a website using XSitePro 2. The options for XSitePro 2 have changed from XSitePro 1. Now, it's easy to change the right panel, but the options to change the left panel have been hidden. Watch as Jason shows you how to rebuild the template in XSitePro 2 to allow you to modify and customize the left panel.
Don't get us wrong: We love the iPhone, but given that every other person we know has one, it doesn't exactly make us feel unique. Yes, it comes in black and white, but that sure doesn't give us a lot of options, you know?
Here's a fast lesson in hosting video on your own Drupal website using the FileField and jQuery Media modules. The Filefield and jQuery Media modules are a one-two knock out combination for allowing users to upload media files to fields in your custom content types and then playing back the media files in their matching player or handler. It represents a positive direction for treating fields containing files and is a great starting point for researching your own implementation of this recipe.
Watch this Chinese language tutorial video and learn useful phrases and additional vocabulary when checking into customs, such as "Visa" and "Your passport, please." Learn how to correctly pronounce these words and phrases, and how to use them in the real world with your Mandarin teacher Benny.
Own a Playstation portable? With a PSPTUBE, you can watch and download videos from YouTube and other video sites. Take a look at this instructional video and learn how to install the PSPTube. Keep in mind that your PSP requires a custom firmware of at least 3.71m33 or higher and 8MB of free space on your memory stick.
In this video tutorial, Chris Pels shows how to use the ASP.NET IIS Registration Tool to configure ASP.NET. First, see how file extensions are mapped to ASP.NET in the IIS Manager on a global and web-site-by-web site basis. These script maps provide the basis for configuring individual ASP.NET applications to run under a specific version of the .NET Framework. Next, see how aspnet_regiis.exe, the IIS Registration Tool command line utility, is specific to each version of the .NET Framework and...
Watch this video tutorial of custom skateboard spray painting. This could be on your skateboard! The theme of this one is 'Master of the Universe.'
This tutorial teaches you how to manipulate character stats in Mugen - the custom PC game engine - including how to adjust a character's health, defense, attack, and change their name.
This video creates glossy/glassy plastic looking shapes in Photoshop CS2. See how Al Ward experiments with the layer style to get different effects. Learn also how to create custom styles for use later in the future.
Learn how to recreate "Pedobear" from 4chan as a custom, multilayer Black Ops playercard emblem! This COD Emblem Editor tutorial presents a complete, step-by-step walkthrough of the drawing process.
Art should be playful, not intimidating. And with this video tutorial, you'll see just how easy crafting can be. Learn a basic watercolor technique that will make your creations stand out and sparkle.
Kick up your look by adding dresses you make yourself to your wardrobe. It's simple to create a patter and sew a dress that will fit your exact measurements. You'll be amazed at the differene of having a drees you made yourself makes.
This video will show you how to use Custom Firmware Enabler on your PSP. This tutorial starts off assuming that you already have intalled ChickHEN. Once this has been done, you can follow this tutorial and get CFW installed onto your PSP 3000.
One of WhatsApp's best features is being able to change the default wallpaper for all chats. There's no reason to stick to the default WhatsApp backgrounds when you can be texting over an image of literally anything. In a newer WhatsApp update, you can go a step beyond that by setting custom wallpapers for individual chats, personalizing every text thread you have.
In iOS 13, Apple added the ability to use Memoji and Animoji for your contact photo and then share your name and photo with others through iMessage. It works excellent for contacts that use iMessage, but those that don't are stuck with old pictures or gray monograms. With a few simple steps, however, any contact in your list can have their own Memoji, Animoji, or colored monogram.
Apple's Reminders app is essential for those of us with a forgetful memory. But a standard Reminders entry isn't foolproof. They aren't great if you need to do something right when you get somewhere, since it can be tricky to set a specific time for that reminder. That's why Apple's location-based reminders are so darn useful.
According to a study done by Kaspersky, 7.6% of Android users root their phones. That may not sound like a lot, but with over 2 billion Android devices out there, the math works out to over 150 million rooted phones — more than the total population of Russia, Mexico, or Japan — so root nation is an important demographic that deserves being catered to.
Slack recently released a dark mode for its Android and iOS apps, and for the most part, it works great. Super dark gray backgrounds and light gray fonts, which is much easier on the eyes than blinding white backgrounds and black text. But there's one thing that is not affected by the new night mode setting — your sidebar.
Location services company Mapbox has added new capabilities to its location-based gaming tool to fend off Google's challenge for the same mobile app category.
Snapchat is in the midst of a massive redesign — one that not everyone loves. Still, it's clear that this is a decision fueled by money, and Snap Inc. believes this redesign will help attract more advertisers. Even so, Snapchat has a few more tricks up their sleeves to make a little extra dough. And while the average user couldn't care less about ads, they very easily could care about custom Filters and Lenses.
When it comes to modding Android, root gets all the glory, but a good custom recovery is really the only thing you need. Not only does it allow you to back up your entire phone, install flashable ZIPs, and load custom ROMs like LineageOS, but a custom recovery will even let you root your device. For years now, the only custom recovery worth mentioning has been Team Win's TWRP.
