Functions Diligently Search Results

How To: Use the Format Menu, Underline and Align Full buttons in the WordPress editor

In this clip, learn how to use the Format Dropdown Menu, Underline, Align Full and color adjustment buttons in the WordPress editor. Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.

How To: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Fix a cracked wood cutting board

If you have a cutting board that you made or purchased from the store, excessive exposure to water can be bad. Water can be sucked into the wood and damage the wood board, eventually leading to a crack. Instead of throwing it out, you may want to let it sit for a couple of weeks so that the water is able to dry out.

How To: Synchronize graphics in Adobe Flash Professional CS5

Looking for a primer on how to sync graphics when working within Flash CS5? This clip will teach you everything you'll need to know. Whether you're new to Adobe's popular Flash-development platform or a seasoned web developer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started making your own Flash-based twinkling starscapes, watch t...

How To: Add curtains to a wall in Autodesk Revit Architecture 2011

Interested in adding curtains to a wall in Revit Architecture 2011? It's easy. And this clip will show you how it's done. Whether you're new to Autodesk's popular CAD building information modeling application or a seasoned professional merely looking to better acquaint yourself with the newest features and functions of Revit Architecture 2011, you're sure to bell well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, watch the vi...

How To: Create a defined name for a dynamic range in MS 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Average the last three values for an entity in 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Extract records with 2 criteria with Excel's AGGREGATE

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...

How To: Add an IMDB search function to the Chrome web browser

Looking for a quicker way to use IMDB in Chrome? On today's Tekzilla Daily, Veronica shows you how to use GoToIMDB for the best way to look up films with a single click.This clip will show you how it's done. It's simple! So simple, in fact, that this home-computing how-to can present a complete, step-by-step overview of the process in just under two minutes. For more information, including complete, step-by-step instructions, take a look.

How To: Extract the rows in a data set to 1 column in MS 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 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.

How To: Calculate invoice due dates with EOMONTH in MS 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 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.

How To: Use Verizon Wireless's new Motorola Droid X cell phone

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.

How To: Make realistic 3D shuriken with Photoshop & Cinema 4D

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.

How To: Use image-based lighting & depth of field in Cinema 4D

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.

How To: Make budget summary tables that add by month in 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 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.

How To: Create bullet-time explosions inside MAXON Cinema 4D

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.

How To: Build a grungy scene using MAXON Cinema 4D

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...

How To: Create a simple growing tree animation in Cinema 4D

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, ...

How To: Use Vue Xtream to light your 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...

How To: Create soft body dynamics when working in Cinema 4D

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.

How To: Create multicolored fur and hair in MAXON Cinema 4D

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...

How To: Add & set up sub-surface scattering in MAXON Cinema 4D

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.

How To: Use the material attributes window in MAXON Cinema 4D

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 ...

How To: Create global illumination in a MAXON Cinema 4D scene

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...

How To: Create text splines when working in MAXON Cinema 4D

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.

How To: Create a 3D model of a bathtub in MAXON Cinema 4D

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.

How To: Make a 3D model of a chair in MAXON Cinema 4D

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...

How To: Use the flash and both cameras on your new iPhone 4

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...

How To: Shatter a 3D object in Cinema 4D

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.

How To: Use the constraint system when programming in Clojure

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-...

How To: Create 3D characters via polygon modeling in Cinema 4D

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.

How To: Create Target Effector MoGraphs in Cinema 4D

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...

How To: Use the basic editing tools within Blender 2.5

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.

How To: Apply special formatting to past-due invoices in 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 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.

How To: Count dates falling within a given year in MS 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 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.

How To: Highlight dates falling within a given year in 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 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.