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 639th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will do an approximate match lookup with an unsorted lookup table that can be copied across multiple columns and do lookup from multiple columns.
You can take high resolution photos with just about any digital SLR, but whether these high resolution photos turn out impressive depends on setting, lighting, and the compliance of your subjects to pose. While photographing your friends and family in everyday life has these aforementioned conditions already set for you, if you take photos in the studio many factors can be adjusted to your liking.
This clip provides detailed, step-by-step instructions on how to texture a head with projection painting when working in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started texturing modeled heads yourself, take a look!
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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.
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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.
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 634th installment in their series of digital spreadsheet magic tricks, you'll learn how to build logical formulas for counting with criteria or conditional formatting so that the comparison is between text and text or numbers and numbers. Text-to-number comparisons (e.g., 2003 to "2003") do not yield matches. Learn h...
This timelapse video shows how to start a simple model in Blender 3D and set up a render in LuxRender. The video also demonstrates how to create a daylight simulation and set up UV Maps in LuxRender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step inst...
Add energy and excitement to your scene with lightning! During this tutorial you will discover how to quickly model a detailed lightning bolt, make an object disintegrate, create light flashes, add glow and glare effects in the compositor. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more ...
Learn how to create realistic rain for animation or stills, how to add droplets to the camera lens, reduce your render time and create a glowing sky with this clip. from Blender Guru. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a...
Learn how to create a crack in a 3D object in two minute or less with this video guide. The technique involves no scripts, just a powerful tool that has been right under your nose for years! Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions,...
There seems to be a growing number of people who decide to try out blender but when you download Blender and start it the first time, it doesn't look very inviting, does it? Well, here's a little tutorial for those who are annoyed by Blender's default setup. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software ...
Learn how to create and rig a 3D model of a 3D character in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including step-by-step instructions, take a look!
Learn how to create a character rig when animating 3D models in Blender. Specifically, this clip addresses the following topics: Bone creation, splitting and re-parenting. Weighting with bone heat, mirrored weight painting and posed weight painting. IK setup, bone roll, and pole targets. Advanced foot rig with control to pivot off of the heel, toe, ankle or ball and control to lift the toes. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or...
This five-part guide presents detailed, step-by-step instructions on how to create a low-polygon model of a tree when working in Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, and to get started making your own 3D trees, take a look!
This Blender tutorial discusses how to set up action contraints, where you can use a bone to control things like finger curl/expand, or something more advanced, like facial expressions. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including ste...
With this quick Blender 2.5 video tip, you'll see how to stave off frustration in the case of a crash or lost work by using Blender's autosave feature to recover your work. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step ins...
In this quick Blender 2.5 video tip, you'll see how to use the new external drag and drop functionality recently added to Blender. This feature enables you to drag and drop images and videos from your operating systems file browser into Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from...
This Blender 2.5 quick video tip demonstrates how to easily place decals onto your model with empties. This technique provides you complete control over the location, rotation and scale of your decal without the need for UV maps. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG...
This clip demonstrates how to create a simple scene of blowing leaves. This technique makes good use of alpha mapped leaves, particle systems and a particle instance modifier to achieve the result. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, i...
Arguably the single most important aspect to modeling is topology. This Blender 2.5 overview tutorial takes a look at the topology of the human foot, examining each of the main edgeloops, poles, etc. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information,...
In this quick Blender 2.5 video tip, you'll see how to make a lowpoly model appear smoother than it actually is by using an Edgesplit modifier. This technique also resolves the issue with artifacts you commonly face when displaying a lowpoly model as smooth. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software ...
In this quick Blender 2.5 video, you'll see how to use the fly mode to position the camera. This method allows you to fly the camera around from a first-person perspective. It can aid in setting your camera angle and provide a bit of fun. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the fo...
This Blender 2.5 video tutorial offers a lesson in how to create an easy chain with nothing more than a single link, a array modifier and a curve modifier. Then see the process of using the freshly created chain in a simple scene. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at C...
In this Blender 2.5 video tutorial, you'll see a method for generating neat-looking blueprint graphics. This tutorial includes using the Gears add-on, creating outline-only objects, setting up the World to look like a blueprint, and more. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the fo...
This quick Blender 2.5 video tip shows how to make a simple drop-cloth effect like those you see photographers often use. The tip also demonstrates how to make the drop cloth follow the camera's rotation. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more informa...
This quick Blender video tip demonstrates how to use viewport snapping to lock the viewing angle to any 45 degree increment. This feature is similar to the viewport navigation that is found in ZBrush. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information...
This quick Blender 2.5 video tip tutorial demonstrates how to use multiple background images. This feature is very useful and allows for layering images in the viewport and assigning separate images to specific viewing angles. Without the need for multiple viewports. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video ...
This Blender 2.5 video tutorial offers a demonstration and overview of clean hand topology. The tutorial includes tips on how to structure your mesh, including clean topology, mesh flow and edgeloop density. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more info...
In this Blender 2.5 video tutorial, you'll see how to UV unwrap a full, stylized female character. The tutorial covers creating seams, unwrapping, pinning and techniques to reduce stretching. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, includi...
In this quick Blender 2.5 tip, you'll see how to easily create insets in your mesh. This technique uses the Extrude Individual Faces and Smooth tools. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
Before you can work in Blender, you'll have to learn how to work with it. Fortunately, this guide will show you everything you'll need to know to get started creating your own models within Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, ...
This clip offers instruction on how to export a model from Blender to Unity 3D and import it into a game. The tutorial also demonstrates how to bake a normal map and a color map from a highpoly model to the lowpoly counterpart, real-time display of the color/normal maps in the Blender viewport with GLSL shading, and real-time updating of assets in Unity. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely ...
See how to create a 3D model of a cuddly teddy bear within Blender 2.5 with this detailed, comprehensive guide. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
This Blender 2.5 video tutorial tackles something that is on most people's "create -before-I-die" list, a Jedi light saber. This tutorial focuses in on the post-processing aspect by setting up a node network to create the effect of the glowing blade. Modeling is not covered in this tutorial. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well s...
In this Blender 2.5 video tutorial, you'll see a technique that makes use of array and curve modifiers to create light streaks like those you would see froma long exposure capture. The tutorial covers modifiers, materials and node compositing. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from t...
See how to work with Blender's Camera Fly Mode tool. The tool is a great way to help navigate your 3D scene, and also for camera placement (or any object set to be a "camera", for example a Spotlight). Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more informatio...
In this tip video, you'll see how to set the aspect ratio of a plane object to match that of the image mapped to it. This is important to prevent distortion in the mapped image. This knowledge will be helpful when using image planes for cutout trees and people, instanced image planes for particle effects, and any situation where you need non-distorted images on plane objects. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned ...
This sculpter's guide presents a look at how to create reptilian scales with alpha maps as a custom brush. The tutorial makes use of both Blender 2.5 and Photoshop. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instruction...
This clip demonstrates the process of creating a model of a strand of Christmas lights in Blender 2.5. The tutorials covers modeling and how to use array and curve modifiers to create a strand of lights that will automatically lengthen as needed. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial fro...
