Website Functions Search Results

How To: Use a unit circle to find trig values

In this tutorial, we learn how to use a unit circle to find trig values. The unit circle has a radius one, use the definition of the trig functions to figure this out. Write them down if you need to, to remember what they are. You will also need two special triangles to help figure this out. Make sure you know the short side is opposite 30 degrees. Now, draw out your graph and find the ordered pair of pie, then find the y value of it. From here, find the cosine, tangent, and other units using...

How To: Retrieve the cell address of the minimum value in a column 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.

How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.

How to Lower your gun in Halo: Reach on the Xbox 360 to make machinima

If you all remembered back in the Halo 3 days, trying to lower your gun while filming machinima was a major pain because the button combination that you needed to required you to be some kind of circuis freak! But not anymore, with Halo: Reach, Bungie has realized that everyone wants to make machinima and have released a much easier to do button combination with Halo: Reach that will allow you to lower your gun. Unfortunately, you have to be offline in order to do it, all multiplayer and onli...

How To: Enable and use sticky posts to highlight content on a WordPress blog

Looking for a quick guide on how to create "stickies" on your WordPress blog? Look no further. 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: Clean and replace an aerator on a faucet or filer screen on a shower head

The aerator on your faucet serves a very important function: by adding air bubbles, it helps to fuse the water and give it a softer feel. It also helps reduce the amount of water you use. So if you're faucet's water stream is acting funny (like a drop in pressure), it might be time to either clean or replace your aerator. If you're having trouble with your shower head, too, a little vinegar might do the trick.

How To: Simulate paper resting on a hard surface in Adobe Photoshop CS5

Want to create a realistic paper simulation in Adobe Photoshop CS5? It's easy! And this clip will show you how it's done. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer 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, watch this video guide.

How To: Fix an "unable to create directory" WordPress error

Faced with an "Unable to create directory" error when attempting to upload an image to WordPress? This clip offers instructions on how to fix it. 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: Use Boolean math formulas in Microsoft Office 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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.

How To: Do node-based compositing as an After Effects user

In this tutorial, we take an introductory look at node based compositing from the perspective of an After Effects user. If you are someone who has lots of experience with After Effects, and wants to get into using a program like Shake, Nuke, or Fusion, this will help you get on the right track. Whether you're new to Adobe's popular compositing application or are just looking to get better acquainted with AE and its various features and functions, you're sure to enjoy this free video software ...

How To: Speed up your Cinema4D workflow with easy shortcuts

In this C4D user's guide, learn how to ctrl-drag axes to bypass the object axis tool; how to change a group axis with several selected items; how to set a light to negative values to make darker areas; and how to undo camera (view) moves by choosing "shift-command-Z." 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 i...

How To: Create and use Xrefs when working in MAXON Cinema 4D

This tutorial looks at streamlining your C4D workflow, organizing your assets and working with groups. Xrefs can be incredibly useful and as well as helping you to stay organized can also hugely reduce hard drive space used. 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 tr...

How To: Create a grassy landscape within MAXON Cinema 4D

This tutorials shows you how to set up a grassy scene, using C4D's Hair engine. Learn about the importance of lights and shadows and scene scale. 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 pillow or cushion in Cinema 4D

In this tutorial, you'll see how to use the cloth engine with a basic primitive object to create a scatter cushion for an architectural render. For a nice, simple addition you'll also see how to use the hair module to add a fluffy fringe to the seams. 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 t...

How To: Create a basic hand rig within MAXON Cinema 4D

This tutorial covers the C4D rigging system, applying it a model of a hand. It goes from start to finish covering all the different aspects of the technique. 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 paper crumple animations without keyframes in C4D

This tutorial shows you how to create an animation that makes a piece a paper crumple into a ball with no keyframes at all. It uses the cloth 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 using this trick in your own Cinema 4D projects, watch this 3D modeler's guide.

How To: Create a camera controller with nulls in Cinema 4D

In this clip, learn how to create a camera controller using nulls and user data. This makes animating a camera in a scene much easier. 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: Find the hidden error code behind your Xbox 360's RLoD

It goes by many names. The RLoD (Red Lights of Death), the RRoD (Red Ring of Death), absolute disaster. Whatever you call it, the XBox 360 error that causes many console's front LED's to turn red in rage and cessation of function has caused all sorts of headaches for consumers and Microsoft. It can be caused by a couple of different cooling-related issues, and determining the error code that has caused your console to malfunction can go a long way to helping you fix it. This video will show y...

How To: Make pasta alla formiana with Giada De Laurentiis

In this tutorial, learn how to make a perfectly healthy pasta dish with Giada De Laurentiis from the Food Network. This dinner is so easy to make and takes no time at all. You don't even have to cook the pasta! The pasta will cook itself in the oven. This baked pasta is great for family gatherings and holidays so give it a try at your next function. Enjoy!

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: Work with context and subcontext buttons in Blender

This clip covers the confusing array of buttons and controls in Blender that are used for the different functions. Specifically, it talks about context and sub-context buttons, presets for TV broadcast (and the different standards for those) in HD or high-definition broadcast. 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 vid...

How To: Craft a green ribbon banner gift bow and tag

Sure, you could hit up Target and purchase a large bag filled with cookie cutter ribbons and bows, but why not adorn your next special gift with something a bit more, well, special? In this beginner origami tutorial, you'll learn how to craft a green ribbon banner that can be used to top anything from gift boxes to gift bags.

How To: Use the new menu system in WordPress 3.0 Thelonious

WordPress 3.0 adds powerful CMS capabilities with a new menu system. This clip walks though this feature and shows what it can do for you. 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: Use the menu feature in WordPress 3.0 Thelonious

Having trouble with crating a custom page navigation? Your troubles are about to be solved with the menu feature in WordPress 3.0. Learn how to use WordPress 3.0's built-in menu management system 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 t...

How To: Tie a Padlock style decorative Knot

In this Arts & Crafts video tutorial you will learn how to tie a Padlock style decorative knot. Padlock knot is a clever way to achieve the look and function of a padlock without having to bother about the key. Take a piece of rope, bend it in the center and make two loops on either side of the rope. Ensure the working end is over the rope in the left side loop and under the rope in the right side loop. Now overlap both the loops so that the left side loop is over the other loop. Now pass the...

How To: Create a scrolling background in Adobe Flash CS4

Want to animate a background you've designed for scrolling? See how to do just that using Adobe Flash CS4. See how to use the Code Snippets panel to add ActionScript functionalities to your Adobe Flash CS5 projects. 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 inform...

How To: Load text into a dynamic text field within Flash CS5

Learn how to load HTML-formatted text for an external .txt file into a dynamic text field or textarea component within Adobe Flash CS3, CS4 or CS5. See how to use the Code Snippets panel to add ActionScript functionalities to your Adobe Flash CS5 projects. 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 thi...

How To: Slice up images for HTML image maps in GIMP

See how to use GIMP to generate a HTML image map in minutes. This mimics the slice function from Photoshop. Whether you're new to the GNU Image Manipulation Program, GNU's popular free graphics editor, or a seasoned designer just looking to pick up a few new tips and tricks, you're certain to enjoy this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started chopping up digital images yourself, take a look.

How To: Create exploding movie titles in Cinema 4D

Interested in creating exploding 3D title text? Have a copy of Cinema 4D and about 35 minute spare time? If so, you're in luck. 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 on how to create your own exploding title text, watch this 3D modeler's guide.

How To: Create a film strip icon in Adobe Illustrator CS4

Remember film? With Adobe Illustrator, it's easy to make an old-timey film strip icon perfect for a video application. This clip will show you how it's done. 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: Retouch photos to remove acne in Adobe Photoshop CS4

Your photos should show how you as you normally look and not, notably, as you looked that particular day when you had that huge pimple. Learn how to remove pimples and other blemishes when working in Adobe Photoshop CS4. 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. Fo...

How To: Sum year over year sales using MS Excel's SUMPRODUCT

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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.

How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.

How To: Use VBA code for conditional formatting 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 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.

How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...

How To: Create horizontal subtotals for a data set 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 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.

How To: Find a weighted average cost ending inventory value

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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.