Pre Sale Passes Search Results

How To: Export UV and Object Buffer passes from Cinema 4D

In this tutorial, you'll see how to export UV and Object Buffer passes from Cinema 4D, and how to use those passes to re-texture objects in 2D inside of Fusion 5. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.

How To: Make a dynamic named range in Excel (left to right)

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

How To: Use color passes and add masks using Premiere Pro

Sin City used some of the coolest visual effects of any recent film. This two-part video uses a clip from the iconic film as an canvas to which we can apply some other editing effects using Adobe Premiere Pro. Specifically, the first part covers using color passes to absorb colors and adding a mask to focus the color spot. The second covers animating a garbage matte with keyframes and other topics. Unfortunately there is no link for downloading the Sin City clip from the video, so you are goi...

How To: Tie the Trilobite decorative knot

Learn the right way of tying the ‘Decorative Trilobite Knot’, by watching this video. Take a rope and form two bends, as shown. Now pass each bend over a hook to form two loops at the center, resembling number eight. The free end of the rope on the right side is then passed over the lower loop of the eight, to the left. The free end of the rope on the left side is then passed under the rope, just passed from the right. Thereafter, it is passed under the lower loop of the eight, and pulled thr...

How to Walkthrough Darksiders: Drowned Pass

There's four shadow arena fights in this level of the Xbox 360 game Darksiders. In the Drowned Pass, there's the Counter Killer, Wrath of War, World of Pain, and Defender. The Drowned Pass features a deep lake in the middle of the area, a path that runs about the outer edge, and various hidden nooks and caves (some which can only be reached by swimming under water). Follow the path to the left. As you proceed along this path, keep an eye out for an opening along the right side. This will lead...

How To: Decorate bake sale pie cupcakes with Karen Tack

These aren't your mother's bake sale pies. In fact, they're not really pies at all. Rather, these delicious and pretty treats are cupcakes decorated like pies. A simple concept, yes, but these cupcakes make for a divine arrangement. You'll learn how to arrange various colors of jelly jeans to look like food - red for strawberries and blue for blueberries, for instance.

How To: Play tritone substitution & passing chords on guitar

In this guitar lesson, learn how to play chord substitutions and passing chords in basic jazz guitar. With the guitar, as with any other instrument, if you want to improve, you'll need to practice. Fortunately, the Internet is awash with free, high-quality guitar lessons like this one. For more information, and to get started pusing tritone substitutions and passing chords yourself, watch this video tutorial.

How To: Add fiscal year sales in Microsoft Excel

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 617th installment in their series of digital spreadsheet magic tricks, you'll learn how see a SUMIFS and SUMPRODUCT functions formula to sum the fiscal year's sales when the year does not end on December 31st. Also see a formula for year-over-year percentage change.

How To: Stage your home for sale

In this video Andrea Osterkorn demonstrates how to stage your home for sale. It is not a comfortable process to transform your home into a home for sale. The entry way should be inviting because first impressions are important. Closets should be cleaned out. Consider renting different furniture for the living area to make it more open and inviting, and move it around to create an impression of space. Add accessories and let natural light in. Try to depersonalize the room and remove clutter so...

How To: Do metric conversions in pre-algebra

Lawrence Perez, from Saddleback College, and his assistant Charlie, give this pre-algebra three-part lesson on metric conversions. Why can't we all use the same system of measurement, who knows? But until we see this day, you'll need to know how to do this.