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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.
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 657th installment in their series of digital spreadsheet magic tricks, you'll learn see howto calculate Invoice Due Dates & Financial Statement Dates using the EOMONTH function including end of the month and beginning and ending dates for each quarter.
You may be a little confused about all the new functions and features of your new Motorola Droid X cell phone from Verizon Wireless, bud don't worry, help is here. This video will give you a complete walkthrough of the new Droid X mobile device, showing you all the new stuff and how to use it. It's the newest and most sophisticated Verizon Android phone, so don't let it get the best of you — watch and learn what it can do. See a full review at Android Central.
In this four-part tutorial, you'll learn how to create realistic 3D ninja throwing stars with Adobe Photoshop and 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, including complete instructions, watch this 3D modeler's guide.
These days, with such an intense demand for everyone to be on the go, up, productive, and "happy," it's no wonder we supplement our tired souls with a cup of coffee every morning. In fact, we know of some friends who simply don't function without that first cup...or two.
In this tripartite video tutorial, you'll learn how to create image-based lighting and depth-of-field effects within C4D. 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.
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.
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, ...
Learn how easy it is to use Vue atmospheres/skies to light your cinema 4d scenes, even if you don't have Vue Xstream. It's simple to do and can give some lovely 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 model...
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 ...
Hosted by Rob Redman.
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...
Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube
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.
One of the most obvious perks of using the Clojure is the user community organized around it. With this clip, the fourth installment in Sean Devlin's "Full Disclojure" series of Clojure video tutorials, you'll learn how to use the new constraint system in Clojure 1.1. Constraints are certain pre and post conditions that need to be met in order for a function to execute properly. If you've used D or Eiffel you've worked with constraints before. For more information, including a detailed, step-...
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...
This tutorial presents a general introduction to the basic editing functions and tools available within Blender 2.49 & 2.5. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, 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.
If you're starting to use your digital SLR for the first time, it can be quite confusing to determine what all its functions mean as well as where to find them and how to use them.
In order to prevent accidental CAP LOCKS, you can use a number of new, innovative and free software solutions. With your Windows 7, there are functions available to assist you.
This quick Blender 2.5 video tip demonstrates how to replicate objects with an array modifier in the same way that the Spin Duplicates function works. This techniques maintains the objects edit-ability even after spinning. a while back i posted about having a nasal voice that needs taming (i sound a bit like bob geldolf). 2 suggestions were the beyer m500 and the EV re20. i borrowed a friends re20 and found it very dull sounding. so dull i immediately threw in the towel. duller then my sm57 o...
This Cinema 4D tutorial offers a lesson in creating a very fast and easy comedy title sequence using MoGraph, MoGraph Spline Effector and a bit of compositing in After Effects. 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 detailed, step-by-step instructions, watch this 3D modeler's guide.
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.
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn about a robust formula for counting unique items in a list using the SUMPRODUCT, COUNTIF and an array formula component. You'll also see an array formula that uses SUM, IF, FREQUENCY, MATCH and ROWS functions to achieve the same.
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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
Want to use an Illustrator CS5 illustration in a Microsoft PowerPoint presentation or Word document? This video clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, wat...
Need help figuring out how to save PDF-compatible AI files from Illustrator CS5. This clip will show you how it's done. Whether you're new to Adobe's popular vector graphics editor or a seasoned graphic arts professional interested in better acquainting yourself with the new features and functions of Illustrator CS5, you're sure to benefit from this free software tutorial. For more information, and to get started using this trick in your own Illustrator projects, watch this video guide.
