This video teaches how to fill in the blanks with custom number format in Excel. Open any similar worksheet as shown in the video or type the same to use. Select all the cells in the columns E and F and press F5. Now click 'Specials', then select 'Blanks' and click 'OK'. All the blank cell will be highlighted, now enter the value and press 'Ctrl+Enter' to populate all the blank cells. Press 'Ctrl+1' to format cells, select custom if you want something to show up in the cell but not really be ...
This tutorial teaches you how to create a mosaic photo made up of many smaller photos in Photoshop. It explains the use of the crop tool, image resizing, use of sharpen filters and of fading command. It also handles creation of custom patterns with the use of the define pattern command as well as later use of the said pattern for a custom pattern fill. Finally, it describes the use of the overlay blend mode for achieving the desired effect.
This video shows you how to install ChickHEN onto a PSP with firmware version 5.03. It then will explain how to install CFW (custom firmware) onto a PSP.
This video shows you how to get ChickHEN R2 on your PSP, which allows you to get custom firmware on any PSP without using a pandora battery or a magic memory stick. You will need to have 5.03 ofw (official firmware) on your psp. If you don't have 5.03, you will need to download it.
Follow the steps in this video, and you should be on your way to getting custom firmware (CFW) on your PSP 3000. This makes use of software called ChickHEN. You need to ensure that your PSP firmware is 5.03 or else this will not work!
This is a quick guide on how to use Krylon Fusion to Custom Paint an Xbox 360 Controller. Krylon spray paints are basic and found at Home Depot.
This is flawless iPhone 3G ringtone creation for dummies. You can use iTunes or any music track to make the custom track your newest hip ringtone! This is a simple version of PC iPhone 3G ringtone creation. This will probably work with the old iPhone.
Devolped by the same team of engineers responsible for LightWave 3D, modo delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however, things can ...
This image editing software tutorial shows you how to create custom brushes in Photoshop CS3. After creating a brush, you will learn how to use it as a design element in a very basic business card. The tutorial assumes you know the basics of the Photoshop CS3 interface.
Do you do a lot of printing on your Apple computer? In this tutorial, Molly Stanberry from MacMost.com demonstrates the extended print settings in Mac OSX. Learn to set up custom print options with this how-to.
Take a look at this instructional video and learn how to build a custom iPod and iPhone cable that'll simultaneously charge the Apple device and give an audio line out connection. Keep in mind that this process requires some soldering and since the pins on the Apple dock connector are really tiny, this can be a very strenuous process.
RC Car Action Magazine Editor Kevin Hetmanski shows how to properly solder brass tubing to make custom bumpers, chasis, roll cages and more. Once you know how to do this, you can do any sort of custom building. Watch this video tutorial and learn how to solder brass tubing on an RC vehicle.
Watch this video to learn how to update your Sony PSP to firmware 3.71 m33-4. This is custom firmware which is used for many PSP hacks. The link to download this is http://www.pspsource.de/news.php?extend.2747
In this video tutorial, Chris Pels will demonstrate how to create a custom user control in ASP.NET that can be used throughout a web site or across many web sites. Start out by learning the basics of creating a user control that will be used in multiple pages including validation, controlling formatting using style elements, and loading/saving data for the user interface elements. Throughout the video considerations for building user controls that can be easily maintained and used across mult...
In this video tutorial, Chris Pels will show how to persist and restore information in the ViewState of a custom user control. First, learn how to persist simple values containing .NET primitive types such as String, Int32, Boolean, etc. Then see how to persist complex types such as Class which contain properties storing information. The sequence of processing View State information during the lifecycle of an ASP.NET page is also discussed.
How to do the tissue and tape mod on a Playstation 2 (PS2) so that you can play backups and customs like Guitar Hero 2 custom.
Learn how to save a custom print template in a format that would let you send it to a printer or some one else to print. Technically, there really is no way but in this week’s Lightroom video I’ve got a workaround for you.
A quick tutorial on setting up custom error pages using cPanel,This video is provided to you by Scandicsoft.
Windows Vista's boot screen is pretty boring, and for those of you that like to really customize your desktop, you may be wondering why it isn't as easy in Vista as it was in previous versions? While it isn't as easy as it used to be, if you follow along while watching this tutorial you will see that changing the boot screen to your own custom image still fairly simple.
Facebook is the world's fastest growing social networking site with over 50 million users worldwide. ImageChef is a cool, online application that allows you to personalize a range of images, some famous, by adding your own text.
How to create a custom mouse pointer with Flash and ActionScript. You can even use an animated gif as your pointer.
How to create a custom cursor in Flash using ActionScript.
Learn to create custom songs on Guitar Hero 2 for the Playstation 2 (PS2)using Guitar Hero Explorer software. This will not work unless you have a PS2 with a mod chip.
Installing custom firmware on your PSP allows you to run outside and homebrew applications, run games directly from your PSP, and burned games on your PSP. Note that you need to have PSP firmware version 1.5 to install this otherwise you will have to downgrade.
Keynote '08 allows you to make custom animations and move things from point A to point B on a slide. You can also animate opacity, scale or rotations. This tutorial will show you how.
Wow friends and colleagues by learning how to make preset and custom PowerPoint animation, to enliven your next deck and keep your audience riveted.
If you have digitized photos in your computer, you might want to decorate them using Photoshop. How about adding frames? In this video tutorial you will learn to use custom shape frames in Photoshop CS2.
When you unlock the bootloader on your Essential PH-1, you open your device to a host of new possible tweaks. One popular modification is a custom kernel, which can not only speed up your phone, but give you new features that wouldn't be possible otherwise.
Matte and flat colors have became quite popular. I was surprised to see how many cars used these colors at SEMA 2011.
UPS gives you all the tools you need to take away the complications and confusion of international shipping. UPS provides simple, step-by-step online instructions and helps guide you through the required documentation to reduce the likelihood of customs delays.
The Samsung Galaxy Tab 2 (7.0) 4G LTE on Verizon has only been released for a couple months now with good reviews. It comes with dual cameras, memory expansion, and very quick 4G LTE speeds, without needing a contract. While most users are satisfied with the tablet as is, there are others that prefer rooting the tablet in order to install their own custom ROM. Now you can do it with the Samsung Galaxy Tab 2.
Custom ring and text tones are great for knowing who's attempting to contact you without having to actually look at your iPhone. However, this feature is useless when your device is in silent/vibrate-only mode.
In this Threadbanger video, Secret Life of a Bionerd gives you tips on making a custom tank top pattern. She'll teach you how to measure yourself, along with making a simple pattern from those measurements. Making this tank pattern sure makes life easier when sewing. This is the basics to starting your own tank top designs, and opens the door to create many other pieces as well. Once you get this method down, you will love collecting homemade patterns.
APK files are the EXE files of the Android phone, the executables that mark the point of entry to most programs and Apps. If you have rooted your Motorola Droid or other Android phone, you're probably come in contact of an APK file in or around your custom ROM. This video will show you how to install APK files on a rooted Motorola Droid, which will allow you to find Apps without going to the App Market and take advantage of all of the features of your custom ROM.
In this video tutorial, viewers learn how to set custom sound volume for different applications in a Windows 7 computer. This task is very easy, fast and simple to do. Begin by simply clicking on the speaker icon in the system tray and select Mixer. There users will have access to the master audio mix on the left and each application listed individually, with their own volume bar. Just adjust each volume bar of the applications to your liking. This video will benefit those viewers who use a W...
Creating a modern video game is a mammoth undertaking, especially if you are working alone. Hopefully, this video will make it a little bit easier. It will teach you how to create a custom class for your game's hero character using Flash CS4 and Actionscript 3. Doing so will make your main character react in predetermined ways to a variety of actions, which is very useful if you want the character to react consistently throughout the game.
Are your digital photos missing something? Could it be fairy dust? In this tutorial, you'll learn how to create a custom brush to paint randomized sparkles to create a fantasy effect. Want to separate a foreground object from its background? 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 TutVids. For more information, including step-by-step instructions on how to cre...
Need to make an newsletter for your company or business? It's really not that hard to do, if you know a little bit about HTML coding. Ryan Quintal and the Email Dance House sits you down and shows you how easy it is to make a custom HTML email from design to Constant Contact.
Systm is the Do-It-Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. They will help you avoid pitfalls and get your project up and running fast. In this DIY episode, see how to custom spray paint your project, laptop, or PC.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
