Demanding Function Search Results

How To: Make spinning 3D text with specular highlights in C4D

In this tutorial, you'll learn how to use Cinema 4D and Mograph to create spinning text with specular highlights. 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 3D model of a children's book in Cinema 4D

Learn how to model a fairytale Book in Cinema 4D with this video walkthrough. 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 proxy object when working in RealFlow

Need some help figuring out how to generate proxy objects in RealFlow? Never fear. This guide will show you how it's done. 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.

How To: Create a 3D model of a pillar & egg in MAXON Cinema 4D

This clip discusses how to use the basic modeling tools within C4D to create a classical pillar and egg. 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: Control hair & fur settings with UV maps in Cinema 4D

In this tutorial, you will learn how to utilise UV maps for both root colour and hair length. This guide also offers a quick look at polygon selection tags and organising a scene with hair objects as well. 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 Cin...

How To: Unlock the iPhone 3G to work with alternate carriers

In this tutorial, we learn how to unlock the iPhone 3G to work on other carrier networks. First, purchase an ATT Universal unlock SIM card and cut it so it is the same size as the SIM card in your phone. Don't cut any important parts off the back of the card. Now, remove the card from the iPhone and install the Universal unlock card. This is all you have to do and now you can run your iPhone on a different network. This is the most simple way to use your phone on another network. You can rese...

How To: Convert PSone games to PSP

In this Video Games video tutorial you will learn how to convert PSone games to PSP. For this you will need a 5.03 firmware update. It is capable of running ChickHEN enabler. After you upgrade, run the firmware. You will need a utility called magic ISO for ripping the discs. Put in your PSone game in to your PC and use the extract game function. Then a program called Simple Popstation GUI comes up. Browse to where you saved your ISO, pick the output destination and click GO. Then you drag the...

How To: Use LightScribe with a Nimbie NB11 disc burner

In this video tutorial, viewers learn how to light-scribe with a Nimbie BB11 disc burner. This device is an auto disc loading system that allows the user to light-scribe multiple disc without manually inserting them one-by-one. Simply load the disc into the machine with the labels faced down. On your desktop, double-click on the Q-Q-Box icon to start the program. Start up the labeling function, select a desires image and quantity up to 100. Then click on Print. The machine will then product l...

How To: Properly prune and trim your garden

Something that every gardener needs to know is how to prune and trim your plants properly.Being able to perform both of these functions is important for keeping your garden beautiful and making sure that they will last for a long time. When pruning or trimming plants, it's important to always use the right tools for the job.

How To: Add a sidebar to a WordPress theme and set it up

This tutorial will guide you through the steps involved in setting up a sidebar on a WordPress page. 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 its features through videos like this one. Take a look.

How To: Model a streamlined octopus character in Cinema 4D

In this short video tutorial, you'll see how to create a Space Octopus character using Low Poly Modeling (Box Modeling) and HyperNURBS in 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 Space Octopus, watch this 3D modeler's guide.

How To: Fix a WordPress database connection error

See how to resolve a WordPress MySQL database connection error with this free video tutorial. 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 its features through videos like this one. Take a look.

How To: Access & use exposure compensation on a G1 or GH1

Learn how to find and set the exposure compensation function on a Panasonic 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 find . For more information, including detailed instructions, watch this digital came...

How To: Use the Shutter Priority mode on a Panasonic G1 or GH1

Learn how to set and use the Shutter Priority (S) function on a Panasonic G1 or GH1 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 use the Shutter Priority mode on a G1 or GH1 camera. For more information, including detailed i...

How To: Use Excel to sort data & present data in a line chart

This video introduces how to use Excel to sort data, perform the Frequency function, and present data in line chart. See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating your own li...

How To: Upload images, audio & video to your WordPress blog

Here is a step by step tutorial on inserting media (images, audio, video etc), from your computer, into your blog posts and pages. 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: Reorder pages within your WordPress navigation bar

Using the My Page Order plugin, you can simply and easily change the order of the pages on your WordPress navigation bar (or nav bar for short). See how it's done with this free video blogger's guide. 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 ...

How To: Embed a Wiki article reference in your WordPress blog

See how to insert a hyperlinked reference to a Wikipedia article in your blog post or page with this free video blogger's guide. 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: Create a blog roll on your WordPress blog

Learn how to create a blog roll (blogroll) of your favorite sites on your WordPress blog with this free video software tutorial. 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: Embed HTML code into a WordPress post or page

This clip presents a general tutorial on how to work with and embed HTML code into your WordPress posts and pages. 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: Create main and subpages on your WordPress blog

See how to create a main page with a drop down menu revealing secondary pages — also known as parent/child or main and sub pages (subpages). 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: Insert an image gallery in a WordPress 3 blog post

If you need to display thumbnails on a WordPress page and link the smaller thumbs to the original larger pictures, this post shows the process involved, using the Lightbox plugi,n which creates a special overlay effect when an image link is clicked on. 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 mak...

How To: Find APR, EAR & amortization for payday loans 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Sum and average statistical data within 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGE, STDEV, MAX, MIN and SUM function to add statistical data. Specifically, this video lesson discusses how to sum and average evidence in an age discrimination case.

How To: Make grilled corn sheet with Bobby Flay

Bobby Flay is a leading figure in the television-grilling world. In this episode of his show Grill It! with Bobby Flay, he veers away from his usual pile of meat to make a delicious side dish, grilled corn sheets with a homemade vinaigrette. Corn is not generally served in sheets, and this original presentation adds some flair to what is thought of as a rather boring staple of the American diet. All you need is some skill with cutting vegetable, a functioning grill, and a blender to make this...

How To: Sort numbers with a 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 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.

How To: Create random dates within a set 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.

How To: Find outliers using the Z-score method

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 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

How To: Calculate simple and compound interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Build confidence intervals given the sigma 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 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Avoid a #NUM! error when changing NPER inputs in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Find the first instance of an item in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Deliver words to a cell via IF, AND & VLOOKUP in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 35th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the IF, AND and VLOOKUP functions to deliver the words Bid, No Bid, or Alert to a cell. Is VLOOKUP better than IF AND? Find out with this free video lesson.

How To: Use SUMIFS or SUMPRODUCT to get invoice info 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 497th installment in their series of digital spreadsheet magic tricks, you'll see a formula that uses SUMIFS or SUMPRODUCT functions that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock) for each store or branch of the company.

How To: Count blanks in an dynamic range 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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).

How To: Check to see if a string contains a value 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 530th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR, SEARCH and ISNUMBER functions to see if the descriptions in a data set contain a given value (in this case, "Repair" or "Rework").

How To: Look up & retrieve a row of data from a table 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 552nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up and retrieve a row of data from a table and display it vertically using the VLOOKUP and ROWS functions.

How To: Extract the nth word from a text string 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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.

How To: Extract first, middle, & last names 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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.