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 642nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budget summary table that adds by month and payee. See the benefits and drawbacks of the SUMIFS & EOMONTH functions method or the PivotTable method. Also learn about the Excel Table feature for adding dynamic ranges.
Check out this tutorial of how to create moving curtains in After Effects. You create a set of curtains that opens up to reveal footage placed behind it. You can render the clip out with an alpha channel and always have a curtains clip ready to reveal some footage. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well ...
This tutorial uses After Effects to design a quick animation that looks like several light streaks form the letters of a word. The letters burst from the light streaks with a particle explosion. This tutorial uses Trapcode 3D Stroke and Particular. Whether you're new to Adobe's popular motion graphics and compositing software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this vi...
Despite being well known as the Era of Homogenously Bad Taste, the '80s have recently been referenced by high end designers (think Marc Jacobs), movies (think "Sex and the City 2"), and makeup artists (think the strong fuchsia lips that are in right now).
This tutorial will show a simple technique for achieving the bullet time, freezing effect. This is used regularly in TV idents, films and music videos. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
This tutorial walks through the process of building a grungy scene. Starting with an overview of the process and scene elements, you will learn how to use stacked layers. Mixing them with alpha channels you can build up complex materials; in this case rust and dirt on a nice clean object. You will learn how to set up moody lighting, with volume effects and dust to add to the overall old & dirty look. Whether you're new to MAXON's popular 3D modeling application or are just looking to get bett...
This tutorial will show you how to create a simple scene of a stylised tree growing out of the ground. You'll also learn a few settings needed to add snow to your scene, using PyroCluster. 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, and to get started using this trick in your own Cinema 4D projects, ...
This clip covers various methods for modeling soft-body dynamics within Cinema 4D. In particular, this video discusses jiggle deformer and paint vertex maps. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
This tutorial will show you how to make your hair module materials multi-colored. There are also some tips on setting up lights to help sell the hairy look. 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, and to get started creating rainbow-colored hair in your own Cinema 4D projects, watch this 3D model...
Learn how to easily add and set up SSS in your Cinema 4d scenes. Avoid one of the common mistakes made and get great results. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
This quick tip shows one way of using the material attributes window to preview your material on different objects. It also takes a look at using and setting up the content browser. 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, and to get started using the material attributes window in your own Cinema ...
This tutorial will explain some of the ways you can implement global illumination in your scene, using luminous materials and HDRIs. It also presents a look at how to set up realistic reflections in your materials, using the standard reflection channel with a fresnel mixed in. 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. F...
This clip teaches you how to use a text spline object with a sweep NURBs. There is also a tip on using the sweep NURBs to animate your text. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
In this clip, you'll see how to use a variety of tools to build and texture bath tub, with taps and even a towel created using the clothilde engine. 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, and to get started using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.
In this clip, you'll see how to use a variety of tools to build a chair. Starting with a spline and a sweep nurbs, you will learn how to create a frame. Then on to poly objects, using soft selections, magnet, bevel, extrude and more to create realistic cushions. 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 informa...
In this video tutorial, viewers learn how to remember Windows Explorer positions. Users will need to download the Shell Folder Fix program provided in the video. Once downloaded and installed, the program will remember the position of every Windows Explorer window that is opened. Now whenever ever the user opens that folder in the future, it will be displayed in the same location as before. There are also some additional features to the program such as: displaying the windows title and saving...
Do you swoon over Justin Bieber and wish you could have him all to yourself? Though he's probably not going to pay a personal house call to you anytime soon, you can draw yourself a very lifelike picture of him!
In this clip, learn all about the brand new cameras on your iPhone 4. The latest iPhone from Apple has made major improvements on the cameras from the older models. Not only do you now have a flash, but you also have TWO fully functioning cameras with great picture resolution for a cell phone. In addition to that, the iPhone 4's new camera has face recognition software, a zoom lens AND an autofocus. There are so many fun things you can do with these cameras from photography to video to two-wa...
This clip presents a lessson in how to create an eye-catching shatter effect within Cinema 4D. 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, and to get started creating and rendering your own 3D mushrooms, watch this 3D modeler's guide.
With this clip, you'll learn how to use iOS4's built-in email application. Apple's new iOS 4 for the iPhone and iPod Touch brings with it a host of new features. While that's certainly a cause for celebration, there's also, believe it or not, a downside: learning how to take advantage of them. Happily, the web is awash in helpful video tutorials like this one which make the process a pleasure (and a simple one at that).
Photoshop lets you modify your view of an image using a variety of tools, commands, and options. But you don't need a single one of them. Learn a few navigational shortcuts and you'll be working at maximum efficiency in no time. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information...
Photoshop doesn't sharpen focus, it sharpens detail using any of three remarkable filters: Unsharp Mask, Smart Sharpen, and High Pass. Apply them as smart filters, and you're ready for any output scenario. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, s...
The safety-net trio of Undo, History, and Revert protect the intrepid image editor from unexpected disasters. But they also let you toggle operations, compare before-and-after images, and move back and forth through time. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, inclu...
The ubiquitous eyedropper is simple in purpose and easy to use. But imagine a world without it, where you had to dial in every one of the 16.8 million+ colors manually. The eyedropper is Photoshops color ambassador. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including d...
Want to let the world know who made your photo? Then choose File Info. Here you can assign a title, an author, a copyright, and a Web site. No image should go out without a visit to File Info. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step i...
Much can be said of masking: Masking is the art of using the image to select itself. Masking lets you apply the entire weight of Photoshop to the task of editing a selection. And masking, thy name is alpha channel. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including de...
Smart objects aren't all that smart. And they aren't objects. What they are is envelopes. The kind that hold things. And keep them safe. So that everything you do protects the image from harm. This is Photoshop at its best. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, inc...
As powerful as Photoshop is, there is little about the program that is obvious. Case in point: How do you rotate a layer? Right-click on it and select Rotate? Choose Rotate from the Layer menu? Click on the Rotate tool? The answer is no, no, and no. Fortunately, there's the Free Transform command, which rotates the active layer and much, much more. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with th...
The Liquify filter lets you paint in distortions so you can perform digital nips and tucks. You can slim people down, edit their posture, and make them look exactly how you want them to. See how in this video. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detaile...
The modest brush tool is one of the deepest, most versatile tools in Photoshop. It's not only a terrific painting tool, but it is also invaluable for masking, as this video demonstrates. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instruc...
Many folks select images in Photoshop with the likes of the Quick Select and Magic Wand tools. Highly automated, but these tools rarely work accurately. Experts use the Pen tool. Using the Pen tool is an art form worth learning, because it always works. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutor...
One of the oldest, most abstruse, downright incomprehensible commands in Photoshop, Calculations lets you merge two channels to create a new alpha channel. Learn it: It's the backbone of masking. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-ste...
Photoshop offers lots of tools for automating selections, but two stand out from the pack: The first, Refine Edge, lets you modify your selection using five different parameters and preview the results in five different ways. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, i...
Layer comps let you assemble multiple image variations or even independent pieces of artwork inside a single Adobe Photoshop file. The Layer Comps palette gives you the freedom to explore. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instr...
In this short C4D user's, you'll see how to create a simple 3D character using polygon modeling and hyperNURBS. The end result is a very low poly model. 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, and to get started creating and rendering your own 3D characters, watch this 3D modeler's guide.
In this Cinema 4D tutorial, you'll see how to create a Target Effector MoGraph which is amazing. With only 4 simple steps, you can create a very special scene. Primitive Object, Cloner Object and Target Effector will be used in this tutorial. 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, and to get sta...
Are you a left-handed crochet addict who's tired of finding only right-hander oriented YouTube crochet tutorials and having to put a mirror up to the screen to get what the heck is going on?
A crochet single rib stitch is essentially a fancy way of saying a crochet stitch with an undulating up and down pattern. A "rib," or elevated stitch, runs across the finished piece vertically, forming an interesting pattern that can be used to accentuate scarves and mittens.
This clip explains how the Adobe Premiere Pro CS4 Media Browser panel can save you time and keep your projects tidy. Also learn about Equalize Volume within Soundbooth to make volume matching files easy. Whether you're new to Adobe's popular non-linear editor (NLE) software or a seasoned video professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detaile...
