Play Key Search Results

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...

How To: Create jump rings in three minutes

Karen Bratt demonstrates how to make jump rings for jewelry and key chains. To prepare jump rings the things required are a coil of silver plated wire, a pair of round pliers and a pair of cutting pliers. Take the coil of silver plated wire and place it at the wider end of the round pliers. Slowly bend the wire and form a circle around the pliers such that the wire coils. As you bend allow the coil to come up the beaks of the pliers until you make half a dozen of jump rings. Take it out of th...

How To: Back up and restore the Windows 7 registry

This video tutorial from Britec09 presents how to backup and restore Window 7 registry.First, press Start button and enter regedit command into Start Search area.Registry editor window will open, click File-Export.This option works on all Windows operating systems.Type file name - registrybackup and click Save. You can save it wherever you want, but in this video it was saved to Desktop.Next step is to reboot to Windows DVD. Insert you Windows DVD and reboot computer.Press any key to boot fro...

How To: Create songs using loops on Garageband

Elliott Berring shows us how to create songs in GarageBand using Loops. First, launch GarageBand and create a new music project. Keep the default tempo, time signature, and key. Click on the Show Loops browser, indicated by the Eye icon in the bottom left of the window. In this example, he starts with a drum beat by choosing All Drums, then Rock/Blues. Find a beat you like, then drag it into the timeline. Position your cursor over the top right hand corner of the blue bar of the beat you just...

How To: Change Skin Tone in Photoshop

With Adobe Photoshop on your computer, it's super easy to change or adjust the skin tone of somebody in a digital photo. The process uses some basic selection and color adjustment tools, and it's a fun way to make a friend's face nauseously green or lessen the effects of overly strong, sometimes even orange, makeup.

How To: Create realistic smoke and dust particles in Maya

The key to being able to animate realistic smoke or dust is being able to master the particle texture rate technique in Maya. Once you have gotten this down, you can create any sort of particle effect, such as sand or bubbles in addition to smoke and dust. This three part tutorial series goes in depth into the subtleties of Maya, showing you how to get the most out of working with particles to lend an extra layer of realism to your project.

How To: Get the unique Knock Knock unique Fire Axe in Fallout New Vegas

Camp Searchlight may be an infested ghoul town, once owned by the NCR, that's completely engulfed by radiation, but popping a few Rax-X's and a healthy supply of RadAway should do the trick! If you can last long enough and find Logan you'll be able to get the key to the Fire House there in town. Inside of the Fire House lies a unique weapon called Knock Knock, a powerful Fire Axe that looks similar to the ones used by the Pyro in Team Fortress 2! To learn the location and get the axe yourself...

How To: Change presets in Logic Pro instruments

In this video, we learn how to use Logic Pro: Changing presets in Logic instruments. First, insert the ES2 and add in a preset that you like. You can also use key strokes to step through presets instead of using the mouse to click through all of them. By doing this, you will save time while you are going through presets to audition a bunch of presets to find the one you want. Use the drop down menu within the instrument to find the different presets and then choose one you would like to inser...

How To: Create amazing facial expressions in Adobe Photoshop CS3

When drawing any sort of art, conveying emotion is key to creating a great and significant scene. The twist of an eyebrow, the way the eyes stare at you, it all conveys a different emotion, and with a very small change to one of many different features of the face, you can completely change the idea and emotion conveyed by the picture. In this amazing video series, you will learn all the various positions and looks of the face that'll convey all the emotions that you want to bring out in your...

How To: Make perfect hard boiled and soft boiled eggs

Talk about stepping on eggshells. The process of boiling an egg and achieving your desired consistency is a very delicate process, though super easy with a little practice. When it comes to boiling, or simmering, an egg, the time you keep the egg in the water is key to how it will turn out.

How To: Fold an origami grand piano for beginners

These are the pianos of concert halls, of greats like Mozart and Beethoven, and of piano masterpieces that still set the standard for good music production. Grand pianos are large and a bit ostentatious, yes, but they create a deep, resonant sound that tugs on your heart strings.

How To: Deal with having your website hacked

Google is one of the most powerful forces on the Internet, and their technology can be the key to helping you find success in whatever your online endeavor might be, from web design to filmmaking. This video is a part of their Google Webmaster Series, offering help to webmasters the world over on how to best utilize Google in their work. This video will show you how to restore your Google ranking after your website has been hacked. Hopefully you never will be, but if you are this video is her...

How To: Make a healthy chicken wrap for your kid's lunchbox

With obesity now a confirmed epidemic in the United States, we should be putting more emphasis than ever on how we feed our children and what they consume at school. While many educational instititions sell salads and healthier options like apples and carrot sticks, these foods often don't catch your kids' attention when they're placed side-by-side with cheeseburgers and calzones.

How To: Put together a resume as an ex-offender

Eric Mayo teaches us how to put together a resume as an ex-offender. Your resume should be a one page paper of all your skills and work experiences. If you don't have a lot of experience writing resumes, get help from friends who have experience. When you write it, add your name, address and telephone number onto it so you can be contacted. After this, you will want to list: objective, work experience, education/training, skills/strengths, and references. Remember not to list your references ...

How To: Write a proper thesis statement with Jennifer Mensink

The key to a great essay or dissertation is a strong thesis. In this two part tutorial from teacher Jennifer Mensink, learn exactly what a thesis is, why it is important and how to craft the perfect one. This video lesson will cover everything including an anticipation set, input and an assessment. Jennifer teaches as though you are her only student, and you will love listening to her step by step breakdown. So, get ready for finals with this refresher course on thesis statements.

How To: Write a Java applet that accepts keyboard input

Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to to accept key inputs from a user when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.

How To: Use the "adult blatt" deer call for hunting

In this how-to video, you will learn how to do the adult Blatt call. This call is made by an adult deer about 18 months old. There are many types of Blatt calls. The Estrus Blatt is the most effective in getting a Buck to respond. The key is to keep the call short. This call will be made by a Doe when in peak heat and looking for attention from a Buck. Turn the calling device quickly. This will be done several times in a row. Do not make a loud alarm Blatt. Keep it short. This video gives you...