References Retrouves Search Results

How To: Input values & formulas into a cell in Excel macros

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Use the Panasonic HVX200 with Avid Media Composer

Download the P2 Step-by-Step Reference Guide. With Avid, editing footage captured with the Panasonic HVX200 camera is fast and easy. Avids system uses the same native file format as Panasonic P2 memory cards, so theres no need for any transcode, capture or file conversion process at all. You can edit directly and immediately from the P2 cards if you like or have Avid Media Composer create a rapid backup of your files. Nothing could be simpler or more immediate.

How To: Draw and color landscape scenery

In this video, we learn how to draw and color landscape scenery. First, draw your starting point, making a horizontal line. After this, draw other reference points on the paper, then start to draw in lines to see where your structures are going to be. After you do this, make trees on the paper, then start to fill in details of plants and flowers around the trees. Draw in buildings and stairs, making mountains and hills in the background. Add as many detail as you feel needed, and then start t...

How To: Draw and color a city with art markers

In this video, we learn how to draw and color a city with art markers. First, draw a horizontal line as your reference point to where the city buildings are going to go. Make a point in the middle as the background line. Now, start to draw in the buildings around the middle line, making diagonal straight lines, then drawing in the details of the buildings. Draw in taller buildings in the back, then start to draw the larger details in the front of the drawing. Add in shading and details as nee...

How To: Learn makeup mask basics

In this tutorial, we learn makeup mask basics. If you're good with makeup, then you can try to freehand your mask. If you don't feel you can do this, you can make your own. To do this, fold a piece of paper in half and bring it on your face to mark the outline of the face. You can also purchase a mask from the store and apply it yourself. You can also cut a plastic mask to use as a reference and help shape the mask that you are creating. Whichever way you choose, make it unique and enjoy crea...

How To: Draw steps in perspective

In this tutorial, we learn how to draw steps in perspective. Start off by drawing a dot in the middle of the paper. From here, draw lines using a ruler coming from the middle diagonally on the top middle and sides. Now, you will be able to draw your pictures using these as a reference point. The lines at the top will show the steps that are at the top and farthest away the closer they get to the dot in the middle. After this, fill in the details of the picture making different items around th...

How To: Sketch a street drawing

Miandza teaches us how to sketch a street. You start with a horizontal line and two diagonal lines, all intersecting in the middle. You then start to add parts of buildings, in perspective. You continue to use the lines as reference and add more buildings. Then start doing trees and people. Also add pavements and start doing details on all objects. You finish by drawing the sky and the birds. The final scene is still a sketch, but has lots of details and uses the perspective to look natural.

How To: Make a simple HTML hyperlink

This how to video shows how to put an HTML hyperlink on a web page. It starts with the basic code to simply insert the link and have that link open in the same window. The code appears as follows: <a href="http://www.website.com">Text that will show up on the page </a>. The example used is Google, so it would be, <a href="http://www.google.com">Google</a>. The video then explains how to create a hyperlink that shows up in a new window. Sticking with the Google reference it would read <a href=...

How To: Tune your guitar with the 5th fret rule

The ability to tune a guitar is a skill every guitar player should possess. With this tutorial, learn how to properly tune a guitar either using a digital tuner or by using the fifth fret rule. Though a digital tuner is by far a more convenient option, certain situations my require the player to tune an instrument by ear. Start by tuning the low E string and use that sound as a reference for the tuning of the other strings. If a tuning fork is unavailable, a guitar can still be tuned relative...

How To: Spot a bench press

One very important part of bench pressing is knowing how to spot someone properly. In these two how-to videos, Mark Rippetone shows you how to spot someone when they are on the bench. Watch as he focuses on grip distance, visual reference points and breath. Improve someone's bench pressing with your spotting abilities.

How To: Model a low poly character in Blender 3D

This tutorial uploaded from Stage6 shows you how to model a low polygon character in Blender 3D. Low poly characters may have less details than higher poly count characters but they will move faster in video game engines and are easier to work with. So watch and learn how to model a low poly character in Blender 3D from image plane references.

How To: Sew on a zipper to a pair of pants

This how to video is a good general reference for anyone making their own pants, trousers, or jeans; basically any article of clothing with a fly front. The example uses a Suitability pants pattern, and can also be used to substitute a button fly. Watch and learn how to sew on a zipper to a pair of pants or trousers using a sewing machine.

Steampunk R&D Podcast 01: Thomas Willeford on Creating His Empire

Today, on our first episode of Steampunk Research and Development, we'll be interviewing Thomas Willeford, owner and operator of Brute Force Leather. Thomas is a man of many talents, and has worked in a vast array of fields. His Steampunk work can be seen in his book, Steampunk Gear and Gadgets, as well as on the television show Castle. Thomas is also one of the creative consultants on the upcoming television show Lantern City.

How To: Create fire and smoke using Pyro FX in Houdini 10

The new Pyro FX in Houdini 10 are very impressive with improved workflow. The Pyro FX are great for creating 3D fire and smoke effects. And in this video tutorial series, you will learn the Pyro FX workflow in-depth and the parameters used to create fire and smoke effects. You will also see how volumetric data is created and recorded, and how to visualize it.

How To: Tune up your bass guitar with Dale Titus

In this how-to video, you will learn how to tune your bass. This is important, as weather can affect your tuning. Every time you pick up your bass, you should tune it. First, start with the low E string. You will need to listen to a reference E note to tune this string. A tuner or piano can be used. Go to the fifth fret on the E string and tune the open A string to this note. Tighten or loosen up the string accordingly. Now, go to the fifth fret of the A string to tune the D string. Next, go ...

How To: Do gesture drawing

Jordon Schranz brings you this tutorial on drawing. Search WonderHowTo for Sessions Online School of Fine Arts for more drawing tutorials. The technique & craft of drawing isn't necessarily about inherent talent, it is something that comes with lots of practice. It is all about being able to accurately record what you see.

How To: Hack a remote Internet browser with XSS Shell

XSS Shell is a cross-site scripting backdoor into the victim's browser which enables an attacker to issue commands and receive responses. During a normal XSS attack an attacker only has one chance to control a victim's browser; however, the XSS Shell keeps the connection between the attacker and the victim open to allow the attacker to continuously manipulate the victim's browser. XSS Shell works by setting up an XSS Channel, an AJAX application embedded into the victim's browser, that can ob...

How To: Use Zotero to create bibliographies & citations

Learn to use Zotero to create bibliographies and citations with this tutorial. In addition, collect and organize information from all sources. So help correct the sources research paper. Before using the excitation features, make sure to select and prepare the style of your paper. If you are not sure ask your instructor. She has a preference style. You will select by clicking on the action button +preference then choose the style. It will include the number of most common style. You can downl...

How To: Build APRS on the cheap

Long-time packeteer Bob Bruninga, WB4APR, developed the Automatic Packet Reporting System (APRS), which allows packet radio to track real-time events. It deviates markedly from the usual message- and text-transfer activity. Instead, APRS concentrates on the graphic display of station and object locations and movements.

How To: Apply localized correction in Lightroom 2

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to apply localized correction in Lightroom 2.