References Retrouves Search Results

How To: Record and use macros in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to record and use macros in Microsoft Excel 2007.

How To: Use the INDEX & MATCH functions in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the INDEX & MATCH functions.

How To: Draw a shy chibi angel character

In this "how to" video, we learn how to draw a "chibi" form of an angel. Chibi is a Japanese term meaning "short person" or "small child". It has become a style of art in which Japanese Anime and Manga artists attempt to make all of their characters into "cute", childlike characters (with small bodies, large heads, and large eyes). The artist in this video shows his/her step by step process of drawing a small "chibi" angel holding tightly onto a heart. The artist starts with the eyes, then wo...

How To: Draw an eagle with an American flag

Michael Weisner, a 2D illustrator and graphic designer teaches us how to draw a majestic Eagle on a waving American flag. To start, you should box in the area for the flag. It should be roughly centered on the page, add a bit of a wave to box to simulate the wind on a flag. Complete the rough outline with the flag pole on the left side. Now you can begin with the Eagle. Use an oval to draw the chest of the Eagle and allow you to easily place the wings and other important features. You should ...

How To: Use circuit bending

Circuit bending an audio device typically involves removing the rear panel of the device and connecting any two circuit locations with a "jumper" wire, sending current from one part of the circuit into another. Results are monitored through either the device's internal speaker or by connecting an amplifier to the speaker output. If an interesting effect is achieved, this connection would be marked for future reference or kept active by either soldering a new connection or bridging it with cro...

How To: Communicate between Flash AS3 and PHP

All the files you need are in a free download on DevelopPHP. PHP has to be on a server. It will not run on a local machine. Type your name. There are two variables which show up in the dialog boxes (which are stacked.) You can change the user name. It sets up a URL request and a URL loader and sends some URL variables and are placed into the value of names and pairs. They get posted to the PHP file. Place the URL reference location of where the PHP files are on your server in the line that sa...

How To: Autotune your voice using Mixcraft 5.0

Autotune your voice using MixCraft 5MixCraft 5 is the latest version of the program. The program is an instrumental, video and voice editor. We will be using the audio track. Use your best mike and record a short voice recording. Add a songy tune to it to get the full effect. Go to effect, autotune bst. Use the preset. Input auto is soprano voice, auto correct, left select pitch reference, vibrato on 0 or .1. Format amplitude at 130. Set pitch to 0. Natural vibrato needs to be at a 90 degree ...

How To: Draw Yoshi from Mario Brothers in MS Paint

In this how-to video, you will learn how to draw Yoshi from the Mario Brothers universe using MSPaint. First, have a reference photo ready. Open the program and use the line, curved line, and freehand tools to draw the outline. Start off with the face. Outline the body, and then move on to the eyes and mouth. Move on to the outline of the body. Just as with the head, move on to the interior details of the body. Once the outline is finished, fill in the basic green color of the body. You can a...

How To: Draw dynamite

First of all use a grey color shade to draw the outline sketch of the figure. First draw the trapezium in the front. Now draw a rectangle at the side of the trapezium. Make a flat top to the figure. From the middle of the trapezium draw a string protruding downwards. Now divide the figure into three equal sections. Now you have to darken sections on the rectangular side. Draw the vertical lines of the rectangular side curved outwards at the far end. At the front end of the rectangular side ma...

How To: Light for video to get a filmic look

In this video, Tony Reale describes some cinematography tips for video lighting. He focuses mainly on different ways to capture the look of video. The lighting style he's using in this video is a 2-light setup. One light is reflecting off a foam core and is placed at the right side of the room. The second light is acting as background light and is smaller and placed in the back, right corner of the room. This is a very simple setup and, with a cost of $100-$200, it is an inexpensive, effectiv...

How To: Make an instant book

Do you want a unique way to display your vacation photos or present your holiday newsletter? Try making an instant book. This video, you will guide through the simple process. The presenter starts by referencing Esther K. Smiths book: How to Make Books. You do not need a lot of materials, just scissors, paper, and some pictures. After showing examples of different types of paper you can use, she demonstrates the step-by-step process of folding and cutting the paper. She even shows a slow moti...

How To: Edit footage from a Canon 7D at 1080 24p using Avid

The video shows us how to edit footage from Canon 7D at 1080/24p using Avid Media Composer. Canon 7D is first of the video DSLR which is actually an easily editable of an Avid media composer. If you are shooting a project at 1080 24P, then Canon 7D records the footage at 23.98 which is perfectly compatible and tested with Avid. Firstly create a new 1080/24P project. Now import footage from a CF card in DNxHD codec. Then edit the time line in real-time apply the real-time effects but here the ...

How To: Carve a net needle out of wood

Carving a net needle from wood is probably easier than you think as long as you have your trusty Swiss army knife at hand. It has a wide array of available tools in a small unit. First you will need a piece of balsa wood. It should be 1/8 of an inch thick by 3 inches wide and 8 inches tall. Using the sharp narrow blade of the knife, you will cut 3 reference holes in a triangular pattern. The points of the triangle should be 1 inch apart at the bottom and the triangle should be 2 inches high. ...

How To: Void a check

Woops! Make a mistake? Whether you’ve made a mistake, like writing the wrong year or wrong amount, or want to set up automatic bill payments or direct deposit, you may need to void a check. In this tutorial, learn how to properly void a check.

How To: Sell a screenplay

Attention aspiring screenwriters! In this tutorial, learn how to sell that script. You may have written the next Hollywood blockbuster – but unless you can finance the film yourself, you’ll need to sell the screenplay to a producer who can make it come to life.

How To: Track a USB device

Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to track a USB device.

How To: Create a textured face in 3ds Max 8

This is a three-part 3ds max video tutorial that takes a look at using reference photos for creating a head texture. If you have photographs that can work, there really isn't any reason not to use them since they can often provide plenty of subtle details that would be very time consuming to add otherwise.

How To: The Hardware Hacker's Introduction to Microcontrollers, Part One: Anatomy of an Arduino

In this article, I'll be explaining the basics of how microcontrollers work, physically and virtually. First off, microcontrollers are no simple thing, so don't be discouraged if you find it mind-boggling! The world of microcontrollers is fascinating, engaging, and an awesome hobby; it never gets boring. I'll be focusing more on I/O and analog based microcontrollers, such as those running Arduino, and using Atmel chips as examples (these are most commonly available, and easy to program).

How To: Use the Mastering Suite in Studio One

Two books were presented as suggested reading. One was by Bob Katz: Mastering audio; art and science. The other was Bob Alginski: the Audio Mastering handbook. Mastering takes a collection of songs and makes them sound like they belong together by making certain technical changes. The project page in Studio One is where the mastering is done. Drag in your sound content that you will be working with. Make sure you have the most recently updated version. If you are using multiple tracks, you mu...

How To: Create a custom duct tape wallet

In order to make a wallet with duct tape, you will need the following: duct tape, scissors, a ruler, a pen, plastic, credit card, and a smooth surface. Cut a strip or duct tape 8" long. Place it on a flat surface, with the silver side facing up. Cut another piece. Attach it to the first piece, laying it down at half the width of the first piece. Fold it over. Try to avoid making bubbles. Now, make a sheet by cutting 8 strips and attaching them together in the same manner. With a ruler, measur...

How To: Find your Blackberry Messenger PIN

One of the coolest features on a Blackberry is BBM or Blackberry Messenger. BBM allows you to talk to anyone with a Blackberry, anywhere in the world, absolutely free! You can send messages back and forth and you phone will even keep a record of the conversation in case you need to reference something later.