Functions Diligently Search Results

How To: Create simple animation loops in Adobe Flash Professional CS5

Has looping got you thrown for a loop? See how it's done with this clip. 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 this video guide.

How To: Calculate the difference between two dates in Microsoft Excel 2010

Learn how to find the difference between two dates with MS Excel 2010's DATEDIF function. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Use sub polygon displacement in MAXON Cinema 4D

In this C4D user's guide, you'll learn how to use sub polygon displacement in your projects. 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: Adjust irradiance cache settings in MAXON Cinema 4D

Learn how saving an irradiance cache can save time on rendering in this C4D-user's guide. 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 Slide and SlideToggle() Effects in jQuery

The slide effect is a popular feature of many websites that allows information to cascade out from an item on a page and the rest of the page to adjust accordingly. This effect is created using the SlideToggle() function in jQuery, the popular Javascript library. This video will teach you how to use it to make your website much easier for your users to access.

How To: Create Transformers-style movie titles in Cinema 4D

This video presents a simple setup for imitating the Transformers title text effect in Cinema 4D using Explosion FX. 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.

How To: Create Sherlock Holmes-style movie titles in Cinema 4D

Want to recreate the look of the titles used in Guy Ritchie's 2009 adaptation of Sherlock Holmes? See how it's done with this Cinema 4D lesson. 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.

How To: Create a 3D box icon in Illustrator CS4

Create a vector three-dimensional box icon in Adobe Illustrator CS4. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Draw fire and flames in Adobe Illustrator CS4

See how to create a vector flaming box in Adobe Illustrator CS4. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Create a vector leather texture in Adobe Illustrator

See how to create a vector-based leather texture from scratch when working in Adobe Illustrator CS4. Whether you're new to Adobe's popular vector graphics editor program or a seasoned graphic arts professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Make a Harry Potter-style logo in Adobe Photoshop CS4

You don't need to be a Photoshop wizard to create Harry Potter-style text. Whether you're new to Adobe's popular graphic editing program or a seasoned design professional looking to better acquaint yourself with the new features and functions of this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started creating Harry Potter-style logos yourself, watch this designer's guide.

How To: Animate growing vines in Adobe Flash CS4

See how to create a trendy growing vine animation when working in Adobe Flash CS4. 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 this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this Flash developer's guide.

How To: Create a "slide to open" iPhone effect in Flash CS4

See how to create an iPhone-style slide-to-open effect in Adobe Flash CS4. 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 this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this Flash developer's guide.

How To: Create an ActionScript drop-down menu in Flash CS4

See how to create dynamic drop-down menus when working in Adobe Flash CS4. 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 this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this Flash developer's guide.

How To: Animate slide-out info panels with AS3 and Flash CS4

See how to create roll-over panels using Adobe Flash CS4 and a little bit of ActionScript 3. 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 this particular iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this Flash developer's guide.

How To: Tween with ActionScript 3.0 in Flash CS4

In this advanced level tutorial, learn how to tween with Actionscript 3.0 in Flash CS4. This video starts out slow with a simple fade-in animation and later gets more complex. Subjects covered in this tutorial include: Tween class, creating tweens, timers, timer events, tween events, using event listeners, functions, and more.

How To: Use Adobe Camera Raw in Photoshop

If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.

How To: Use tritone chord substitutions in jazz guitar

This free video guitar lesson discusses tritone chord substitution. In short, when a dominant 7th chord is functioning, it can be substituted by a dominant chord that is a tritone or augmented fourth away from its root. For more information, and to get started playing tritone chord substitutions on your own guitar, watch helpful jazz tutorial.

How To: Make a multitouch table computer pad

Multi-touch input has been spreading throughout a huge variety of devices, from phones to all-in-one PCs. However, most multitouch (table) displays that can function with your computer tend to be fairly expensive, so with this project we're going to make our own display, that can run on any operating system, and reuses some useless everyday materials.

How To: Make USB air conditioning

Wondering how to most effectively combine ice cubes and a simple USB-powered computer fan into a fully functioning air conditioning system? In this video tutorial, you'll learn how to hack a coffee can and USB-powered fan into a simple, but effective, air conditioning unit. For detailed instructions on hacking together your own tin-can AC unit, watch this über-short how-to.

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Calculate weekly gross pay from time values in Microsoft Excel 2010

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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Use the UVW unwrap function in 3D Studio Max

In this video, we learn how to use the UVW unwrap function in 3D Studio Max. First, go to the UV modifier wrap and select all the faces. Once here, edit the parameters and then go to the mapping menu. After this, you will be able to change the object as you would like. After you are finished with this, save your object to your computer in a spot you won't forget it. You can create several different layers and change the colors as you prefer. You can completely customize your experience on thi...

How To: Add custom buttons to a Thunderbird Toolbar

In order to add additional buttons to your Thunderbird Tool Bar, you will need an add-on called "Custom Buttons". It will allow you to add additional buttons to your tool bar. You will need to give instructions for the buttons, which you will use Java Script in order to set it up. Otherwise, the button will not have a function.

How To: Use the main menu functions in Photoshop CS3

In this tutorial, we learn how to use the main menu functions in Photoshop CS3. All of your main menus are up on the top toolbar. There will be a drop down list for each different tab you select. When you create a new document, you will be prompted with a dialogue box that asks you how you want your page to be set up. Change the preferences to fit how you want your page to look. When you have changed all of your different settings, click on "ok" and you will be brought to your new document cr...

How To: Use the timer function on a Panasonic G1 or GH1 camera

Learn how to set the timer function when using aPanasonic G1 or GH1 digital camera. Learn how to set the auto mode on a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to take timed photographs with a G1 or GH1 camera. For more information, including detailed instructions, ...

How To: Use log to solve for an unknown variable

Thinking of an unknown exponent as a cat stuck in a tree, you will see how to bring down the exponent by using the the log function. In other words, you will be utilizing the Power Law to bring the exponent down in front of the log function. In this slightly more complicated example, a little work has to be done to first be able to take the log (i.e., get the base by itself). Then once you take the log, the unknown still isn't entirely by itself, so you divide off everything it's being multip...

How To: Use the concatenate function & ampersand 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 166th installment in their series of digital spreadsheet magic tricks, you'll learn about the relative advantages and disadvantages of the ampersand symbol and the CONCATENATE function (both join two [2] or more elements together into one text string).

How To: Sort data with sorting functions in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Use the RANK and PERCENTRANK functions in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Remove duplicate entries with Excel's COUNTIF function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Link buttons to external urls in Flash CS3

This is a video tutorial showing its audience how to link a button to external urls in Flash CS3. First create a exoscript 3 document with a rectangle textbox that says youtube. Next select your rectangular box and convert it to a button. Next name your button and click okay. Next give your new button an instance name, remember this name. Now click on actions and create your actions. Start with a stop action and then put the name of the button as an action. Next name your function that you wa...

How To: Calculate probabilities with Excel's NORMDIST function

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 22nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NORMDIST function to calculate probabilities for a population with a normal (bell) distribution! You even get to see the four types of situations that you most commonly encounter -- plus visual pictures of each situation...

How To: Do dynamic range w/Excel's OFFSET function & top data

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 240th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function and a named formula when new records are added at the top instead of the bottom.

How To: Use an OFFSET as a dynamic range in an Excel VLOOKUP

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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.