Market Digital Search Results

How To: Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Create an Excel Gantt Chart by conditional formatting

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.

How To: Change lenses on a camcorder

Make sure you have the appropriate lens for your digital camera. Look for markers on the lens that correspond with any mark on the camera body. Different brands have different markers. Some have square dots while some have red dots. Line these marks In one hand, hold your camera body firmly pointing to you. While holding it, push the lens button. Firmly hold the bottom of the lens (where the lens meets the camera body), and twist. Some cameras let you twist clockwise, others counterclockwise....

How To: Use Sekonic light meters to balance flash and ambience

In this episode of Digital Photography 1-on-1, host Mark Wallace goes in depth on the subject of light metering and flash balancing. Making use of a Sekonic light meter, Mark shows how to read the light levels in a room, and explains how to interpret those readings in order to adjust flash levels, ISO levels, and alternative light source manipulation. Mark also goes over the important roles that aperture settings and film speeds play when attempting to successfully balance flash and ambient l...

How To: Care for a child with a fever

Dr. Bob Sears explains to parents the difference between a child's fever that may be serious and one that isn't. Only when the child's fever is high and any efforts to bring it down have failed, should you seek medical attention. This means the child could have a serious infection. A temperature of 103 or more is considered high, 101-102 is medium, and 99-100 is typical. Dr. Sears recommends using a regular digital underarm thermometer to check the child's temperature. Hold the thermometer un...

How To: Apply depth of field to your photographs

Learn how to use depth of field with help from this photography tutorial. Although it may seem that depth of field is a confusing factor in photography, it's actually quite easy to understand & adjust once you've gotten the hang of it. Depth of field (or, DOF) is a great way to experiment with your photography & improve your skills as a beginner photographer. When taking your photograph using DOF, it is imperative to remember that the shutter speed and aperture (or F-stop) need to change at e...

How To: Use & adjust shutter speed

Have a passion for photography but know nothing about the basics? This video might be a great place to start on the topic of shutter speed. Shutter speed is the amount of time that the film, or your digital sensor, is exposed to the light. Whether it be outdoors, at night, or low indoor light, the shutter speed allows your camera to take a photograph with the correct amount of exposure in reference to how much light is readily available in your setting.

Beat Mirror's Edge Chapter 1: Flight Part 1/2

This is a video walkthrough for Chapter 1: Flight (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

Beat Mirror's Edge Chapter 2: Jackknife Part 1/2

This is a video walkthrough for Chapter 2: Jackknife (PT. 1/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

Beat Mirror's Edge Chapter 2: Jacknife Part 2

This is a video walkthrough for Chapter 2: Jacknife (PT. 2/2) in Mirror's Edge for the Xbox 360. The game has a realistic, brightly-colored style and differs from most other first-person perspective video games in allowing for a wider range of actions—such as sliding under barriers, tumbling, wall-running, and shimmying across ledges—and greater freedom of movement, in having no HUD, and in allowing the legs, arms, and torso of the character to be visible on-screen.

How To: Setup basic PBR lighting in Houdini 9

This Houdini n9 software tutorial covers a very simple lighting and rendering scene to show the basic workflow for generating a PBR render. We use a digital asset to quickly establish a group of geometry to light. In the lesson we also add an area map so that we can extract the lighting information from it. There are two .rat files to experiment with, the seashadow.rat file simply provides a pattern. The st.peters_cross.rat is an HDRI image from the Debevec site. Watch and learn how to set up...

How To: Cut Boss Kut dies in a Sizzix Big Kick machine

While embossing machines are marketed to be used brand specifically, all those Boss Kut dies and embossing folders are completely compatible with a Sizzix Big Kick embossing machine. Make the most of your stamping materials without having to purchase to much of everything. Watch this video crafting tutorial and learn how to use Boss Kut dies and embossing folders to make die cuts with a Sizzix Big Kick embossing and die-cutting machine.

How To: Cut a Nestability Die in a Cuttlebug machine

While embossing machines are marketed to be used brand specifically, all those Nestability dies and embossing folders are completely compatible with a Cuttlebug embossing machine. Make the most of your stamping materials without having to purchase to much of everything. Watch this video crafting tutorial and learn how to use Nestability dies and embossing folders to make die cuts with a Cuttlebug embossing and die-cutting machine.

How To: Make your own underwear

In this how to video, Allyce and Melissa entice you to throw a Panty Party, arming you with a few simple techniques to whip up lots of these sexy undies with your girlfriends. You will see this DIY project 3 minutes in to the video, after the hosts take you to a quilting market.

How To: Get fuller lips with ELLEgirl

There are tons of products on the market designed to help you achieve that pouty lips. But there is a cheaper, old fashioned way to get that sexy lip look. In this makeup how to video brought to you by ELLEgirl, learn how to get fuller, pout-ier lips just using lip liner and chapstick.

How To: Make fish pakoda

In this video Chef Sanjay shows you how to make three different types of Indian fish pakoda. Sanjay is using mahi but you can substitute for your favorite fish or market availability.