Dynamic Digital Search Results

How To: Use pool and billiards shot dynamics

Ever wonder what happens after you hit the cue ball or after the cue ball hits the object ball? Here are some of the dynamics involved when hitting the cue ball and object ball. This video tutorial breaks it down for all of you billiards beginners. Learn how to use pool and billiards shot dynamics.

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Sum values after a deadline 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

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 a dynamic area chart 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 351st installment in their series of digital spreadsheet magic tricks, you'll learn how to create an area chart for x and f(x) data as well as how to use the IF function to show a second data set plotted to show a specific area section.

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Create high-dynamic range images in MAXON Cinema 4D

This tutorial presents a lesson in generating high-dynamic range images (HDRI) within MAXON 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: Create a dynamic 3D chain in Cinema 4D

Learn how to model a dynamic 3D chain with 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: Create animations with Motion Dynamics in Cinema 4D

In this tutorial, you'll see how to create a simple animation scene using Motion Dynamics and assigning a Rigid Body tag. 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 your own simple animations, watch this 3D modeler's guide.

How To: Use dynamic range names in Excel 2007 tables

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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Use the new features in Adobe Flash Catalyst CS5

Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, Terry White discusses his five favorite features of the newest addition to Adobe's CS, Flash Catalyst, an application which allows you to create dynamic web pages without coding. Learn how to create dynamic scrolling content and functional Flash buttons ...

How To: Create dynamic text effects in Sony Vegas 7

Learn how to create dynamic, eye-catching title text effects within Sony Vegas 7 with this two-part software tutorial! Whether you're new to Sony's popular non-linear editor 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 detailed, step-by-step instructions, watch this free video guide.

How To: Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.

How To: Use and work with tables in Microsoft Excel 2007

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 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:

How To: Automatically create pivot tables in Excel 2007

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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

How To: Find the last row or column used in an Excel data set

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 135th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range when there are blanks in the data set. Learn also how to use an array formula to find the Last row or column used in a data set.

How To: Build an Egyptian Pharaoh's room in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to build an Egyptian Pharaoh's room in Photoshop.

How To: Create clouds over a sea in Photoshop

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create cloud over a sea in Photoshop.

How To: Build a 3D rocket in Photoshop and Illustrator

Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to turn build a 3D rocket in Photoshop and Illustrator.

How To: Create dynamic tables with PHP & MySQL in Adobe Dreamweaver CS5

In this clip, you'll learn how to generate dynamic tables with PHP & MySQL in Dreamweaver CS5. Whether you're new to Adobe's popular WYSIWYG HTML editor or a seasoned web development professional just looking to better acquaint yourself with the CS5 workflow, you're sure to be well served by this video tutorial. For more information, include detailed, step-by-step instructions, watch this free video guide.

How To: Create wind using Blender 3D modeling software

The wind is one of the most dynamic of all natural forces, and rendering it properly in a digital environment is important and challenging. This video will show you how to create and animate wind in the 3D graphics suite Blender by showing you how to make a flag, then make it wave realistically. Unless you want to make a replica of the flag planted on the moon, you're going to need some wind in your 3D flag model, and this video will show you how to make it so.

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.

How To: Render dynamic XML files with a PHP loops

In this clip, you'll learn how to render dynamic XML files with PHP loops. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Set up a dynamic publishing workflow in InDesign CS5

In this clip, you'll learn how to set up a dynamic publishing workflow within Adobe InDesign CS5. Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS4's most vital new features, you're sure to be well served by free video software tutorial. For more information, take a look.

How To: Destroy a wall using RealFlow and rigid body dynamics

In this tutorial, you'll learn how to destroy a modeled wall using rigid body dynamics within RealFlow. Whether you're new to RealFlow's popular fluids and body modeling software or are just looking to get better acquainted with the application 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 RealFlow projects, watch this 3D modeler's guide.